Hi
I am looking to extend the purchase line with a flow field which will multiply the "qty to invoice" by the "Unit cost".
This is what I have so far.
field(50202; "lAmountToInvoice"; Decimal)
{
FieldClass = FlowField;
CalcFormula = sum("Purchase Line"."Unit Cost (LCY)" where("Document No." = field("Document No."), "Qty. to Invoice" = filter(> 0)));
}
This will just sum the unit cost but I want to multiply it by the qty to invoice.
Am I doing this the correct way is is there a better solution?
Thanks Neil.
