What are Number Changers?

2 minute read time.

As the name states, it is a program for changing numbers. Quite often, one may not thoroughly think over what style of numbers or a specific number to use for many different areas when setting up a database. Later, one may realize that the wrong format or length was selected for a certain number. What can be done? If such a decision was made in Sage 300 for one of the following modules, there may be a number changer program which can change the number to the desired format or length. The number changer programs will modify the existing data accordingly in all regular Sage 300 modules as specified in the change. The modules with a number changer program include:

  • Accounts Payable: Vendor Number Change
  • Accounts Receivable: Customer Number Change
  • General Ledger: Account Code Change
  • Inventory Control: Item Number Change

 

Types of Changes: Change, Combine, Copy

Each of the number changer can perform these 3 types of changes in their respective way. A brief description of each type of change for each Number Changer is below. Changes may be entered from the interface one at a time or imported from a file if many changes are required. I will explain more on how to create an import file of changes in a future blog.

Vendor Number Change                                           

Change – will change an existing vendor number to a new one and retain all existing information from the old vendor.

Combine – will merge the source vendor to a target vendor and combine the balances, history and transactions into the source vendor.

Copy – will create a new vendor from any existing vendor with basic information.

 

Example of entering a change for a vendor:

 

Customer Number Change

Change – will change an existing customer number to a new one and retain all existing information from the old customer.

Combine – will merge the source customer to a target customer and combine the balances, history and transactions into the source customer.

Copy – will create a new customer from any existing customer with basic information.

Example of entering a change for a customer:

  

Account Code Change

Change – will change an existing account number to a new one and retain all existing information from the old account.

Combine – will merge the source account to a target account and combine the balances, history and transactions into the source account.

Copy – will create a new account from any existing account with basic information.

Example of entering a change to increase an account length: 

Example of entering a change for an account number: 

 

Item Number Change

Change – will change an existing item number to a new one and retain all existing information from the old item.

Combine – will merge the source item to a target item and combine the balances, history and transactions into the source item.

Copy – will create a new item from any existing item with basic information.

Example of entering a change for an item: