Francesca Nicole Mendoza-Oracle Gold Crown

Hello @Bart Jonk, Good day. Just to give you an update. I ran each line that has a sum operation and so far the lines are working except for this one: sum(TO_NUMBER(BUILTIN.CURRENCY_CONVERT(transactionLine.foreignamount))), TO_BINARY_FLOAT(TO_NUMBER(CURRENCY_CONVERT(TransactionAccountingLine.amount))) as A_EUR I am still…

Hello @Joris Belgium, Good day. I attempted to overwrite the value for the author field on my end but it always ends up using the email address from the preferences. Here is the script that I used: /** * @NApiVersion 2.1 * @NScriptType UserEventScript */ define(["N/record"], (record) => { /** * Defines the function…

Hello @Andrii Siryi, I believe this is possible using the GET operation for the file record. You can use SuiteAnswers Resolve Unexpected Error When Retrieving File From File Cabinet Through Web Services for reference. Here's what it contains: <soapenv:Body> <platformMsg:get…

You're welcome! Always happy to help. 😊

Hello @Progeorgek, Good day! Have you seen my previous comment regarding your concern? If you need further assistance, please let me know. Thank you!

Hello @User_JPTT1, Good day! Did you get a chance to check my comment above? Thanks!

Hello @User_5KNNG, Bumping this thread in case you missed my previous comment. Thank you!

Hello @Kaushik_B-Oracle, Yes, that is correct.

Hello @Andrii Siryi, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support. Your participation and willingness to assist a fellow member are sincerely appreciated. 

Hello @JPrice, Can you please provide the code so I can test and modify it from my end? Thank you!

Hello @JPrice, Have you tried the try-catch method to work around this? If it does not work, the other method I could think of is to use a validation where if the current record 1. has a value in the "createdfrom" field and 2. the createdfrom field's type is "salesorder" then perform the load. Else, skip or perform a…

Hello @User_5KNNG, Good day. Important: I redacted the confidential information shown in your screenshot and file for your security. May I know if you followed these steps when you attempted to set up your OAuth2.0 in Postman? https://www.alphabold.com/netsuite-rest-web-services-restlets-with-oauth-2-0-using-postman/ Note:…

Hello @Progeorgek, Is this only affecting the custom fields but not the standard? I tested them for the start date (standard) and a custom transaction line field but could not encounter the same behavior. This looks like a potential defect so please let me know if you need assistance filing a case so I can assist you.…

Hello @User_JPTT1, I saw that you posted a new thread that is related to the Vendor Preference concern here: As for your other concern regarding the workaround for user notes, you can send them by sending a separate REST API Request. You can check out this video guide from SuiteAnswers to learn more on how to use the REST…

Hello @Nickey, Thanks for the update, yes this was announced last June and is now implemented as part of NetSuite version 2023.2. I hope this helps! If you find this reply to your question useful, others might as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to help the…

Hello @Progeorgek, Can you please check if the User Preference of the Integration User under Home > Set Preference and the company's time zone preference under Setup > Company > Company Information are the same? This could be causing the discrepancy between the payload and the displayed dates. I hope this helps! If you…

Hello @Kaushik_B-Oracle, Following up on this thread in case you missed my previous comment. Thanks!

Hi @Camila O, Good day! Upon checking, this feature is not yet available but has been filed as an enhancement request under Enhancement #640039 SuiteApprovals > Record created via Map/Reduce or Scheduled Script > approval flow not triggered. To support this Enhancement, you can cast your vote on the SuiteIdeas page by…

Hello @JPrice, Glad to know you got it to work! Thank you for letting us know. Have a great day.

I'm glad to hear that. Happy to help!

Hi @Dext3r, I'm so sorry for missing this but client scripts only run on Edit mode. This is mentioned in SuiteAnswers: pageInit(scriptContext) I hope this helps! If you find this reply to your question useful, others might as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to…

Thanks for the update, @Michael Shparber. I'm still confirming this matter as of now but I have not received any response so far as well.

Hello @Dext3r, Yes, either send the code as a .txt file or just paste the code here. Thank you!

Hello @Nickey, Thank you for posting in the NetSuite Support Community! Hello everyone! Your expertise and knowledge are greatly appreciated, and we ask that you kindly offer your support. Your participation and willingness to assist a fellow member are sincerely appreciated. 

Hello @Kaushik_B-Oracle, So far both SuiteAnalytics Connect and SuiteTalk are the same. They can only fetch the internal ID of the custom form but not the list itself.

Hello @Dext3r, Thank you for providing us with this information. Can you please put a log.debug() line on the very first line of the pageInit function? So that we can see it in the execution logs. Note: Make sure your log level is 'Debug' in the Script Deployment record. If this still does not work, please check the…

Hello @User_HPB3I, Good day and thank you for posting this new thread! Hello everyone! We'd greatly appreciate your support in this matter. Your willingness to assist a fellow member doesn't go unnoticed and is sincerely valued.

Hello @Michael Shparber, Has anyone reached out to you so far? I'm also checking who you can reach out to regarding this concern. I'll get back to you once we have an update. Thank you!

Hello @Fionax, Were you able to check my previous comment? If you still need assistance, please let us know. Thank you!

Hello @User_FL4CK, Bumping this thread in case you missed my previous comment. Thanks!