The Inventory Item Bulk Create Options dialog allows you to create new Inventory Item Codes based on a range of existing Inventory Item Codes by simple replacement of a Prefix. The dialog also allows you to update existing Codes with new information; such as Fees, Rules, Descriptions, etc…, if desired.
The Bulk Create process works by substituting all or part of the existing Inventory Item's Code (the "prefix") with a new Prefix. For Example: Your Inventory Item Code is "POOL-Coke-SM," a small Coke sold at the pool. When bulk creating new Inventory Item Codes, you could use any part of that code as the prefix. For purposes of example, you might have four (4) different Inventory Items for Coke sales at the pool: POOL-Coke-SM to POOL-Coke XLG. To Bulk Create four new Inventory Item Codes for your Rec Center, you would enter POOL-Coke-SM to POOL-Coke XLG as your Item Code Range and then use "POOL" as your Old Item Prefix and "REC" as your New Item Prefix. Upon running the Bulk Create program, the system would create new Inventory Item Codes REC-Coke-SM to REC-Coke XLG..
The process works on a Prefix basis only and it only creates as many new Codes as you have included in your Item Code Range. Using the example above, you could NOT use Inventory Item Code POOL-Coke-SM to create Inventory Item Code POOL-ORANGE-SM because "ORANGE" cannot be considered a "Prefix." Likewise you could not enter a four-item range and have the system create five (or more) new Inventory Item Codes. It is a direct one-to-one replication process.
From the bottom of the screen….
Click Continue to run the Bulk Create process. You will be presented with a dialog explaining the number of new records to be created and the number of existing records to be updated. Click OK to complete the process.
Click Cancel to abort the process. No new Codes will be created and no existing Codes will be updated.
PSInventoryBulkCreate_Tab1
Begin Item Code (PSInventoryBulkCreate_BeginItemCode)
Click the Picklist icon to select your Beginning and Ending Range of Inventory Item Codes that you want use as the base for the bulk creation of new Codes. These are mandatory fields in the standard VSI Design. Your Design may vary.
The Bulk Create program is a direct one-to-one replication. When you run the Bulk Create program the system will create as many new Codes as those which currently exist in your range. So if your range is one (1) item only then one (1) new Inventory Item will be created; if your range is 12 items long then 12 new Inventory Items will be created and so-on.
DeleteEnd Item Code (PSInventoryBulkCreate_EndItemCode)
Click the Picklist icon to select your Beginning and Ending Range of Inventory Item Codes that you want use as the base for the bulk creation of new Codes. These are mandatory fields in the standard VSI Design. Your Design may vary.
The Bulk Create program is a direct one-to-one replication. When you run the Bulk Create program the system will create as many new Codes as those which currently exist in your range. So if your range is one (1) item only then one (1) new Inventory Item will be created; if your range is 12 items long then 12 new Inventory Items will be created and so-on.
DeleteOld Item Prefix (PSInventoryBulkCreate_OldItemPrefix)
Enter the Old Item Prefix in this field. This can be any or all of the Inventory Item Code in your range. When you run the Bulk Create program, the system will replace whatever you enter in this field with whatever you enter in the New Item Prefix field. The remainder of the Code will remain the same. This is a mandatory field in the standard VSI Design. Your Design may vary.
For Example: Your Inventory Item Code Range is "POOL-Coke-SM" to "POOL-Coke XLG" You enter "POOL" in this field and "REC" in the New Item Prefix field. Upon running the Bulk Create program the system will create 12 new Inventory Item Codes REC-Coke-SM to "REC-COKE-XLG"
Note: Optionally you can use this program to Bulk Update existing Codes. To do this enter the same Prefix Values in both fields and THEN make selections in the If Item Already Exists… field below. When the Bulk Create process runs the system will overwrite the "old" Codes with their "new" replacements and the system will go through and update the items you've check in the Combo Box with their new value.
New Item Prefix (PSInventoryBulkCreate_NewItemPrefix)
Enter the New Item Prefix in this field. When you run the Bulk Create program, the system will replace whatever you entered in the Old Item Prefix field with the value you enter in this field. The remainder of the Code will remain the same. This is a mandatory field in the standard VSI Design. Your Design may vary.
For Example: Your Inventory Item Code Range is "POOL-Coke-SM" to "POOL-Coke-XLG." You enter "POOL" in the Old Item Prefix and "REC" in this field. Upon running the Bulk Create program the system will create 12 new Inventory Item Codes REC-Coke-SM to "REC-COKE-XLG"
Note: Optionally you can use this program to Bulk Update existing Codes. To do this enter the same Prefix Values in both fields and THEN make selections in the If Item Already Exists… field below. When the Bulk Create process runs the system will overwrite the "old" Codes with their "new" replacements and the system will go through and update the items you've check in the Combo Box with their new value.
Old UPC Prefix (PSInventoryBulkCreate_OldUPCPrefix)
Enter the old UPC Prefix for this Code, if any, in its field
THEN
Enter a new UPC Prefix in its field. Upon running the Bulk Create, the new UPC Codes will be entered for the new Items.
Leave these fields blank if you do not use UPC Codes.
DeleteNew UPC Prefix (PSInventoryBulkCreate_NewUPCPrefix)
Enter the old UPC Prefix for this Code, if any, in its field
THEN
Enter a new UPC Prefix in its field. Upon running the Bulk Create, the new UPC Codes will be entered for the new Items.
Leave these fields blank if you do not use UPC Codes.
DeleteIf Item Already Exists, Update The Following Items (PSInventoryBulkCreate_UpdateOption)
This field is applicable only if you are opting to use this program to update existing Codes with new information.
Click the Combo Box icon and select the screens you want to copy from the "old" Code to the "New" Code. Multiple selection is allowed.
DeleteNew Item Short Description (PSInventoryBulkCreate_NewItemShortDesc)
Enter a new Short Description for this Code, if desired, or leave this field blank to have the existing Short Description copied from the old" Codes to the "new" ones upon running the Bulk Create program.
DeleteNew Item Long Description (PSInventoryBulkCreate_NewItemLongDesc)
Enter a new Long Description for this Code, if desired, or leave this field blank to have the existing Long Description copied from the old" Codes to the "new" ones upon running the Bulk Create program.
Delete