Operations AR - Download Lockbox File per Host in Multi-Site Mode

1. Navigate to "Accounts Receivable"

   To download payment records from the operations portal, navigate to the "Accounts Receivable" section.

   

2. Click "Accounts Receivable"

   Then, click on "Accounts Receivable". In order to access and update "Accounts Receivable" you will need to be set up either as an "administrator" or a "superuser", or "accountant", or have the following role: "paymentEdit".

   

3. Click the "Pull Payments to ERP" icon

   Next, click on the "Pull Payments to ERP" icon.

   

4. "Pull Web Account Payments" dialog box should appear

   The "Pull Web Account Payments" dialog box will appear.

   

5. You can mark the payment records as exported or not

   You can mark the payment records as exported or not. The default value is "Yes".

   

6. Select if you want already exported data to be included or not

   You can select if you want already exported data to be included or not.

   

7. Select Export File Format

   Next, you will be able to choose the file format you would like to download the payment records as. You can select CSV, JSON or API format. Standard EDI files are also supported such as EDI823XML and EDI820.

   

8. Select the Date Range

   Next, you can select the date range you'll be pulling the payment records from.

   

9. Enter Host Code

   Then, enter and select the host code of the site. In this example, we will use "metalsales".

   

10. Click "Submit"

    Once everything is all set, you can click the "Submit" button to generate your file. File output is dependent on your export format. Note: A maximum of 1000 payments will be pulled.

    

11. Payment Records has been downloaded

    Payment records for the host selected have been downloaded.