Item Doesn’t Appear in Vendor Credit Transaction

A client recently reported that a specific item was not appearing in a Vendor Credit transaction. They had already verified key configuration details such as the subsidiary, location, and other relevant fields. Despite this, the item remained absent from the Vendor Credit form. Upon reviewing the item setup, it was discovered that the item in… Continue reading Item Doesn’t Appear in Vendor Credit Transaction

Proposal for Implementing Product Specification Document in NetSuite V2

Proposal Summary  The Proposal Covers the scope of the development and implementation of a Product Specification Document for Item Records in NetSuite. The document will feature a static header on all pages, include product images, package images, barcode generation, carton details, and a revision history. Users can generate the document directly from the item record… Continue reading Proposal for Implementing Product Specification Document in NetSuite V2

Change Item’s External ID

External ID of an item record is a standard field that cannot be modified through user interface. Modification can only be accomplished through CSV Import. 1. Create a CSV file, basic example is to add 2 columns: a. Internal ID – internal ID of the item record to be updated. This can be located on the item record… Continue reading Change Item’s External ID

Setting Up an Item Group

Setting Up an Item Group Navigate to the New Item Record List: Go to the Lists > Accounting > Items > New Select Item Group from the list of item types. Give the Item Group a Name. In our example, we are creating an item that supports preventive maintenance for a forklift.  Add a Description for the item group that will be displayed… Continue reading Setting Up an Item Group

CSV Import Update of Cash Sale Error: The total inventory detail quantity must be XXX.

Customer is encountering an error in CSV Import Update of Cash Sale Error: The total inventory detail quantity must be XXX. Solution: Perform CSV Import by following the steps and field mapping below: Setup > Import/Export > Import CSV Records Import Type = Transactions Record Type = Cash Sale Data handling: Update Map the following… Continue reading CSV Import Update of Cash Sale Error: The total inventory detail quantity must be XXX.

Matrix, Kit, and Group Items – How Do They Differ?

What are Matrix items? Matrix items are used when there are multiple options for the same product. An example would be different colorways to choose from for the same welding helmet model or different rebar lengths. This type of item allows multiple options to fall under one “parent” item. A parent item is the overarching… Continue reading Matrix, Kit, and Group Items – How Do They Differ?

Sort Items on web store by Product Reviews

User wants to sort items on commerce categories/search results in web store by Product Reviews Pre-requisite: Reference Product Review Records bundle must be installed on your account To sort items by product reviews, do the following: Navigate to Commerce > Web Sites > Website List Select Edit the SCA website Under Search Index > Sort Fields, Add Product Reviews Rating (Custom) in the list Choose Save Go to Commerce > Web Sites > Configuration Select Web Site and Domain… Continue reading Sort Items on web store by Product Reviews

Items not displaying in website

Even after the website setup, the products are not displaying. Solution: Go to Commerce > Websites > Website List. Click Edit next to your website. On the Web Site Setup page, choose Actions > Rebuild Search Index. Do the cache invalidation and refresh the website.