Create unique sequential alternate part numbers for inventory items

You can create a series of incremental unique alternate part numbers, starting with X00001 and incrementing by 1 (X00002, X00003, and so on) when you manually add an inventory item or create inventory items using the Data Viewer inventory upload feature. All alternate IDs will start with X and increment by one each time. They will never be reused.

Note: This feature is turned on by default, but is optional to use.

This article provides instruction and information on the following:

• Using the Add Item in the Inventory module
• Using the Data Viewer Import feature

Using the Add Item in the Inventory module

1. In Paladin, on the top ribbon, select the Inventory module.
2. On the bottom ribbon of the module, click F2 Add Item.
3. In the Add New Item window, fill out the inventory item details, leaving the Alt Part # box blank.
4. Click Next X # to add the unique incremental part number.
5. Click F12 Add.

Figure 1: Add New Item window

Back to Top

Using the Data Viewer Import feature

1. Create the file of items to import. For details, see Single store: Import inventory data into a Paladin database
2. In Paladin, on the top menu, select Maintain > Data Viewer.
3. Select the Inventory tab, then click the Import subtab.
4. Click Load File and select the file of items to upload.
5. Select X Alt Part Number Sequence. Unique incremental part numbers are added automatically when the item is imported.
6. Click Import.

Figure 2: Data Viewer Import

Back to Top