On the Results subtab, click Columns. For adding Discount Item: Select Formula(Text) from the list. In the Summary Type field, select Group CASE WHEN {item.class}=’Specify the discount name here‘ THEN {item} ELSE ” END For adding Discount Applied Item: Select Formula(Text) from the list. In the Summary Type field, select Group CASE WHEN nvl({discountamount},0)!=0 THEN {item} WHEN(NVL({grossamount},0)-NVL({netamount},0))>0 THEN {item} ELSE ” END For adding Discount Amount: Select Formula(Currency) from the… Continue reading How to add a discount item, discount applied item, and discount amount into the saved search
Month: May 2023
Assigning NetSuite Support Cases
Cases in NetSuite can track issues that the customers report and the responses the support representatives give. When Support cases are created, we can assign these support cases to one or more employees. Cases can be assigned manually or by case territories that support administrators or support managers set up. Support administrators, support managers and… Continue reading Assigning NetSuite Support Cases
Scheduling Amazon DRR reports using MultiLogin
Multilogin is a tool that allows users to manage multiple Amazon Seller Central accounts simultaneously from one browser. With Multilogin, users can schedule data range reports for their Seller Central accounts to automatically run at specific times. To schedule a data range report(DRR) using Multilogin, you will need to follow these general steps: Log in… Continue reading Scheduling Amazon DRR reports using MultiLogin
NetSuite Activity Codes
The NetSuite activity codes enable users to categorize different aspects of their projects, which improves both reporting and budgets. You can use the activity codes feature when you also have enabled the Advanced Project Budgets feature. With activity codes, you can set up a logical categorization for your project activities. You can also create global… Continue reading NetSuite Activity Codes
NetSuite Advanced Project Budgets Feature
Advanced Project Budgets provides several key benefits. For one thing, it allows you to set up a work breakdown structure, or WBS, for your projects. This means that you can define the hierarchical relationships within your projects. This feature also (as the name suggests), provides advanced budgeting capabilities. It allows you to budget effectively for… Continue reading NetSuite Advanced Project Budgets Feature
To find the Days difference between the two Dates
When we need to find the days difference between two dates use the below-added code. Add the configuration module to the script The comparing date should be in the same format. Here if ‘todayDate’ is 30/05/2023, and the ‘referenceDate’ is 28/05/2023, then the ‘differenceInDays’ value will be ‘2’. If ‘todayDate’ is 28/05/2023, and the ‘referenceDate’… Continue reading To find the Days difference between the two Dates
NetSuite Use Deletion Reason Feature
In some countries, recording a reason for deleting transactions is legally required? And even if you don’t have business transactions in a country with that requirement, you may still find it helpful to keep a record of why you chose to delete transactions. The NetSuite Use Deletion Reason feature provides a native NetSuite way for… Continue reading NetSuite Use Deletion Reason Feature
The Power of Newsletters: Fueling Success in the Corporate World
In the bustling corporate landscape, effective communication holds the key to success. One invaluable tool that enables companies to connect, engage, and inform their audience is the humble NewsLetter. A well-crafted and strategically implemented newsletter can yield numerous benefits for a company, enhancing internal cohesion, nurturing customer relationships, and driving business growth. Let’s delve into… Continue reading The Power of Newsletters: Fueling Success in the Corporate World
Print Picking Ticket Field value changes from True to False reason
When a user prints a Picking ticket from a sales order record, then the field value of that ‘print picking ticket’ on the sales order’s system note, will be changed from False to True for the first time. If the sales order is partially fulfilled, then after the user prints the picking ticket for that… Continue reading Print Picking Ticket Field value changes from True to False reason
Enter a statistical journal
Go to Transactions > Financial > Make Statistical Journal Entries. If you use a customized user center or user role, Make Statistical Journal Entries must manually be added to the center or role to access this menu option. In the Primary Information section: In the Entry No. field, accept the default, or enter a different number. In the Date field, accept today’s… Continue reading Enter a statistical journal