Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Contributor
PhilMcIntosh
Posts: 23
Registered: 11-03-2008
0

Vendor Alias Import

Is there a way to force VI imports of vendor aliases to overwrite the existing vendor alias when there is one instead of creating a second alias record for the same item and vendor?
Switcher
SPyle
Posts: 905
Registered: 11-03-2008
0

Re: Vendor Alias Import

Which version are you using, and to which file are you referring?
Steve
Switcher
SPyle
Posts: 905
Registered: 11-03-2008
0

Re: Vendor Alias Import

If you are refering to the vendor records in IM.Alias, you cannot change the number because the alias is part of the key. 

 

An alternative procedure would be to import the Alias file into excel, make your changes there and then purge the IM.ALIAS file and then import the replacement.  Before you do this - make back-up files and also review the data dictionary to ensure that the alias key isn't used anywhere else.  Otherwise, you will have to change that file as well.

Steve
Contributor
PhilMcIntosh
Posts: 23
Registered: 11-03-2008
0

Re: Vendor Alias Import

Version 4.3 - importing into IM_04
Switcher
SPyle
Posts: 905
Registered: 11-03-2008
0

Re: Vendor Alias Import

You can confirm that the alias number is part of the key by looking at the file in the data dictionary.  There should be a link to it in the VI folder.
Steve