Unable to Print Bin Numbers in Picking Ticket via Advanced PDF/HTML Template

Scenario On Advanced PDF/HTML Template the string ${ITEM} is used to print the Bin Numbers for each line item. However, the string does not display the Bin Numbers.   Solution   Enable Advanced Bin/Numbered Inventory Management Navigate to Setup > Company > Enable Features Click Items & Inventory Advanced Bin/Numbered Inventory Management: Enter Checkmark Click Save Enable Inventory Detail column on Transaction Form Navigate to Customization > Forms > Transaction Forms Preferred… Continue reading Unable to Print Bin Numbers in Picking Ticket via Advanced PDF/HTML Template

Apply Custom Format to Item Table for Specific Item Type

Scenario Formatting rows on the item table based on the item type is currently a limitation in Advanced PDF/HTML Templates and is related to Enhancement : 376525. Note: To search and vote for the enhancement, see 10054 Voting for Enhancements You can leverage the HTML language in customizing the Advanced PDF/HTML in order to dynamically update the formatting… Continue reading Apply Custom Format to Item Table for Specific Item Type

Ability to print both Item Name and Display Name on the Picking Ticket using the Advanced PDF/HTML Template.

Scenario Print both Item Name and Display Name on the Picking Ticket using the Advanced PDF/HTML Template Solution 1. Create a Transaction Column/Line Field    1. Navigate to Customization > Lists, Records, & Fields > Transaction Line Fields > New       • Enter Name: (e.g. Item Display Name)       • Type: Free-Form Text       • Store Value: Unchecked       • Applies To: Sale Item       • Sourcing… Continue reading Ability to print both Item Name and Display Name on the Picking Ticket using the Advanced PDF/HTML Template.

Inventory Detail Is Not Shown in the Picking Ticket Printout When Using Advanced PDF/HTML Template

Scenario The Inventory Detail can be printed in the Picking Ticket using Advanced PDF/HTML Template by using {item.inventorydetail} code. In an instance that the value of the Inventory Details are not shown in the printout, make sure that the inventory detail sublist field is shown in the Custom Transaction Form.   Solution   Navigate to Customization > Forms > Transaction… Continue reading Inventory Detail Is Not Shown in the Picking Ticket Printout When Using Advanced PDF/HTML Template

Send a POST Request from a Suitelet to RESTlet

Scenario The user wants to create a Suitelet that submits data into a RESTlet which creates a Customer record. Solution Create 2 scripts. One is a Suitelet that prepares the Customer data and calls the RESTlet. The other is a RESTlet that creates the Customer record with the data handed by the Suitelet. Suitelet: SuiteScript 1.0 function requestFromForm(request, response) { if (request.getMethod() == ‘GET’) { //create a form where… Continue reading Send a POST Request from a Suitelet to RESTlet

Setting Grid Order Management Preferences

You can set preferences for the Grid Order Entry form, grid printing, and preferred grid template. Note The navigation paths used in these instructions are based on the Administrator role. If you are not an administrator, you may see a different view of the NetSuite center. For more information, see Roles and Permissions for Grid Order Management.… Continue reading Setting Grid Order Management Preferences

Exclude Assembly Components from the Open Sales Order Report

Scenario Exclude Assembly Components from the Open Sales Order Report Solution To create the report: 1. Navigate to Reports > Order Management > Open Sales Orders > Customize. 2. Provide a Name for the report. 3. Click on Edit Columns link. 4. Expand the Open Sales Order folder, then the Item folder. 5. Insert the… Continue reading Exclude Assembly Components from the Open Sales Order Report

Create a Sales Order Report Showing Combined Data Found in Open Sales Order Report and Sales Back Order Report

Scenario It is possible to customize the Open Sales Order Report to show the details of the Back Order Report. Below are the steps to create the report: Solution 1. Navigate to Reports > Order Management > Open Sales Orders Report > Customize   2. Under Edit Columns add the following fields:  a. Expand Open… Continue reading Create a Sales Order Report Showing Combined Data Found in Open Sales Order Report and Sales Back Order Report

Saved Search to show Quantity Sold for an Item, whether it was sold individually or as a Member of an Assembly or Kit Item

Scenario Create a report that will display the total number of items sold whether or not they were sold individually or part of a kit or assembly with additional columns that shows item sold per month. Solution 1. Navigate to Reports > Saved Searches > All Saved Searches > New 2. Click Transaction 3. Search Title : Enter Title 4. Click Criteria tab 5. Click Standard subtab 6. Filter: Select Type            1. Type :… Continue reading Saved Search to show Quantity Sold for an Item, whether it was sold individually or as a Member of an Assembly or Kit Item

An untrusted, unsupported, or invalid certificate was found for this host

The error message you’re encountering, An untrusted, unsupported, or invalid certificate was found for this host, indicates that the HTTPS request to the specified endpoint (https://rspportal.net/api/tasks) is being blocked due to certificate issues. Here are some steps to troubleshoot and resolve this problem: 1. Check SSL Certificate Validity Ensure that the SSL certificate for rspportal.net… Continue reading An untrusted, unsupported, or invalid certificate was found for this host