Creating Custom Child Record Sublists

1.Define a custom record type (such as the fixed assets record mentioned earlier). 2.Establish the parent–child relationship between your new custom record type (fixed assets) and another record type. Parent–child relationships are established through custom fields. Add a custom field to your new custom record type. On the field definition page for the new field,… Continue reading Creating Custom Child Record Sublists

An email template that uses anchor tags (jump links) to different areas of the message inserts the BASE tag https://system.netsuite.com/ to all relative anchors

An email template that uses anchor tags (jump links) to different areas of the message inserts the BASE tag https://system.netsuite.com/ to all relative anchors such as <a href=”#top”>Back to top</a>.   i.e. The email message includes a “Back to Top of Page” link and clicking it should return the user to the top of the page. This looks… Continue reading An email template that uses anchor tags (jump links) to different areas of the message inserts the BASE tag https://system.netsuite.com/ to all relative anchors

Wave

A wave transaction is used to consolidate orders for release to the warehouse. When you release a wave, the items from the order become available for picking and further fulfillment processing on a mobile device. Released waves display pick tickets and pick tasks generated from items in the orders, as well as status updates that… Continue reading Wave

autogenerated ID formats:

To define autogenerated ID formats: Edit the default format for the ID or code by doing the following: Using the Packing Administrator role, go to Packing > Autogenerated ID Formats > Autogenerated ID Formats. On the PackShip – Autogenerated ID Format List page, click Edit next to the format. (Optional) On the Autogenerated ID Format page, in… Continue reading autogenerated ID formats:

Create a Saved Search that will Show Number of Expense Reports filed by Employee

1) Navigate to Lists > Search > Saved Searches > New 2) Choose Transaction as Search Type 3) Under the Criteria tab > Standard subtab, add the following filterDate = is (choose date range, ex. last fiscal year)Type = is Expense ReportMain Line = is true (Yes) 4) Under the Criteria tab > Summary subtab,… Continue reading Create a Saved Search that will Show Number of Expense Reports filed by Employee

Saved Search to Compare the Amount of a Sales Order and the Invoice Created from it

1. Navigate to Reports > Saved Searches > All Saved Searches > New2. Choose Transaction link3. Modify the Search title4. On the Criteria tab > Standard subtab > set the following Criteria:    — Type is Sales Order    — Status is Sales Order: Billed    — Date | set date range for sales orders    — Main Line is false    — Billing Transaction Fields…Type is Invoice 5. On the Results tab > Columns subtab > add or remove fields as… Continue reading Saved Search to Compare the Amount of a Sales Order and the Invoice Created from it

Auto Lot Number Generation

We can auto-populate the purchase order number in Scan/Enter Lot Field within NetSuite WMS customization. The formula is dataRecord:scriptParams:transactionName

Display the Date of the Last Case Submitted by a Customer

User wants to create a custom field that displays the date of the last case submitted by the customer. A. Create a saved search to pull the date of the last case submitted. 1. Navigate to Lists > Search > Saved Searches > New > Case.2. In the Results tab, add Incident Date field and set the Summary Type to Maximum.3.… Continue reading Display the Date of the Last Case Submitted by a Customer

Ability to add the PO# (a standard field from the Sales Order Transaction) field in the Inventory Back Order Report.

The PO# field in the Inventory Back Order Report is labelled as Reference Number found in the Order Items Pending Fulfillments folder. Here are the steps:                 1. Navigate to Reports > Inventory/Items > Inventory Back Order Report > Customize.                 2. In the Edit Columns tab, add Reference Number from the Order Items Pending Fulfillments folder.                 3. Click Save.

User cannot see one of the accounts he has access to in the “View All Roles” page.

Customer has access to Account “124567 Company A” using the email address abc@noemail.com. The same customer was given access to another NetSuite account. For instance, Account 012456 Company B, using the same email address (abc@noemail.com). When the customer log in to his account, he cannot see the role/s assigned to him for Account 012456 Company… Continue reading User cannot see one of the accounts he has access to in the “View All Roles” page.