Reporting Warehouse Codes

Hi All.

In the inventory items menu you can define the Group Code
Is it in any way possible to transfer this sorting to a report? It would make stocktaking much easier that way.

Here is an example of what I would like to see:

And maybe:

Thanks in advance

I made these example reports by doing this:

So they don’t actually report anything.

Any help would be appreciated. Thanks guys.

Take a look at some of the reporting tutorials.
Also the report template help button which shows available expressions.
They are generally in a format like this;

Colons split the expression into sections like type, fields/columns, filters/constraints, format etc.

Do you want to group Inventory report by Warehouse and Inventory Item group code like that?

This is the report template I’ve used.

[Inventory Report 2:4, 2,1]
{REPORT CONSUMPTION DETAILS:C.Name.asc,C.Prediction,C.Unit:(PCW=$1) and I.GroupCode="$2"}

How to configure consumption report per workperiod / day?

Nobody knows? It’s possible or not?

I think the default report ‘Item Sales Report’ should display the information you need.

Nope, this reort contain only products sales, without warehouse

Should not the Date filters in Reports do the job?

Maybe explain a littler more what you are looking for/want?

When I try to change date, I have the same result. I need to see consumption only per workperiod

Pls see my screenshots. Both the same.

I want to see this row on report

Do you have multiple workperiods in a day?

Emre’s sample report showed the prediction of what should be in inventory. If you change 'C.Prediction' to 'C.Consumption' you will see what was sold.

IIRC, all reports initially default to the work period.

Try this:

[Inventory Consumption by Warehouse:4, 2, 1]
{REPORT CONSUMPTION DETAILS:C.Name.asc,C.Consumption,C.Unit:(PCW=$1) and I.GroupCode="$2"}

Thank you, this code nice working.

1 Like