Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Best Of
Re: INCOME STATEMENT DETAIL WITH CLASS
Thank you @Patrick Fresnosa-Oracle for your insight
Hello @User_2LQKP
Since you want to see the class column on each transaction in the Income statement. Do the customization on Income Statement detail level, not on the summary level.
1.) Navigate to Reports > Financial > Income Statement
2.) Click view detail
3.) Go to Edit Columns page
4.) Go to Financial folder > Class > click Name
Re: AE: Making department mandatory but only on expense account types
Hi @User_SP0KO
To overcome this issue, we have separate customize bundle to handle the classification mandatory based on the account type.
Auto trigger alert on transaction line level for classifications based on the COA types
a. Income
b. Expense
c. Other Income
d. Other Expenses
Easily can add conditions for mandatory classifications for ex:
Condition 1: If the account type is Expenses and Other expenses – "Department" & Location is mandatory
Condition 2: if the account type is Income and Other Income – (Class) "Revenue stream" is mandatory
Condition 3: If you use the item tab instead of the expenses tab, then also the same condition is applicable based on the Item master income and expense account mapping.
Let me know if you need this bundle
Re: Deposits That Were Voiced AFTER Bank Reconciliation - How to Remove Them from Bank Reconciliation
You have to edit the account record for it to show on the Match Bank Data page. Here's how:
Go to Lists > Accounting > Accounts > Click edit on the Bank Account
and then save it.
NetSuite Admin Tips: Electronic Bank Payments > TypeError: Cannot read property "0" from null
Most of the users that just recently set up their Electronic Bank Payments encounter this TypeError: Cannot read property "0" from null (2663_common_lib.js#707). This is due to no email templates selected on the Electronic Payment Preferences.
To resolve this, follow the instructions below:
1. Go to Payments > Setup > Electronic Payment Preferences
2. Click Edit
3. Under the General Preferences tab, select and populate Vendor and Customer Email Templates
4. Click Save
Hope you found this useful! Have you encountered a similar scenario like this one? Let us know by commenting below. 😊
Re: Identify Case issue trends
Hi @User_5OUXV,
I'm afraid the result you're looking for isn't available through a saved search. To get the report you want, I recommend creating a workbook with the case dataset.
Step I: Create dataset.
- In the case dataset, add Issues: Issue Type and Case Creation Date/Time fields.
- To get this week's cases with issue type created, create a formula field with formula =
CASE WHEN trunc({datecreated},'WW') = trunc(CURRENT_DATE,'WW') THEN 1 ELSE 0 END. - For Last Year's field formula, you can use
CASE WHEN EXTRACT(YEAR FROM {datecreated}) = EXTRACT(YEAR FROM CURRENT_DATE)-1 THEN 1 ELSE 0 END - Add a Days field with
365in the formula as you will need this to create a calculated measure in your workbook. - Set Criteria to
Issues: Issue Type = none of <NO VALUE>, so only cases with issue types will appear on the report.
Step II: Create a Workbook using the case dataset created.
- When creating a workbork, select Visualization Type = Chart.
- Put the Issue Type field in X-Axis and This Week and Last Year fields in Measures.
- Set the Summary type of Last Year field to Average or you can create a calculated measure using the formula =
Last Year (sum) / 365.
Step III: Dashboard
- Navigate to the Dashboard and add the Analytics portlet.
- Set up and configure the workbook.
For reference, please see below SuiteAnswers.
- User Guides | Answer Id: 50287
- SuiteAnalytics Workbook
- Sample Formula and Results Using Trunc Function With Dates in Saved Search | Answer Id: 63246
I hope this helps.
Regards,
Re: Supply Required by Date
I wanted to follow up as i did get resolution to this. The answer was to create a saved transaction search and export all lines with line ID as well as the Ship Date included in the order.
Using excel, i set the supply required by date to the ship date listed with each PO.
I then reimported via CSV with the following mapping - making sure to set all historical PO's to have my new inventory allocation strategy.
Now the supply required by date is working appropriately and all inventory is currently allocating correctly!
Chad C
Re: Name fields lack on Journal CREATED FROM REVENUE RECOGNITION SCHEDULE
Hello @Strategit_Shunta4
Pls, check the customer status.
Generally, if the customer is Inactivated then revenue recognition journal entries should not show the customer name in line level.
However, Invoice with Revenue Recognition Schedule will still show up on the Create Revenue Recognition Journal Entries page for the inactive customer.
Re: "Each line must have a non-null value. Zero is permitted." Advanced Intercompany JE Import Error
Hi @User_DRO1D
To resolve this error, pls remove the gross and VAT amount columns in CSV since you are not mapping the Tax codes
Make sure that Debit and credit values are in numeric format.
Re: No Data Available Commission Overview Detail Report
Hello @Nine-Oracle
I have tested the commission detailed report in the same demo account. It is showing transactions
Pls reselect the from and to date and check
Re: Allow Cross-Subsidiary: Not all Sales Reps visible
Thank you, @CDuf. Glad to see you here! ?
@Dirk Nieuwkamp, can you please check in your Employee 1 & 3 records if there is a Classification set?
Navigate to your Sales Account Manager role > Restrictions tab. Is there anything in the list?
