Share
Report
90I have created a flow field in job planning lines where it should give the sum of invoice quantity and show the invoice record when opining job invoices page. I wrote this code
CalcFormula = Sum("Job Planning Line Invoice"."Quantity Transferred" WHERE("Job No." = FIELD("Job No."),
"Job Task No." = FIELD("Job Task No."),
"Job Planning Line No." = FIELD("Line No."),
"Document Type" = filter(Invoice)));
Caption = 'Qty. Transferred to Invoice';
DecimalPlaces = 0 : 5;
Editable = false;
FieldClass = FlowField;
The same code is written in the base application table but without " "Document Type" = filter(Invoice))) " so when I click on the number , the job invoices page opens and show the filters but without any record.
All responses (
Answers (
