Author: Able Wilson

Using TRIM, LTRIM, and RTRIM for Formula functions

This article gives examples on using some common string functions that can be used for NetSuite search formulas via user interface or script, and on custom formula fields. TRIM: Removes leading or trailing characters (or both) from a character string Syntax: TRIM([ { { LEADING | TRAILING | BOTH } [ trim_character ]| trim_character}FROM ]trim_source)… Continue reading Using TRIM, LTRIM, and RTRIM for Formula functions

Unapply the Payment applied to an Invoice and reverse the impact of the Payment record

User creates a payment record and applies it against an invoice but later on the payment becomes invalid. To resolve, user needs to follow below steps: I. Unapply the Payment from the Invoice record 1. Pull up the Payment record on edit mode. 2. Under Apply tab > Invoices sub tab, unmark the Apply box for the invoice it was applied to. 3. Hit Save button. II. Reverse the… Continue reading Unapply the Payment applied to an Invoice and reverse the impact of the Payment record

Invalid subsidiary reference key xxx is received on CSV Import of Journal Entry

To correct the error message “Invalid subsidiary reference key xxx” when importing Journals: 1. Verify that the subsidiary is an active and existing subsidiary by navigating to Setup > Company > Subsidiaries. The subsidiary should be spelled the way it is spelled in the record. It is also possible to export the list of subsidiaries to get the correct format. If the Subsidiary… Continue reading Invalid subsidiary reference key xxx is received on CSV Import of Journal Entry