function createJournalEntry(bill, incomeTaxAmount) { try { let vendorId = bill.getValue(‘entity’); let apAccount = bill.getValue(‘account’); let subsidiary = bill.getValue(‘subsidiary’); let currency = bill.getValue(‘currency’); let trandate = bill.getValue(‘trandate’); if (!apAccount) { log.error(‘Missing A/P account on Vendor Bill’); return null; } let journal = record.create({ type: record.Type.JOURNAL_ENTRY, isDynamic: true }); journal.setValue({ fieldId: ‘subsidiary’, value: subsidiary }); journal.setValue({ fieldId:… Continue reading Creation of Journal Entry for Bill
Tag: journal entry
Confirm message in workflow on custom button via workflow – before user submit
Requirement: Trying unsuccessfully to create a journal entry workflow that once you click on a customized button (reject) a message will pop in case the user didn’t fill in the rejection reason field (customized field). Solution: Unfortunately, the Confirm Action does not work on Customized Buttons. This is because it uses the Before User Submit trigger. Which executes after a user… Continue reading Confirm message in workflow on custom button via workflow – before user submit
Resolve error: “You cannot disable journal entries approval routing because there are journal entries pending approval or journal entries with a rejected status” when disabling Journal Entry Approval Preference
Scenario User wants to disable Journal Entries Approval Routing in from the Accounting Preferences but received an error: “You cannot disable journal entries approval routing because there are journal entries pending approval or journal entries with a rejected status”. Solution Navigate to Transactions > Financial > Make Journal Entries > List Click Customize View Click Available Filters Filters: Select Status Click Save Status: Select “Rejected” and “Pending Approval“ All Journal Entries: Click Edit… Continue reading Resolve error: “You cannot disable journal entries approval routing because there are journal entries pending approval or journal entries with a rejected status” when disabling Journal Entry Approval Preference
Unable to find edit button on Approved Journal Entries for Custom Roles
User with custom role is unable to edit a Journal Entry after the Approval Status has been set to Approved. The account’s Approval Routing for Journal Entries = T and is using the Journal Entry Approval Workflow. Navigate to Customization > Scripting > Scripted Records View Journal Entry Workflow tab: Click Internal ID of the Workflow Released Workflow page: Click Edit Click Approved State box Hover to Lock Record Click Pencil icon… Continue reading Unable to find edit button on Approved Journal Entries for Custom Roles
Approving the journal entries in bulk
The Approved checkbox is not displayed if you have enabled the Journal Entries Approval Routing Accounting Preference. This preference enables you to use SuiteFlow to create a custom journal entry approval routing workflow. If the preference is enabled, an Approval Status Field will be displayed instead of an Approved checkbox. In this case, the Approved checkbox cannot be mapped during CSV import as it is not showing on… Continue reading Approving the journal entries in bulk
Can I add Revenue arrangements to a Journal Entry?
You can create Revenue Arrangements from a Journal Entry, provided that you add an Income account, add a Revenue Recognition Rule, Rev Rec Start Dates/End Dates (Optional) and name. Please check SuiteAnswers Id: 49249 For example: 1.) Navigate to Transactions > Financial > Make Journal Entry 2.) Adde a Sales Order Line with Income Account and Revenue… Continue reading Can I add Revenue arrangements to a Journal Entry?
‘To Subsidiary’ and ‘Eliminate’ options in Journal transactions
Basically, those fields are used for Intercompany Eliminations. Prior to the 2024.1 update, if customer would like to use the standard Journal to record the intercompany transactions, they need to customize the form to display the To Subsidiary and Eliminate fields. Customizing Standard Journal Entries for Intercompany Elimination [ SuiteAnswer #20805] We should use advanced intercompany journal entries… Continue reading ‘To Subsidiary’ and ‘Eliminate’ options in Journal transactions
Display parent and child name of chart of accounts separately in transaction search
For example, if we have to find account names separately for journal entry transactions do the following, Goto Reports -> Saved Search -> New, Select Transaction Choose the type of transaction as – Journal under criteria subtab Under results subtab, For parent account, Select Formula(Text) as field and in formula section – CASE WHEN INSTR({account.name},’… Continue reading Display parent and child name of chart of accounts separately in transaction search
“Use Custom Journal” preference missing in FAM System Setup
Usually, we see the asset-related journal entries in the Journal list in Transactions -> Financial -> Make Journal Entries -> List. However, we have the preference of using a custom journal type for the asset related journal entries. Subsequently, the journals would be displayed in Fixed Assets -> Journal Entries. We check the ‘Use Custom… Continue reading “Use Custom Journal” preference missing in FAM System Setup
INVALID_RECIPIENT on posting a Journal Entry
It’s hard to say exactly what the issue is without taking a deeper look at your account. The INVALID_RECIPIENT error code description is “Recipient internal id does not match an existing entity.”, meaning that you’re trying to email someone and it’s not matching an existing employee/vendor/customer/contact record with an existing email. Upon first glance I… Continue reading INVALID_RECIPIENT on posting a Journal Entry