By using this website, you agree to our Terms of Use (click here)
Another one I'm hoping ARC can help me with. 🙂
One of my clients has changed banks, and wants to update the payment method for all vendors. The import scenario to do this is simple enough, however in doing so the Payment instructions (account details) are removed.
Despite a few attempts I've been unable to compile a scenario to export the existing details or import them.
Any expert advise would be greatly appreciated!
Nic
Hi Nic,
I wasn't able to figure out how to do all fields in the same import scenario, but I do have a way to do separate import scenarios for each field.
Here is the import scenario that I used:
The whole key is the row that says <Line Number>
The numbering starts with 0, then 1, then 2, etc. So a <Line Number> of 1 actually means line 2 (Beneficiary Name) in the screenshot below:
Does this make sense?
Thanks Tim,
Attached is the scenario I ended up using. This scenario allows for all lines to be imported from a single file but requires three separate rows on the spreadsheet.
Nic
Oh wow, this is MUCH better than what I was able to do. Very nice that you were able to include all of the fields in one import.
And thanks for attaching the import scenario!
Old post, but still helpful!Adding to @nwood - In my case (v:20.207.0012)i added multiple lines and it required COMMIT on the value in addition to the description. If i just had Commit on the details row as in your XML, the import did not fail, but if any fields in the data provider happened to be empty, the subsequent lines got unaligned.
Thanks to the previous posts I was able to use the attached to import multiple Payment Instruction fields on one line.