Sage 100

I have a client that gets multiple updates from their vendors with pricing and cost updates. The item code is an alias. I want to update the CI_item using the alias. I have not tested but do not believe importing will trigger the business object to translate back to the item code. Anyone addressed this through perform logic or enhancement to resolve this one. The client is on 2016 PU3.

Idea: Import to a blank UDT, with a UDS on the UDT to look up the item code from the alias table. Then run a second job to import from the UDT.

How often does it happen? Would a script that 'pre-processes' the file to replace the aliases with the real item code be allowed?

That is what we started by addressing. I just thought since SO converts alias to item number, there might be something already developered or implemented with a script that translates the alias to item when not found in the item masterfile. We are only updating current records. @JimWoodhead or @AlnoorCassim