Author: Parvathi K J

The formula to calculate for the quantity of each item that shows on the Items to Order page if the Replenishment Method = Reorder Point: (Preferred stock level + quantity needed ) less (quantity available + quantity on order ) Where: A. Quantity Needed = The Quantity on Sales orders* and Transfer Orders.  *Quantity on… Continue reading Calculate Quantity per Item on the Order Items Page

To show the Memo field of the Sales Order on the related Work Order Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New Label: Enter Label Type: Select Free-Form Text Store Value: Remove Checkmark Click Applies To  Work Order/Assembly Build: Enter Checkmark Click Display  Subtab: Select Main Display Type: Select Inline Text Click Sourcing & Filtering  Source List: Select Created From Source From: Select Memo Click Save

It is possible to customize the Print Bills of Materials page found under Print Checks and Forms to add or remove columns for reviewing. However, the Status field of the related Sales Order is not available for this selection when a Work Order is created from the Sales Order. To achieve this, a custom transaction… Continue reading Add Column to See Sales Order Status on Work Order Print Bills of Materials

Scenario Some users require to have receipts printed in all capital letters. There is a setting in NetSuite Point of Sale (NSPOS) that allows this output. Solution Login to NSPOS as an Administrator Press Ctrl + F10 Settings Window: Search Print in Caps Print in Caps: Enter Checkmark Click Done Note: Restart NSPOS for the change to take effect.

There are situations where the user decides to change the account’s FedEx Account Number but after updating the existing FedEx Account, the FedEx Meter Number does not get updated.  The user must first delete the existing FedEx Account by opening the FedEx registration page  Hover over to Actions > Delete  After the FedEx Account has… Continue reading Key Integration Points to Consider When Implementing FedEx and UPS

After we’ve enabled both the Multi-Location Inventory and Shipping Label Integration features, we can set up different UPS, USPS, and FedEx accounts for each location.  We can then receive UPS, USPS, and FedEx real-time rates and labels specific to the warehouse you are shipping from and set up pick-up preferences for each warehouse.  With shipping… Continue reading Shipping Integration with Multiple Locations

NetSuite allows users to enter a lead time for Item records when Auto-Calculate check box for Lead Time is marked. Thus, to update Lead Time via CSV Import, Auto-Calculate check box for lead time should be unmarked. Users can update the Lead Time field and unmark Auto-Calculate for Lead Time check box together through CSV… Continue reading Update Item Record Lead Time via CSV Import

Scenario By default, the Currency field in the Non-Inventory Item record is set as Disabled which does not allow users to edit the field. This setting can be bypassed by creating a workflow to set field display as Normal. Solution Navigate to Customization > Workflow > Workflows > New Basic Information: Name: Enter Currency Display Record Type: Select Item Sub Types: Select Non-Inventory Part Release Status: Select Released Keep Instance… Continue reading Set the Currency Field on Non-Inventory Items to be Available for Editing

Scenario Created a matrix item and the item is available in the Webstore but the Matrix option is not available for selecting Solution Navigate to Customization > List, Records & Fields > Transaction Item options. (Transaction item options are fields that you can ass to the line items of your transaction records to gather information… Continue reading Matrix Option Is not showing in Web Store