AR EDI batch inquiry/maintenance
A customer may choose to make payments directly into the company bank account rather than send a cheque. In order to record the payments, an EDI (Electronic Data Interchange) file must be received from the bank. Direct Debits or monthly subscription debits can be processed as EDI transactions. AR EDI batch inquiry shows all such payments grouped into EDI batches. Details shown are: the date when the batch was created, the status of the batch, how many payments were included in that batch and the total value of the batch.
- In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > Debtors EDI > AR EDI and then double-click Debtor EDI Batch Inquiry. ARM310 A/R EDI Inquiry panel appears listing the batch details.
- Select the Batch number and click option Detail to inquire on A/R EDI batches. ARM310 A/R EDI Inquiry panel appears.
| Option | Description |
| Invoice detail | Shows the invoice reference and the payment amount. |
| Payment details | Shows the payment details. |
To maintain details of a batch use the menu option A/R EDI Batch Maintenance.
- In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > Debtors EDI > AR EDI and then double-click Debtor EDI Batch Maintenance. ARM310 A/R EDI Maintenance panel appears listing the batch details.
| Option | Description |
| Detail | Shows the customer number, document date and the payment amounts that make up the batch total. Delete option here, allows a sequence to be deleted (so invalid customer entries can be removed). |
| Check | Allows you to run the AR EDI Validation report to check for any errors in the EDI transaction. If the batch is error free then the status changes to V – batch verified. The EDI batch statuses are defined in control file TMSAR/ED-ESTS. |
| Recalc totals | Recalculates the batch header totals from the details. If the batch is in error, Delete option via Detail can be used to remove invalid entries and Recalc totals can used to calculate the total again. |
| Process batch | This would process the batch that has been validated (status V – batch verified). After processing the status would change to C – completed processing. |
| Delete batch | Removes a batch from the batch header. A batch with status C can not be removed as it is already processed. |
| Function | Description |
| Show open/all | This function toggles to show open & all EDI batches. |
AR EDI batch process report/update
- In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > Debtors EDI > AR EDI and then double-click Debtor EDI Batch Process Report for the report or Debtor EDI Batch Process Update to update the payment. XAR900 panel appears for the report or the update accordingly.
- Click OK.
| Note |
The Update menu option will automatically upload and process payment details supplied by the bank. Warning messages will be issued in the following instances and the payment will left as unallocated.
|
