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)

J.E on at

Like (0)

Report

RE: Discrepancies between inventory subledger and ledger balance

Good morning Ludwig,

What do you mean 'transactions recorded in the inventory module only doesn't seem to make sense to you'?

-> This is the movement journal with voucher

Ledger voucher from GL inquires: do you mean voucher transactions?

If yes, here is. One for (-) and one for (+).

Yes, all of the subledger transactions are moved, posted and the period task inventory recalculation and closing are also done months ago.

Just to make sure, I check there is no lines on the not yet transferred transactions form.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Discrepancies between inventory subledger and ledger balance

Good morning J.F,

I cannot get the issue based on the screenprints you shared.

In the journal lines, I can see a ledger account 131011.

The voucher is missing.

In the voucher transaction origin, I see only transactions recorded in the inventory module.

That does not seem to make sense to me.

Can you please try sharing the ledger voucher from the GL ledger inquiries form?

Also, are all of your subledger transactions moved to GL already or are some still pending?

There is a specific GL form for those not yet transferred transactions.

Can you check that one please?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

Report

RE: Discrepancies between inventory subledger and ledger balance

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
J.E on at

Like (0)

Report

RE: Discrepancies between inventory subledger and ledger balance

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
J.E on at

Like (0)

Report

RE: Discrepancies between inventory subledger and ledger balance

Yes,

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

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

Report

RE: Discrepancies between inventory subledger and ledger balance

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
André Arnaud de Cal... 297,421 Super User 2025 Season 2 on at

Like (0)

Report

RE: Discrepancies between inventory subledger and ledger balance

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
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Discrepancies between inventory subledger and ledger balance

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
J.E on at

Like (0)

Report

RE: Discrepancies between inventory subledger and ledger balance

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
André Arnaud de Cal... 297,421 Super User 2025 Season 2 on at

Like (0)

Report

RE: Discrepancies between inventory subledger and ledger balance

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