About Expanding the Accounts Receivable Invoice Number

 

Expanding the invoice number in Accounts Receivable, Sales Order, and Job Cost is a business decision that has significant impact on how your company uses Sage 100.

Warning After expanding the length of the invoice number in Common Information Options, it cannot be reduced.

We recommend expanding the invoice number in a sample Test company first and reviewing the forms, reports, and data entry tasks your staff most frequently uses. After you’re satisfied with results in the sample Test company, then expand the invoice number in a Live company.

Note If you want to convert your existing 7-digit numeric invoice numbers to the new invoice number length, use the A/R Invoice Expansion Conversion Utility accessed from the Sage 100 Utilities menu. In the Sage 100 Desktop, select File > Run. In the Run Program window, enter *utl in the Program field to open the Utilities menu. Back up your data before using the utility.

The following changes will occur throughout Sage 100 when the invoice number is expanded:

  • The entry of invoice numbers expands from 7 up to 20 characters.
  • If only numerics are used for the invoice number, leading zeros are inserted automatically to pad the invoice number.
  • If the invoice number length is....

    Then invoice number 1234 displays as....

    7

    0001234

    10

    0000001234

    20 00000000000000001234
  • In the following next number fields, leading zeros are entered automatically to pad the invoice number to the new length:
    • Next Automatic Invoice Number field in Accounts Receivable Options
    • Next Automatic Invoice/Shipping Number field in Sales Order Options
  • When the invoice number is expanded, a record is written to the Activity Log.
  • Forms, reports, and screens are changed to accommodate the expanded field.