Back to connectors… Back to Sage 300...

0 - The value assigned to field ID 462 does not match the field type. (4 replies)

Arline Welty
4 years ago
Arline Welty 4 years ago

Just curious how to interpret this message. Nothing is registering in Errors.txt, and the job does complete successfully. 

I'm using O/E Shipments to create an invoice from a shipment record in Sage 300 ERP.

I copied the data types from another successful job in this environment that does not throw any error even though I'm mapping the exact same fields. The difference is that I'm getting this message in the test Sage 300 company. But I still don't see how the data type would be different?

Then again, it does seem wrong that the Shipment Date (stored as decimal) would work - but it's mapped as Text in IMAN in the successful connector. Here's how I have both connector fields mapped, attached.

Thanks for any leads on troubleshooting this error and tracking down field ID 462.

 

https://www.realisable.co.uk/wp-content/uploads/2020/09/Sage300Fields.png
Support
4 years ago
Support 4 years ago

Arline, there are numerous instances of this message in our forum.

https://www.realisable.co.uk/sage-300/retrieving-field-type-from-sage-300-object-model/

Thanks

Arline Welty
4 years ago
Arline Welty 4 years ago

Point taken. Thank you. Found it! 🙂

Arline Welty
4 years ago
Arline Welty 4 years ago

Ok, I can see in the Sage 300 AOM that the field type for the field 'Invoice Date' in OE0692 is type "date."

But I keep getting that error, no matter how I set the field type in the map transform preceding the Sage 300 connector. I've gotten the error with types:

  • Text
  • Decimal
  • Integer
  • Date/Time

I've deleted & re-added the connector and I'm getting the same results. So what is the field type in IMAN that corresponds with 'Invoice Date' in OE0692 (type "date" )?

Support
4 years ago
Support 4 years ago

When pushing dates to Sage you need them in a proper date form (MM/dd/yyyy OR dd/MM/yyyyy) (the format is local to the server), not in the form yyyyMMdd as stored in the database.

 

 

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