Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • Software
  • InventoryControl: Automatic customer numbering is out of sequence.
Subscribe Download PDF

InventoryControl: Automatic customer numbering is out of sequence.

Scott Leonard
2025-01-07
in Software

The automatic customer numbers will always count up from the highest active customer number. The numbering may be out of order if, for example, a customer number is accidentally entered with too many digits.

There is a two part solution to correct this issue:

Step One:

  1. In InventoryControl, go to Tools > Options and disable the Automatic Customer Number option.

  2. Go to Lists > Customer. The Customer List will appear.

  3. On the Customer List locate the customer numbers higher than the range you want to use and edit them to give them a lower customer number.

Step Two:

  1. On the database server machine, download https://dl.waspbarcode.com/wasp/supportfiles/ResetAutomaticCustomerNumberIC.zip and extract it, then run Update.bat.*

  2. In InventoryControl, go back to Tools > Options and re-enable Automatic Customer Number.

 

Note: If this script does not work as expected, there are probably deleted objects retained by the database that are disrupting the calculation. Contact Wasp Support for assistance with resolving this.

------------

*Enterprise users will need to edit ResetAutomaticCustomerNumber.wql to supply the correct server\instance name and the password if InventoryUser has been set to use something other than the default.

This same file will work for both v6 and v7.

 

 

Rate the quality of this page

This page was helpful :) :( This page was not helpful

6 of 19 people found this page helpful


Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro