This error is received when the system detects a non-numeric character under the Period x Amount columns (that is columns J till U in Budgets Template file from Transactions> Financial> Set Up Budgets> Import> Budgets Template File link). To resolve this error, check the CSV file being used in the import. Make sure that Period x Amounts columns all have numeric… Continue reading Budget Import> Error Details: You have entered an Invalid Field Value enter Period xx Amount for the following field: periodamountxx
Month: January 2024
Why Sitemaps Matter for Your Website
Improved indexing: Search engines prioritize websites with readily available sitemaps. A well-formatted map makes their job easier, increasing the chances of all your pages getting indexed and appearing in search results. Faster crawling: A sitemap streamlines the crawling process, allowing search engines to quickly identify and understand your website’s structure. This translates to faster indexing and potentially higher rankings. Priority guidance: You… Continue reading Why Sitemaps Matter for Your Website
Data Migration Process
When it comes to data migration in NetSuite, it involves transferring your existing data from other systems or spreadsheets into NetSuite. This process ensures that your historical data, such as customer records, sales transactions, inventory information, and more, is available in NetSuite for ongoing operations and reporting. To migrate your data effectively, you’ll typically… Continue reading Data Migration Process
Sending email to all the customers for overdue Invoices
Map/Reduce script is designed to run monthly and send overdue invoice reminders to customers via email. 1. getInputData: – Purpose: Generates input data for the map/reduce process. – Retrieves overdue invoices from the previous month using a search. – Filters include invoices with a due date before the start of the current month, with a… Continue reading Sending email to all the customers for overdue Invoices
Scripting the Sales/Pricing tab in the item record.
The client (BGGN) would like to copy the costing details from the costing subtab to the sales/Pricing subtab in the item record. We have created a user event script that will fetch the costing from the costing subtab and store them in the corresponding sales/Pricing details tab. Initially, we will identify the internal id of… Continue reading Scripting the Sales/Pricing tab in the item record.
Sales order PDF template
The client would like to create a PDF template by clicking the print button from the sales order record. We have customized the advanced pdf template and applied it to the forms used for creating the sales order. <?xml version=”1.0″?><!DOCTYPE pdf PUBLIC “-//big.faceless.org//report” “report-1.1.dtd”> <pdf> <head> <link name=”NotoSans“ type=”font“ subtype=”truetype“ src=”${nsfont.NotoSans_Regular}“ src-bold=”${nsfont.NotoSans_Bold}“ src-italic=”${nsfont.NotoSans_Italic}“ src-bolditalic=”${nsfont.NotoSans_BoldItalic}“ bytes=”2“… Continue reading Sales order PDF template
Purchase order pdf
The client would like to create a purchase order pdf on clicking the Print from the Purchase order record. We have customized the advanced pdf template and applied the same to the form used for creating the purchase order. <?xml version=”1.0″?><!DOCTYPE pdf PUBLIC “-//big.faceless.org//report” “report-1.1.dtd”> <pdf> <head> <link name=”NotoSans“ type=”font“ subtype=”truetype“ src=”${nsfont.NotoSans_Regular}“ src-bold=”${nsfont.NotoSans_Bold}“ src-italic=”${nsfont.NotoSans_Italic}“ src-bolditalic=”${nsfont.NotoSans_BoldItalic}“… Continue reading Purchase order pdf
Proforma invoice PDF Template
The client would like to print the proforma invoice from the sales order record. We have created a custom button in the sales order record and on clicking the Print proforma invoice button the pdf will be printed. <?xml version=”1.0″?><!DOCTYPE pdf PUBLIC “-//big.faceless.org//report” “report-1.1.dtd”> <pdf> <head> <link name=”NotoSans“ type=”font“ subtype=”truetype“ src=”${nsfont.NotoSans_Regular}“ src-bold=”${nsfont.NotoSans_Bold}“ src-italic=”${nsfont.NotoSans_Italic}“ src-bolditalic=”${nsfont.NotoSans_BoldItalic}“ bytes=”2“… Continue reading Proforma invoice PDF Template
Setting a table field as empty if any of the content is empty
<tr padding-bottom=”3px“> <td colspan=”3“ align=”left“ color=”#4472C4“ style=”font-size:10.5px;vertical-align: middle;“>Return speed: </td> <td colspan=”3“ style=”border: 1px solid rgb(187, 187, 187);font-size:10.5px;line-height:13px;“ vertical-align=”middle“></td> <td colspan=”2“ align=”right“ color=”#4472C4“ style=”font-size:10.5px;vertical-align: middle;“>Insure for: </td> <td colspan=”4“ style=”border: 1px solid rgb(187, 187, 187);font-size:10.5px;line-height:13px;“ vertical-align=”middle“> <#if record.custrecord_vr_outbound2_contact1?has_content && record.custrecord_jj_outbound2_address_text?has_content && record.custrecord_vr_svcord_outbound2_shipcarr?has_content && record.custrecord_vr_svcord_outbound2_shipacct?has_content && record.custrecord_vr_outbound2_contact2?has_content && record.custrecord_vr_outbound2_contact3?has_content && record.custrecord_jj_return_facility_2?has_content > ${record.custrecord_vr_svcord_insurefor} <#else> N/A </#if>… Continue reading Setting a table field as empty if any of the content is empty
Showing the whole table as empty/Not available if there is no content in the table
<table> <tr> <td> <#if record.custrecord_vr_outbound3_contact1?has_content || record.custrecord_jj_outbound3_address_text?has_content || record.custrecord_vr_svcord_outbound3_shipcarr?has_content || record.custrecord_vr_svcord_outbound3_shipacct?has_content || record.custrecord_vr_outbound3_contact2?has_content || record.custrecord_vr_outbound3_contact3?has_content || record.custrecord_jj_return_facility_3?has_content > <table style=”width: 100%; border: 1px solid rgb(187, 187, 187);padding-bottom:3px;padding-right:8px;height:233“> <tr padding-bottom=”8px“><td background-color=”rgb(187, 187, 187)“ colspan=”9“ style=”font-size:10.5px“>Return Shipping Information – Location 3</td> <td colspan=”3“ ></td></tr> <tr padding-bottom=”3px“> <td colspan=”3“ align=”left“ color=”#4472C4“ style=”font-size:10.5px;vertical-align: middle;“>Contact: </td> <td colspan=”9“ style=”border: 1px… Continue reading Showing the whole table as empty/Not available if there is no content in the table