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
Tag: Journal
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
Apply Bill to Journal using Script
In some cases, the client applies Bills to Journals via the Bill Payment page. In such cases, we check the apply box for the relevant bills and journals such that the body amount shows 0. This can be done via UI but not csv.We can done this through scripting. Here we consider one bill can… Continue reading Apply Bill to Journal using Script
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
Journal line field is not editable
This article summarizes the reason for the greyed journal lines which are not editable.
Create an edit screen for JE using Suitelet.
Create edit screen for Journal Entry.