The attached spreadsheet puts into perspective the number of FGS sales order lines with no item ledger record, 21K+ sales units since 1 January 2016.
This is due to missing or incomplete item set up for summary and availability, missing primary location = 6000WIP and secondary = DESPATC H.
Of the 113 items this related to, 29 items still remain set up incorrectly – per highlighted in red on “items list”.
The remaining items have since been corrected with WIP and despatch.
Since only the sales transaction has occurred for these documents per R42800 sales update, ie debit COGS, credit inventory (6000.1051), I would be interested to know what and how they have been doing FGS inventory rec (6000.1051) and WIP (6000.1020). As the WIP relief inventory issue GL entry never happened ie to CR WIP 6000.1020 and DR FGS 6000.1051.
If Saichon would like further guidance or training on how these transactions occur and how best to tackle the recs, feel free for her to contact me on my working days, Wednesdays to Fridays.