Dear all,
I’m trying to display “Qty. on Purch. Order” and “Inventory” on “Make PR to PO” form.
“Qty. on Purch. Order” is quantity of item which we’ve placed purchase order but not received yet.
“Inventory” is quantity of item which we’ve already received and not withdrawn yet.
Before issuing Purchase orders, users would like to confirm on “Make PR to PO” form how much quantity of item they have.
So I added 2 flowfields “Qty. on Purch. Order” and “Inventory” in Purchase Line table [39].
I refered to the Item table[27].
In Item table,“Qty. on Purch. Order” - Properties CalcFormula’s value as below
Sum(“Purchase Line”.“Outstanding Qty. (Base)” WHERE (
Document Type=CONST(Order),
Type=CONST(Item),
No.=FIELD(No.),
Shortcut Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Shortcut Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Expected Receipt Date=FIELD(Date Filter),
Receipt Type=FILTER(<>Receipt),
Outstanding Qty. (Base)=FILTER(<>0)))
I copied this and added key to Purchase Line table as below.
Document Type,Type,No.,Variant Code,Drop Shipment,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Location Code,Expected Receipt Date,Receipt Type,Outstanding Qty. (Base)
SumIndexFields:Outstanding Qty. (Base)
But it didn’t work.
In item table,“Inventory”
Sum(“Item Ledger Entry”.Quantity WHERE (
Item No.=FIELD(No.),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Location Code=FIELD(Location Filter),
Drop Shipment=FIELD(Drop Shipment Filter),
Variant Code=FIELD(Variant Filter),
Lot No.=FIELD(Lot No. Filter),
Serial No.=FIELD(Serial No. Filter)))
I copied this and did not add any key to Item Ledger Entry table.
It worked fine.
Form “Make PR to PO” which source table is Purchase Line. So I’m afraid I can not sum SumIndexFields in the same table.
But I’m not sure.
Are there any way to display “Qty. on Purch. Order” on the form which source table is also Purchase Line?