ScenarioAn Inbound Shipment in In Transit status is being deleted but the error “You cannot delete item already associated with an ownership transfer.” comes up when ownership has already been transferred. SolutionThis may occur due to a separate Ownership Transfer record which is being created when ownership is transferred to the company. Navigate to Transactions… Continue reading When deleting an Inbound shipment in Transit error shows “You cannot delete item already associated with an ownership transfer.”
Author: Anand Mohan
While billing a Billing Inbound Shipments error popping up “Please enter value(s) for: Reference No.”
Senario: Upon billing an Inbound Shipment, the processing yields an error: “Please enter value(s) for: Reference No.” Solution: This error can be avoided by setting the Reference No. as non-mandatory on the Vendor Bill. Go to Customizations > Forms > Transaction Forms Click Edit beside the Vendor Bill form that is Preferred On the Custom… Continue reading While billing a Billing Inbound Shipments error popping up “Please enter value(s) for: Reference No.”
Remove All Spaces in Item Records Description as Displayed in the Search Results
Scenario: User wants to pull up the Sales Description field with no spaces. Solution: Navigate to Reports > Saved Searches > All Saved Searches > NewSelect TransactionOn the Criteria tab > Standard subtab, add the following filters:Filter:Select Type (select the Item Types you want to include in the search results. Example: Assembly/Bill of Materials, Inventory… Continue reading Remove All Spaces in Item Records Description as Displayed in the Search Results
Display the item description that contain non-alphanumeric value in their Item Search
Scenario: The user needs to display items descriptions that contains non-alphanumeric values. Solution: 1. Navigate to Lists > Search >Saved Searches > New 2. Click Item 3. Search Title: Enter a new Title 4. Click Criteria tab 5. Click Standard sub tab 6. Filter Select Formula (Text) | Formula : REGEXP_REPLACE ((REGEXP_REPLACE (Replace({name},’ ‘,”), ‘(\d*)’, ”)), ‘[[:alpha:]]’, ”) | Formula (Text) : is not Empty Click Add Save and Run
Requirement to display the Foreign Currency Amount without the Currency symbol in a Saved Transaction Search
Scenario: User wants to display the Amount (Foreign Currency) without the Currency Symbol in a Saved Transaction Search. Solution: Navigate to Lists > Search > Saved Searches > NewClick TransactionSearch Title: Enter TitleClick CriteriaClick StandardFilter: Add all necessary filtersClick ResultsClick ColumnsField:Select Formula (Currency)Formula: Set {fxamount}Custom Label: Enter Amount (Foreign Currency)Click Save & Run
Need to split the character in the field and display the same.
Senario: User need to show Customer ID and Customer Name as Separate fields in transaction saved search. Solution: Navigate to Reports > Saved Searches > All Saved Searches > New.Click Transaction.Enter the needed filters in the Criteria tab.Under the Results tab, enter the needed information and add the following:Formula (Text) | Formula: SUBSTR ({name}, 1,5)Formula… Continue reading Need to split the character in the field and display the same.
Add a Column for Item Line Memo Instead of Body Memo in the Income Statement
Scenario: Customer wants to add a Column for Item Line Memo Instead of Body Memo in the Income Statement. Solution: Customize Income Statement Report Under Edit Columns tab and Search Fields text box, search for Description Choose Description under Financial > Description Click Preview or Save
User needs to pull up the Memo from the Item Line Level of the transaction.
Scenario: Users need to pull up the Memo from the Item Line Level in the Income Statement Report Solution: Navigate to Reports > Financial > Income Statement > Customize On the Edit Columns, expand the Financial folder, expose the Description Hit Preview/Save Note: The Description that will be exposed will be coming from the transaction… Continue reading User needs to pull up the Memo from the Item Line Level of the transaction.
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