AP and GL not reconciling

[benny]

Hi Members,

We had recently worked through an SR to fix an invoice which had an issue after being cancelled. After we had got it fixed user has said that there is a difference b/w AP and GL PSOB and RSOB. User has given the difference through an external system and says its the same invoice causing the difference.

The question is how can we find out if the invoice fixed by the SR is causing the difference in GL? Is there a way that we can find which invoice (Liability line) is causing the difference in oracle GL? Any reports or such to locate the cause of difference.

Your replies are truly appreciated.

Rgrds
Ben[?]

[karthikeyanp1981]

Hi Ben,

System will not say it straight forward.
If there is an issue which is known by system, it would have prevented in either validation or accounting or period close or transfer to GL or journal import. Since we have crossed all that, will assume,there is nothing wrong with the system.
Now you are facing issues in Invoices alone, you need to run reports from GL and AP and export the outputs to excel and do a manual reconciliation (Vlookup in excel can help a bit)
Report to run from payables is = Posted invoice register
Report to run from General Ledger is = Account analysis report OR You can switch to journal and review the journal of the batch with category 'Purchase Invoices' and source as 'Payables', export the entries to excel.

OR

Open the journal batch with purchase invoices category in GL, and search by amount (using find option), then use drill down feature to check the base record of the journal entry.