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?

Just got this resolved: I had left the last depreciation field blank on the asset record thinking it was not needed since it was on the depreciation history record Once this was populated and I toggled the 'depreciation active' field from true to false and true again (to trigger the 'reset asset value' process), the…

Hi @Jack Daryl Espiel-Oracle Would the client script be on page init? Or would it be after field sourcing?

Hi @Jack Daryl Espiel-Oracle If I were to use a script, would it be a user event, before record load?

Thanks @Katerina Winklerova-Oracle I have found that a setting in customer payments screen that lets you adjust the number of visible rows So it looks like it might be record by record type based?

Hi @Elychelle Gulen-Oracle I have responded to the email. I have found this issue in yet another account. So in total, there are 3 accounts where I have encountered this issue: 2 demo and one sandbox.

Hi @Kristoffer Viray-Oracle Thanks for looking into this. A colleague suggested the following field (appliedtotransaction.rate) and that seems to work to source the SO rate on an IF search. The tips you have given are still useful though for future use :)

More suggestions of workarounds for items that are currently enhancement requests.

Thanks @Kristoffer Viray-Oracle That worked!

Hi @Kristoffer Viray-Oracle Thanks for your suggestion. I tried this right now though it is treating all lines as being on back order even though they aren't actually on back order: This is the workflow action