How to sort the Inventory Report by Product or Category?

V5 Question
1

Hi team,

We are working with inventory reports the last month, so we want to know if is possible sort the output, by Product Name (A-Z), or by Category (A-Z)

This is my output without order option

And this is my report code

[Inventory Report:2,1, 1]
{REPORT INVENTORY}

Regards

2

That is a hard coded report, you’ll need to re-make it yourself and sort it by ascending or descending order.

There has been an inventory report somewhere here in this forum, but I could not find it …

3

There are the following Report Tags for Inventory:

{REPORT CONSUMPTION DETAILS:X}
{REPORT INVENTORY TRANSACTION DETAILS:X}

This is how you sort by Item Name for example using .asc or .desc …

[Inventory Report:1, 1, 1,1]
{REPORT CONSUMPTION DETAILS:C.Name.asc,C.Inventory,C.InStock,C.Unit}
2 Likes
4

Thanks a lot QMcKay,

So… is possible sort the output by Category Name (A-Z) also?

5

There is no “Category” for Inventory. You can reference the following fields with I.<fieldName> …

I.GroupCode
I.WarehouseCode
I.Warehouse

For example, if we want to separate by Group Code, we make a list first with @, then use that value as $1 …

@{REPORT CONSUMPTION DETAILS:I.GroupCode.asc::,}
[Inventory Report:1.5, 1, 1,1]
>>Item|Inv|Stock|Unit
>>$1
{REPORT CONSUMPTION DETAILS:C.Name.asc,C.Inventory,C.InStock,C.Unit:I.GroupCode=="$1"}
1 Like
6

thanks a lot QMcKay,

I just format your report with decimal places, and works so good :clap:

@{REPORT CONSUMPTION DETAILS:I.GroupCode.asc::,}
[Inventory Report:2, 1, 1, 1]
>>Item|Stock|Inv|Unit
>>$1
{REPORT CONSUMPTION DETAILS:C.Name.asc,=N([C.InStock]),=N([C.Inventory]),C.Unit:I.GroupCode=="$1"}

Regards