dimitrishuk
Member
dimitrishuk Sep 19, 2019 1:02 PMHi,
Hi All, we have a repeatedly cascading problem that is causing us a host of issues with "Item Ledger / Account Integrity". We are on JDE World A9.2.
Take the below example
G/L Date | Creation Date | Doc No | Description | Extended Cost (F4111) | Account Ledger (F0911) | Variance |
12/1/2018 | 16/10/2018 | OV18000137 | Landed Cost | 184,7000 | 184,7000 | 0 |
12/1/2018 | 12/1/2018 | OV18000109 | Inventory Receipt | 52.800,00 | 52.800,00 | 0 |
12/1/2018 | 12/1/2018 | IM14999 | Inventory Issue to Workorder | -14.919,53 | -14.896,62 | -22,91 |
Basically, inventories are received, they are sold or issued to work orders and debited from stocks in inventory ledger (F4111). There are many cases when landed cost is added in later in time (see creation date) with a different G/L date, totals and unit costs are recalculated, but all of a sudden all transactions that follow no longer balance with the G/L (F0911).
I'm personally stumped on how to fix this. The simple answer is not to receive inventory without landed costs, or just expense them when they are too late. Business on the other hand says that neither of these options are good enough. How does everyone else approach this?