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.
Lists inventory transactions.
|T.TransactionType||Transaction Type Name|
|T.Source||Source Warehouse Name|
|T.Target||Target Warehouse Name|
|T.ItemGroup||Inventory Item group|
|T.AccountName||Transaction’s Account Name|
Reports Inventory Consumptions.
|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.Added||Added to inventory|
|C.Removed||Removed from inventory|
|PC.||Periodic Consumtion Item reference|
|I.||Inventory Item reference|