Articles tagged #JOURNAL
Articles tagged
#JOURNAL
Journal Entries not Available in the Customer Profitability Report
The user creates a Customer Profitability Report by going to Reports > Customers/Receivables > Customer Profitability. However, journal entries are not available on the report.
Summarized Intercompany Elimination Journal Entries
If you use the Journal Entry Summarization on Intercompany Elimination accounting preference, NetSuite groups similar elimination journal entries into a single, summarized journal entry line. If you do not use the accounting preference, each elimination journal entry appears on a single journal entry line. You can change the state of the preference, as required.
Journal Entry Transaction Nexus
The user wants to determine how the system identifies the Nexus of a Journal Entry Transaction.
Journal Shows the Same Figures in Columns Net Amount and Tax Amount in the Business Activity Statement Total Sales Box G1 in a VAT/GST Report
Reports>VAT/GST>Business Activity Statement> Drilldown Total Sales Box G1 > Journals show the same Figures in Columns Net Amount and Tax AmountHere are few illustrations of the standard behavior when applying GST in Journal Entries.
Journal Import of Sales with GST Not Showing Up in the Business Activity Statement Report
The user has imported a sales transaction through CSV import of general journals and the CSV template has no mapping for Tax Account column in the Journal which in result made the sales transaction not reflect in the Business Activity Statement Report.
Associate Vendor Credit to a Refund in Foreign Currency
If the vendor in a foreign currencysent a refund by cash or check in a currency other than the vendor's currency, user needs to record the deposit in the vendor's currency via a journal entry.
Error: The subsidiary selected for To Subsidiary on the journal entry and Representing Subsidiary of Intercompany Vendor/Customer must match if you want to run Intercompany Elimination for this line
Create Advanced Intercompany Journal Entry > error: "The subsidiary selected for To Subsidiary on the journal entry and Representing Subsidiary of Intercompany Vendor/Customer must match if you want to run Intercompany Elimination for this line."
Cannot Select Intercompany Customer in Intercompany Journal Entry
On Intercompany Journal Entry, the Intercompany Customer of a Subsidiary does not appear in the Customer field.
Pay Run Journals > Get a Breakdown of Account-specific Amount in the Journal
User is preparing for their budgets for upcoming fiscal year and noticed that when running their Profit and Loss report, a specific account ought not to be used displays certain figures for specific periods instead of displaying zero (0) amount.
Electronic Bank Payments > Reversing Payments
You can reverse payments if the bank has not yet processed the associated payment file. When you reverse a payment, a new payment file is created and the payments are reprocessed. However, any credit transactions are still applied to the bill or invoice. Full payment reversal voids all payments and the payment file is deleted. On the other hand, partial reversal voids only selected payments and a new payment file is created with the remaining payments.
Clear Beginning Balance of No Customer/Job in A/R Aging Report
Customer wanted to clear the beginning balance of No Customer/Job in A/R Aging Report throughTransactions > Financial > Make Journal Entries.
Resolve error "You have entered an Invalid Field Value XXX for the following field: tax1acct" when create customer payment
Transactions > Payables > Pay Single Vendor
Custom Role with Make Journal Entries Permission is Unable to See Edit Button on Journal Entry
Custom RolewithFullpermission level onMake Journal Entriescannot see theEditbutton onJournal Entry.
Resolve error:"You have entered an Invalid Field Value xxx for the following field: debit" on Journal Entry CSV Import
CSV import of Journal Entry throws the error in the CSV Response file.
Resolve Error: Update Transaction Failure: No Valid, Open, Tax Period for Date - Null When Approving Journal Entry with Reversal
User is unable to approve journal entry with reversal date next period due to notice: "Update Transaction Failure: No valid, open, tax period for date - null"
Journals With Name Fall Under the -No Customer/Project- Category in Sales Reports
When running the Sales or A/R Aging Reports, Journal Entries are grouped under the category - No Customer/Project-.But in these Journal Entries the Name column field is populated with customer. Hence, these journals should not appear under the- No Customer/Project-category.
Create Journal Entry to record Cash Receipt of Overpayment Transaction
There are times when we pay the Vendor more than the amount that was billed for our purchases. Each time, we have the option to either claim it as a credit to our accounts or simply received the cash refund. Since we received money as a refund from the Overpayment we made, we need to record it correctly in our accounting books.
Journal Entries > Related Records tab > Payments subtab > view applied to and applying transaction to this transaction
Scenario
- Journal Entry#1 (JE1) has Accounts Receivable debited while Journal Entry#2 (JE2) has the same Accounts Receivable account credited for the same amount
- These journals were applied to each other via Customer Payment
- Related Records tab > Paymentssub tab of:
- JE1showsJE2as the payment applied to it
- JE2shows no value
- User needs to viewJE1in theJE2transaction form >Related Records tab > Paymentssub tab
Solution
- Navigate toLists > Search > Saved Searches > New > Transaction
- Set the following values:
- Public =True
- Available as Sublist =True
- In theCriteriatab:
- SetUse Expressions =True
- Add the following filters in theStandardsub tab:
- Type =Journal
- (Applied To Transactions : Internal ID (Number) =is not empty or
- Applying Transactions : Internal ID (Number)=is not empty)
- In theResults tab > Columnssub tab
- SetSummary Type =Groupfor the following fields:
- Date
- Number
- Applied To Transaction
- Applying Transaction
- On theAvailableFilterssubtab, add at least one available filter to the search, and ensure that the first filter listed is aList/Record type. Otherwise, the saved search is not available to assign as a sublist.
- Renamethe search
- Example: Journals Applied
- ClickSave
- Set the following values:
- Navigate toCustomization > Forms > Sublists > Transactiontab
- Set:
- Search =Journals Applied
- Label =Journals Applied
- Tab =Related Records
- Journal =True
- ClickSave
- Set: