Also, it appears that case has to be the same as well now.
Works in pre-4.0: Requesting field "Available" works.
Doesn't work in 4.0: Request field "Available" doesn't work. Must match case with Lookup.
Hi Randy, thanks. I'll try and reproduce here and get back to you.
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
When using a Lookup we are getting the following error from IMan:
"Error while processing lookup [(lookupname)]. Return field [(fieldname)] is invalid."
After some research I found that in pre-4.0, you do not need to surround an alias field in quotes, In 4.0, you have to or you get the above confusing error.
Works in pre-4.0: [QTYONHAND]-[QTYSHNOCST]+[QTYRENOCST]+[QTYADNOCST]-[QTYSALORD] as available
Doesn't work in 4.0: [QTYONHAND]-[QTYSHNOCST]+[QTYRENOCST]+[QTYADNOCST]-[QTYSALORD] as available
Fix: You have to surround the alias in single quotes.
However this is a breaking change that doesn't appear to be checked with the "V4 Upgrade Checker"