Inventory Transactions for specific Warehouse

V5 Question
1

I found an excellent Inventory transactions report which lists first all purchase by Group as a total and then the individual entries for each Warehouse, which works great, however I try to restrict this to just 1 Warehouse and whatever I try by restricting it does not seem to work…

[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)

}

I tried to use C.Warehouse == “BF CONSUMPTION” but that somehow does not seem to work, it still shows all transactions and summarizes as well all transactions and does not show the purchases by Group anymore, just a total (which is the whole total for all warehouses).

This is what I tried for the purchases and to be honest I am totally stuck on the filter for the transactions to just 1 warehouse

[Purchases by Group:1, 1]
{REPORT INVENTORY TRANSACTION DETAILS:T.ItemGroup,T.TotalPrice.Sum:C.Warehouse == “BF CONSUMPTION”}
>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)

Any help with this or pointing me in the right direction would be very much appreciated.

Max

2

try this one

go under Transaction Types in your Inventory ….for example mine is Bar Purchase Transaction Type, the first report i filter by Inventory Transaction Type (ITT=Bar Purchase Transaction Type)

Screenshot_10
Screenshot_10699×349 5.56 KB

then you change you first report where (ITT=Your Transaction Type Name)

[Purchases by Group:1, 1]
@{REPORT INVENTORY TRANSACTION DETAILS:T.TransactionType.asc:(ITT=Your Transaction Type Name):{0}:,}
>>$1
{REPORT INVENTORY TRANSACTION DETAILS:T.ItemGroup,T.TotalPrice.Sum:(ITT=$1)}
>Total|{REPORT INVENTORY TRANSACTION DETAILS:T.TotalPrice.Sum:(ITT=$1)}

then the next report you go under Warre house then you copy the Name of you warehouse and change this part on the report (PCW=Your Warehouse Name) to filter by warehouse

[ENTRIES by WAREHOUSE:3, 2, 2, 2, 1, 2, 2]
@{REPORT CONSUMPTION DETAILS:C.Warehouse.asc:(PCW=Your Warehouse Name):{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)

}
2 Likes
3

You are the man, works perfectly, thank you very much,

Max