Faisal
October 13, 2020, 7:44am
1
Hello Everybody
i was trying to merge 2 tags i.e report consumption details and report cost details but its not lining up correctly. here is my report:
`[Item Profit Margins:2,1,1,1,1,1,1]
Name|Group|Sales|Avg Price|Portion|Inventory
{REPORT COST DETAILS:C.Name,M.GroupCode,C.Quantity,C.AvgPrice,C.PortionName}|{REPORT CONSUMPTION DETAILS:C.InStock}`
as you see its giving stock level for all the items instead of 1…
Faisal
October 13, 2020, 8:03am
2
Also this report not giving the required data:
[Inventory Consumptions:1,1,1,1,1,1]
Item|Opening QTY|Purchase|QTY Available for Loading|Sold
{REPORT CONSUMPTION DETAILS:C.Name.asc,C.InStock,C.Consumption.Sum,C.Inventory.Sum,C.Added.Sum:C.GetPhysicalInventory() < 2}|{REPORT COST DETAILS:C.AvgPrice}
{REPORT CONSUMPTION DETAILS:C.Name.asc,C.InStock,C.Consumption.Sum,C.Inventory.Sum,C.Added.Sum:C.GetPhysicalInventory() < 2}|{REPORT COST DETAILS:C.AvgPrice}
This syntax is incorrect and it will load two separate reports that will be separated by a column. You will have to use expressions to constrain the report with what you want it to show.
1 Like