Scenario User is unable to send email from Record > Communication > Email. Receiving error “Exception during message creation. Caused by: com.netledger.common.exceptions.NLUserError: Template not found” when selecting a PDF template under Email > Attachments > Attach Document Template. Error is caused by missing attachment on the saved template. Solution Log in as an Administrator Note: Take note… Continue reading Unable to Send Email When Adding a PDF Template Through Attach Document Template. Error Exception During Message Creation
Month: July 2024
Resolve Error: “A problem occurred during dunning letter PDF file creation probably due to malformed XML template”
Scenario User is unable to generate Dunning Letter due to an Error: “A problem occurred during dunning letter PDF file creation probably due to malformed XML template” The error is usually received if there is a missing HTML Tag on the Dunning Letter Template. To resolve, check the exact Error message of the Template in Customization > Scripting… Continue reading Resolve Error: “A problem occurred during dunning letter PDF file creation probably due to malformed XML template”
Error Base on field that is sourced from a Deleted field.
Issues: you entered “ERROR: Field ‘field id’ Not Found” into a field where a numeric value was expected. Please go back and change this value to a number. Reason for the error: When a field is sourced from a deleted field and when trying to save the record with the field that is sourced the… Continue reading Error Base on field that is sourced from a Deleted field.
Default Intercompany Accounts
DEFAULT INTERCOMPANY ACCOUNTS Need to set the default accounts for intercompany transactions the set accounts will reflect in transactions. Navigation for default Intercompany Accounts Setup -> Accounting -> Intercompany Preferences and select (Accounting Tab)
Intercompany Elimination
AUTOMATIC ELIMINATION: The Automated Intercompany Management feature manages intercompany transactions and generates elimination journal entries automatically Reducing: – Need to manually create, track, and eliminate intercompany transactions – Manual steps required to manage and report intercompany activity. NetSuite generates the elimination journal entries based on the intercompany transaction lines and intercompany journal lines marked to be eliminated.… Continue reading Intercompany Elimination
Elimination Journal Entries
Different business transactions between a parent company and its subsidiary involve a profit or loss. Consolidated financial statements compute the financial position and the results of the two operations of two or more subsidiaries as if they were one company, so the unrealized profits or losses in these intercompany transactions need to be eliminated. General Ledger accounts that will require… Continue reading Elimination Journal Entries
Automated Intercompany Management Feature
Intercompany The system identifies transaction lines that require elimination: Journal Entry Sales Order (invoice) Purchase Order (billed) Enabling the Automated Intercompany Management feature adds the following: Cumulative Translation Adjustment-Elimination (CTA-E) account is added to your chart of accounts. Eliminate Intercompany Transactions is added as the last task in the Period Close Checklist. Eliminate box… Continue reading Automated Intercompany Management Feature
FreeMarker/NetSuite PDF Template – Double sorting by date, with possible empty values
<table> <tr> <th>name</th> <th>quantity</th> <th>dateFrom</th> <th>dateTo</th> </tr> <!– Print entries with from/to dates –> <#list records?filter(x -> x.custcol_from_date?has_content && x.custcol_to_date?has_content)?sort_by(“custcol_to_date”)?sort_by(“custcol_from_date”) as record> <tr> <td>${record.name}</td> <td>${record.quantity}</td> <td>${record.custcol_from_date}</td> <td>${record.custcol_to_date}</td> </tr> </#list> <!– Print entries without from/to date at the end of table –> <#list records?filter(x -> !x.custcol_from_date?has_content || !x.custcol_to_date?has_content) as record> <tr> <td>${record.name}</td> <td>${record.quantity}</td> <td>${record.custcol_from_date}</td> <td>${record.custcol_to_date}</td> </tr>… Continue reading FreeMarker/NetSuite PDF Template – Double sorting by date, with possible empty values
How can I track which fields have been edited in Netsuite when syncing NetSuite sales orders to Salesforce?
If you have a limited set of fields to check you can make use of the old record. Rough idea below: function afterSubmit(context) { const oldRec = context.oldRecord; const newRec = context.newRecord; const updateSpec = getBodyChanges(newRec, oldRec); updateSpec.lines = []; // similar idea for lines but you also have to make sure lines (checking lineuniqekey)… Continue reading How can I track which fields have been edited in Netsuite when syncing NetSuite sales orders to Salesforce?
How to Call https.patch in NetSuite to Update a Salesforce Record
You can work around this limitation by sending a POST request and including a query string parameter _HttpMethod to override the HTTP method. For example, if you need to perform a PATCH requestyou can modify your request as follows by adding ?_HttpMethod=PATCH to the end of your url POST /your/endpoint?_HttpMethod=PATCH I found this solution in… Continue reading How to Call https.patch in NetSuite to Update a Salesforce Record