How to sort the Inventory Report by Product or Category?

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

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 …

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

Thanks a lot QMcKay,

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

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

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