InvoiceNum
​
​
​

ZeroImportedAccountsRec: When set, it zeroes all imported AR before importing new AR. Turn this on if reimporting.
​
​
​

CustomerID or CustomerID_Translation: It is recommended to use CustomerID as the preferred field. To join the table Translations to the Customers table, ensure the mapping is established. This field is required if OpenBalance is provided.
​
​

OpenBalance: It is recommended to include this field to indicate the remaining balance on the invoice. This field is only applicable to imported invoices.
​
​

LocationID or LocationID_Translation: While it is technically possible to run with just InvoiceNum and LocationID, it is recommended to include this field. Without LocationID, the field will serve no purpose.
​
​

Date: Although the invoice can function without the Date field, it is highly recommended to include it. Without a Date, the invoice is likely to be recorded on 1/1/2000, which may not reflect the accurate timeline of the transaction.

Will open the balance (unapply payment) to the amount mapped in the routine, for a given invoice number/date/customer. If an invoice is not found with the given invoice number/date/customer, then an o.
​
​

AR Aging will NOT automatically be available. Wait for the 15 minute sync to sync Invoices then Update Accounts Rec for this report.
​
​

Import Invoices First. If AR is imported before, this will cause AR on 1 invoice and the sales on a separate invoice.
​
​

Reports - 13140549 ForceSyncForUpdateAccountsRec.

Importing Accounts Receivable for historical purposes