I am working on a new project. I am scripting tasks that I have done similar in other projects. And, this time I am not getting the results I need.
I have 20 Transactions (Debit Amounts). I need to create the offsetting Credit Amounts. I export these to an XLSX file and import back to the table except importing the Debit Amounts to the Credit Account field. Our accounting software works with positive numbers only.
Here is my EXPORTED data file:
Here is my IMPORTED results:
When I am on the Mapping screen of the Import Step, I can scroll to see the records. But the Vendor ID and DocNumber are not imported. I have done it manually as well as scripted. Same. Any suggestions. I am trying to automate a process, that has relatively few transactions today, but who knows later.