Item & Value Entry

Hi all,

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.

Please help.

ZEN [:D]

Hi Zen,

The net change on the item card is off of the item ledger. While your detailed report is coming from the value entry.

What version of Navision are you running?

Dear Zene

As u hv mentioned the error is not on qty part but value.

Can u tell with what value are u multiplying the net change in

Summary Report ?

Thanks

Isn’t that the Item Ledger and Value Entry should tight up one to the other?

We are under 3.60

Thanks,

ZEN

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.

ZEN

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:

  1. The timing of when the adjust cost is ran
  2. The timing of when you posted your invoce
  3. 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.

Alex, thanks for reply.

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?

ZEN [:)]

The reports off of item ledger and value entry are for different purposes.

If you want your reports to be the actual amounts posted to G/L, then the report based on value entry should be used.

If you want your reports to give the true profitability, then the report based on item ledger should be used.

This is also based on how your reports are written…

Look at the Amount fields on the Item Ledger Entry table; they are flowfields but there is no Date Filter applied to the calulation.

You can:

Change the standard fields to include a Date Filter (based on Posting Date).

Create a new field in the Item Ledger Entry to do that (above).

Write code in a report to do the calculation applying a filter to the Value Entry Table.

Not so difficult just time consuming.

[:D]

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.

Thanks,

ZEN

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.

Even I can manage that sort of code…

[:D]

Jonathan,

All the links (flow fields) are there but the result are different.

ZEN

Have you applied filters for SETRANGE or SETFILTER before the CALCFIELDS?

[:)]

Yes, I did.

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.

Thanks

HOLD ON!

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.

Thank you Alex.

ZEN