how to do the jv for difference in valuation report

Business Central/NAV User Forum
1

Hi all,

I am having the issue like when i run the inventory valuation report, the value in the valuation report isdiffer from the inventory acc g/l balance.

for example :

g/l balance for inventory acc( finished goods) is rs.1000

when i run the valuatio report for inventory acc (finished goods) is rs.800.

here i need to pass jv for rs.200

can anyone kindly let me know, how i can pass the jv.

Thanks,

N.Senthil kumar

2

But do you have the reason of the differences ?

3

Some ideas:

1: I suppose that you have used the “Cost Adjust”-batch. If not, do that.

2: And I suppose that no entries have been posted to the InventoryAcc manually
Check your entries; the field “System-Created Entry” should be “Yes”.
If entries contain “No”, perhaps theese entries make the difference.

3: Run your valuation-report with an ending-date in the future (2999-12-31 eg).
If some entries by any chance have been dated in the future, this should catch it.
Compare the report to your G/L Accounts without any filters.
And remember to check all Inventory accounts.

4

Hi Anfinnur,

Thanks a lot .