Month: August 2024

Override Default Value of Handling Mode Field via Workflow Action Script

On the Enter Sales Order page, there’s a Handling Mode field under the Billing subtab, which is set to a default value of “Processing.” This default value can be overridden and set to “Save Only” using a Workflow Action Script with the Before Load Trigger Type. Solution Navigate to Customization > Scripting > Scripts > New Select the Add (+) button which will prompt… Continue reading Override Default Value of Handling Mode Field via Workflow Action Script

Enabling Multi-Row Results for Email Alerts in Saved Search

Normally, each saved search alert email includes only one row, because the search is filtered by the triggering record. However, certain searches, such as those with results fields from one-to-many joins, or transaction searches, can return multiple rows for each triggering record. In this case, you can include multiple matching rows in each alert email… Continue reading Enabling Multi-Row Results for Email Alerts in Saved Search

Create a Custom Transaction Line Item to Display Item Line Number on Transaction Records

Users sometimes want to establish a Custom Transaction Line Field that acts as a Line Number, automatically assigning sequential values based on the existing Item Line Number. Solution Create the Custom Transaction Line Field    Navigate to Customization > Lists, Records, & Fields > Transaction Line Fields > New Label: Enter Line Number ID: Enter _line_number Type: Select Integer Store Value: Enter Checkmark Click Applies To Sale: Enter Checkmark 7. Click Save   Create a Workflow… Continue reading Create a Custom Transaction Line Item to Display Item Line Number on Transaction Records

Restore Cancelled Sales Order

Cancelled Sales Order is different from a Closed Sales Order. While a Closed Sales Order can be re-opened, a Cancelled Sales Order can no longer be restored. The ability to restore a Cancelled Sales Order is currently being addressed by Enhancement 28338. When a Sales Order has been cancelled, the only option is to recreate (manually or through Actions > Make Copy) the Sales Order.

Advanced Patterns with the Vue 3 Composition API

Composables are functions that encapsulate reusable logic. They can be imported and used across multiple components, making your code more modular. Composables allow you to share state, methods, computed properties, and watchers across different parts of your application. // useFetch.js import { ref, onMounted } from ‘vue’; export function useFetch(url) {  const data = ref(null);… Continue reading Advanced Patterns with the Vue 3 Composition API

preSavePage hook in Celigo

The preSavePage hook is invoked on a page of records before the page is sent to subsequent steps in your flow. This hook can be used to add, update or delete records. This hook is a great place to execute logic on batches of records at the same time. For example: Filter or group records… Continue reading preSavePage hook in Celigo

Published
Categorized as Celigo Tagged

exchange rate fields in General Ledger and Balance Sheet reports

Added exchange rate fields in General Ledger and Balance Sheet reports.  However, the decimal point is not displayed.Enhancement # 145845 – Exchange rates should not be rounded off to 2 decimal places when exposed on saved searches and reports.  Enhancement # 372832 – Balance Sheet Detail Report > Exchange Rate Field > Change Decimal Places to Match with the… Continue reading exchange rate fields in General Ledger and Balance Sheet reports

Enhancing Data Integrity with NetSuite User Event Scripts

NetSuite User Event Scripts are a powerful tool for enforcing business rules and maintaining data integrity within the platform. By executing custom logic at specific points in a record’s lifecycle, you can prevent errors, improve data accuracy, and streamline your business processes. Understanding User Event Scripts A User Event Script is a client script that… Continue reading Enhancing Data Integrity with NetSuite User Event Scripts