Vernita Bronze Trophy

Hi @Nicole Mendoza-Oracle The script only runs for the day it is scheduled for. However, the records don't finish updating by that date due to the number/volume of them. Is there a way to force the script to continue running until all items have been updated?

I tested the same script in another account which resolved. it. The issue must have been with the account because the syntax and the script is correct

The workflow

Hi @Joahnna Given Uy-Oracle It is a standard field. id={duedate}

Hi @CDuf I had grouped the results in a saved search though was getting the incorrect results. Likewise with pivots. Both of these showed the total number of lines and not individual journal documents

Hi @Micah Timbol-Oracle Are you able to please look at this? Or do I need to create another thread for the same concern?

Hi @Michelle Jabanes-Oracle It was over 72 hours. How would you set up the DNS for the email campaign domain specifically? The main DNS is showing as being correctly set up for under the Company>Email Preferences tab. This appears to be separate to that 2 What are the implications of having an email campaign domain set up…

hi @Michelle Jabanes-Oracle The DKIM and SPF were set up correctly and verified against an external tool. For the SPF record, using https://powerdmarc.com/ For the DKIM: However, the domain page has the following error Why would the domain record show a DNS error when the actual DKIM entry is valid? Also, in this case,…

Hi @Nicole Mendoza-Oracle These are the two script deployments I have for that script For the EDP MR Item Category Price Update script deployment:

Hi @CDuf In the workbook? Yes

Thanks @Michelle Jabanes-Oracle In this case, the emails being sent out of Netsuite are not campaign or marketing emails. They are standard transaction and notification emails e.g. when a staff member submits an expense claim and a request for approval email is sent to the staff member's supervisor. Would the above…

Hi @Michelle Jabanes-Oracle Yes SPF was set up though DMARC wasn't. The client's email provider has requested a CNAME. Does this exist for Netsuite?

Hi @Katerina Winklerova-Oracle No, I haven't. This was mentioned under Release Previews so I assumed it was a feature of 2023.1. Is that not the case?

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