Inventory and stock report

V5 Question
1

Hello everybody

I created a report to see inventory items stock and cost price. the only thing I want to add is the inventory prediction and the supplier name in it. I tried a lot of things but cant figure it out.
here is the report:

[Item Profit Margins:2,1,1,1,1,1,1,1,1]

Name|Group|Sales|Cost|Sale Price|Profit|Margin %|Barcode
{REPORT COST DETAILS:C.Name,M.GroupCode,C.Quantity,C.Cost,C.AvgPrice,[C.AvgPrice]-[C.Cost],([C.AvgPrice]-[C.Cost])/[C.AvgPrice]*100,M.Barcode}

image
image1920×1080 160 KB

2

Also want to add supplier name and sale price in this report:

@{REPORT CONSUMPTION DETAILS:I.GroupCode.asc::,}
[Inventory Consumption:5,5,5,5,5,5,5,5,5,2]

Item|Sell|Unit|InStock|Purchase|Removed|Warehouse|Cost

$1
{REPORT CONSUMPTION DETAILS:
C.Name.asc,C.Consumption.Sum,C.Unit,C.Inventory.Sum
,C.Added.Sum,C.Removed.Sum,C.Warehouse,C.Cost:I.GroupCode==“$1”}

image
image1920×1080 169 KB

3

Take out the >>, think there is a bug when using $ in title like that.

4

If you are trying to make purchase per supplier, I made something similar in this post.