Maybe there's a way to write a script to submit the '1' response on load? : ) @Ivy Lopez-Oracle thank you for submitting the case to get this taken care of.

@Ivy Lopez-Oracle Thanks for the reply, but no need to file an enhancement request for this one. I have seen scenarios in the past where a field exists, and is accessible via Saved Search formula, but isn't well documented and does not show up in the UI. If anyone has a way of determining the field name here, I'd welcome…

Hi @Sophie Sk This sounds like it may be an issue of language. We work with products 'back ordered' at the vendor quite frequently where I work. In Netsuite they're represented as "On Order" or using the field {quantityonorder}. Depending on what you're trying to do, you may need to use a formula to display the vendor back…

Hi, Will Hendrick here, based in New York, New York. I'm the director of technology at a thriving specialty wine & spirits retailer. I'm the Netsuite administrator (erp) and technical generalist for the company. This year I'm training to run my first marathon(s!) in October and November.

Hi @"Michelle Jabanes-Oracle", Thank you for this information. Refreshing the Sandbox feels like a simple task -- maybe too simple. I wanted to make sure I wasn't missing something. Take care, Will

Thank you @"H Medina-Oracle". I opened support case 3723738.

Hi @"H Medina-Oracle" Were you able to replicate the behavior described?

Thank you for all the updates. After I initially created this thread indicating some users had regained access, all of our users lost access. Oracle resolved the issue within 60-90 minutes. It takes a bold engineer to update DNS settings in production !!

Hi @"4179904", I'm able to re-create a similar search using your screen shots here and see expected results. What are you seeing that you're not expecting? As is, the search includes data for item receipts and item fulfillments. You may consider setting Type is Invoice in the criteria section. Take care Will

Hi @"Jack Daryl Espiel-Oracle" Thank you for the information. This works brilliantly as a work around for the task at hand.

Hi @"H Medina-Oracle", Thank you for your reply and confirming the landscape and the enhancement.

@"Regine Pineda-Oracle", Thank you. This summary and linked information is what I was looking for (but hadn't found ) Have a pleasant day. Will

Thanks guys. I took Paul's advice and that works OK ✔ for the situation. Turns out we set this account up with an email address in my company's domain, so the vendor was never getting the 2FA initial registration email.

Try something like this: <#if item.itemtype='Discount'>${item.rate?string}<#else>${item.rate?string.currency}</#if>

Hi @"ksage", It sounds like the problem could be with the templates used to print out your different documents. Quotes, sales orders, cash sales, and invoices each have there own unique template used for printing (even if all the documents are branded the same and look really similar). You can find the list of templates by…

Hi Antoine, Happy to help, but I'm not sure we are on the same page exactly I read the issue to be linking multiple sales reps to a single customer (entity record). My assumption was that transactions were a different topic and that a customer's sales rep is mutually exclusive from the sales rep on any given transaction.…

Martha, We are not experiencing any issue with this feature. Have you verified no one changed the settings? Setup>Accounting>Accounting Preferences>Order Management Tab DEFAULT COMMIT OPTION ON SALES ORDER DEFAULT COMMIT OPTION ON TRANSFER ORDER Have you verified there are sufficient stocks available for the orders? Best,…

Hi Antoine, Two ideas to consider, each with trade offs you will need to weigh. 1) There's a team selling feature documented in the Netsuite help. (Search Help for "Team Selling") " The Team Selling feature lets you associate sales transactions and customers with sales teams comprised of various employees. In addition to…

Hi Martha, I may have something that can help you out here. This solution uses saved search instead of Reports. In my environment it helps to think of it like this. Instead of Fulfilling a sales order and billing a sales order, the software fullfills each item line and bill each item line on the order. This allows for the…

Hi Paul, I think my team worked through a similar issue to the one you're having. Where I work, we have two locations: a warehouse with a bin system and a retail store. The warehouse is laid out systematically with a few hundred bins, while the retail store location is set up with only one single bin. When receiving an…

John, Be sure to note the subtle distinction -- the criteria limits Bin On Hand : Location rather than simply Location -Will

Great trick using the div tags to change the way the results look on screen. Thanks for sharing.

Hi John, Depending on what you are trying to do, you may consider limiting the results to a single location as an alternative to grouping results. Try adding a criteria like this: Bin on Hand : Location is Consigned Inventory In my environment for a similar use case, it looks like this: Hope that helps Will

Robert, Thanks for the explanation. What I understand from your reply is that the 'old URL' scheme will continue to work for file cabinet files and Advanced PDF Templates after our production account is upgraded to the new URL scheme. At this time I should not need to update the template files. Is that right? Thank you

More than one way to skin a cat. Using a formula (numeric) can work for the comparison too. /*return only products recently modified. Set the Value field to adjust the time period. 0.0416667 should be about 1 hour. 1 is one day. 0.0138889 is about 20 minutes*/ (to_number({now}-{modified}))

Voltron, Thank you for all this information. I hadn't noticed the Search Form portlet before, and I've been looking for a way to present search forms to users (without first running the search, then clicking Return to Criteria). (assuming good data). We've got great data...it just includes lots of hyphens :)

John, I see what you're suggesting. We used to use ODBC connections between Excel and our legacy erp program's sql reports tables -- essentially to ask the same question of the data and get up-to-date results. So far we have really gotten a lot further simply using Netsuite's saved search capabilities. The use cases I have…

Hi Jocelyn, Question -- are the Debit Account and Credit Account values you're specifying constant? Or are they different, depending on the transaction? If you're filtering your saved search so that these are always the same value, you could potentially set a saved search criteria to return just Debt or Credit accounts.…

Hi Lyn, The items in our product catalog have a mean character count of 80 and a max of 120. I feel your pain! Having migrated from another erp system recently whose limitations were even stricter (just 40 characters), we've found ways to adapt along the way. Item Name - used as a short, alphanumeric unique ID that is 5 or…

Hi there, hochiai, Consider setting the restriction on the shipping item itself, rather than the promotion. Using this logic, you would need to set up a distinct shipping item for AK and HI if you ever plan to ship there. -Global search "page: shipping items" -Edit the specific item -Set the restrictions under the Shipping…