Dealing with late landed costs and integrity issues
Hi,
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).