Data Export for Inventory

V5 Question
6

You’ll use custom reports to prepare your report. For example:

[Inventory Report:1,1, 1]
{REPORT CONSUMPTION DETAILS:C.Name,C.Unit,C.Inventory}

You can use this report to export data. For example you can create a new Data Export as shown on the topic I’ve referenced and add this as export template.

{REPORT CONSUMPTION DETAILS:C.Name,C.Unit,C.Inventory::{0},{1},{2}}

That will put commas between fields.

Here are possible REPORT CONSUMPTION DETAILS Fields.

C.StartDate
C.EndDate
C.Name
C.Unit
C.Inventory
C.Warehouse
C.InStock
C.Added
C.Removed
C.Consumption
C.Cost

2 Likes