Vernita

My Stuff

See All the Unlockable Badges See All the Unlockable Badges

Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.

Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more

No Limits. Just possibilities.
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.

Celebrate Your 2025 Community Recap & Achievements!

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!

Please note that on Friday, January 9, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 60 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.

Comments

Hi @Clarisa De Torres-Oracle There is no net amount column available in the transaction dataset from what I can see

in Foreign Currency Net Amount Field in Analytics Dataset Comment by Vernita Jul 22, 2023 1:53AM
Hi @Patrick Fresnosa-Oracle In this case, the subsidiary currency and the parent currency are the same (AUD). It is only the transaction that was conducted in another currency (USD). Why would this use the consolidated exchange rate? Wouldn't the consolidated exchange rate be used when the parent and child subsidiaries…

in Different Amounts on Saved Search and Transaction Record Comment by Vernita Jul 22, 2023 1:48AM
Hi @Angelica Mae Segador-Oracle Just to clarify, I was wanting the system notes on when a child record was attached to a parent record. Not so much the ability to create a child record (which I can do). But more around when the child record was attached to the parent. From the system notes, i can see that visible on the…

in System Notes for a Custom Record Attached Comment by Vernita Jul 22, 2023 1:42AM
Hi @Tigran Shahnazaryan I saw that though assumed that shouldn't affect the bank details record. There is a default company wide calendar and one on the employee record. Since that error only appears in one of the environments of the account, I believe this is an issue with the script/version of the bundle.

in Netsuite Electronic Bank Payments Bundle Error: "Please enter value(s) for: Work Calendar" Comment by Vernita Jul 22, 2023 1:30AM
Hi @Clarisa De Torres-Oracle I did and I can't see that field:

in Foreign Currency Net Amount Field in Analytics Dataset Comment by Vernita Jul 21, 2023 1:37AM
Thanks @Clarisa De Torres-Oracle ! That worked Though am I able to access that field in a dataset for transactions? (rather than sales (invoiced))?

in Foreign Currency Net Amount Field in Analytics Dataset Comment by Vernita Jul 20, 2023 2:55AM
Hi @Clarisa De Torres-Oracle That option doesn't appear for me in any of the accounts I am looking at for Sales (Invoiced) dataset

in Foreign Currency Net Amount Field in Analytics Dataset Comment by Vernita Jul 20, 2023 2:18AM
Sorry, related to that @Clarisa De Torres-Oracle , the amount (net) transaction currency field doesn't appear to be in the Transaction dataset. It seems to only be present in the Transaction Line data set

in Foreign Currency Net Amount Field in Analytics Dataset Comment by Vernita Jul 19, 2023 7:25AM
Hi @Patrick Fresnosa-Oracle I am using the transaction data set. The field I am filtering on here is the 'date' field: does the First Fiscal Month represent the Calendar of the Parent Subsidiary? Do you mean is the July First Fiscal Month taken from the parent subsidiary record? That screenshot was from the company…

in How to set Company Fiscal Year in SuiteAnalytics? Comment by Vernita Jul 19, 2023 7:23AM
Hi @Clarisa De Torres-Oracle I don't see any option for conversion: This is the field I am using:

in Foreign Currency Net Amount Field in Analytics Dataset Comment by Vernita Jul 19, 2023 6:24AM
Hi @Patrick Fresnosa-Oracle I have updated the setting, logged out of the account, cleared cache though am still getting the following: This setting has never changed:

in How to set Company Fiscal Year in SuiteAnalytics? Comment by Vernita Jul 18, 2023 10:27PM
Hi @Angelica Mae Segador-Oracle Per the screenshots in my post above, it is possible to create a saved search showing standard cost at different dates. Is the limitation around sourcing it on a transaction record?

in Standard Cost as at transaction Date Comment by Vernita Jul 17, 2023 10:26PM
Hi Here are the details of the field: The items are mainly 'Lot Numbered Inventory Items' Example: All items have a standard cost sublist on the item record showing what the standard cost is :

in Standard Cost as at transaction Date Comment by Vernita Jul 11, 2023 10:07PM
Thanks @Tigran Shahnazaryan I wanted to copy a pivot within the same workbook without having to add all the fields to it again Similar to Excel's copy sheet function.

in Copy Analytics Workbook Visualisation Comment by Vernita Jul 11, 2023 9:39PM
Hi @Kristoffer Viray-Oracle I am trying to populate a transaction line field on an invoice with the standard cost of the item as at the transaction date. I will try to get screenshots from the account thanks

in Standard Cost as at transaction Date Comment by Vernita Jul 8, 2023 1:23AM
Hi @Richard James Uri-Oracle I couldn't see from my script which function was missing the fieldid

in Client Script on a Suitelet-how to return field values? Comment by Vernita Jul 4, 2023 11:35PM
Hi @Micah Timbol-Oracle The current period is set up in Netsuite which is why I am confused over the error in the cash flow report.

in Is it possible to integrate Cash 360 forecast into the Cash Flow report? Comment by Vernita Jul 4, 2023 10:10AM
Hi this was a new schedule that has not been edited. This particular one is in a sandbox environment though the problem originally arose in production

in Why is this amorisation schedule showing varying amounts per month? Comment by Vernita Jul 1, 2023 1:59AM
Hi @Clarisa De Torres-Oracle The Suiteanswers matches what my expectation was Namely, the months with the same number of days should have the same amounts. It is inconsistent with what I am seeing the account however: Months that are 31 days have different amounts For example: Why would May and Oct have different amounts…

in Why is this amorisation schedule showing varying amounts per month? Comment by Vernita Jun 30, 2023 3:09AM
Hi @Micah Timbol-Oracle Have you had a chance to look at this yet?

in Is it possible to integrate Cash 360 forecast into the Cash Flow report? Comment by Vernita Jun 29, 2023 9:57PM
Hi @Clarisa De Torres-Oracle Does this work for suppliers that are not one world?

in Is it possible to set up a default tax code on a supplier record? Comment by Vernita Jun 29, 2023 1:27AM
Thanks @Patrick Fresnosa-Oracle Do you know how I got look at the variance of cash flow actuals vs cashflow forecast?

in Is it possible to integrate Cash 360 forecast into the Cash Flow report? Comment by Vernita Jun 29, 2023 1:24AM
Hi @Joahnna Given Uy-Oracle i got the answer from stack overflow map reduce scripts need proper error handling (try-catch) to get debugging like in this instance

in Map Reduce Script failing to create record Comment by Vernita Jun 28, 2023 9:11PM
Hi @Patrick Fresnosa-Oracle Is that report budget vs actual? i am after forecast vs actual s for cashflow thanks

in Is it possible to integrate Cash 360 forecast into the Cash Flow report? Comment by Vernita Jun 28, 2023 9:08PM
With the period, I cannot select anything. I get the error message as soon as I try to navigate to that report or if I try to select customise to change the period I can't change the period or see what the default period is

in Is it possible to integrate Cash 360 forecast into the Cash Flow report? Comment by Vernita Jun 27, 2023 9:41PM
Hi @Micah Timbol-Oracle Re: the data for the forecast, yes I need data for cash flow forecasts to be incorporated into reporting. I am assuming the cash 360 is the only source of the cash flow data? I want to create a report that has the following: The actuals figure would be the net cash flow for the month while the cash…

in Is it possible to integrate Cash 360 forecast into the Cash Flow report? Comment by Vernita Jun 27, 2023 9:35PM
Hi @Joahnna Given Uy-Oracle the title is included. The. “Failed to create sales order” is the title. There are no details which is not mandatory per the method description on the Netsuite help.

in Map Reduce Script failing to create record Comment by Vernita Jun 23, 2023 9:05PM
@Joahnna Given Uy-Oracle the full script in case that helps with replicating the issue: ** *@NApiVersion 2.x *@NScriptType MapReduceScript */ define(["N/search", "N/record"], function (search, record) { function getInputData() { var salesorderSearchObj = search.create({ type: "salesorder", filters: [ ["type", "anyof",…

in Map Reduce Script failing to create record Comment by Vernita Jun 21, 2023 11:46AM
Hi @Joahnna Given Uy-Oracle this is the search in the script: function getInputData() { var salesorderSearchObj = search.create({ type: "salesorder", filters: [ ["type", "anyof", "SalesOrd"], "AND", ["mainline", "is", "F"], "AND", ["taxline", "is", "F"], "AND", ["shipping", "is", "F"], "AND", ["item", "noneof", "@NONE@"],…

in Map Reduce Script failing to create record Comment by Vernita Jun 21, 2023 10:42AM
I just found the following on SuiteAnswers 7664: Am I correct in thinking that this options only appears if you have inventory enabled?

in Resolve Date/Period Mismatches not showing on period close checklist Comment by Vernita Jun 15, 2023 2:28AM

More Comments

Vernita Bronze Trophy

Comments