Section 11: Exporting Data > Data Exports from Ledgers

Exporting Inventory Ledger

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 (for credit notes, for purchase orders, for repair orders, and 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:

Custom Data Exports