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

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

I just found the following on SuiteAnswers 7664: Am I correct in thinking that this options only appears if you have inventory enabled?

Hi @Clarisa De Torres-Oracle This is the current period structure (production account): This is the proposed period structure(sandbox account)

Hi @Elychelle Gulen-Oracle I have confirmed with a few colleagues (developers) and it is not possible to change the status to billed using a script

Hi @Kristoffer Viray-Oracle Apologies for the delay in responding The current output is: 'Parent Customer: Child Customer' on a drop down The expected output is: 'Child Customer'

Thanks Gaurav. These are not pop ups---at least not the form anyway. This is the customer record itself and the invoice form,

Thanks @Richard James Uri-Oracle Also, is there a way to find documentation on how to determine the refName for a number of different enumerations/records?

Hi @Clarisa De Torres-Oracle I have tried that though still get an invalid format error on the CSV since the field is date/time and not date thanks

Hi @Clarisa De Torres-Oracle Any updates on this?

Hi @Katerina Winklerova-Oracle Thank you! I had followed the steps though missed the pressing submit button on the match bank data page. I had missed this because I was looking at other journals (opening balance journal) that appeared automatically on the "Reconcile Account Statement" page without needing to be submitted.…

Hi @Michelle Jabanes-Oracle Still testing this at the moment with the project role (role B)

Hi @Katerina Winklerova-Oracle Did you get a chance to look at this? It it needed for our month end so would appreciate if you can let me know thanks

Hi @Niks Blando-Oracle This is what I get when modifying the report i can't see why this is different to the quantity available from this though