Category: NetSuite ERP

NetSuite ERP

Customer Aging Report Using Saved Search

var invoiceSearchObj = search.create({    type: “invoice”,    filters:    [       [“type”,”anyof”,”CustInvc”],        “AND”,        [“mainline”,”is”,”T”],        “AND”,        [“amountremaining”,”greaterthan”,”0.00″]    ],    columns:    [       search.createColumn({          name: “entity”,          summary: “GROUP”,    … Continue reading Customer Aging Report Using Saved Search

XStudio

XStudio, a test management software designed to help teams manage the entire testing process, including test case creation, execution, and tracking. Key features of XStudio may include: Test Case Management: Organize and manage test cases efficiently, including the ability to group them into test sets or campaigns. Test Execution: Execute manual and automated test cases… Continue reading XStudio

Customer Aging Report Using Saved Search

var invoiceSearchObj = search.create({    type: “invoice”,    filters:    [       [“type”,”anyof”,”CustInvc”],        “AND”,        [“mainline”,”is”,”T”],        “AND”,        [“amountremaining”,”greaterthan”,”0.00″]    ],    columns:    [       search.createColumn({          name: “entity”,          summary: “GROUP”,    … Continue reading Customer Aging Report Using Saved Search

NetSuite’s Immutable System Notes for Comprehensive Record Tracking

NetSuite employs System Notes to meticulously document any modifications made to a record. These notes capture crucial information such as the date and time of the change, the initiator of the change, the interface used, the type of change, the specific field that underwent modification, and the before-and-after values within the record. Notably, System Notes… Continue reading NetSuite’s Immutable System Notes for Comprehensive Record Tracking

Moving Fields and Lists Between Subtabs

Requirement User is needed to move the terms field from the Billing tab to the Main Body fields. Solution To move fields and lists between subtabs: Edit the form to be customized. Click the button “Move Elements Between Subtabs“ Choose the subtab where the “Terms” field to be displayed. Click Save.

Recalculating Line Item Amounts When the Tax Code Changes

When you change the tax code on a line item, the system recalculates the amounts depending on the order of the columns on the form. If the Amount column is before the Gross Amt column, then whenever you change the tax code on the line item, the system updates the value in the Gross Amt column based on the tax rate… Continue reading Recalculating Line Item Amounts When the Tax Code Changes

To cumulate the sales amount based on the salesperson considering amount from parent class.

Scenario: To cumulate the sales amount based on the salesperson considering amount from parent class and sorting using the date and internal ID. Solution: List> Search> Saved Searches Select Transactions Enter Search Title Criteria: Type: Sales Order Main line: False Tax line: False COGS: False Shipping: False Results: Field: Transaction date Field: Sales person Field:… Continue reading To cumulate the sales amount based on the salesperson considering amount from parent class.

Republish a published dashboard

To re-publish an already published dashboard and override the customizations done by users with the original published dashboard setup. Follow the steps below to do this: Edit the Published Dashboard record to re-publish. Mark the Override Existing User’s Settings checkbox for each Role(s) in the Apply To Roles sublist to restore the original dashboard setup.… Continue reading Republish a published dashboard

To cumulate the sales amount based on the salesperson considering amount from parent class.

Scenario: To cumulate the sales amount based on the salesperson considering amount from parent class and sorting using the date and internal ID. Solution: List> Search> Saved Searches Select Transactions Enter Search Title Criteria: Type: Sales Order Main line: False Tax line: False COGS: False Shipping: False Results: Field: Transaction date Field: Sales person Field:… Continue reading To cumulate the sales amount based on the salesperson considering amount from parent class.