An error occurred while saving the Return Authorization : “an Error Occurred While Processing Item Options”

Upon Return Authorization creation, an error notice “An error occurred while processing item options” was received. Solution   Create a test manual Return Authorization Look for Custom Fields where an error is thrown Example: One of the Custom Column Field on the Return Authorization has this error: ‘Field ‘startdate’ Not Found’   Go to Customization > Lists, Records & Fields >Transaction Line Fields to… Continue reading An error occurred while saving the Return Authorization : “an Error Occurred While Processing Item Options”

Display Lot Number Column on Advanced PDF/HTML Template for Invoice

In an Advanced PDF/HTML Template for Invoice, the Lot Number column is required to be displayed. Navigate to Customization > Forms > Advanced PDF/HTML Templates Preferred Advanced PDF Template: Click Edit Source Code: Add below code <#if record.class = “04 Aviation”> <th align = “right” colspan “4”> Lot Number </th> <#else> <th></th> <#if> <#if record.class = “04 Aviation”> <td align = “right” colspan… Continue reading Display Lot Number Column on Advanced PDF/HTML Template for Invoice

Print Status for Closed Sales Order Only Using Basic PDF Layout

There is a requirement to print Status for closed Sales Orders only utilizing Basic PDF Layouts. This is achievable by creating a Custom Body Field and customizing the Sales Order Form. Create Transaction Body Field Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New Label: Enter Label Example: Closed Type: Select Free-Form Text Store Value: Remove Checkmark Click Applies To tab Sale: Enter Checkmark Click Validation & Defaulting tab Formula: Enter Checkmark Default Value: Enter CASE… Continue reading Print Status for Closed Sales Order Only Using Basic PDF Layout

Display Sum of Two Custom Columns in Invoice Using Basic PDF Layout

There are instances when the sum of two Custom Columns needs to be printed on an Invoice using Basic Transaction PDF Layout. This article shows how to achieve this using a Saved Search and Transaction Body Field. In this scenario, the two columns are named Commission Amount and Net Amount. Create a Saved Search Navigate to Lists > Search > Saved… Continue reading Display Sum of Two Custom Columns in Invoice Using Basic PDF Layout

The script is for store the available quantity at custom line fields when adding item into item sublist.

/**  * @NApiVersion 2.1  * @NScriptType ClientScript  * @NModuleScope SameAccount  */  define([‘N/search’],  /**   * @param{currentRecord} currentRecord   * @param{record} record   */  function(search) {      /**       * Function to be executed after page is initialized.       * @param {Object} scriptContext       * @param {Record} scriptContext.currentRecord -… Continue reading The script is for store the available quantity at custom line fields when adding item into item sublist.

The client Script to set addressee field on the address form as empty

/**  * @NApiVersion 2.1  * @NScriptType ClientScript  * @NModuleScope SameAccount  */ define([],     /**      * @param{currentRecord} currentRecord      * @param{record} record      */     function() {         /**          * Function to be executed after page is initialized.          *… Continue reading The client Script to set addressee field on the address form as empty

Send Email Alert using Transaction Saved Search when Item Fulfillment Status Changes

User creates a Transaction Saved Search to send an email alert that is triggered whenever there is a change in the Item Fulfillment status. However, user has customized its Item Fulfillment Status names and the email alert does not send as expected. The system still respects standard name of the status of the Item Fulfillment (Picked/Packed/Shipped), regardless of the name… Continue reading Send Email Alert using Transaction Saved Search when Item Fulfillment Status Changes

Scheduled Search Email Limitations

The Show Internal IDs preference does not apply to results in scheduled saved search email. You must add Internal ID as a results column to return Internal ID values for a search. If a saved search includes criteria filters that have non-specific values, such as -Mine- or -My Team-, scheduled emails may not be sent.… Continue reading Scheduled Search Email Limitations