CDuf · Business Systems Analyst · Bronze Trophy

Thanks. Richard James Uri-Oracle Support's answer doesn't solve my issue. Thanks

Thanks Richard James Uri-Oracle The following is my exchange with Support. Me: Thank you, Joseph for the script. The shipMethod field is not available to access through the Connect ODBC because the Multiple Shipping Routes feature is not enabled in our implementation. We are a Software company that delivers our product…

All and Richard James Uri-Oracle I also logged a case with NetSuite Support and this is their response: Sounds great, we were able to locate the shipmethod field, kindly follow these steps in retrieving the said field: Under the Records catalog, under the Records tab, search for Transaction. Present on the overview tab of…

Thank you Richard James Uri-Oracle We don't need and are not "using" the feature but we do see and use the "field" . We sell software licenses and subscriptions and don't actually "ship" anything. The Licenses are "downloaded" so we use a shipping method of download. I can report on the field in a Saved Search using a…

User283824 Will try to get back on it today 🤞…In the meantime your saved search can send you an email as soon as the prepayment is "done". I know that is too late… so I agree a workflow with popup message is better.

User283824 I was creating a sample for you but am pulled away for now…

User283824 Receiving a warning message based on your business expectation would best be done using a Workflow. Transaction Saved Search Criteria: Based on the Vendor Prepayment Transaction records where Main Line is NOT used as criteria Applied to Transaction is Not Empty. Include Results tab: Applied To Transaction Use…

Elina Kourouzidou The Administrator can at Setup>Sales>Customer Statuses

True

Ginu Have you tried a search on Transactions>Inventory>"Bin Transfers" records and sort by Date Created, descending? I start my searches by navigating to the "list" of transactions I want to investigate then Customize the search list to match the criteria I need. Transfer Orders SuiteAnswer 27974 To create a saved search:…

Hello Angelica Mae Segador-Oracle Yes, thanks. I was OOO for all of Aug and looking now… Thanks! Your suggestion worked. I am including my failure as well in case anyone else makes the same mistake and needs a hint to solve. BACKGROUND: My existing code previews properly but I'd like the hyperlink word ("Agreement") to be…

Thank you Veronica Steluta Mincior-Oracle Yes, I've tried a Login Audit search but the options are limited and don't go to the page view level… I can tell a user logged in at a specific date & time, their role, etc… but not what they looked at. I appreciate it.

Advanced Financials

Great! Thanks!!

How can I compare 2 fields in a Customer saved search for a match but ignore upper/lower case? I tried Case When {email} like {custentity_invoice_email_address} then 'Match' Else 'No Match' End I would like this result to be a Match. My Criteria only returns rows that are No Match. I was hoping to exclude this row (and…

thank you Niks Blando-Oracle. I don't have a meeting notice for either session…. Would you ask someone to send me a meeting notice? Thanks.

Jeremy Guimaras-Oracle Thanks…. Knowing the basis (or lack of) is helpful so I don't keep hunting. I appreciate it.

Yes. Thanks, Niks Blando-Oracle. I agree… I can do it easily in a Saved search but then to get the pivot table & graphs, I have to download the results and create in excel.. I was hoping to leverage the Analytics Pivot and graph features… I would love to promote and get my users to use NetSuite Analytics but each time I…

Niks Blando-Oracle I thought I had it…. I added the same field as a Column then I could select Max….But when I audit my results, the column results are not as expected…. still working on it.. Thanks.

Niks Blando-Oracle My users are planning to move to a non-NetSuite Data Warehouse. I am trying to get them to leverage SuiteAnalytics instead because our users want the Pivot & Chart functionality in the Workbooks. I am trying to demonstrate the workbooks will work for them but I don't see a way to select the maximum Rate…

Thanks Richard James Uri-Oracle and all.

jon.landon.love the topic @Patrick Fresnosa-Oracle refers to is actually SuiteIdea 538825. Please ask your NetSuite administrator to vote for SuiteIdea 538825 and even more important is leave a comment documenting the business need, the burden not having this available and the benefit to having it. I see there are only 2…

Hi Richard James Uri-Oracle Thanks. Yes, for NetSuite controlled settings, it and we handle it well… I'm wondering if anyone has any additional experience with downstream integrated systems (in my case Auth0) and how anyone managed preventing downstream Sandbox system emails from being sent to people outside of our…

The Opportunity is its own record so you can do your saved search on the Opportunity instead of the Transaction record.

User_W5P2B As to tracking actual time on tasks… There are a few ways on the task itself 1.) Manually Enter the Duration 2.) Use the Timer. the Assignee would "Start" the timer, Pause it and Stop it as appropriate. 3.) Use the Calculate Time feature, Enter the Start and End Time and any time spent on break for the Total…

Hi Tris Mendoza-Oracle Of course, makes perfect sense. Good one

Dext3r I can replicate your issue. Odd… I agree, I would think if you have an "Employee" field on your Purchase Order… You should be able to just selected the Employee field without joining it. Even trying to join to the Employee field returns no results. I just tried replicating the search to the same results. The…

Well said/demonstrated, Jeremy Guimaras-Oracle Nice

jon.landon.love I can tinker later… keep you posted.

Yea, NS is a bit awkward when it comes to joins. I sometimes have to re-consider my starting point. You've started at the Time Tracking record which I think of as the lowest level record in the series of joins. Have you tried starting with the Support Case record and going after the time transactions and Project…