Richard James Uri-Oracle

Hi, Apologies on the confusion about my response. As per checking the SuiteAnswers Article: 104564 Customizing Mobile Table Elements, customizing the table to show specific requirements is not included or stated. With this, I have checked related concerns about customizing the tables by adding some filters and this was…

in Is there a way only show the first row of a Data Table in WMS Mobile? Comment by Richard James Uri-Oracle May 19, 2023 12:11PM

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

in How to group Profit and loss by class for actuals and budget? Comment by Richard James Uri-Oracle May 19, 2023 9:23AM

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

in How to resolve Fixed Assets in Negative cost? Comment by Richard James Uri-Oracle May 19, 2023 9:23AM

Hi, You have an interesting question, upon checking different documentations and concerns, I couldn't locate any relevant issues regarding the ability to generate the URL for the saved search result page using SuiteScript. However, I have found this SuiteAnswers Article about transferring the Internal ID obtained from a…

in Is it possible to generate the saved search result page's URL in the SuiteScript? Comment by Richard James Uri-Oracle May 18, 2023 8:33PM

Hi, After checking various associated issues, it was found that due to NetSuite WMS being a managed bundle, users do not have the ability to customize settings in order to add or remove functionalities, unless such modifications are handled by our Professional Services (PS) team. The extent to which customization of the…

in Is there a way only show the first row of a Data Table in WMS Mobile? Comment by Richard James Uri-Oracle May 18, 2023 8:18PM

Nice to see you posting here, @User_5OUXV Kindly allow us to review your concern about emails 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 search to show the Sales Rep's last email? Comment by Richard James Uri-Oracle May 18, 2023 5:30PM

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

in How to get inventory number Created Date via ODBC query? Comment by Richard James Uri-Oracle May 18, 2023 5:10PM

Nice to see you posting here, @Sue Campau 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. Have a great one!

in Adding tax to an invoice in pending billing status Comment by Richard James Uri-Oracle May 18, 2023 4:46PM

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

in Saved search to show no GL account activity Comment by Richard James Uri-Oracle May 18, 2023 1:30PM

Hi @Dext3r , After checking the SuiteAnswers Article 43546 error.create(options), we need to use the Name not the Title parameter. With this, I have tried to replicate again the concern and it seems that this will be the correct error message if the condition will achieve. See Screenshots Code snippet: Error message:: Hope…

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

Nice to see you posting here, @Imzy_code Kindly allow us to review your concern about 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 Saved search to show no GL account activity Comment by Richard James Uri-Oracle May 17, 2023 5:21PM

Nice to see you posting here, @User_TC8QE Kindly allow us to review your concern about Sales Orders 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 pull tax code based on the Store location record? Comment by Richard James Uri-Oracle May 17, 2023 5:07PM

Hi, After cross-referencing the Serial/Lot Number against the inventoryNumber table in the Records Catalog, it appears that there is no field indicating the Creation Date. See Screenshot After executing a query on the inventoryNumber table, I can verify that it does not contain the Creation Date field in each numbers. See…

in How to get inventory number Created Date via ODBC query? Comment by Richard James Uri-Oracle May 17, 2023 2:32PM

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

in How to find all transactions related to jobs using SQL Query using ODBC? Comment by Richard James Uri-Oracle May 16, 2023 8:03PM

Hi @PaulFleetwood , Upon coordinating this concern, we have replicated the script on the TSTDRV account that has a TAF Transaction CS (Part of the bundle Tax Audit Files - 47492). It seems that the script with adding the item at Line 0 works fine on the TSTDRV. See Screenshots Given all of this, it is recommended to file a…

in Why SuiteScript Insert Line 0 - now adding at end? Comment by Richard James Uri-Oracle May 16, 2023 5:44PM

Nice to see you posting here, @User_5HBIC Kindly allow us to review your concern about revenues 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 you allocate revenue across multiple accounts for a single item? Comment by Richard James Uri-Oracle May 16, 2023 5:22PM

Nice to see you posting here, @JarebCoupe Kindly allow us to review your concern about Lead source 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 is everyone handling sales attribution from ABM marketing leads? Comment by Richard James Uri-Oracle May 16, 2023 5:20PM

Nice to see you posting here, @User_7NK3Q Kindly allow us to review your concern about Workflow and 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 route Role Based Purchase Request approval Comment by Richard James Uri-Oracle May 16, 2023 5:18PM

Hi @PaulFleetwood , Thank you for the confirmation. Since the TAF Transaction CS (Part of the bundle Tax Audit Files - 47492) causing the issue. I will coordinate and transfer this thread to the Basic Accounting Team to further investigate you concern. Have a great day!

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

Hi, Since the previous reply to your question useful, others might be as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to help the community members who might have a similar concern find the answer easier and you will also get closer to earning your next Answer Accepter badge.…

in Is it possible to schedule the Rebuild Search Index for our SCA site? Comment by Richard James Uri-Oracle May 16, 2023 2:10PM

Hi, Since you have your file now from Kyriba via SFTP, we recommend that you consult or discuss your technical requirements with your Account Manager for additional customization. Thank you!

in How to create an automated process to upload these journal entries into NetSuite? Comment by Richard James Uri-Oracle May 16, 2023 2:07PM

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

in Is it possible to schedule the Rebuild Search Index for our SCA site? Comment by Richard James Uri-Oracle May 16, 2023 1:54PM

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

in How to put SYSDATE - 10 minutes in OIC Lookup? Comment by Richard James Uri-Oracle May 16, 2023 5:17AM

Nice to see you posting here, @User_CDQ4X Kindly allow us to review your concern about revenue 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 Pop Quiz. You only have until tomorrow/today,…

in Projected Revenue vs Actual Comment by Richard James Uri-Oracle May 15, 2023 5:52PM

Nice to see you posting here, @Carla Bell Kindly allow us to review your concern payroll about 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 Pop Quiz. You only have until tomorrow/today,…

in Payroll: How to find the list of fees for Ceridian payroll and how to remove additional "fees"? Comment by Richard James Uri-Oracle May 15, 2023 5:37PM

Nice to see you posting here, @Sivasubramaniam Kindly allow us to review your concern about Invoicesand 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 Pop Quiz. You only have until…

in How to get the invoice document number and unpaid amount of the invoice in A/R aging Report Comment by Richard James Uri-Oracle May 15, 2023 5:17PM

Nice to see you posting here, @Andrii Siryi Kindly allow us to review your concern about SOAP WS 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 What does "&#xD83D" mean in a SOAP Response? Comment by Richard James Uri-Oracle May 15, 2023 4:55PM

Hi, No worries. Have a great week ahead!

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

Hi, Since Inventory Number is a Lot/Serial Number, we need to filter 'islotitem' and 'isserialitem' to pull the Inventory with created date. See Screenshot Query: select itemtype,itemid,createddate from item where islotitem='T' or isserialitem='T'; Hope this clarifies your concern. Feel free to reply on this thread if you…

in How to get inventory number Created Date via ODBC query? Comment by Richard James Uri-Oracle May 15, 2023 3:40PM

Hi, In order to retrieve a Job along with its associated transactions, utilizing a JOIN table is necessary. Kindly check the Records Catalog, if your are going to use NetSuite2.com Data Source. Navigate to Setup>Records Catalog then Job As you can see here, there are numerous tables available for joining in the Job record…

in How to find all transactions related to jobs using SQL Query using ODBC? Comment by Richard James Uri-Oracle May 15, 2023 2:50PM

MFA for Oracle Community

Richard James Uri-Oracle Blue Diamond

Comments