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

Return field is invalid - False positive (No replies)

Randy
8 months ago
Randy 8 months ago

I'm having an issue with IMan Lookups.

The lookup attempts to pickup 4 fields from ICITEM.  For some reason, recently the lookup stopped working with the error "Return field [DEFPRICLST] is invalid."

The lookup works when I look for a different field from the SELECT part.

The lookup works when I run it as a query in MSSQL.

I copy-pasted to confirm the fields are the same, and my above query confirms it.

Please see attached images.

Very confused.

https://www.realisable.co.uk/wp-content/uploads/2023/08/2023-08-16_20-14-32.png
https://www.realisable.co.uk/wp-content/uploads/2023/08/2023-08-16_20-14-10.png
https://www.realisable.co.uk/wp-content/uploads/2023/08/2023-08-16_20-14-05.png
https://www.realisable.co.uk/wp-content/uploads/2023/08/2023-08-16_20-14-48.png
https://www.realisable.co.uk/wp-content/uploads/2023/08/2023-08-16_20-14-42.png

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