Vernita Bronze Trophy

Any updates on this @Niks Blando-Oracle ? thanks

Hi @Katerina Winklerova-Oracle No the bank details are not updated. That might be the issue. I haven't customised it though the common thread with the two accounts where that issue is seen is they have an old bundle.

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

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…

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…

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.

Hi @Clarisa De Torres-Oracle I did and I can't see that field:

Thanks @Clarisa De Torres-Oracle ! That worked Though am I able to access that field in a dataset for transactions? (rather than sales (invoiced))?

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

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

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…

Hi @Clarisa De Torres-Oracle I don't see any option for conversion: This is the field I am using:

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:

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?

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 :

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.

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

Hi @Richard James Uri-Oracle I couldn't see from my script which function was missing the fieldid

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.

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

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…

Hi @Micah Timbol-Oracle Have you had a chance to look at this yet?

Hi @Clarisa De Torres-Oracle Does this work for suppliers that are not one world?

Thanks @Patrick Fresnosa-Oracle Do you know how I got look at the variance of cash flow actuals vs cashflow forecast?

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

Hi @Patrick Fresnosa-Oracle Is that report budget vs actual? i am after forecast vs actual s for cashflow thanks

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

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…

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.

@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",…