Integrity Item Ledger/Account
Running an integrity report (R41543) i came across an 3038 error (item ledger and G/L do not balance) for a IT document type, the report shows a variance between the item ledger and the account ledger of -27840.
I retrieved all Item Ledger (F4111) and Account Ledger (F0911) records for the report line being evaluated, querying on the document number, type and company.
The transaction, is a item transfer, within the same branch plant (SFW) but into a different location (from location EX401 to location KILAB), as i understand the first line (the original location) of the transaction should be a negative quantity and the second line should be positive, indicating that there´s been an increase of items in the new location, however this two lines are negatives. If i sum both lines, it add up to -27840 wich is the variance shown in the report.