Back to forum list… Back to How Do I?...

GetParent formula (1 reply)

DaneHoover
6 years ago
DaneHoover 6 years ago

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?

Support
6 years ago
Support 6 years ago

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.

 

 

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close