NetSuite Auto Assign UPC

What is Auto Assign UPC?

Auto Assign UPC, SuiteApp automatically assigns UPC codes to inventory, assembly, inventory matrix, and assembly matrix items. In addition, it enables you to create, remove, and manage UPC codes. The SuiteApp lists all assigned UPC codes and tracks their date of assignment and retirement. The UPC code record is linked to the item record for convenience.

Now the question arises, what is SuiteApp?

SuiteSolutions save time and money in the implementation process, or provide flexibility for existing NetSuite customers by augmenting NetSuite’s core functionality to meet scaling business needs.

Before using a Solution, we must we must know what it offers you:

This SuiteApp enables you to:

  • Set custom preferences that determine the status of new items and their UPC code assignment options.
  • Create UPC codes manually or through CSV import.
  • Automate UPC code assignment on item records daily or based on your preferred schedule using the AAUPC MR Auto Assign UPC script.
  • Automate UPC code retirement from child matrix item records if their corresponding parent matrix item records are deleted using the AAUPC MR Retire UPC Without Items script daily.
  • Exclude items from automatic code assignment and lets you assign UPC code to item records manually.
  • Remove UPC codes from an item record.
  • Manage UPC code assignments through the following default saved searches
  • UPC Codes Assigned by System Today
  • UPC Codes not in Use o Items Needing UPC Code
  • All Assigned UPC Codes with Item

Working with Auto Assign UPC

  • Setting Custom Auto Assign UPC Preferences
  • Assigning UPC Codes
  • Viewing UPC Codes
  • Retire UPC Codes Without Items Script Deployment
  • Removing UPC Codes

Setting Up Auto Assign UPC

STEP 1: Installing the SuiteApp

To install and set up this SuiteApp, you must be logged in as an Administrator.

To install this SuiteApp: NAVIGATION: Customization > SuiteBundler > Search & Install Bundles.

NetSuite Suite App Installation
1. On the Search & Install Bundles page, following are the SuiteApp details
  • Bundle Name: Auto Assign UPC
  • Bundle ID: 316640
  • Version number: 1.00.0
  • Availability: Beta
Search & Install Bundles
2. To display the Bundle Details page, click Auto-Assign UPC

3. Click Install

Display the Bundle Details page

  • As soon as the Bundle gets Installed a Custom record UPC Code is Formed. One can Navigate to the Custom Record through the following Navigation:
  • List -> Custom -> UPC Code

As soon as a bundle gets installed, a custom record UPC Code is formed.

  • Following is the Custom Record that is created.

Custom Record Creation

  • All the UPC codes can be Uploaded through CSV import:
Upload UPC codes
STEP 2: Enabling Features

To enable the feature, you must be logged in as an Administrator.

To enable the feature: NAVIGATION: Setup > Company > Setup Tasks > Enable Features

Enable NetSuite Features
1. Click the Items & Inventory sub tab.

2. Under Items, check the following:

  • Matrix Items
  • Bar Coding and Item Labels
  • Check this box to automatically generate a bar code for each item and transaction, as well as be able to print bar code labels for each item.
Enable NetSuite Features
3. Click Save

STEP 3: Setting Custom Auto Assign UPC Preferences

The Auto Assign UPC SuiteApp lets you set custom preferences that will determine status of an item and the UPC code assignment option for that item.

The changes will only apply to items created after setting up the custom Auto Assign UPC preferences.

You should not change the preferences once set.

To set the custom Auto Assign UPC preferences: NAVIGATE: Go to Setup > Company > General Preferences.

Setting Custom Auto Assign UPC Preferences

  • Click the Custom Preferences sub tab.

Assign UPC to New Item

  • Under the Auto Assign UPC sub tab, check the boxes as required. 

Automatically Assign UPC to New Item – If you check this box, the new items will be included for automatic UPC code assignment. 

  • Click Save.

Assigning UPC Codes

You can assign UPC codes manually or configure items for automatic UPC code assignment by running the AAUPC MR Auto Assign UPC Script.

To automatically assign a UPC code:

NAVIGATION: Lists > Accounting > Items > New

Assigning UPC Codes
1. Click the type of item you want to create.
Assign New Item In NetSuite
2. Enter item related information. By default, the UPC Code field is disabled.
Enter Item Related information.
3. In the UPC Code Assignment field, select Assign New UPC Code.

4. Enter information in the available sub tubs as necessary and click Save.

5. Click OK.

To manually assign a UPC code to an item:

To manually assign a UPC code to an item
1. On the item UPC sub tab, check the Exclude from Auto Assign UPC box. Check this box to prevent the MR Script from automatically assigning a code to the item. 

2. Enter a code in the UPC Code field.

Enter a code in the UPC field
3. Click Save.

Viewing UPC Codes 

To view the list of all UPC codes, go to Lists > Custom > UPC Code

The UPC Code List page displays imported and manually created UPC codes. You can view them all but modify only those with an Unused status. 

The status of an UPC code can be one of the following:

In Use – Code that is assigned to an item.

Unused – Code that is available for assignment.

Retired – Code that is either removed from an item or the item using it was deleted.

Viewing UPC Codes 

Auto Assign UPC Script Deployment

As part of the default settings, the system will run the AAUPC MR Auto Assign UPC script once a day at 5AM Pacific Time (UTC-8:00). To schedule the script submission as per your requirements. 

To manually run the script:

NAVIGATION: Customization > Scripting > Script Deployment

1. From the Script column, find AAUPC MR Auto Assign UPC.

2. Click Edit.

3. In the Status field, set the field value to Not Scheduled.

4. Click the Parameters sub tab.

5. To receive a summary of the UPC Code assignment updates in a specific email address, check the Email Summary Results box.

6. Enter the email address in the Email Summary Results To field to which the results will be sent.

7. To receive a summary of the UPC assignment updates only when there are results, check the No Email If No Results box.

8. Click Save and Execute to run the script.

9. On the Map/Reduce Script Status page, click Refresh to verify the status of the script. The Status column displays Complete after the script has finished running.  

Retire UPC Codes Without Items Script Deployment 

The AAUPC MR Retire UPC Without Items script retires UPC codes from a child matrix item record when the corresponding parent matrix item record is deleted.

By default, the script will run once in a day at 4:00 a.m. Pacific Time (UTC–08:00).

To schedule the script submission as per your requirements.

Removing UPC Codes 

When you remove a UPC code from an item, the code status is set to Retired.

To remove a UPC code:

1. Open the item record.

2. Click Edit.

3. In the UPC Code Assignment field, select Remove UPC Code.

Viewing UPC Codes 
4. Click Save.
Netsuite Dialogue Box for Removing UPC code from item
5. A dialog box appears with the warning: Are you sure you want to remove the UPC code from the item? This action will retire the UPC code and make the item inactive until a new UPC code is assigned. Click OK to proceed or cancel to abort the action. 

6. Click OK.

Written by Mousumi Dass, including Advantages and Limitations.

Advantages:

1. Capture Universal Product Code (UPC) information.

2. Automatically assign the UPC codes to the designated inventory items.

3. View UPC Codes and the related items.

Limitations:

1. The solution can assign a maximum of 4000 UPC Codes at a time

2. The SuiteApp does not keep track of the UPC codes that are created manually.

3. For a parent matrix item, you must not change the UPC code assignment option if UPC codes are already assigned to its corresponding child items.

4. All standard SuiteCloud usage and governance limits apply.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to top