Colin,
Connect a filter transform to hierarchy. In field mapping tab Header level , create new field with the following formula
Sum("detailfield", "DetailLines") = 0. This will filter out all orders that have a line that is out of stock.
Please see https://www.realisable.co.uk/support/Documentation/iman-user-guide/Reference/AggregateFunctions.htm# for further information
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
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
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
Hi , Using IMAN 3.2
After applying a hierarchy is it possible to use a MAP transform to calculate a header field based on the detail fields?
I have a detail field which calculates out of stock items. 1 = Out of stock, 0 = In Stock.
I need to filter the whole record based on whether ANY of the detail lines are Out of Stock.
I was therefore hoping to have a field on the header which can be marked 1 or 0 based on if ANY detail rows = 1
Thanks
Colin