Discrepancies between inventory subledger and ledger balance

(0) Share

Report

Posted on by J.E

Hi,

I found out my users used the inventory movement journal with inventory account as offset to change item from license plate controllable to non controllable. And this cause discrepancy between subledger and ledger. (Subledger is lower than ledger approx. 1,000 EUR).

- They used it several times but only some of the inventories have difference output and input amount which cause this issue. (The inventory accounts are blocked for manual entry now)

- What I'm informed is it could be because of item model group: weighted average cost

- However, it seems the differences are from not only WAC but also STD. (we don't use FIFO for stockable item but only WAC, or STD)

Do you have any idea how to correct it?

Thanks in advance.

I have the same question (0)

All responses (12)

Answers (1)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi J.E.,

Posting an inventory movement journal should actually not result in a difference between GL and inventory.

Can you let us know how you identified this difference and what makes you think that specific inventory movement journal postings are responsible for this?

Many thanks,

Ludwig

Was this reply helpful? Yes No
J.E on at

Like (0)

Report

Hi Ludwig,

These are steps why I thought the differences are from inventory movement journal.

- 1st: compare Inventory value report and Inventory accounts per month, week and date. Then found specific date where differences start.

- 2nd: Check the transactions and found out it's from inventory movement journal by voucher number.

- 3rd: Extract the movement journal

- 4th: Generate Potential conflicts report and compare with the movement journal

=> here I found the input and output amount on potential conflict report are not 100% same as on inventory movement journal.

The left is inventory movement journal with item model group and the right side is from potential conflict report.

As you could see, -34.56(filled green) is not same as -38.40.

But I'm not sure why it happens on some items not for all. (see the lines in green box).

Thank you.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi J.E.,

Initially, I would focus on the movement journal entries where the inventory account was used as offset. It would be recommended to block the inventory accouts for manual posting.

Was this reply helpful? Yes No
J.E on at

Like (0)

Report

Hi Andre,

After I realize the inventory accounts are used, I blocked the accounts. But I have to clean up the differences also.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi J.E.,

Thanks for the update.

Is the number that starts with 7311 your item?

What's the number starting with JU in the second column. Is this your voucher number?

If so, can you share the voucher and the transaction origin of that voucher?

Many thanks,

Ludwig

Was this reply helpful? Yes No
André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi J.E.,

It is good that the accounts are blocked now. However, to correct these entries, you probably have to temporarily disable the lock for these accounts and make reversals.

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

Report

Hi J.E,

I believe, your issue can be solved by using "Inventory Marking" option.

As Andre mentioned, Please untick "Do not allow manual entry" option on your inventory accounts to post reversals.

1. As first step, take the back up of your PRD environment since you are going to perfrom inventory adjustment (Super critical activity i must say)

2. Deploy the latest back up of your PRD on your Test environment.

3. Have you prepared the list of transactions from potential conflict report? It will be great if you can prepare the list.

4. If you can find the movement journal number and lot ID which are affected then you can use these information in the marking function.

5. Create new movement journal (with Invert Sign), select product ID, site & warehouse and quantity, System will populate your current item running cost.

6. Click on "function" button and select Marking option, search for your journal number and Lot ID. then mark the check box and click on apply.

7.Finally click on OK, The marking form will be closed and you can post the transaction.

As per system functionality, Please note the marking option doesn't work with standard costing products.

Was this reply helpful? Yes No
J.E on at

Like (0)

Report

Yes,

The below screenshot is for the item on above example from movement journal and transaction origin.

Was this reply helpful? Yes No
J.E on at

Like (0)

Report

Hi Junaid,

Okay, I will try. But I'm not familiar with the movement journal, please could you explain me or share any link for "Function" menu?

Does this also work for closed inventory? The discrepancies on closed inventory period.

And do you know how it could be fixed for STD cost products?

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

Report

Hi J.E,

In order to post the adjustment journal in the same month, you have to open inventory period. You can discuss that with finance team if you want to post adjustment in different month.

1. Navigate to Inventory management > Journal entries > Items >> movement

2. Click New > enter Name, Site and Warehouse.

3. Click OK Lines form will appear

4. Select product ID, site & warehouse and - quantity(With invert sign), System will populate your current item running cost.

5. Click on "function" button and select Marking option, search for your journal number and Lot ID. then mark the check box and click on apply

6. Finally click on OK, The marking form will be closed and you can post the transaction.

Here you go with inventory journal MS docs link:

https://docs.microsoft.com/en-us/dynamics365/supply-chain/inventory/inventory-journals

In case if you want to know about what is inventory marking and how it works: (Build on AX 2012 but worth to read it)

www.sikich.com/.../

Was this reply helpful? Yes No