0 - The value assigned to field ID 462 does not match the field type. (4 replies)
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
Point taken. Thank you. Found it! 🙂
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" )?
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.
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.