Author: Anand Mohan

Fix the “Gateway Timeout Error” in Resource Allocation

Scenario The error is being thrown when updating Resource Allocation End Date. The Resource Allocation for one employee was incorrectly set up and the End Date was set to 1/22/60×8 instead of 12/13/20×8. The allocation was only for 0:25 hours. The Allocation Type of the Resource Allocation is set to Hard. When user tried to… Continue reading Fix the “Gateway Timeout Error” in Resource Allocation

Saved Search To Count the Number of Resource Allocations and Resources on the Resource Details of the Project Record

Scenario Create Saved Search to count the number of Resource Allocations and Resources on the Resource Details of the Project Record. Solution Navigate to Reports > Search > Saved Searches > New Click Resource Allocation Search Title: Enter Title Click Results Click Columns Click Remove All Field: Note: For every required field use the drop-down menu to select it and once adjusted click Add if needed. Select Project Summary Type: Select Group… Continue reading Saved Search To Count the Number of Resource Allocations and Resources on the Resource Details of the Project Record

How to Create Resource Allocations for Unavailable Dates (e.g. Leaves, Holidays)

Scenario A user needs to create Resource Allocations for the unavailable dates such as when the project resource will be on leave, holiday or any other valid reasons. This would require creating a dummy project, which will be the placeholder for the unavailable hours of the Project Resources. Solution Navigate to Lists > Relationships > Projects > New. Project Name: Enter Name Example: Allocation for Unavailable Dates Click Save. Click Resources… Continue reading How to Create Resource Allocations for Unavailable Dates (e.g. Leaves, Holidays)

Resolve Error: You have entered an Invalid Field Value x,xxx.xx for the following field: custrecord_slavebookvalue when Importing CSV

Scenario User is unable to proceed to import CSV file because of the above error message received.  Solution The reason why user is not able to import the CSV file is because the format of the values in the CSV file relating to the amounts is set to “Number”. The correct format should be General… Continue reading Resolve Error: You have entered an Invalid Field Value x,xxx.xx for the following field: custrecord_slavebookvalue when Importing CSV

Client needs to list invoices that are associated the sales order in a single line within a transaction saved search.

Scenario: Client needs to list invoices that are associated the sales order in a single line within a transaction saved search also by summing up the quantity for specific item in the saved search. Solution: Solution Navigate to Lists > Search > Saved Searches > New Select Transaction as the search type In Criteria tab:… Continue reading Client needs to list invoices that are associated the sales order in a single line within a transaction saved search.

NetSuite Saved Search Tips: The field with no value or the record/ form without the field has been eliminated while calculating the desired result.

Scenario: The field with no value or the record/ form without the field has been eliminated while calculating the desired result. Here within the formula the {item.custitem_aha_parent_class} field is applied to all items except discount item and there are items with no values in the field. NVL(SUM(CASE       WHEN {type} IN (‘Invoice’, ‘Credit Memo’) AND {item.custitem_aha_parent_class} <>… Continue reading NetSuite Saved Search Tips: The field with no value or the record/ form without the field has been eliminated while calculating the desired result.

NetSuite Saved Search Tips: Important usage of NVL within the formula.

Scenario: When we add formula within the saved which generates the final output with the application of multiple variables. The sample formula is provided below: (  CASE     WHEN {type} IN (‘Sales Order’) AND {quantity} <> 0 THEN    {amount} – ({quantity} * {custcol_aha_sales_invoice_cost})    ELSE 0   END) / NULLIF(  (    CASE       WHEN {type} IN (‘Sales Order’) AND {quantity} <> 0 THEN         NVL({amount}, 0)      ELSE 0     END  ),   0) However, the… Continue reading NetSuite Saved Search Tips: Important usage of NVL within the formula.

Resolving the Error: “There is a divide by zero error in this search…” on a Saved Search

Scenario: At a saved search, user encounters an error: There is a divide by zero error in this search. It may be an error with a formula you have used. Please retry without the formula(s). If an error still occurs, please file with Customer Support. If it does not, please correct your formula. Typically that… Continue reading Resolving the Error: “There is a divide by zero error in this search…” on a Saved Search

Customer Profitability Saved Search using Shipping Costs from Invoice instead of from Item Fulfillment

Scenario Some users want to get the shipping cost from their invoices because they sometimes change the amount prior to billing the customer. Solution Navigate to Lists > Search > Saved Searches > New Select Transaction as the search type In Criteria tab: FILTER Account Type is any of Income, Cost of Goods Sold  … Continue reading Customer Profitability Saved Search using Shipping Costs from Invoice instead of from Item Fulfillment