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 item numbering is out of sequence.
Subscribe Download PDF

InventoryControl: Automatic item numbering is out of sequence.

Max Holden
2023-01-20
in Software

The automatic item numbers will always count up from the highest active item number. The numbering may be out of order if, for example, you accidentally enter an item number 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 Item Numbers option.

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

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

Step Two:

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

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

 

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 ResetAutomaticItemNumber.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

4 of 16 people found this page helpful


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