-
How to troubleshoot Bin Quantity and Location Quantity Mismatch
One of the common questions we receive at NetSuite would be with regards to Bin and Location On Hand mismatch. The following are the usual root causes for this mismatch (Note that the root causes for the mismatch are not exclusive to the ones listed below) a. Quantity in the Bin Putaway Worksheet has not been putaway yet.…
-
SuiteScript 2.0: Hide a subtab using a beforeLoad function of a user event script
Overview In N/ui/serverWidget module, there is no method that explicitly says that it can hide a subtab of a record. There's a tab object in the module but its only purpose is to set a tab's label and help text. Nevertheless, certain objects within the module can be used to hide a subtab. This is useful on scenarios such…
-
Mass entry of Numerous Serial Number in an Item Receipt
Companies usually receive great quantities of their items per Purchase Order. For companies that utilizes Serialized Items, users would need to enter the Serial Numbers of these items upon receipt. As designed, only one Serial Number can be associated in one unit of the said item. In the Item Receipt form, NetSuite has a…
-
Clear "No Vendor" and "No Customer/Project" on A/P and A/R Aging Report
Here are the steps on how to clear "No Vendor" on A/P Aging Detail Report: 1. Open the A/P Aging report under Reports > Vendors/Payables > A/P Aging. 2. Click on the Amount on Total Open Balances column so that you will be taken to the A/P Aging Detail Report. 3. Take note of the transactions and use Global Search to open…
-
SuiteTalk: API Version
Purpose : To know the API Version used in the integration. How: Create a Saved Search ( SOAP Web Services Operations Search ) Under the Results Subtab, add the field API Version. This is the sample output of the Saved Search created. Using this Saved Search, the user will determine when the WSDL version of the integration…
-
Advanced PDF/HTML Template Tip: Adding Hyperlinks to PDF
A hyperlink can be added on any Advanced PDF/HTML Template using the syntax below. Below is a sample application and the result on the PDF. @Pauline Joy Cac-Oracle
-
NSC | Bulk Update: CSV Import > Customer Records > Relationships tab > Contacts subtab > Role= Blank
While we cannot use Mass Update for this functionality since this is currently logged in as Enhancement under Issue 131958 Mass Update > Contact > Ability to update the Role for the contact, we can use CSV Import instead. Based on my testing, below are the steps you can follow: A. Create a CSV file using MS Excel software.…
-
Release 2020.1: Vendor Bill Approval via Employee Center
Starting 2020.1, this optional feature provides the ability to our users to approve Vendor Bills on the Employee Center role. The feature can be used on the Employee Center and will have an impact on all the approvals operations on the Vendor Bills. The Bill could appear on the Employee Center of the designated approver…
-
Financial Reports: View for a Specific Period
Financial Reports in NetSuite are viewed normally at the end of a specific period. The period drop-down in these Reports can be selected on a monthly basis. However, there are instances where the users wanted to know the details of their Report for a specific date. Did you know that NetSuite actually has a Preference that…
-
How to partially commit on Orders?
There are times wherein businesses would not want to allocate all available inventory to an existing orders. They would like to keep/retain some of your available items for future orders, hence, partially committing the said order and reserving their items as a buffer. For instance, if they have 10 available for Item A and…