If the discount amount is in Currency format: To calculate the amount of discount that each item receives, we can follow these steps: Calculate the total value of the order before any discounts are applied. For each item on the order, calculate the weight of the item as a proportion of the total value of… Continue reading How discount values are calculated and fetched in saved searches and reports
Tag: saved search
Types of Discount Items in Sales Orders and Saved Search
In NetSuite, there are two types of discount items: posting and non-posting. For Transactions:: Posting Discount Item: A posting discount item is a type of discount item that affects the posting of the transaction. When a posting discount item is applied to a transaction, the discount amount is recorded in the general ledger and affects… Continue reading Types of Discount Items in Sales Orders and Saved Search
Remove Parent Item Name in Saved Searches
Remove Parent Item Name in Saved Searches
Saved Search and receives a “Field Not Found” error.
Saved Search and receives a “Field Not Found” error.
SuiteQL to generate a Customer saved search in Power BI via ODBC connector
The requirement was to connect NetSuite searches with Power BI in order to create the reports. We can load tables from NetSuite to Power BI based on the permissions given in the custom role. The searches cannot be load this way. As solution to this we can use SQL queries to recreate the same search… Continue reading SuiteQL to generate a Customer saved search in Power BI via ODBC connector
Total Tax rates from invoices using saved search (Line total)
The Total tax rates from invoices or sales orders can be calculated using the formula: Total tax rate: ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘State’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘County’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype} = ‘District 1’ THEN {taxitem.rate} ELSE NULL END),4) + ROUND(MAX(CASE WHEN {taxitem.taxtype}… Continue reading Total Tax rates from invoices using saved search (Line total)
Proposal For Appointment Report and CRM Report- Phase 1
Proposal For Appointment Report and CRM Report- Phase 1
SuiteQL to generate a saved search in Power BI via ODBC connector
The requirement was to connect NetSuite searches with Power BI in order to create the reports. We can load tables from NetSuite to Power BI based on the permissions given in the custom role. The searches cannot be load this way. As solution to this we can use SQL queries to recreate the same search… Continue reading SuiteQL to generate a saved search in Power BI via ODBC connector
How to pass the date to a search dynamically based on the system date format changes
How to pass the date to a search dynamically based on the system date format changes
Display Quantity Available less than 10 as 0 in a saved search
List>search>Saved searches >New Under the Result, Tab Give the Fields as shown below Name Available ( this shows the available quantity of the items) Formula (Numeric) : CASE WHEN {quantityavailable}<10 THEN 0 ELSE {quantityavailable} END (under the formula option) Here the quantity available is 0 for the available quantity less than 10.