Richard James Uri-Oracle

Nice to see you posting here, @User_ZPOBI Kindly allow us to review your concern about memo field in Invoice record 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 modify the size of a field on an invoice header? Comment by Richard James Uri-Oracle Jan 24, 2023 4:37PM

Hi @User_94CC1 , @GauravAgrawal is right. Thank you for sharing your thoughts. Or kindly check this SuiteAnswer articles to know more about SFTP Connections. You can use two-factor authentication to connect to an SFTP server. A combination of password and key is supported. SuiteAnswer Article: 61949 SFTP Authentication…

in Is there an FTP path/server linked within a NetSuite account? Comment by Richard James Uri-Oracle Jan 23, 2023 8:48PM

Nice to see you posting here, @Deb in UK Kindly allow us to review your concern about Expenses App 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 Is there an Expense Mobile App recommended for 4000 users? Comment by Richard James Uri-Oracle Jan 23, 2023 4:28PM

Hi @User_IJB6M , Upon checking all of the resources, here's what I have found. The unit of measure record is fully scriptable, which means that it can be created, updated, copied, deleted, and searched using server SuiteScript. Here's the SuiteAnswer Article for more details: 10510 Unit of Measure Thank you! Hope this…

in How I can get the ID of the unit type in SuiteScript? Comment by Richard James Uri-Oracle Jan 23, 2023 3:02PM

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

in Which table should I query to list all credit memos using SuiteQL? Comment by Richard James Uri-Oracle Jan 21, 2023 2:10AM

Hi @Durga Rao , Upon checking all of our resources first before checking the script provided, here's what I have found. According to the SuiteAnswer Article: 45313 SuiteScript Error SSS_USAGE_LIMIT_EXCEEDED The nlapiYieldScript API will be deprecated in favor of a new Map/Reduce data processing model. This new model will…

in Why unable to retrieve search results of huge data in Map/Reduce script? Comment by Richard James Uri-Oracle Jan 20, 2023 8:18PM

Hi @Sivasubramaniam You are right, @GauravAgrawal, you need to coordinate to your developer to discuss your concern because they need to make sure the logic within the Script won't exceed the usage limits. You can check the replies on this thread since you have the same concern. What is the SuiteScript Limit? Hope this…

in How to resolve the "Script usage limit exceeded" error on bulk payment? Comment by Richard James Uri-Oracle Jan 20, 2023 6:28PM

Nice to see you posting here, @Gabriel Jarillo Soto Kindly allow us to review your concern about PDF Printing 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 prevent printed PDF files to open in Acrobat and show it directly on the browser? Comment by Richard James Uri-Oracle Jan 20, 2023 5:53PM

Nice to see you posting here, @User_OE4KK Kindly allow us to review your concern about Journal Entries 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 resolve error Invalid item reference key X for subsidiary Y" in Journal Entry? Comment by Richard James Uri-Oracle Jan 20, 2023 5:28PM

Nice to see you posting here, @jitendrapratap Kindly allow us to review your concern about new accounts reports 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 that shows the created date or inactive date for the COA in 2022? Comment by Richard James Uri-Oracle Jan 20, 2023 5:04PM

Hi, Can you check in the permissions if the Credit Memo and Find Transaction are added to the Role you are using? Navigate to Setup > Users/Roles > Manage Roles Click Edit on the Role Go Permissions >Transactions This might be the possible reason of not returning the right results.

in Which table should I query to list all credit memos using SuiteQL? Comment by Richard James Uri-Oracle Jan 20, 2023 12:04AM

Hi @katherine_15328 , Glad to know that it is okay now! Have a great day!

in Emergency-NS Down: Why we can't login to Netsuite? Comment by Richard James Uri-Oracle Jan 19, 2023 6:25PM

Hi @katherine_15328 , As per checking, the page is accessible now and you can now logged back in. Thank you!

in Emergency-NS Down: Why we can't login to Netsuite? Comment by Richard James Uri-Oracle Jan 19, 2023 6:07PM

Hi, @katherine_15328 , We are looking to this issue and and we'll be keeping you updated on the results. Have a great one!

in Emergency-NS Down: Why we can't login to Netsuite? Comment by Richard James Uri-Oracle Jan 19, 2023 6:02PM

Nice to see you posting here, @KNason76 Kindly allow us to review your concern 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 Is there a CSV update process for removing BOMs and Routings from Assembly items? Comment by Richard James Uri-Oracle Jan 19, 2023 5:58PM

Nice to see you posting here, @Melanie Schaefer Kindly allow us to review your concern 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 do Customer Payment & use of Credit(other unapplied Payment) not recalculating Commission? Comment by Richard James Uri-Oracle Jan 19, 2023 5:55PM

Hi, As per checking on the related concerns, for workarounds, try on processing the records by batch.

in Why unable to retrieve search results of huge data in Map/Reduce script? Comment by Richard James Uri-Oracle Jan 19, 2023 5:39PM

Hi @User_VDX5O , Can you try this query if this will meet the concern? SELECT * FROM TRANSACTION tr INNER JOIN NextTransactionLineLink tl ON tr.TYPE = tl.NEXTTYPE AND tr.TYPE='CustCred'; or try to use the transaction and NextTransactionLineLink tables to get the Credit Memo and the related record is Invoice. This is based…

in Which table should I query to list all credit memos using SuiteQL? Comment by Richard James Uri-Oracle Jan 19, 2023 5:26PM

Nice to see you posting here, @Maleeka Kindly allow us to review your concern 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 Are there Audit Trail Pages for Rename Records/Transactions & Auto-Generated Numbers? Comment by Richard James Uri-Oracle Jan 19, 2023 4:59PM

Hi @User_VDX5O , Good day! Lists of Credit Memos are located in the transaction table. You can check the "CustCred" value in the type field to see it or just simply write this query, SELECT * FROM TRANSACTION WHERE TYPE = 'CustCred'; Hope this clarifies your concern. Feel free to reply on this thread if you have further…

in Which table should I query to list all credit memos using SuiteQL? Comment by Richard James Uri-Oracle Jan 19, 2023 3:33PM

Hi @Vernita , In InventoryItem, you can set a location to specific inventory item via Internal ID. You can check this browser to see the field. Upon checking, you can also set or get a child of a specific parent class. This is also same with Location and Department. You can also check the addList operations in SOAP Web…

in How to set a Child Level in SOAP Web Services? Comment by Richard James Uri-Oracle Jan 18, 2023 11:08PM

Apologies on this also, yes, according to my testing, it will show if the child is parent of a specific record. Internal ID: 2 | Name: Purch Child

in How to set a Child Level in SOAP Web Services? Comment by Richard James Uri-Oracle Jan 18, 2023 10:20PM

Hi @Vernita , Am I reading this correctly that since it makes reference to parent department set up, this will always be available through a soap integration? (and that is true for both body level fields and sublists) Yes, parent in Department, Class and Location is available since it is showing in the SOAP Schema Browser.…

in How to set a Child Level in SOAP Web Services? Comment by Richard James Uri-Oracle Jan 18, 2023 9:52PM

Hi @User_VDX5O , It is good that it working in your end! Thank you! 😉

in How to return the full date/time object in SuiteQL? Comment by Richard James Uri-Oracle Jan 18, 2023 7:26PM

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 retrieve search results of huge data in Map/Reduce script? Comment by Richard James Uri-Oracle Jan 18, 2023 6:54PM

Hi @Vernita , Good day! Upon checking all of our resources, here's what I have found. I wanted to confirm first the Departments, Classes and Locations and these are supported in SOAP Web Services. Kindly check the browser to verify your concern. SuiteAnswer Articles and Corresponding Browser: 10949 Location Browser 10903…

in How to set a Child Level in SOAP Web Services? Comment by Richard James Uri-Oracle Jan 18, 2023 6:53PM

Hi @User_VDX5O , Good day! You need to add this format to be able to achieve the date/time object in SuiteQL. TO_CHAR(createddate , date/time format) Format examples: 'DD-MM-YYYY HH24:MI:SS' 'MM-DD-YYYY HH24:MI:SS' 'MON-DD-YYYY HH24:MI:SS' 'YYYY-MM-DD HH24:MI:SS' Given this, you can try this SuiteQL to full the date/time…

in How to return the full date/time object in SuiteQL? Comment by Richard James Uri-Oracle Jan 18, 2023 6:53PM

Hi @User_E0AJC , Glad to have you with us today and thank you for creating another thread in NetSuite Support Community. Kindly allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other members of the community, feel free to share your…

in How to Create an Item Saved Search to Show Vendor Sublist? Comment by Richard James Uri-Oracle Jan 18, 2023 6:49PM

Hi @CRATIV_Jason , Glad to have you with us today and thank you for creating another thread in NetSuite Support Community. Kindly allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other members of the community, feel free to share your…

in How to set Fully Billed Purchase Order Status to Closed Status? Comment by Richard James Uri-Oracle Jan 18, 2023 6:16PM

Hi @Buckeye1497 , Thank you for replying to this thread in NetSuite Support Community. Kindly allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other members of the community, feel free to share your thoughts. Have a great one!

in How to create a Saved Search for Customer record updated fields? Comment by Richard James Uri-Oracle Jan 18, 2023 6:10PM

Richard James Uri-Oracle Blue Diamond

Comments