Has anyone else sen this before and is able to reply with a solution?
I would set your destination to Dynamics GP- File and run the map so you are able to see the data in xml format. Maybe there is something going on in the background that you can't see or haven't picked up on in your original data.
First thing I did was to run the SQL statement against the SmartConnect database which eliminated the field being required.
UPDATE SmartConnect..[Field] SET Required = 0 WHERE Node = 'taPoHdr' AND TechnicalName = 'SUBTOTAL'
Step 2 was to mark the “Update if Exists” field to TRUE in the PO Header node.
End of story till it no longer is! LOL! Thanks…
i know a very old post, but wanted to say thanks to walt herman for his reply, this solved the issue i was having with trying to raise purchase orders using smartconnect 2021
the table structure has changed slightly, but the above answer gave enough information for me to make the change
i find it staggering that 3 years on that this field is still set to be required by default, when quite clearly it should not be.
If you would like to submit an answer or comment, please sign in to the eOne portal.