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
I changed this one setting and importer worked as I wanted
btw, do you think Purchase Order needs to be marked for Update as well? Nothing should change there, but those Items are connected.
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.)
If you do have multiple lines associated with a single purchase order number, try adding a line/sequence number to your spreadsheet that you can used as a second field for matching in the adapter to identify individual purchase lines to be updated.