Advanced CalFormula on FlowField

(0) Share

Report

Posted on by MateuszKILINSKI

170

Hello there. It is possible to make some kind of advanced Calculation Formula on flowfield? I need to count on the Sales Order Line qty of invoiced Purchase Order Lines which are connected with this Sales Order by Special Order. If the purchase order line are really connected to sales order line, there is no problem to count it using CalcFormula*:

Sum("Purch. Inv. Line".Quantity WHERE (Purchase Order No=FIELD(Special Order Purchase No.),Line No.=FIELD(Line No.)))

* Purchase Order No in "Purch. Inv. Line" tab is another FlowField where there is a purchase order number getted form purchase invoice header tab

Now, the problem is when the sales order line is not connected with special order. The calculation filter is:

Screenshot_5F00_2018_2D00_05_2D00_29-09.47.12_5F00_ABlydP.png

And the result is sum of all posted lines with line no 10000.

Is it possible to make depended calcformula on another field? Some kind of this: IF 'Special Order Purchase No' <> '' THEN ....

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

MateuszKILINSKI 170 on at

Like (0)

Report

RE: Advanced CalFormula on FlowField

Damn, silly me... Adding another filter Specjail Order Purchase no <> '' resolved this issue...