GetParent formula (1 reply)
Hi Dane,
The GetParent function takes two arguments fieldName, and transaction. See the documentation by following this link.
Properly written your formula looks like this:
Iif(GetParent("DocumentType", "TransactionName") = 1, %DetailedBilledAmount *-1,%DetailedBilledAmount))
Substitute TransactionName for whatever transaction the parent field is on.
Hi: I am trying to construct a formula in invoice details based on a value in the header. Basically, I need the detail amounts to be multiplied by -1 if the document type is an invoice. My formula is IIF(GetParent("DocumentType" = 1, %DetailedBilledAmount *-1,%DetailedBilledAmount). The error message is that too few arguments have been supplied for the GetParent function. Ideas?