C

User_4RAZZ I hate suggesting this… Can you hard code the sequence to 24001 and update the 24 each year? At this point, I would create a NetSuite Support ticket. If the YY: field is a standard field, this could be a NetSuite defect. I don't know if you have NetSuite Support but if you can demonstrate that a behavior could…

User_4RAZZ I'm not sure. I would try testing this SuiteAnswer #34303 with one sequence, then see if your next transaction/lot respects the leading zeros.

User_4RAZZ So hope you are all set.

I logged a case with NetSuite and their development team worked on it & confirmed there is no native way to use the ODBC to retrieve a comparison between the Invoice Download Items and the files attached to the items so that I can compare the Customer entitlement to what is in the Customer Download Center. They did not…

Jervin Nicholas Teopengco-Oracle Just letting you know I have not forgotten your suggestion. Thank you.

Richard James Uri-Oracle Yes, we store the files that are attached to the items in the NetSuite File Cabinet. When we query the File Table we get results. The difficulty is retrieving the specific files attached to the item sold and tying those to the Customer Download Center. We are trying to validate that when we invoice…

Thank you, Richard James Uri-Oracle I can get the query to run and logically it makes sense, but we get no results returned. In Symmetry's Item table, none of our items have a value stored in the "storedisplaythumbnail" column. We don't use the web store so we don't store thumbnails. I see this field (or storedisplayimage)…

User_4RAZZ Does your Sequence # need to be 00001 instead of the leading 1?

NE_JohnC ooops, I just noticed you originated that thread… sorry. Also found this Saved search with Columns by Class you might take a look at.

Hello NE_JohnC Take a look at I am looking to create a saved search for Inventory on hand with a separate column for each locatio and adjust it for your fields. you will need a formula to accomplish this as well as grouping. in the results tab you will want a formula Numeric - Summary Type Sum or you can use Max your…

Hello Jervin Nicholas Teopengco-Oracle Yes, thank you. I saw your response and shared it with my Data Warehouse team. I will update when I get their response. Thanks so much for the follow up.

JimmyC_SR None for me… I found this (NetSuite WSDL version 2016.2 deprecation) on Celigo's site which relates to an earlier version but still applies I did get this information from NetSuite Support Upon further investigation, we have identified that one or more of your integration records in your account is utilizing an…

JimmyC_SR See if this thread helps What is WSDL and how do I upgrade the version?

JimmyC_SR We use Celigo to integrate some of our systems and this is where I updated mine. Hope it helps

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…