Automate ChartField Expense Mapping - Excel2CI Question
Version 9.10 Bundle #7, Tools 8.59.07
This topic has come up before related to a mass load of updates to chartfield expense mapping.
I have created an Excel2CI from the PYGL_CF_MAPPING component. I can get it to work, HOWEVER, it will NOT insert a new effdt record when it runs. It updates the existing records instead.
I am using the UPDATE action as I'm given to understand this will insert(?)
Perhaps this needs to be a 2-step process to somehow get the new effdt rows in of existing data, then an update to add in the 2 new items (one Deduction, one Tax)?