Vernita Bronze Trophy

Thanks @Jack Daryl Espiel-Oracle I am trying to first source the value of quantityavailable from the previous line though am getting the following error: This is the code function validateLine(context) { var currentRecord = context.currentRecord; var sublistName = context.sublistId; var line_number =…

Hi @Jack Daryl Espiel-Oracle I used a validate line function with a client script to set the freegiftpromotion field to "" just as an initial test (before I add in the logic of it being set to blank if the line preceding has a quantity of 0). I got the following prompt: Is that to say it isn't possible to close or alter…

Thanks @Jack Daryl Espiel-Oracle I have had a look at the Suiteanswers you have linked. There is a script example of 'manually' adding a promotional item rather than it being automatically added. https://suiteanswers.custhelp.com/app/answers/detail/a_id/10467 With that being the case, is it possible to source the quantity…

Hi @Jack Daryl Espiel-Oracle I had asked that a few weeks ago and was told it was not scriptable:

Hi @Katerina Winklerova-Oracle Yes I have gone through your answer. I am currently doing the data migration which is why I had the question so asking an implementation consultant is out of the question. I am not able to ask Netsuite support since they will refer me back here and I am not any clearer on what I should do for…

Hi @Jack Daryl Espiel-Oracle My understanding is that Suitepromotions is not a scriptable record type. Is that correct?

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