Scenario: Developed an excel file using the XML file saved in Excel. But when downloaded an excel file from netsuite, it shows different currency signs in excel and WPS Solution: Open the excel file in WPS and save the file in xml format there and then take the style used for currencies in WPS and… Continue reading Issue: When downloaded an excel file from netsuite, it shows different currency signs in excel and WPS
Author: Lakshmi priya Suresh
Downloading the Excel File from Sales Order
Requirement: Add a new button for sales order records called “Download excel.” In that button’s action, the excel file must be downloaded in excel format. The file must be named in the format “document number.xls”. Solution:
Fetching UPS package delivery status multiple tracking numbers
Scenario: Fetch delivery status for each tracking number in an Item Fulfillment Solution
Resolve Error: “The template cannot be printed due to the following errors: Error on line XXX, column YYY in template. Detail… Please contact your administrator.” When Printing Transactions
Scenario: Even if there’s no any HTML or FreeMarker syntax error within the template, this error message appears when a transaction or record is printed using Advanced PDF/HTML Templates This may be caused by any Rich Text field which is used within the Advanced PDF/HTML Template. Rich Text formatting applied to such custom field is… Continue reading Resolve Error: “The template cannot be printed due to the following errors: Error on line XXX, column YYY in template. Detail… Please contact your administrator.” When Printing Transactions
Rejection Popup window
Requirement: When clicked on the Rejection button in PO , a pop-up window for entering the rejection reason should appear. once the user enter the reason, this reason should be saved in a custom field in PO Solution
Dynamically Source the UOM List into a Suitelet Select Field
Scenario User wants a Suitelet to have a Select field sourcing the Unit Of measure List from another field. In this scenario, the list is being retrieved from the Inventory record. Solution
IQmetrix Integration
Requirement: We need to be able to sell through data.By any date range we want By any dealer?Can it fetch daily and add it and we can analyze all that data through a saved search?We will use the 8 digit UID to filter different stores .Take all the sell thru data and add it to… Continue reading IQmetrix Integration
Email sending functionality when an item fulfilment is created over a 7-days period
Requirement: Over a seven-day period, we have issued email alerts to customers to recognize the sales order is ready for distribution. We are not checking the partial item fulfillment situation of the sales order in the present functionality. When several item fulfilment records are created from the same sales order, the consumer becomes confused as… Continue reading Email sending functionality when an item fulfilment is created over a 7-days period
Repeat a string n times in freemarker
Requirement: Need to repeat a string of characters n times, where n is a variable Solution: Use list to iterate a range:
Remove the CORRESPONDING PO and ETA Column Values from Sales Orders (update)-Proposal
Requirement Identify the sales orders when it’s ordered and committed quantities become equal and remove the corresponding PO and ETA column values from the sales orders item line. Our Solution We will develop a Map/Reduce script that executes twice in a day. So, the script will fetch all sales orders having at least one purchase… Continue reading Remove the CORRESPONDING PO and ETA Column Values from Sales Orders (update)-Proposal