Celigo provides several tools to help you identify the source of errors: Error table: By clicking on the error count in your integration flow, you can access the error table, which acts as your central hub for troubleshooting. This table provides a clear breakdown of where the error occurred—whether internally within Celigo or externally in… Continue reading Celigo Tools for identifying error sources
Author: Allwin Antony
Enable document number editable/override
Navigate to “Set Up Auto-Generated Numbers“ And check the checkbox “Allow Override” under the “Document Numbers” tab to the corresponding record type you want
Ensuring Correct RTL Display for Mixed Arabic and English Text in NetSuite Advanced PDF Templates
When generating PDF documents in NetSuite using Advanced PDF templates, you might encounter challenges when displaying mixed Arabic and English text. While Arabic text should naturally render from right to left (RTL), embedding English text within Arabic strings can disrupt this flow, causing display issues. Simply applying dir=”rtl” or direction: rtl; in your HTML styling… Continue reading Ensuring Correct RTL Display for Mixed Arabic and English Text in NetSuite Advanced PDF Templates
Converting Invoice Amount to Arabic Words in NetSuite: A Comprehensive Guide
Overview: NetSuite allows users to create customizations using SuiteScript to enhance business operations. One such customization is the conversion of invoice amounts into Arabic words for better localization and user experience. This article explains how to implement this functionality using a User Event Script in SuiteScript 2.1, enabling automatic conversion of the invoice total to… Continue reading Converting Invoice Amount to Arabic Words in NetSuite: A Comprehensive Guide
Automating Shipping Method Updates in NetSuite with a User Event Script
Overview: NetSuite provides the ability to customize business processes using SuiteScript, and one common use case is updating the shipping method based on certain criteria in a Sales Order. This article will discuss a User Event Script designed to automatically update the shipping method for a Sales Order based on whether the shipping address is… Continue reading Automating Shipping Method Updates in NetSuite with a User Event Script
Retrieving Price Level and Quantity-Based Pricing in NetSuite
Overview: This saved search retrieves Inventory Items that are associated with a specific Price Level (e.g., Price Level 12) and provides critical data such as Minimum Quantity, Unit Price, and promotional status. This search is especially useful for businesses that have tiered pricing based on customer groups or regions. Saved Search Explanation This search includes… Continue reading Retrieving Price Level and Quantity-Based Pricing in NetSuite
Quantity Pricing in NetSuite Using Saved Searches
Overview: Quantity pricing in NetSuite allows businesses to apply different prices based on the quantity of an item purchased. This guide explains how to use a saved search to retrieve key data related to quantity-based pricing, focusing on the Minimum Quantity field in the pricing records. Saved Search Explanation The following code snippet is for… Continue reading Quantity Pricing in NetSuite Using Saved Searches
Calculating the Est. Gross Profit and Est. Gross Profit Percent when Discount is Applied
Scenario What is the Standard Formuls to calculate Estimated Gross Profit? Solution The standard formula in calculating the Estimated Gross Profit is as follows: Sales –Est. Extended Cost = Est. Gross Profit Where: Sales = refers to the total quantity multiplied with the unit price of the item Est. Extended Cost = based on the… Continue reading Calculating the Est. Gross Profit and Est. Gross Profit Percent when Discount is Applied
Creating A Report Showing The Est. Extended Cost, Est. Gross Profit, Est. Gross Profit Percent And Other Fields For Each Line Item On Invoices And Cash Sales
Scenario User needs to creating a Report for Invoices and/or Cash Sales showing Est. Extended Cost, Est. Gross Profit, Est. Gross Profit Percent and other fields for each line item. Solution 1. Navigate to Reports > Sales > Sales by Customer > Customize 2. Under Edit Columns tab, expand the Sales folder > Item subfolder > Click on Name to display the Item Name 3. Still on the Sales folder, select Est. Extended… Continue reading Creating A Report Showing The Est. Extended Cost, Est. Gross Profit, Est. Gross Profit Percent And Other Fields For Each Line Item On Invoices And Cash Sales
Create Custom Body Field To Show Total Amount of Estimated Gross Profit on Invoice
Scenario Some companies require to display the Estimated Gross Profit using a Custom Transaction Body Field on an Invoice record where the value is being sourced from a Saved Search. Solution Create Saved Transaction Search Navigate to Lists > Search > Saved Searches > New Click Transaction Search Title: Enter Title Example: Estimated Gross Profit Click Criteria Filter: Note: For every required field use the drop-down menu to select it and… Continue reading Create Custom Body Field To Show Total Amount of Estimated Gross Profit on Invoice