Hi @Niks Blando-Oracle Is the Suitepromotions record scriptable?

EDIT: Found the cause: the current Net Book Value field was blank on the CSV upload. Hi @Micah Timbol-Oracle The asset in question where the depreciation is not correct The asset was purchased in Sep 2022 though is only being entered into Netsuite now. It wouldn't have been depreciated prior to now which is why the last…

Hi @Tafara , @Micah Timbol-Oracle Wouldn't this not apply to Analytics though?

Hi @Elychelle Gulen-Oracle Yes, the currency is the same for the copied item and the original (NZD)

Thanks for confirming Richard. For the other two questions, I have searched Suiteanswers though could not find anything on these: For locations, can inventory be stored against the grand-child location? Can all reporting be done to the lowest level (grand-child) class?

Sorry, to clarify I meant since it references parent, I assume that means SOAP webservices recognises the hierarchical structure, and therefore allows mapping to child class, department , and location. Is that correct?

Hi @Richard James Uri-Oracle I had looked at the SOAP scheme browser though couldn't see anything in relation to child levels specifically. e.g Invoices If I look at the recordref, I get: Am I reading this correctly that since it makes reference to parent department set up, this will always be available through a soap…

Thanks @Katerina Winklerova-Oracle This mostly gets the result I am after. I have noticed the '0' drops off on amounts less than zero though is there a way to have it so the number is formatted as $0.92?

Worked out what the issue was: This was only generating a depreciation schedule for the open financial years. I had assumed the fixed asset register forecasts into the future (beyond current open accounting periods) but I am now thinking that is not the case? Update: I found the cause of why open periods is needed:

Hi @Nicole Mendoza-Oracle Thanks for the screenshots. The invoice won't be created from the sales order directly. It will be created in a third party external application--independent of the sales order in Netsuite.. I was wanting a way to update the deposit on integration from the third party system, once an invoice from…

Hi @Katerina Winklerova-Oracle I think I just worked out what the issue is: The setting under Set Up>Accounting>Shipping for 'charge shipping' This is unchecked. Thanks

Hi @Kristoffer Viray-Oracle This is the revised version of the script: /** *@NApiVersion 2.x *@NScriptType UserEventScript */ define(["N/record"], function (record) { /** * @param {UserEventContext.afterSubmit} context */ function afterSubmit(context) { if (context.type == "create") { try { var customer = context.oldRecord…

Hi @Dominica Sevilla-Oracle I have just tested this right now without filling in the preferred vendor option (part 1 of your answer) and the auto fill worked on the purchase order to populate the transaction with the details from the last transaction created for the same vendor. What is the preferred vendor set up in this…

I just realised what the issue was. This line: if (externalid_old == " ") Even though the external id is blank, for some reason, this condition isn't met. after I delete this, the external id is populating correctly. However, is there a way to set external id on record creation @Kristoffer Viray-Oracle ? the submit fields…

Hi @Kristoffer Viray-Oracle I have adapted the script from the suitescript record though have found the external id is not updating: /** *@NApiVersion 2.x *@NScriptType UserEventScript */ define(["N/record"], function (record) { /** * @param {UserEventContext.afterSubmit} context */ function afterSubmit(context) { var…

Hi @Leonard Mallare-Oracle Can you go into more detail on how this would be achieved? Will this be done manually in NetSuite UI, or via scripting? This would be done through the UI. The user would navigate to the customer record and select the 'accept payment' button to create a customer payment transaction. The attached…

Hi @Nicole Mendoza-Oracle I have tried with multiple files. The last one I tried was png. The file sizes were under 100kb. I hadn't tried to encode it in any other way in the script thanks

Thanks @Richard James Uri-Oracle I will log this as a case. So you didn't receive an error message in your test drive account?

Hi @Richard James Uri-Oracle No there are no multiple scripts. There is one suitelet script. It is using functionality from a library file which I could either link via N/https (though I ran into errors for that as well) or uploading via the file cabinet which is what I am trying to do with the following line: // Load the…

Just to clarify, @Richard James Uri-Oracle : when you say multiple scripts, do you mean multiple files related to the library? The library file is a publicly available open source library.

Hi @Nicole Mendoza-Oracle Thanks. The error disappeared of the script. The file is still showing as corrupted though

Hi Richard James Uri-Oracle How would I do that in this instance?

I have attached the file The original source: https://github.com/SheetJS/sheetjs/tree/master/dist

Hi @Richard James Uri-Oracle In this case, the library script which contains that function is being loaded and its contents read Wouldn't this be the same as instantiating the script?

Thanks @Entartes did you get it to work in the end?

Hi @Kristoffer Viray-Oracle Thanks for your response. So would the consolidated invoice be the standard Netsuite sales order (now combining all of the different sales orders into one however) or will it be a custom record type? Likewise with the invoice. Would this be a custom record or a standard record? thanks

Hi @Kristoffer Viray-Oracle Thanks. Is it possible to script an advanced pdf to bring in additional data sources-? in this case, the underlying fields from the invoices in a custom record? (which is then a custom pdf?)

Hi @Jack Daryl Espiel-Oracle Thanks for the updated response. If the customer has multiple currencies however, it is only bringing up the primary currency for example, for one customer, their statement is split into two pages: they have a balance owing in NZD and USD However, on the statement, using…

Thanks @Kristoffer Viray-Oracle ! That worked perfectly. I must have missed something when I set it up originally because once I followed your set up, it worked EDIT: I realised where I went wrong: I missed the part in the instructions that said to only update the internal id. I was trying to also set the custom form using…

Hi @Jack Daryl Espiel-Oracle I found that the id doesn't print on the actual statement when I use ${statement.currency} However, the currency name does and not the currency iso code. How would I get the iso code to display instead?