R047024 A/P Payments To G/L By Batch

Rauf

VIP Member
For A/P integrity purpose, we ran the report R047024 A/P Payments To G/L By Batch.
We got a huge list of batches, but we are sure there should not be this much of records.

So, for some random batches, we ran R09301 General Journal by Batch Report, and could not find any balancing issues (i.e., total of debit and credit is zero)
I read some documents on the report R047024 A/P Payments To G/L By Batch, and understood that it checks F0414 Accounts Payable Matching Document Detail table.
Now, how can I fix issues with those batches, or is there any issue exist (as total of debit and credit is zero) in reality ?

One note to the above issue that, most or all the batches are having Inter company Settlements.
 

rsvconsulting

VIP Member
R04702A-A/P Payments To G/L By Batch-------Identifies out of balance payment batches. The report verifies that the Payment Amount (RNPAAP) in the AP Matching Document Detail table (F0414) is equal to the total Amount (GLAA) in the Account Ledger table (F0911) for each batch. The batch is printed on the report if the payment amount in the AP Matching Document Detail table (F0414) is not in balance with the Account Ledger table (F0911) amounts.



It is advisable to run the AP to GL Integrity by Offset Account report (R047001A) first.
If any differences are found on this report, run the following reports to check for unposted transactions:
Batch to Detail and Out of Balance (R007031)
Transactions to Batch Header (R007021)
Unposted Batches(R007011)
After the all transactions have been posted, run the following reports to identify out of balance transactions:
AP to GL by Batch (R04701)
AP Payments to Voucher (R04713)
AP Payments to GL by batch (R04702A)
If any differences are reported on the AP to GL by Batch report (R04701), run the AP to GL with Adjustments (R04711) in PROOF mode.
If any differences are reported on the AP Payments to GL by batch report (R04702A), run the AP Payments to GL with Adjustments (R04712) in PROOF mode to trace in details differences.
If the AP to GL Integrity by Offset Account report (R047001A)is still showing an out of balance condition after correcting unposted and out of balance transactions, run the following reports to verify the balance between the General Ledger table (F0911) and the Account Balances table (F0902):
Repost Account Ledger Report (R099102)
Account Balance to Transactions Report (R09705)
General Journal by Account Report (R09311)
 
Top