Hi Erik,
I am trying to get the ‘Reserve Qty on Sales Orders’ field transferred to the ‘722 – Physical Inventory List’ report. I have tried this a few different ways through FlowFields, Transfers etc. but I cannot seem to get it to work in any event. Initially I tried to transfer through to Sales Line, then Item Journal Line, but all values are showing as 0. Is there a better way to achieve through FlowFields or Report Calculated Fields?
Do you have a recommendation on how best to achieve this?
Best Regards,
Jack
That report run on the Item Journal Line table. I would create a new flowfield on that table, here’s the calculation formula:
CalcFormula = – Sum(“Reservation Entry”.”Quantity (Base)” WHERE(“Item No.” = FIELD(“No.”),
“Source Type” = CONST(37),
“Source Subtype” = CONST(“1”),
“Reservation Status” = CONST(Reservation),
“Location Code” = FIELD(“Location Filter”),
“Variant Code” = FIELD(“Variant Filter”),
“Shipment Date” = FIELD(“Date Filter”)));