Reporting Warehouse Codes

V5 Question
1

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

2

I made these example reports by doing this:

So they don’t actually report anything.

Any help would be appreciated. Thanks guys.

3

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;
{REPORT EXPRESSION DETAILS:COLUMN1,COMULMN2:FILTER/CONSTRAINT EXPRESSION}

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

4

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

image.png3429×1832 566 KB

This is the report template I’ve used.

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

How to configure consumption report per workperiod / day?

6

Nobody knows? It’s possible or not?

7

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

8

Nope, this reort contain only products sales, without warehouse

9

Should not the Date filters in Reports do the job?

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

10

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

11

cons2
cons21018×684 30.3 KB
cons1
cons11035×666 29.8 KB

Pls see my screenshots. Both the same.

cons3
cons31366×768 74.6 KB

I want to see this row on report

12

Do you have multiple workperiods in a day?

13

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]
|QTY|Unit
@{REPORT CONSUMPTION DETAILS:C.Warehouse.asc::,}
@{REPORT CONSUMPTION DETAILS:I.GroupCode.asc::,}
>>$1
>$2
{REPORT CONSUMPTION DETAILS:C.Name.asc,C.Consumption,C.Unit:(PCW=$1) and I.GroupCode="$2"}
2 Likes
14

Thank you, this code nice working.

1 Like