I have 2 inventory reports that are using 2 different tables; the 1st report (Inventory Summary) is using Item.“Net Change” and the 2nd report (Detail Inventory) is using Value Entry table.
The value in the 1st report is less about $500.27 and I found the item that causing the discrepancy.
With the same date filter and filter condition; what is the causing for both reports are having different inventory value (mean while the inventory quantity is showing the same figure)? We run the adjust cost on daily basis.
Well, it’s actually not an error but the figure between those 2 reports are not tight up. Meanwhile, I thought the information between the Item Ledger and Value Entry (with the same condition ) should giving you the same value/result.
It’s not about multiplying but the sum up of a flow field.
The item ledger is using the date based on when the item is shipped and received. Based on the question you’re asking, I’m thinking you’re probably back dating your reports.
The difference occurs because item ledger entry gives you all the values that are posted against the item ledger, filtered the date on the item ledger. If you’re running the report based on value entry, it’s using the date on the value entry.
In English, this is caused by the timing on:
The timing of when the adjust cost is ran
The timing of when you posted your invoce
The timing of when you posted the landed cost
Navision’s design of this process is significant and important because you need to keep proper account of your inventory by day. Because a cost to a received item may change a month or 2 down the line. Your accounting should reflect appropriately.
You’re right; I was back dating the date on the report that are using Item.“Net Change”. I thought the “Net Change” was created to the purpose of back dating the date; since Item.Inventory field doesn’t cover this capability.
In this case; what is the solution to match the figures in both reports?
The amount field on the Item Ledger does not have date filter there by design. There are a lot of instances where you need to use the Item Ledger for report, i.e., true profitability reports.
I don’t recommend changing the table structure, but to just change your report based on your specific requirements.
Alex, I am a little bit confused [*-)]. If the quantity can match to decimal point. Why can’t the amount? Besides the Item.“Netchange (LCY)” is flow field to ValueEntry.“Cost Amount (Actual)”.
Programming wise; it would easier for me if I am using Item table instead of Value Entry.
It is easy to add a similar field into the Item Ledger Enry, just check that there is a SumIndex that supports the calculation in the Value Entry table. If you are using SQL and a well managed database then this should have little impact on perfromance.
The ooption with the least system impact is to add code into a report to calcualte the value entries.
Actually, the different is only from 1 item and about $500.27 less and I found the item that causing the discrepancy. I don’t know why is only happening to that item.
Before you decide to take the modification route. I highly recommend you understand how the Navision inventory and inventory costing works. It’s done this way by design, it’s NOT a bug.
It’s only a bug if you don’t take the time to understand it fully. This is why Microsoft has a certification course and exam SPECIFICALLY for Costing.
There is nothing wrong with Navision costing, you just need to understand how it works.
Ask your local solution center to walkthrough with you on the difference between the value entry and item ledger, and why your reports do not match. They should be able to show you exactly why you’re getting the results you’re getting.