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.
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
Best Of
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!
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?
Re: can not edit bill payment (vendor payment) after aproval, but I can do this for customer payment
Hello @Amjad Kasem
You can able to edit the bill payments after posting if approval routing is not enabled for Vendor payment.
Pls, check Setup-Accounting-Accounting Preferences(Setup Accounting) - Approval Routing tab.
Without this preference system will allow us to edit the transactions:
If it's enabled already, you cant edit the vendor payment transactions since it's already posted or associated with bill transactions.
Re: Solve the difference between balance in base currency and foreign currency
Hi @Amjad Kasem,
Apologies for this limitation.
However, I was able to find a possible workaround in your scenario, in which we should apply the other journal entry via Accepting Payment:
Using my example above:
1.) I have deleted the Currency Revaluation earlier (this can also be done without deleting too, since it is reversed at the first period)
2.) Navigate to Transactions > Customers > Accept Customer Payment
3.) Select your Customer and Currency
4.) Create Customer Payment
Go to Invoices Subtab and click apply checkbox beside the Journal/s:
Go to Credits subtab and click apply:
5.) Click Save
RESULTS
If you check the related records of the Debit Journal/s you will be able to see currency revaluation and applying JE:
When checking the Currency Revaluation, you will now be able to check the Realized Gain/Loss transaction which is not reversed next period:
Upon checking, the results will zero-out the A/R aging report, as observed in my test account, and no Unrealized Gain/Loss will be Generated.
Per checking it was zeroed out in the Account Register and the Journal Entry was marked paid:
Please do test first in your Sandbox Account ?
===========
If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer your question”, you’ll be able to aid the community to find the solution much easier and faster without the need to read through all the replies.
Re: Expose Today's Date in Dataset Formula in SuiteAnalytics Workbook
I was able to create a formula to calculate the days since a date field value by doing this:
TO_DATE(TO_CHAR(CURRENT_DATE,'MM-DD-YYYY'))-{hiredate}
LissaM
Re: Google Analytics 4 - GA4
Hi @MJ NCO,
One of the possible reason why you cannot find any internal articles related to GA4 is due to the fact that it is currently not supported in SuiteCommerce/SuiteCommerce Advanced tracked on Enhancement #606462.
On the other hand, I tried to look for external reference that may be helpful to use GA4 through GTM: https://searchengineland.com/how-to-set-up-google-analytics-4-using-google-tag-manager-374584
I hope this is helpful for you. Kindly let us know.
-Charles















