Creation Of Journal Entry

 let journal = record.create({           type: record.Type.JOURNAL_ENTRY,           isDynamic: true         });         journal.setValue({ fieldId: ‘subsidiary’, value: subsidiary });         journal.setValue({ fieldId: ‘currency’, value: currency });         journal.setValue({ fieldId: ‘trandate’, value: trandate });         journal.setValue({ fieldId: ‘memo’, value: ‘Auto JE for Income Tax on Vendor Bill ‘ + bill.getValue(‘tranid’) });         // DEBIT A/P         journal.selectNewLine({ sublistId: ‘line’ });         journal.setCurrentSublistValue({ sublistId: ‘line’, fieldId: ‘account’,… Continue reading Creation Of Journal Entry

Extra Journal Entry Creation

Summary  This release summarizes the customization which encompass the redirection of account posted in GL to some target account based on user discretion.  Custom record setup and field creation    CUSTOM RECORDS SCHEMA/GUIDE:  1. Inbound-Outbound Account Map    DESCRIPTION  ID  TYPE  LIST/RECORD  MANDATORY  Rule ID  custrecord_grw_016_rule_id  Integer Number     Yes  Subsidiary  custrecord_grw_016_subsidiary  List/Record  Subsidiary  Yes … Continue reading Extra Journal Entry Creation

Adding ‘To Subsidiary’ column in Journal Saved Search

Unfortunately, the ability to add ‘To Subsidiary’ column in the journal search is logged as an enhancement in the voting stage [#327120]. Also, the ability to add the Due to/From Subsidiary in the Advanced intercompany journal search is also logged as an enhancement [#471651]. For accounts using the feature ‘CENTRALIZED PURCHASING AND BILLING’ in Enable… Continue reading Adding ‘To Subsidiary’ column in Journal Saved Search

Sales Transactions – Billing Status ‘Open’ does NOT show unmatched journals

NetSuite users often face a common issue where journal entries are marked as closed in the Billing Status, even before being matched to any invoices. This occurs because NetSuite considers a journal entry closed upon posting, regardless of its invoice matching status. While this behavior cannot be changed within NetSuite, there are practical workarounds to… Continue reading Sales Transactions – Billing Status ‘Open’ does NOT show unmatched journals

Unable to Edit the Name field in the Journal

even if the accounting period is open, the Name filed at the line level is unable to be edited. The status of the journal is “Approved for Posting Payments Applied”. The reason why the user is not able to edit the Customer on the transaction line of the Journal is because it is applied to… Continue reading Unable to Edit the Name field in the Journal