Inventory Transaction Report report with Target Warehouse

V5 Question
1

Hey guys, hope all is in good health.
I am try to create an Inventory Transaction Report that will list a Target warehouse then the items listed under the Warehouse Name.
E.g.
Items----------------------------QTY-----------------Unit-----------------Price----------------Total
Bar Warehouse
Mosi------------------------------50-----------------Bottle----------------5----------------------500
Kitchen Warehouse
Salt-------------------------------500-----------------Grams-------------10---------------------5000

I have done this :point_down: But my items are not showing

[Item Purchases:2, 1,1,1, 1]
>Items|QTY|Unit|Price|Total
@{REPORT INVENTORY TRANSACTION DETAILS:I.Target,T.TotalPrice.sum.desc::{0}:,}
>>$1
{REPORT INVENTORY TRANSACTION DETAILS:T.Name,[T.Quantity.Sum],T.Unit, 
[T.TotalPrice.Sum]/[T.Quantity.Sum],T.TotalPrice.Sum.desc:I.Target="$1"}
>Total||||{REPORT INVENTORY TRANSACTION 
DETAILS:T.TotalPrice.Sum.desc:I.Target="$1"}
>>Grand Total||||{REPORT INVENTORY TRANSACTION 
DETAILS:T.TotalPrice.Sum:I.Target}
2

I.Target is a field and I dont think you can use it as an expression.

Try (ITT=xx)

3

Hey tried but still nothing…

4

Can you show me how you used Inventory Transaction Type in this ITT expression?

5 
[Item Purchases:2, 1,1,1, 1]
>Items|QTY|Unit|Price|Total
@{REPORT INVENTORY TRANSACTION DETAILS:I.Target,T.TotalPrice.sum.desc::{0}:,}
>>$1
{REPORT INVENTORY TRANSACTION DETAILS:T.Name,[T.Quantity.Sum],T.Unit, 
[T.TotalPrice.Sum]/[T.Quantity.Sum],T.TotalPrice.Sum.desc:(ITT=$1)}
>Total||||{REPORT INVENTORY TRANSACTION 
DETAILS:T.TotalPrice.Sum.desc:(ITT=$1)}
>>Grand Total||||{REPORT INVENTORY TRANSACTION 
DETAILS:T.TotalPrice.Sum:I.Target}

Hope its what you meant I do?

6 
[Purchases by Group:1, 1]
{REPORT INVENTORY TRANSACTION DETAILS:T.ItemGroup,T.TotalPrice.Sum}
>Total|{REPORT INVENTORY TRANSACTION DETAILS:T.TotalPrice.Sum}

[ENTRIES by WAREHOUSE:3, 2, 2, 2, 1, 2, 2]
@{REPORT CONSUMPTION DETAILS:C.Warehouse.asc::{0}:,}

>>Item|Purchased|Transfers|Result|Unit|Unit Cost (K)|Total Cost (K)
>>$1
{REPORT CONSUMPTION DETAILS:
C.Name.asc,
C.Added.sum,
C.Removed.sum,
[C.Added.sum]-[C.Removed.sum],
C.Unit,
C.Cost.sum,
[C.Cost.sum]*[C.Added.sum]:C.Added>0 and (PCW=$1) or C.Removed>0 and (PCW=$1)

}

This seemed to have done the trick