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
15

That works great, I adjusted it a bit more for me, however I am now stuck on restricting it to just 1 Warehouse … so I does not show the other Warehouses as well, as otherwise its 5 pages with just Group names…

[Inventory Consumption by Warehouse:4, 2, 2, 2, 2]
|QTY|Unit|Cost|Total
@{REPORT CONSUMPTION DETAILS:C.Warehouse.asc::,}
@{REPORT CONSUMPTION DETAILS:I.GroupCode.asc::,}
>>$1
>$2
{REPORT CONSUMPTION DETAILS:C.Name.asc,C.Consumption.desc,C.Unit,C.Cost,[([C.Consumption]*[C.Cost]).Sum],:(PCW=$1) && C.Consumption>0 and I.GroupCode=“$2”}
>TOTAL COST|||{REPORT CONSUMPTION DETAILS:[([C.Consumption]*[C.Cost]).Sum],:(PCW=$1) && C.Consumption>0 and I.GroupCode=“$2”}

I tried replacing the (PCW=$1) with (PCW=Beach Bar) which worked in another report for me, but somehow here it does not work, as it then just puts the same consumption in every single warehouse…

Anybody has some advice?

Thanks

Max

16

I am terrible with reporting in SambaPOS. I am almost 100% certain that the report I shared with you was originally copied from somewhere else.

Have a look at this thread:

what I googled:
"CONSUMPTION DETAILS" "warehouse" site:forum.sambapos.com

1 Like
17

I know the feeling, I am struggling with this quite heavily, but was lucky to find it via an answer to another of my questions…

Just in case somebody runs into the same issue, here is the solution:

[Inventory Consumption Costs for Kitchen:6, 2, 2, 2, 2]
|QTY|Unit|Cost|Total
@{REPORT CONSUMPTION DETAILS:C.Warehouse.asc:(PCW=WAREHOUSE NAME HERE):{0}:,}
@{REPORT CONSUMPTION DETAILS:I.GroupCode.asc::,}
>>$1
>$2
{REPORT CONSUMPTION DETAILS:C.Name.asc,C.Consumption.desc,C.Unit,C.Cost,[([C.Consumption]*[C.Cost]).Sum],:(PCW=$1) && C.Consumption>0 and I.GroupCode="$2"}
>>TOTAL COST|||{REPORT CONSUMPTION DETAILS:[([C.Consumption]*[C.Cost]).Sum],:(PCW=$1) && C.Consumption>0 and I.GroupCode="$2"}

Thanks for the help and the tip…

Max

1 Like