Navigate to Lists > Search >Saved Search > New, then select item search. Provide the criteria and results as per the requirement. Under the results tab, select ‘Formula(currency)’ Select summary type as ‘Maximum’ Provide the formula: MAX(({transaction.rate}*{transaction.quantity})/{transaction.quantityuom}) KEEP(DENSE_RANK LAST ORDER BY {transaction.trandate} ) Then save and run the search
Author: Mindu Paul
Item saved search to get the last purchase price from the most recent PO
Client requested to retrieve the last purchase price from the most recent PO. Navigate to Lists > Search >Saved Search > New, then select item search. Provide the criteria and results as per the requirement. Under the results subtab, select Transaction Fields: Item Rate Summary type – Maximum When ordered by field – Transaction Fields:… Continue reading Item saved search to get the last purchase price from the most recent PO
How to create sublist action group
If you have not already done so, open the existing workflow that contains the state where you want to create an action group in edit mode. In the diagrammer, select the state and click the Edit icon on the State tab in the context panel. Click New Sublist Group. The Sublist Action Group window appears with the Type field set to Sublist Action… Continue reading How to create sublist action group
Why is the standard Alternate Email field not appearing in vendor and customer records?
Navigate to Lists > Relationships > Vendors/ Customers > New On the page that opens, if the customer/vendor type is set to “Company,” the standard Alt. Email field will not be displayed. Select “Individual” as the type to make the Alt. Email field visible.
To Update Address field using CSV import
User is updating the Address field that is exposed in the primary information section of the form. Navigate to Setup > Import/Export > Import CSV Records Import Type: Select Relationships Record Type: Select Customers Only CSV File(s): Click Select… and select the file Click Next Data Handling: Select Update Field Mapping: Your Fields: Select Internal ID NetSuite Fields: Select Internal ID Your Fields: Select Address Line 1 NetSuite Fields: Select Address1 Your Fields: Select Address Line 2 NetSuite Fields: Select Address2… Continue reading To Update Address field using CSV import
To make CSV imports public
Opening the Share Import Dialog from the Import Assistant After you have saved an import job, on the Finished page, click Share Import. Opening the Share Import Dialog from the Saved CSV Imports Page Go to Setup > Import/Export > Saved CSV Imports to see all imports to which you have access. Review an import’s setting in… Continue reading To make CSV imports public
Setting Up Rebate Agreement Records
After the installation of Rebate and Trade Promotions SuiteApp completes, you must set up all the required records to set the conditions for how rebates should be calculated, applied, and settled. The following records must be created before you create or enter transactions: Rebate Preference When you set rebate preferences, you can specify the rebate… Continue reading Setting Up Rebate Agreement Records
Limiting Inventory Transfers from and to a particular Location.
Navigate to Customization > Workflow > Workflows > New. Select the record type as transaction Select Inventory Transfer from the subtype Set the workflow to trigger on Create and Edit events. Add a State and set the action as ‘Return User Error’ Then add condition to the state In the workflow condition, select the fields… Continue reading Limiting Inventory Transfers from and to a particular Location.
To get amount without tax in transaction saved search
1. Go to Reports > Saved Searches > All Saved Searches > New > Transactions 2. Under the Criteria tab > Standard subtab, add Filters: Select Type Main Line = is True 3. Under the Results tab > Columns subtab, add Fields: Formula (Currency) = nvl({totalamount},0)-nvl({discountamount},0)-nvl({taxtotal},0)-nvl({shippingamount},0) 4. Change the Search Title 5. Click Save & Run
Formula to get the sum of the count of on-hand inventory at particular locations using workbook
Click on Analytics tab Select Item dataset Select formula field Type the formula: CASE WHEN {inventorybalance.location#display} IN (‘L1′,’L2′,’L3’—>Name of locations) THEN ‘Location Sum’ END Save the dataset and apply to the workbook Select desired visualization type Then select the formula field