Robert Robinson
Reputable Poster
When our staff reconciled A/P to the G/L this month, they found that the two main companies had issues in reconciling from A/P to G/L (in each case, the F0411 total is greater than the F0902 balance). They found this by comparing the A/P "as of" aging to the 902 balance on the account ledger; I confirmed it by running the A/P to G/L Integrity by Offset Account. The odd thing is that none of the "usual" items that cause integrity issues exist (companies are in balance, A/P for the previous months were in balance, no batch headers are missing, all detail G/L lines are posted, no batches are in error). However it looks like either 1) Invoices were entered against the F0411 detail that did not even appear on the F0911 side or, 2) Checks posted against (and relieved) the F0902 balance but did not hit the F0411 records. Was wondering if anyone had encountered this inexplicable situation (we have had some incidents where transactions halted in the middle of processing), and if so, what tools were used to solve the problem...to date, this has eluded all integrity reports...