VENDORS - Code Change

Change the Vendor Code with this utility and have it affect all Accounts Payable and Purchase History

 change the Vendor Code in one of 2 ways: 

1. Vendor Text Menu for one item at a time

1. • type or browse for existing Vendor No
   • enter the New Vendor Code you want to replace it with
   • Save or Save and Close if you want to access this worksheet later
   • click Apply to complete the process
   •  Print the Vendor Code Change List if need be
2. Import Vendor Code Change for changing a list of Vendors at once

• • Export Vendor list filtered or unfiltered - see Export
  • create a new column for the new Vendor Codes
  • access - Tools > Import
• click on Open config if you are accessing settings for a previously saved import configuration, or continue as follows:
• Browse Files to load the Excel spreadsheet (.xlsx or .csv only) created earlier
• select the Import Type - ‘Vendor’
• under the Import File Field Value from your Excel spreadsheet, select New Vendor No. field
• under Spire Field Name select the Vendor No field
• click on Match and those two field names will drop to the bottom mapped section
• next match the Import File Field New Vendor No to the Spire Field Vendor No
• select the Destination folder (where successful import will be moved to)
• select the Failure folder (where failed import will be moved to)
• check  Has Header Row (at top)
• click on Save config / Save config as to save the Source, Import Type, Field Mapping, Destination and Failure folders into the current user’s documents folder
• click on   Import to complete the process