Sage 100

I have several Sales Order Entry imports and the source files have country names, not codes. What's the best way to assign a country code based upon the name? I can make a bunch of conditional assignments, but that's lame. How do others handle this issue?

Conditional for me. Or use access to link in a country table

If it's a one-time import, I'd just do it in your source file. If it's an ongoing import routine, I'm guessing there's some perform logic you could incorporate into the VI job. Another option if it's an ongoing import is to first bring your source file into Access and have it pull in the Country Codes from MAS. Or might it be a possibility to include the Country Codes on the source file generation side?

Thanks. No option to include country code in source file, and this is an ongoing import. Didn't know if I was missing something. tried creating a system UDT (to validate country name), but can't access it from the VI job. Will try using a module specific one, but don't have much hope.

For situations like this, we would go with an Access DB to message the data. One can be developed ""fairly"" easily so that the data is imported, then exported back out quickly. If the macro auto executed, you could probably create a batch file to make it part of the VI job.

I agree with @JeffSchwenk. That's probably the easiest way to do this.

Thanks guys. Was hoping not to get other software involved in the process, buuut...

Can you access the CU Tables on the import? CRM has a country conversion table in MAS since CRM uses full names. Might be worth turning on the CRM integration just to get to that table if you can.