I posted a question a few weeks ago in relation to mapping to sets of vendor transactions from two different ERP systems. I am attempting to link the old transactions to the new using mapping, which is linked to a spreadsheet.
Attached to this post you will find the script I am attempting to use, which doesn't fail to load all the data, but fails to link the data together. Is there something obvious I am missing?
Not sure that this is what I am after - I want the data to load, but, when the vendor is brought across from the old system, if there is a matching record in the new system, the new value of vendor name should overwrite the old value. If there is no new value, use the old vendor name.