Greetings gathered Genii!
On the item card there is a flow field which shows the sum of outstanding quantities of each item which is currently on purchase order. Quite rightly, this quantity does not include any qty on blanket order.
When you drill down through this field, you see the purchase line form with a table filter applied. I want to permanently modify the table filter applied to this form from Document type = Order to Document type = Order|Blanket Order so that I can see at a glance if I have any quantity on Blanket Purchase order. I tried modifying the calc formula of field 84 of the line table to
Sum("Purchase Line"."Outstanding Qty. (Base)" WHERE (Document Type=FILTER(Order|Blanket 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)))
but this affects the vlaue shown in the field on the item table, whcih I dont want to do.
Any ideas or hints would be greatly appreciated.
Matt
0
Answers
What I would do in your shoes is copy the field, change the flowfield definition on the new field, and leave the existing one alone.
RIS Plus, LLC
MVP - Business Apps
RIS Plus, LLC
MVP - Business Apps