IL/AS OF Integrity issue due to company split
Hi,
While doing the Historical clean of of IL vs AS OF i have come across a scenario which requires immediate attention.
Issue details:
Earlier we had company 01001(Norway) where we had transaction for Fuel as well as Lubes items. Later on it was decided that there should be a separate company for Lubes so split happend and 01002(Norway- Lubes) was created and then for Lubes items all the transaction have been happening in 01002 company.
Recently i have run the R41760 IL vs AS OF report for 01002(Norway Lubes) company and the report showed below integrity:
AS OF is showing 0 in Quantity and 177.04 in Amount for FY 14/Period 11 but item Ledger is showing -2 Quantity and -5387.06. When i dig deeper into this by checking the item ledger(Item/BP/Location), here is the item ledger screen shot for FY14 period 11