Back to forum list… Back to Issues and Problems...

Iman v4.1PU5 Aggregate step does not like the GetParent function (1 reply)

Sue Herrmannn
4 years ago
Sue Herrmannn 4 years ago

This is the second time I've actually run into this issue. The aggregate step does not like the use of a GetParent function in a formula. The first instance was on a job where I was subtotaling an amount at the GL Entry Header level. Then I built an aggregate step at the detail level that added a detail line where the gl amount was the total from the header plus another value at the detail level. No matter how many fields I set to decimal - it kept treating the two numbers like strings, so instead of adding 2 +3 = 5, it would give me 23.

Today, I was working on an order posting job, and I wanted to pull the Order Header location into a conditional formula at the line item level in the aggregate step. We insert a catalog item onto the order and want it to ship from the same location as the rest of the order. Again, I used the GetParent function to pull the value of the order header location, and it ignored it. So, I had to go to a prior map step and build a formula at the line item level with GetParent to grab the value and then had my conditional formula in the aggregate step just look at that formula.

All that to say, there is something "hinky" when you combine the GetParent function with the aggregate step. thanks!

Support
4 years ago
Support 4 years ago

Sue, it will depend on the function, but this is easy to fix by forcing the value returned by GetParent to a numeric value.

CCur(GetParent("Field1", "Record")) + CCur(GetParent("Field2", "Record")) 

Thanks

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