//Info: SZCO-4 Solution:We are going to include a new transaction line field in NetSuite. “ON ORDER” will be the field name, and a decimal number will be the field type. This field is used to display the quantity of the item that is “ON ORDER.” Based on the transaction body level location, the value for… Continue reading Showing the On Order Quantity of items in the Sales order
Month: December 2022
Input and Output filter in Celigo
//Info: JSTN-1192 The filters used in Celigo have a great impact on the process flow.we can restrict data between two platforms using the filter. While doing integrations, it’s better to add an input filter rather than an output filter. Even though both have similar functionality, the Output filter doesn’t work in many scenarios (verified with… Continue reading Input and Output filter in Celigo
Alert when an item with quantity greater than Reorder point is selected in the Sales Order
//Info: POW-292
Add Replace functionality in HTML Code
//Info: CDUS-2127 We met a requirement where we needed to update the content in an email body which was generated through certain criteria.The email content will be changed based on the location selected in the Sales Order and this should be reflected in the associated Html file. Solution: We already predefined the content in the… Continue reading Add Replace functionality in HTML Code
Proposal For Inventory Adjustment Of Trash Items
Requirement Add a scheduled or map/reduce script in the sandbox that takes every serial number that is in the TRASH bin in Warehouse and creates an adjustment where inventory adjustment reason is “Trash Inventory”. Our Solution 1. Saved search to fetch the Items moved to the Trash Need to create a saved search for the… Continue reading Proposal For Inventory Adjustment Of Trash Items
Custom Asset Module
NetSuite provides a standard Asset Module to manage Assets and take Reports.Apart from the standard module, It’s possible to build a custom module so that Assets can be transferred, Revalued add Interests and Dividends for Asset. In this custom module, Asset transactions can be created by manipulating Journal entries. An asset can be tracked using… Continue reading Custom Asset Module
Remove Standard Center Tabs for Roles
Remove Standard Center Tabs for Roles
Impact When Inactive is Set for Items with Open Transactions
Impact When Inactive is Set for Items with Open Transactions
Display Custom Field Checkbox Blank or Null if Not Checked
A user wants to display a Custom Checkbox as Null or Blank on Transactions sublist under the Sales subtab on Customer Records if the Checkbox is not checked or set to False. Solution Create a Custom Transaction Body Field Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New Label: Enter LabelExample: CF Checkbox ID: Enter _checkbox Type: Select Checkbox Store Value: Enter Checkmark Click Applies To Sale: Enter Checkmark Click Save… Continue reading Display Custom Field Checkbox Blank or Null if Not Checked
How to overcome the Error “Overage Is Not Allowed” Occurred when Billing the Sales Order
Scenario: When the user is trying to Edit and Save a Sales Order record with multiple line items and creating an Item Fulfillment with only one of the line items this error message is encountered. The error is encountered when the following are met: Setup > Accounting > Accounting Preferences > Allow Overage in Item Fulfilment = F Create a Sales… Continue reading How to overcome the Error “Overage Is Not Allowed” Occurred when Billing the Sales Order