This data export includes all records from the payments ledger (see Payments).
The data export defaults to the comma-delimited (.csv) file format. It may be filtered by the range of dates that the transactions were recorded.
Export Option Fields
Field |
Description |
Date Range |
Enter or select the starting date for records to include in the exported data or leave blank for all records before the ending date. Also enter or select the ending date for records to include in the exported data or leave blank for all records after the starting date. The date range is based on the dates that the transactions were recorded. |
Exported Fields
AYS Field |
Exported Field |
Type |
Notes |
|
BillingCustomerNumber |
Number |
|
|
FormType |
Text |
A list of characters representing the various modules for which the transaction applies (C for credit notes, P for purchase orders, R for repair orders, and S for sales invoices) |
|
FormNo |
Number |
The number of the record for which the transaction applies |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Location |
Text |
Business location ID for the inventory store to which this item belongs (Shared for the shared inventory store) |
|
Quantity |
Number |
Quantity of the part added to or removed from inventory |
|
Price |
Number |
Monetary value of the items added to or removed from inventory |
|
RecordDate |
Date |
Date and time that the transaction was recorded in the ledger |
|
TransactionDate |
Date |
Date for which the transaction applies |
Exporting the inventory ledger is available only for licensed users of version 3.1 and higher, and is available only in the Repair SQL, Repair, and Repair Mobile editions.
More: