Scenario Error: “You have entered an Invalid Field Value xx for the following field: custcol_in_uqc” when user is approving invoice through Invoice Approval Workflow Solution The error above is encountered if the Unit of Measure used on the transaction does not have a corresponding value in the India Tax UQC column. To resolve the error: Navigate to Lists > Accounting… Continue reading Resolve Error: “You have entered an Invalid Field Value xx for the following field: custcol_in_uqc” on Invoice Approval
Author: Shekha E K
Add Sales Order Transaction Date on Invoice
Scenario: When printing Invoices, the Date field shows the date when the Invoice was created. To show the Sales Order creation date of the Invoice, a Custom Field must be created first. Solution: Create custom Transaction Body Field: Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New Custom Transaction Body… Continue reading Add Sales Order Transaction Date on Invoice
Display print option in a record
The “Print” option missing from the record typically occurs due to one of the following reasons: 1. Form Customization The current record form might have the Print button disabled. Check the form customization settings: Go to Customization > Forms > Transaction Forms. Locate the form associated with the record Click Edit on the form. Under… Continue reading Display print option in a record
Hide Picked, Packed column from Sales order
Scenario Customize the preferred Sales Order form to hide the Fulfilled line field. Solution Navigate to Customization > Forms > Transaction Form Preferred Sales Order Form: Click Edit Click Sublist Field Fulfilled: Remove Checkmark Click Save
Resolve Error: “You have entered an Invalid Field Value xx for the following field: expenselimit” when Importing Employees
Scenario When user is trying to import Employees, they received an error “You have entered an Invalid Field Value enter Period xx for the following field: expenselimit”. Solution This error is received when the system detects that the Expense Limit column have different format set in the CSV file. To resolve this error: Edit the… Continue reading Resolve Error: “You have entered an Invalid Field Value xx for the following field: expenselimit” when Importing Employees
Resolve Error: “TRANS_UNBALNCD” when Creating Sales Order via SuiteScript
Scenario The sample snippet below generates the error : TRANS_UNBALNCD. var salesRec = nlapiCreateRecord(‘salesorder’); salesRec.setFieldValue(‘entity’,”2432″); salesRec.selectNewLineItem(‘item’); salesRec.setCurrentLineItemValue(‘item’,’item’,”33485″); salesRec.setCurrentLineItemValue(‘item’, ‘quantity’, “1”); salesRec.setCurrentLineItemValue(‘item’, ‘rate’, “140”); salesRec.setCurrentLineItemValue(‘item’, ‘taxcode’, “5”); salesRec.setCurrentLineItemValue(‘item’, ‘amount’, “145”); salesRec.commitLineItem(‘item’); var recordId = nlapiSubmitRecord(salesRec, true, true); Solution One possible cause of the error is the transaction lacks Shipping information. To resolve the error: On the… Continue reading Resolve Error: “TRANS_UNBALNCD” when Creating Sales Order via SuiteScript
Show multiple rows of the same sales order when viewing the sales order list from the Customer Center
Scenario Show multiple rows of the same sales order when viewing the sales order list from the Customer Center. Solution Login as an Administrator Navigate to Setup > Users/Roles > Manage Roles Custom Customer Center role: Click View Click Searches Click Standard Transaction: List View: Take note of the selected saved search Navigate to Lists > Search > Saved Searches Saved Search noted from step 6: Click Edit Click Criteria Filter: Select Main… Continue reading Show multiple rows of the same sales order when viewing the sales order list from the Customer Center
Unable to Enter Sales Order in the Customer Center
Scenario By default, the Customer Center has Permissions > Transactions > Sales Order = Edit. This lets users Create or Edit an existing Sales Order that they have created. In instances that the Standard Customer Center role or a Custom Customer Center role is unable to Enter a Sales Order, user can test the steps… Continue reading Unable to Enter Sales Order in the Customer Center
Populate Shipping Address Subrecord Values in Transactions Using Script
Scenario: User wants to set the values of Shipping Address subrecord using Client Script for existing records. Solution: /** * * @NApiVersion 2.x * @NScriptType ClientScript * */ define([‘N/record’, ‘N/currentRecord’, ‘N/runtime’], function pageInit(scriptContext) { try { var recordid = scriptContext.currentRecord.id; var recordtype = scriptContext.currentRecord.type; var rec = record.load({ type: recordtype, id: recordid, isDynamic: true });… Continue reading Populate Shipping Address Subrecord Values in Transactions Using Script
Write User and Session Information to the Response
A Suitelet to write user and session information for the currently executing script to the response: Solution: /** * @NApiVersion 2.x * @NScriptType Suitelet */ // This script writes user and session information for the currently executing script to the response. define([‘N/runtime’], function(runtime) { function onRequest(context) { var remainingUsage = runtime.getCurrentScript().getRemainingUsage(); var userRole = runtime.getCurrentUser().role;… Continue reading Write User and Session Information to the Response