Richard James Uri-Oracle

Hi, Happy Monday! May I request an update on this thread? Kindly inform us if any additional help is required. Thank you!

in How to group Profit and loss by class for actuals and budget? Comment by Richard James Uri-Oracle May 15, 2023 1:35PM

Hi, Happy Monday! May I request an update on this thread? Kindly inform us if any additional help is required. Thank you!

in How to resolve error Invalid subsidiary reference key X for entity Y" in credit card upload Comment by Richard James Uri-Oracle May 15, 2023 1:35PM

Hi, Happy Monday! May I request an update on this thread? Kindly inform us if any additional help is required. Thank you!

in Is it possible to depreciate the residual value of a Fixed Asset? Comment by Richard James Uri-Oracle May 15, 2023 1:34PM

Hi, Interesting question about the execution order, as per checking, when scripts and workflows are deployed together and share the same triggers and contexts, the scripts will be triggered prior to the workflows. See SuiteAnswers Articles: 103495 Best Practices for Workflow Configuration 38093 Execution Order of Scripts…

in Why SuiteScript Insert Line 0 - now adding at end? Comment by Richard James Uri-Oracle May 14, 2023 4:06AM

Hi, May I request an update on this thread? Kindly inform us if any additional help is required. Thank you!

in how to reference the inactive field on a customer record via SuiteScript? Comment by Richard James Uri-Oracle May 12, 2023 8:52PM

Nice to see you posting here, @Kitin Basilla Kindly allow us to review your concern about orders in saved search and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. Have a great one!

in How to create a Saved Search for Back Orders that show if it has PO or WO? Comment by Richard James Uri-Oracle May 12, 2023 5:19PM

Nice to see you posting here, @User_0C4S5 Kindly allow us to review your concern about Vendor payments and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. Have a great one!

in How do I split a vendor payment by subsidiary & percentage Comment by Richard James Uri-Oracle May 12, 2023 5:03PM

Hi, Can you try to change the line var checkLine = currentRecord.getSublistValue to var checkLine = currentRecord.getCurrentSublistValue then execute the Script again. Upon trying the updated code on my TSTDRV account, the new item is at line 1. See below: To check if there's changes made of the concerned code, you can…

in Why SuiteScript Insert Line 0 - now adding at end? Comment by Richard James Uri-Oracle May 12, 2023 3:57PM

Hi, Upon checking, the ORA-29024: Certificate validation failure occurs when the certificate sent by the other side could not be validated. This may occur if the certificate has expired, has been revoked, or is invalid for another reason. I have found this information by extending help outside the NetSuite documentation.…

in What is ORA-29024: Certificate validation failure in SuiteQL from Oracle database using REST? Comment by Richard James Uri-Oracle May 12, 2023 2:53PM

Hi, Thank you for the confirmation. As you can see in the Joins subtab on the Note Records Catalog, you need to use join query to get the specific record to meet your requirement. See below screenshot Also, Upon checking, there's an existing multiple Enhancement requests for notes table in NetSuite2.com data source: 610784…

in How to access user notes table in SuiteAnalytics connect? Comment by Richard James Uri-Oracle May 12, 2023 2:25PM

Hi, May I request an update on this thread? Kindly inform us if any additional help is required. Thank you!

in What is the difference between Bank Reconciliation and Balance Sheet? Comment by Richard James Uri-Oracle May 12, 2023 1:41PM

Hi, May I request an update on this thread? Kindly inform us if any additional help is required. Thank you!

in Setting Up Automatic Accruals tied to Sales Invoices Comment by Richard James Uri-Oracle May 12, 2023 1:40PM

Hi, It's great that the issue has been resolved. Please let us know if you need further assistance. Thank you!

in Why unable to fetch & deploy SCA Theme & Extension after 2023.1 release? Comment by Richard James Uri-Oracle May 12, 2023 1:34PM

Hi, Upon replicating your concern, the Client Script fieldChanged type triggered on my end. See GIF See code snippet function fieldChanged(scriptContext) { var curRec = scriptContext.currentRecord; if (curRec.getValue('isInactive')=='T'){ alert("True"); } } Hope this clarifies your concern. Feel free to reply on this…

in how to reference the inactive field on a customer record via SuiteScript? Comment by Richard James Uri-Oracle May 11, 2023 7:20PM

Hi, Good day! If you are using NetSuite2.com data source, you need to navigate to Setup > Records Catalog to see the available fields, feature and permission requirements for Note record. (See below) If you are using NetSuite.com data source, you need to access the Connect Browser to see available fields. (See below) Hope…

in How to access user notes table in SuiteAnalytics connect? Comment by Richard James Uri-Oracle May 11, 2023 5:37PM

Nice to see you posting here, @User_XNZ2C @User_FL4CK Kindly allow us to review your concern about saved searches and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. In the meantime, you might be interested to participate in our Weekly Quiz. You only have…

in How to marry 2 different search formulas in a single Saved Search? Comment by Richard James Uri-Oracle May 11, 2023 5:28PM

Nice to see you posting here, @rgonz-mhi Kindly allow us to review your concern about SuiteAnalytics Connect and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. In the meantime, you might be interested to participate in our Weekly Quiz. You only have until…

in How to access user notes table in SuiteAnalytics connect? Comment by Richard James Uri-Oracle May 11, 2023 5:05PM

Nice to see you posting here, @User_FL4CK Kindly allow us to review your concern about invoices and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. In the meantime, you might be interested to participate in our Weekly Quiz. You only have until May 11, 2 PM…

in How to resolve unexpected SuiteScript error when printing Invoices using Advanced Template? Comment by Richard James Uri-Oracle May 11, 2023 4:52PM

Hi, Can you try to change the message under error.create for us to make sure that this is the standard popup message of the error.create? Thank you!

in What's the meaning of this Error in SuiteScript 2.0? Comment by Richard James Uri-Oracle May 11, 2023 4:35PM

Hi, I would like to follow up on this thread. Please let us know if you need further assistance. Thank you!

in Saved search for Vendor Transactions /Bill Payment---YTD/MTD Comment by Richard James Uri-Oracle May 11, 2023 3:40PM

Hi @Pradeep Kumar. , I would like to follow up on this thread. Please let us know if you need further assistance. Thank you!

in Is possible to create Budget dataset and workbook where I can determine the budget amount in USD? Comment by Richard James Uri-Oracle May 11, 2023 3:40PM

Hi @Angel Chang , I would like to follow up on this thread. Please let us know if you need further assistance. Thank you!

in How to resolve the expense report POST error? Comment by Richard James Uri-Oracle May 11, 2023 3:38PM

Thank you for sharing your thoughts, @GauravAgrawal . Anyone from the community who might had the same need and happen to know of an alternate solution to this? Any insights you can provide would be highly appreciated. Thank you!

in How pull CTA value in NetSuite Reports via queries? Comment by Richard James Uri-Oracle May 11, 2023 3:07PM

Thanks for sharing your insight with regard to the concern, @GauravAgrawal @emcee_uk , let us know if you still further assistance. ------------ In the meantime, you might be interested to participate in our Weekly Quiz. You only have until May 11, 2 PM EST to comment your answers and earn rewards! Click here for more…

in What to do when asset values are not updating? Comment by Richard James Uri-Oracle May 11, 2023 2:41PM

Thanks for sharing your insight with regard to the concern, @GauravAgrawal . @Kedalene , let us know if you still further assistance. ------------ In the meantime, you might be interested to participate in our Weekly Quiz. You only have until May 11, 2 PM EST to comment your answers and earn rewards! Click here for more…

in How to update Chart of Accounts to check "REVALUE OPEN BALANCE FOR FOREIGN CURRENCY TRANSACTIONS"? Comment by Richard James Uri-Oracle May 11, 2023 1:11PM

Hi, I would like to follow up on this thread. Please let us know if you need further assistance. Thank you!

in Why unable to fetch & deploy SCA Theme & Extension after 2023.1 release? Comment by Richard James Uri-Oracle May 11, 2023 1:02PM

Nice to see you posting here, Kindly allow us to review your concern about roles and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. Have a great one!

in How to show the Sales Order List on Custom Role? Comment by Richard James Uri-Oracle May 10, 2023 5:29PM

Nice to see you posting here, @User_J6WYT Kindly allow us to review your concern about files and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. Have a great one!

in Why is the <Ustrd> section empty in XML Electronic Payment File generated? Comment by Richard James Uri-Oracle May 10, 2023 5:12PM

Nice to see you posting here, @Kedalene Kindly allow us to review your concern about chart of accounts and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. Have a great one!

in How to create a Saved Search: Chart of Accounts REVALUE OPEN BALANCE..FOREIGN CURRENCY TRANSACTIONS? Comment by Richard James Uri-Oracle May 10, 2023 5:06PM

Nice to see you posting here, @KNason76 Kindly allow us to review your concern about bundles and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. Have a great one!

in Any confirmation that Concur is no longer offering an integration via their bundle to NS? Comment by Richard James Uri-Oracle May 10, 2023 4:50PM

MFA for Oracle Community

Richard James Uri-Oracle Blue Diamond

Comments