Order job erroring on both update and insert/update (3 replies)
David, what is your integration supposed to be doing? Is it updating Orders, creating Shipments? Can send screenshots of your mappings?
In respect to the field 13...this corresponds to the field id per the Object Model.
If you look at the Shipment Detail, it corresponds to a Date field. This should be supplied as a Date, not as in reverse yyyyMMdd format.
Thanks
Sorry, forgot to attach file.
Thanks for both tips. I will try both and report back.
The purpose of the job is to update existing Orders; there are a set of fields that are on both the Order header and detail lines that do not have to be in sync: Exp Ship Date, Req Delivery Date, Ship Via Code, Location. On initial create of the detail lines, the header values trickle to the details; however, updating the header fields later does not update the detail lines. Since the customer always wants the detail lines to be in sync with the header, and doesn't want to update dozens or hundreds of lines manually, this job will run hourly to set these fields at the detail level based on the header values.
I've built and have been testing a fairly simple job:
7/17/2018 03:45:51 CJEWYKED 424 Object required
7/17/2018 03:45:51 CJEWYKED 424 Object required
7/17/2018 03:45:51 CJEWYKED 424 The Accpac data import incurred an unrecoverable error and is quitting. [Object required]
7/17/2018 03:45:51 CJEWYKED 424 Error occurred whilst processing transform [CJEWYKED]. Object required
7/17/2018 03:45:51 CJEWYKED 10500 Transformation [CJEWYKED] has terminated.
7/17/2018 03:45:51 424 TransformCoordinator Job [CHEDAT_OEORD060] has aborted due to a transform failure.