I have added a new field to a table because I want to see for a particular PO, how many items have been received into inventory. This new field is a flowfield;
SUM(“Purchase Line”.“Quantity Received” WHERE (Document Type= CONST(Order), Document No.=FIELD(“Purchase Order No.”, Line No. = FIELD("Purchase Order Line No.))).
It has no trouble getting the SUM, but when I “Drill Down” to see the PO lines, sometimes it works okay and sometimes it flags a standard error message:
"The Purchase Header does not exist.
Identification fields and values:
Document Type=‘Quote’, No.=‘xxxxx’
Document Type:Quote, No.:xxxxx
In the flowfield calcformula I have clearly requested Orders only. Why does it even look for Quotes? Moreover, the Quote Document No does not exist, but the Order Document No. DOES exist.
Can anyone help explain this please?