This data export includes all records from the inventory ledger (see Inventory).
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 |
|
RecordDate |
Date |
Date and time that the transaction was recorded in the ledger |
Part Number |
PartNumber |
Text |
Unique system part number of the inventory item |
Location |
Location |
Text |
Business location ID for the inventory store to which this item belongs (Shared for the shared inventory store) |
Item Description |
ItemDescription |
Text |
Item description |
Storage Bin |
StorageBin |
Text |
Bin in which the inventory item is located |
|
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 |
|
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 |
The item description field is not stored in the ledger but is determined by the current item description assigned to the corresponding part number and inventory location.
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: