Set the Next Order Number

Contents of this Topic: Show

Overview

Procedure

If you want to reset the next order number to a new higher number, here's what you should do:

  1. Back up your data file in case you make a mistake!

  2. Go to Monsoon Order Manager 's Main Menu.

  3. Press the F11 Function Key on your keyboard to open the "database window".

  4. Microsoft Access has buttons down the left-hand side of the window. Select the tab or button labeled "Tables".

  5. Locate the OrderNumbers table. This is a linked table, so be sure to scroll down far enough to see it.

  6. Select the OrderNumbers table, right-click and select Open.

  7. Scroll to the bottom of the table. On the blank line at the bottom of the table, select in the Order Number column (usually the first column) and enter a new order number. If you want your next order to be order number 2001, enter the number 2000. This creates a "dummy" order with that order number.

  8. Close the table.

  9. Minimize the database window to return to the Main Menu.

The next order that you import or enter manually is given an order number 1 higher than the number you entered in step #7.

 

After you have entered or imported some orders, you should delete the "dummy" order:

  1. Repeat steps 1 thru 6 in the list above.

  2. Locate the "dummy" order.

  3. Select the small gray rectangle to the left of the order to select the order.

  4. Press the Delete key on your keyboard to delete the order.

  5. Close the table.

  6. Minimize the database window to return to the Main Menu.

 

Additional Information

 

Created:

Revised: 2/9/15

Published: 08/19/15