i have created a flow field in the vendor table in which i would be needing the balance of the invoices with on hold column having a value of ''Y' from the vendor ledger entry table. below written is the calcformula
Sum("Vendor Ledger Entry"."Remaining Amt. (LCY)" WHERE (Vendor No.=FIELD(No.),On Hold=FILTER(<>'')))
but i am getting the below shown error
please help me.
I guess field you try to sum is a flowfield itself.
Probably you should sum fields from table Detailed Vendor Ledg. Entry.
I am guessing from nav v.4 perspective.