Author: Hari Krishnan

Resolve Error: “Error Parsing XML: The entity name must immediately follow the ‘&’ in the entity reference”

This issue is normally seen in PDF and XML file of the pdf template which are rendered through script. This happens when our data contains ‘&’. ‘&’ are not supported in pdf and xml. Instead need to use ‘&’ Solution This can be resolved by using replace() function Example: If you are updating Advanced PDF… Continue reading Resolve Error: “Error Parsing XML: The entity name must immediately follow the ‘&’ in the entity reference”

Setting Default India HSN and SAC Codes on Shipping Item Records

To assign a default India HSN or SAC code on a shipping item record: Go to Lists > Accounting > Shipping. Click Edit next to the shipping record. In the India Tax HSN or SAC Code field, select the default HSN or SAC code for this shipping item record. Depending on your shipping preference, this code applies to both shipping… Continue reading Setting Default India HSN and SAC Codes on Shipping Item Records

Render PDF using Suitelet and Set Filename via SuiteScript

Solution Deploy the following code on a Suitelet: function renderPDF(context){‌ var serverResponse = context.response; //Gets the response object var testData = ‘TEST BODY’; //Test string to be rendered as PDF var filename = ‘PurchaseOrder_123456.pdf’; //Sample File name to be set when downloaded serverResponse.setHeader({‌ name: ‘Content-disposition’, value: ‘filename=”‘ + filename + ‘”‘, }); //sets the filename to… Continue reading Render PDF using Suitelet and Set Filename via SuiteScript

Number Formating in PDF Template

Solution For example, if currently the ${item.rate} is shown as 8.6354, we can use number formatting to format the digits display after the decimal. ${item.rate?string(“##0.0”)} This helps to format the digits. After formatting it will be displayed as 8.6

Cannot enter more quantity for components on Work Order Issue then Work Order

When the Accounting Preference “Allow Overage on Work Order Transactions” is enabled, users are not able to increase the quantity of components on Work Order Issue. Solution Check whether the following Accounting Preference is set to “Limit to Committed“: Setup > Accounting > Accounting Preference Click on Order Management tab Go to Manufacturing Issue Based on Commitment If this preference is set to “Limit to Committed“, we… Continue reading Cannot enter more quantity for components on Work Order Issue then Work Order

Create a Saved Case Search Based on Case Aging

Report on Support Cases which were closed within a certain number of days or which are considered aging. Solution Create a Saved Case Search that were closed in X days. In this example, assume that X = 7 days. Navigate to Lists > Search > Saved Searches > New Select Case Search Title: Enter a Search Title Check Public checkbox Click Criteria tab  Click Standard subtab Filter:  Select Formula (Numeric) Saved Case Search popup: Formula: Enter CASE WHEN (ROUND({‌closed} –… Continue reading Create a Saved Case Search Based on Case Aging

Create a Case Rule that Picks Up Some Keywords From an Inbound Email

The user can make use of the Incoming Message case field when creating a case rule as long as the Email Case Capture is enabled in the account (Setup > Company > Enable Features > CRM tab > Support section).  To set up a case rule, please see the steps below. Solution Navigate to Setup > Support > Case Rules > New  Click Case Fields, click Incoming Message In the Name field, enter a… Continue reading Create a Case Rule that Picks Up Some Keywords From an Inbound Email

Merge Customer Records with same Email address that is not being detected as Duplicate Records

Solution Enable Duplicate Detection for Customers and Vendors with different Subsidiaries Navigate to Setup > Company > Duplicate Detection  Detect Duplicates Across Subsidiaries (Customers and Vendors Only):Enter Checkmark Click Save Merge the Customer records Navigate to Lists > Relationship > Customers Click Edit to the Customer you would like to set as a Child record Select Master Customer RecordNote: This is where the child record will be merged. Click Merge Click OK Click Refresh