Dynamics Community Forum Thread Details

Movement Journal vs. General Ledger $ Amount Differences

Hi,

I am trying to research items which posted to my inventory adjustments general ledger account in a prior period. I am noticing that items which appear to have originated in a Movement Journal have slightly different values than what is posted to the general ledger. The inventory period has been recalculated and then closed.

Example:

In the Movement Journal, I have an entry for a physical count adjustment removing 3 Each at $145.00, for a total of -$435.00.

In the General Ledger, my Inventory Account is showing a credit and my Inventory Adjustment Expense account is showing a debit of $436.12.

We are on Weighted Average cost method, so cost for all transactions is recalculated and adjustments are made at the end of the month when inventory closing is run.

My questions:

1) Why is there a discrepancy between the Movement Journal and the General Ledger? If cost is recalculated at month end, I would expect the recalculation to be reflected everywhere the voucher is posted.

2) Since there is a discrepancy, does anyone have an idea where I might look in the setup to see where the difference is being posted (and to verify that it is being posted someplace!)

Hi PaladinSteve,

What is the cost price that is setup in your item master?

I would assume that it is 145$ per item.

Can you verify that?

Can you also check the current running average price of the item for example by checking it via the on-hand form?

I would assume that the price is different probably 145,37$ (436,12$)

If so, then please check the inventory transactions that have been posted.

They should show you 436,12$.

Provided that my assumptions are correct, there is nothing wrong in AX as the cost Price that you see in the Journal is not necessarily the one that is used for posting. It might be confusing from a user perspective - agree. Yet, for reconciling GL and inventory you cannot simply use the amounts you see in the inventory Journal but rather have to check and compare the inventory Transactions.

Would be great if you could double check your postings and update us.

Many thanks and best regards,

Ludwig

Quick Links