Hello Community,
I am building a Business Adapter, that would update cost center value of Purchase order line, based on provided .xlsx file.
Source of data is a spreadsheet with PO number, Name, Description and said new cost center.
I had some success with using business adapters previously, but I have a weird problem here. When I try to run it, nothing gets updated. There are no errors, but no desired effect either.
What's interesting, if I don't add Cost Center as a separate item and instead just go to Purchase Order Line item. enable Cost Center ID property, from source select "fixed value" and just enter hard coded Cost Center ID (from GroupEx table), then it works fine.
Any ideas what might be happening? I attached .xml file here
‎Jun 05, 2019 08:45 AM
‎Jun 05, 2019 08:51 AM
‎Jun 05, 2019 08:51 AM
‎Jun 05, 2019 08:59 AM - edited ‎Jun 05, 2019 09:03 AM
I usually run a minimal approach and allow the import to only update/create the objects I directly plan to update/create. This forces more strict planning and helps to minimize errors. Always keep in mind that data provided by others may contain errors - if now now, maybe later.
You write "nothing should change" - better make sure nothing does change. (If the PO changes, it should probably be another import.)
‎Jun 05, 2019 09:09 AM
‎Jun 05, 2019 05:36 PM