Back to connectors… Back to Sage 300...

Retrieving Field Type from Sage 300 Object Model (3 replies)

Arline Welty
5 years ago
Arline Welty 5 years ago

Just a general question. How do I use the object model to discern which field type is being referenced in an IMAN message (sent from the sage API?) 

EG: "0 - The value assigned to field ID 47 does not match the field type."

How do I discern which field is Field ID 47?

Here's a screen snap of the object model open in a browser.  I believe the field must be INVDATE because I've been making changes to that field. But where can I see the link between INVDATE and Field ID 47? Is there a different way to view/use the AOM than what I'm doing?

 

https://www.realisable.co.uk/wp-content/uploads/2018/11/Field47.jpg
Support
5 years ago
Support 5 years ago

Arline, the date in IMan should be a date and NOT the reverse date format of yyyyMMdd.

Thanks

Arline Welty
5 years ago
Arline Welty 5 years ago

Hey, thanks for the reply- yes, I understand it needs to be date. My question, though is more about how to interpret the message from the Sage 300 API. How am I meant to understand that Field ID 47 = INVDATE? That's my struggle. I uploaded the screenshot of the AOM because while I see INVDATE, I don't see anything in the AOM that indicates that it is Field 47.

Support
5 years ago
Support 5 years ago

Arline, sorry, misinterpreted your query.

The field id can be found (or at least could be found) on the AOM if you access by the View vs. the Table per the attached screenshot.

 

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