| The Accounts Receivable Batch Reconciliation from and to GL Reports do not reconcile when using Service Management |
Cause | The AR Batch Reconciliation to GL report does not include non-invoice batches from Service Management.
Service Management sends transactions to General Ledger and to Accounts Receivable. The invoice transactions are posted to General Ledger through Accounts Receivable. The non-invoice transactions are also in the same batch from Service Management but posted directly to General Ledger. These Service Management non-invoice related transactions are included in the Accounts Receivable Batch Reconciliation from GL report but not in the Batch Reconciliation to GL report. The Batch Reconciliation to GL report only has invoice related transactions that pass through Accounts Receivable.
|
Resolution | Condition the Batch Reconciliation to GL report and print the SM to AR/GL Batch report
Print the Accounts Receivable Batch Reconciliation to GL report and condition it to exclude batches from Service Management:
- Go to Accounts Receivable, Reports, Reconciliation, Batch Reconciliation to GL.
- Click Conditions.
- Highlight the last condition and click Add.
- Create the condition:
Application of Origin - Not equal to - SM
- Click OK twice.
- Click Start to print the report.
To compare the Service Management invoice batches to Accounts Receivable and General Ledger:
- Go to Service Management, Reports, Reconciliation, SM to AR/GL Batch.
- Enter the date range if necessary.
- Click OK.
- The report appears on the screen and you may print it.
Note: This report may need to be added to the Service Management Reports menu.
DocLink: Accounts Receivable and General Ledger are out of balance
|
|