Hi, I would like to know how to export the entire inventory including departments, categories, items, cost price and selling price as well as UPC for V5 into a csv file preferably.
Before posting a new topic try searching your post name such as “Inventory Data Export”. There is a data export option in the reports tab. You can do something like this.
If you need to cross reference products with inventory you’ll likely need to create a custom SQL report or see if you can meet your needs with available report tags.
REPORT INVENTORY TRANSACTION DETAILS
Lists inventory transactions.
| Field | Description |
|---|---|
| T.TransactionType | Transaction Type Name |
| T.Name | Transaction Name |
| T.Date | Transaction Date |
| T.Time | Transaction Time |
| T.Source | Source Warehouse Name |
| T.Target | Target Warehouse Name |
| T.ItemGroup | Inventory Item group |
| T.AccountName | Transaction’s Account Name |
| T.Unit | Unit Name |
| T.Multiplier | Multiplier Amount |
| T.Quantity | Quantity |
| T.TotalPrice | Total Price |
| T.Price | Price |
| D. | Document Reference |
REPORT CONSUMPTION DETAILS
Reports Inventory Consumptions.
| Field | Description |
|---|---|
| C.StartDate | Consumption period start |
| C.EndDate | Consumption period end |
| C.Name | Consumption period name |
| C.Unit | Consumption Item Unit |
| C.Inventory | Consumption Item Inventory |
| C.Prediction | Consumption Item Inventory Prediction |
| C.Warehouse | Consumption Item Warehouse |
| C.InStock | In Stock |
| C.Added | Added to inventory |
| C.Removed | Removed from inventory |
| C.Consumption | Consumption |
| C.Cost | Cost |
| C.PhysicalInventory | Physical inventory |
| PC. | Periodic Consumtion Item reference |
| WC. | Consumtion reference |
| I. | Inventory Item reference |
1 Like