CDuf · Business Systems Analyst · Bronze Trophy

Hello jon.landon.love On the "case" record you should have a Time Tracking Tab where your team is entering time spent on the case or using the timer to track the time. You can join the Case record to the Time Record to get this information. Your team would have to be including the Project on the Case Time Tracking too Best

There has to be more than one unique value in one of the fields of data. As example, if a contact has 2 addresses, 2 rows will be returned. Criteria to only pull the Default (billing or shipping) address, would eliminate the 2nd address. The same theory is true for every line of data. If you have a multi-select field in…

lcrumling_42244 5/23/2024 update: As discussed, we have attached your case to the following defect on your behalf: Defect 766323 Custom Record > Saved Search > Total number of records are shown but UI shows "No Search Results Match Your Criteria." Alternate Solution: None 5/27/2024 update: We would like to let you know…

Hello @Hans de Molenaar While they have been merged legally, there is not really an easy way to "Merge" NetSuite Subsidiaries. This is a complex undertaking. Are you working with an experienced partner & your Account Manager? Are you working through this in Sandbox? Do you have multi-book enabled? Did you intend to…

Hello User_4BBKV What business problem are you trying to solve? What do you need that NetSuite does not already provide? Do you already have a list of requirements/business gaps? I know you said you are in Australia do you have the OneWorld version? Have you considered business process change instead of purchasing…

Hello @User_8ITTC & Patrick Fresnosa-Oracle this formula worked for me… I wonder if you could/would update the Discussion Subject &/or tags to be a bit more descriptive so we can find it again, if we search. This is great Patrick Fresnosa-Oracle

@Martin Randall I know this is an enhancement request & I hope you voted for it and provided a business case as to the burden of not having the enhancement and benefit of having it. We use Celigo CloudExtend, currently the Google Workspace version but previously the Microsoft 365 version & both overall, worked the same…

Hello Naresh_-Oracle I'm not sure what you mean. As you drill into each graph and hover over the line details, the Page Time Details and Profiler Details icons appear. Click on one to see the Operation ID in the top left of the screen. Hope this is it. Take Care

Naresh_-Oracle re: "Yeah APM we tried, we wanted to check if any other solution is there through which we can get a better understanding of the time consumed by each of the bundles/workflows are using for each transaction we do on the NetSuite account." What problem are not not able to solve with review of the APM details?…

User_KYVAD I had a similar need and documented it here . Not sure it will help but… https://community.oracle.com/netsuite/english/discussion/4489376/how-to-create-a-workflow-action-script-to-attach-a-file-to-a-custom-record Best

User_KYVAD There is a Workflow Session starting in approx 30 min. If you belong to the RMNSUG If you'd like: Hello Colleen, We invite you to join the Rocky Mountain NetSuite User Group on Wednesday, May 15, 2024 from 8:30am – 12:00pm (US Mountain timezone). Our Online-Only feature presentation will cover NetSuite…

Hello User_2I30C Absent any saved search criteria or knowing what the maintenance was…. Have you tried clearing your cache since the issue? I would close all windows, open one back up & clear your cache then try again. 🤞

User_OAFYM we use Celigo for our integration also. Have you validated that all your NetSuite required fields are mapped properly? The slightest difference can cause issues. One of my examples is "s" included in SF but not NS I had to specifically map the entire List of NS values to ensure no "nulls" I know your message…

@Kedalene Do you perhaps have multi-book in place? Are all the books open for May 2024? 🤞

User_L8T63 Yes, I see we can't "disable" the Price Level field using a workflow. Did you try unchecking the Price Level field on the custom Form? If you want your Controller to have access to the Price Level, you can have a 2nd form they can switch to that shows the field. Best,

User_84VR3 Have you tried creating a new Tab and moving it there? SuiteAnswer 37291 might help with the steps…

Kathy Woll ddennison Today's update: Case Closed. Fix Released. The fix allows us to hide the UPC Code on forms. It did not remove it from widespread distribution. We do not have the Inventory module so should not have the UPC Code but the field is still available to me. I did hide the field on my form, successfully.…

Bill Quinn Perhaps an additional criteria that evaluates and only reports transactions where line #s are not consecutive. Best.

Veronica Steluta Mincior-Oracle I send myself an email daily when records are deleted from a Saved Deleted Record Search so at least I know about it. I don't ask for (and can't get) a pdf of the item.

User_YLQQA Do you see the Remove link on the far right?

Bill Quinn I do it in Saved Searches by including the line #. If the line #'s are not consecutive, I know one has been deleted. Doesn't help if the "last" line is the one deleted… and doesn't give details of deleted but I can usually determine that a line was deleted. Try including line # Best.

Turns out the trouble he was having related to using upper case letters instead of lower case. the url we call is case sensitive : Good: const url = 'https://1234567-sb1.restlets.api.netsuite.com/app/site/hosting/restlet.nl?script=customscriptcustomscript_rest_getdl_item&deploy=1&custscript_companyid=3639' Bad: const url =…

Gia My "Mei" Luc As others note, without explicit limitation in SuiteAnswers & the reference to the same behavior as Departments, I would agree the list in a custom segment could be as long as necessary. The UI performance would mimic any excessively large pick list selection and may be annoying. Another consideration is…

User_XMFHV Not sure what your business need is, but if it is a list bills that are not paid, does the Open Bills report help? For future transactions, leaving the Vendor name off the Journal Entry the A/P Aging Summary and your custom A/P Register by Vendor would sort them to the top. 🤷‍♀️ I realize the Vendor Name on the…

Kathy Woll ddennison Today's update on my case: Oracle | NetSuite has investigated the defect and a fix has been identified to resolve the issue. After testing the fix, we will prepare and schedule its release to your account. Issue Number: 764866 Abstract: List > Accounting > Inventory Item > Customize > UPC Code is…

Hello GeorgeV. No, I did not solve for this. I created a support case hoping NetSuite had a tool/feature like LogRocket so we could see how our software Customers use NetSuite. Support suggested I reach out to Professional Services or Advanced Customer Support. I did find Enhancement # - 470616 Summary: 2FA > Two Factor…

A & B

Thanks Nicole Mendoza-Oracle for moving this to its own thread. I appreciate the SuiteQL link in the last thread. I also let him know…. "I have not encountered NetSuite instances that have stored SQL procedures so far. I believe it is currently not yet within standard NetSuite features for SuiteQL." Hoping 🤞 anyone might…

Thanks Nicole Mendoza-Oracle He says he is using N/query in the restlet but he's looking for a way to make a SQL Stored Procedure in NetSuite so the query doesn't just sit in the restlet file? Has anyone been successful creating a SQL Stored Procedure? Thanks all.

lcrumling_42244 thanks. I added my defect # to my above response. Thanks