Export A/R Invoices

Back Office Menu -> Daily Close Menu -> Daily Close 3 -> Export A/R Invoices

System Maintenance Menu -> Configure System Settings -> Automatic Job Scheduling -> Function XMLEXP5A -> runs Export A/R Invoices

This utility can be used to re-create the XML export A/R invoice file, if the parser has failed or the XML files were deleted.
This utility can also be used to directly generate a new XML export data file for a range of A/R invoices.
A record is written for A/R Invoice exports to the View Application Log.

Refer to Company Daily Close Parameters for the directory and parser setup used by the XML Export process with the option to email the resulting XML files to the operator currently signed in.
The feature to automatically capture and export AR invoices by XML transactions in Daily Close 3, can be activated in the Company Daily Close Parameters.

The ability to automatically capture and export the A/R invoice information can be setup to run automatically using Automatic Job Scheduling.
When this automatic scheduled export process is activated, then the A/R invoice file export is NOT triggered by the Daily Close posting process as well.

Note: If the option to Post Zero Dollar A/R Invoices On Account is NOT activated in the Support Application Parameters, any zero dollar invoices are omitted from the export files.

The prompts in this Export AR invoice utility are:

XML TRANSACTION#

Recreate XML Export file:
To reproduce an XML file from an existing export file, select the XML transaction from the Select XML Transaction# window.
If an XML transaction number is selected the other filters for this utility do not apply.

Export New XML file:
Leave the XML Transaction# field blank, to export a new XML data file for a batch of A/R invoices, using the selection prompts in this utility.

FROM CUSTOMER#

Enter the starting customer number for the selection range, or select a starting customer from the Accounting Customer Search window.

TO CUSTOMER#

Enter the ending customer number for the selection range, or select one from the window.

FROM POSTING DATE

Accept the default date or enter a starting posting date for the range of invoices.

TO POSTING DATE

Accept the default date or enter an ending posting date for the range of invoices.

ONLY INVOICES NOT EXPORTED

Uncheck this box to include all A/R invoices and finance charges in the selected range and export the data to an XML file type ARAR.

Note: Because this export file may include AR charges that have already been exported and have already been assigned an XML transaction number, no change is made to the contents of existing XML transactions when this new composite XML file is created.
Instead this new XML file will use the naming convention TRS_ARAR_yyyymmdd_hhmmss.xml where TRS represents the 3 digit company code, ARAR (Accounts Receivable) is the data type, yyyymmdd is the date, and hhmmss is the time of creation.

Check this box to select only AR invoices that are NOT already included in a saved XML transaction record.
The option is then provided to stamp the invoices in this file with an XML transaction#.

ASSIGN XML TRANSACTION#

This field is only enabled if Only Invoices Not Exported has been selected.

Check this box to create an XML transaction for future use, identifying this batch of A/R invoices as included in this trx file.
TRS_ARAR_000000000000000104556.xml where TRS represents your 3 digit company code, ARAR (Accounts Receivable) is the data type, and 00000000000000104556 is the sequential XML transaction number.

Uncheck this box to generate a one time XML export file identified by date/time in its name, but leaving the A/R invoices unstamped by any XML transaction number.

Finished?

Click ACCEPT to proceed or CANCEL to abort the export.