Adding condition in Email template

We have met a scenario where we need to take the difference between two field and convert that answer in to 2 decimal points Here the two field are ‘transaction.shippingcost’ and ‘transaction.custbody_srtipesubtotal’. So taking the difference between these fields and assigning that two a variable ‘shippingcostvalue’ .Then checking whether the variable ‘shippingcostvalue’ has content. If… Continue reading Adding condition in Email template

What is Semantic Search?

Semantic search helps search engines understand the meaning of the search queries and give results that are relevant to the query. For example, if you search for “Jennifer Lawrence”, Google will give you relevant results that are related to the actress, fashionista, and star of the Hunger Games. This is possible because Google understands entities… Continue reading What is Semantic Search?

To display a unique value on the transaction line of the Sales Order.

Scenario: User wants to show the Line Unique Key field value in the UI on the Sales Order. SolutionNavigate to Customization > Lists, Records, & Fields > Transaction Line Fields > NewLabel: Enter Unique KeyType: Select Integer NumberStore Value: Remove CheckmarkClick Applies ToSale: Enter CheckmarkClick Validation & DefaultingFormula: Enter CheckmarkDefault Value: Enter {lineuniquekey}Click Save Note:… Continue reading To display a unique value on the transaction line of the Sales Order.

Average rate calculation in Consolidated Exchange rate

Scenario: The procedure in which NetSuite calculates the average rate in the consolidated exchange rate page. Solution: NetSuite calculates the average rate in the consolidated exchange rate by weighted average based on transactions amounts posted to all accounts with a general rate type of Average. Here all the transaction amount in the base currency is… Continue reading Average rate calculation in Consolidated Exchange rate

NetSuite – Single Vendor ERP

A single vendor ERP is an ERP that includes almost all modules such as finance, order processing, and supply chain. As a result, it will cover the vast majority of business requirements and processes. It requires little maintenance. If, as the organization grows, the business requires any addition of modules, users can easily add on… Continue reading NetSuite – Single Vendor ERP

Map reduce Script- Automatic credit notes generation

Requirements: All the return authorizations which have the status Pending Refund, Pending Refund/Partially Received, and “Exclude Auto credit” unchecked will be taken and be creating credit notes through workflow/script. Return Authorization having the item “MISCSALE” will be excluded from the automatic credit note generation process. An email notification will be sent to the corresponding customer… Continue reading Map reduce Script- Automatic credit notes generation