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

Unable to add filter condition on a field that should "flow" into the filter (3 replies)

John G
9 years ago
John G 9 years ago

(Images attached)

In my job I have a Sage 300 connector, a filter, and a File task that moves a source file under certain conditions.

The first condition is that %SYS.ERROR is empty, and that has been working beautifully for months.

I want to add another condition: Now I only want the file moved if TRNTYPE = 3.  When I enter the condition and click "Check", I get the error, "Field [TRNTYPE] is invalid" or "Field [AR0031.TRNTYPE] is invalid."  It is both mapped and assigned a Log Key in the Sage 300 Connector so it should flow through to the filter.  By the way, I only added LogKey when trying to get the filter to work; previously it was 0 but the field was mapped.  In any case, it should be available to the Filter according to the documentation.

https://www.realisable.co.uk/wp-content/uploads/2016/09/6Documentation.jpg
John G
9 years ago
John G 9 years ago

Apparently I can only attach one image per post.

https://www.realisable.co.uk/wp-content/uploads/2016/09/5Sage300Audit.jpg
John G
9 years ago
John G 9 years ago

Here are more images, I hope...

https://www.realisable.co.uk/wp-content/uploads/2016/09/1Transforms.jpg
https://www.realisable.co.uk/wp-content/uploads/2016/09/2Sage300Mapping.jpg
https://www.realisable.co.uk/wp-content/uploads/2016/09/3TRNTYPE_Invalid.jpg
https://www.realisable.co.uk/wp-content/uploads/2016/09/4AR0031TRNTYPE_Invalid.jpg
John G
9 years ago
John G 9 years ago

Figured it out

https://www.realisable.co.uk/wp-content/uploads/2016/09/1Transforms1.jpg
https://www.realisable.co.uk/wp-content/uploads/2016/09/3TRNTYPE_Invalid1.jpg
https://www.realisable.co.uk/wp-content/uploads/2016/09/2Sage300Mapping1.jpg
https://www.realisable.co.uk/wp-content/uploads/2016/09/4AR0031TRNTYPE_Invalid1.jpg

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