The following numbering systems are established in this setup:



To change the number sequence to a different number type other than the one shown, then type in the new starting number. The user must not enter a number less than an already existing number.


Inventory Part Number
The user has the option of assigning a prefix to the number based on part-type information established in the Materials setup section. In most instances, the user may easily find an inventory item without having to remember the number, because manexSQL provides several ways to locate a part, for example, by customer, by class and type, by description, by where used, etc.
Sales Quote Numbers
If the user is in the Quote module, the creation of a new quote will require a control number before saving the quote. manexSQL can assign these numbers, releasing the user from having to maintain a separate log, or the user may assign numbers when the quote is generated.
Sales Order Numbers
When a sales order is created, there must be a control number assigned before the order is saved. manexSQL can assign these numbers, releasing the user from having to maintain a separate log, or the user may assign numbers each time a new sales order is entered.
Work Order Number
When a work order is created, a control number must be assigned before the order can be saved. manexSQL can assign these numbers, releasing the user from having to maintain a separate log, or the user may assign numbers each time a new work order is entered. Also, if the user elects to have manexSQL automatically create work orders from sales orders, then the numbering system for work orders must be automatic.
Packing List Numbers
Packing lists need a control number assigned when they are created. The user may do this manually, or manexSQL can assign these numbers.
Invoice Numbers
Invoices must have a control number assigned to them. The user may do this manually, or manexSQL can assign these numbers.
Credit Memo Numbers
Credit memos are created in accounting or via an RMA receiver, and require control numbers. The user may do this manually, or have manexSQL assign these numbers.
Order Configuration Part Number
The numbering selection for an order configuration can be set to automatic or manual.
Supplier ID Numbers
As the user adds suppliers to the database, it is useful to have a supplier code assigned to each supplier. In manexSQL, the supplier code may be used to find a vendor, but every screen requiring a supplier identification code will display at least the supplier’s full name to choose from, and often the code. Thus, the user does not need to customize the supplier codes, but can let manexSQL automatically apply a new number for each new supplier.


Purchase Order Numbers
Tracking numbers may be assigned manually, but the reasons for assigning them manually is usually associated with the ability to group purchasing actions by buyer or commodity. In manexSQL, the user may use a wide variety of selections to view procurement information. The user may view the orders by the following: buyer code, class code, part types, require actions, and more. For ease of use, it is recommended that the user utilize the auto-numbering system to track order numbers. The auto-numbering obviates the need for separate log books for each buyer, and trying to find the book when the buyer is not available.
PO Receiver Number
Each time a shipment is received against a purchase order, it is assigned a tracking number to identify the specific receipt against the order, and to reconcile the accounts payable. The user may do this manually, or have manexSQL assign these numbers.
Discrepant Material Return (DMR) Numbers
DMR Numbers track shipments when previously purchased items are returned to the supplier. The user may do this manually, or have manexSQL assign these numbers.
Discrepant Material Return (DMR) Packing List Numbers
When the shipping department is ready to make a shipment, they must create a packing list to go with the shipment, and record in manexSQL the specific details of the shipment. These also must have a control number assigned at the time the packing list is created. The user may do this manually, or have manexSQL assign these numbers.
Debit Memo Numbers
Debit memos against a supplier’s invoice are created in accounting or via a DMR return shipment, and require control numbers. The user may do this manually, or have manexSQL assign these numbers.
Corrective Action Request (CAR) Numbers
When issuing a corrective action request, manexSQL will require the assignment of a tracking number in order to report on the progress and resolution of the findings. The user may do this manually, or have manexSQL assign these numbers.
Calibration Numbers
Calibration numbers are used to assign control numbers to specific equipment and tooling. If the user is using the Calibration and Maintenance module, these control numbers are provided to identify equipment and tooling that need regular maintenance or calibration. In manual mode, the user may choose to use asset numbers (if available). Otherwise, manexSQL can automatically assign numbers to each piece of equipment or tooling as it is entered into the manexSQL database. (The user may wish to use these numbers as asset numbers for their equipment). 
ECO Numbers
In the Engineering Change Order (ECO) module, whenever a new ECO is created or saved, manexSQL will require the assignment of a tracking and control number. The user may do this manually, or have manexSQL assign these numbers.
Project Numbers
If the user has a system which tracks project numbers, and when the user sets up a new project, there is a requirement to use a new unique number. The user may do this manually, or have manexSQL assign these numbers.