Inventory cost reports according to group code

[andrej305]

Good Day

I have a customer that is still on version 4 and very adamant.

Is there a way to get a inventory report sorted by group code. Even if it is a sql report.

Like this one from version 5

[Inventory Prediction Report:2, 1, 1, 1]

Name|Unit|Used|Prediction
@{REPORT CONSUMPTION DETAILS:I.GroupCode::{0}:,}
$1
{REPORT CONSUMPTION DETAILS:C.Name,C.Unit,C.Consumption,FN([C.Prediction],‘0.0’)].desc:I.GroupCode=“$1”}

Help with inventory cost reports according to group code

Kindly help me to include list of groups code orderly Inventory Cost Report:1, 1, 1, 1, 1] Item|Unit|Inv|Cost|Total {REPORT CONSUMPTION DETAILS:C.Name,C.Unit,C.Inventory, C.Cost, ([C.Inventory][C.Cost])} Totals||{REPORT CONSUMPTION DETAILS:C.Inventory.sum, C.Cost.sum, [([C.Cost][C.Inventory]).sum]}

Kind Regards