Ivy Lopez-Oracle NSC Guru

For that formula in the Criteria, try this: case when {inventorylocation} = {binonhand.location} then 1 else 0 end

The {binonhand} would show the total quantity on hand in the bins. Per checking in my test account, the field id is now changed to {binonhandcount} so you can try using this in the formula instead and check if it still returns the same error.

Hi @Nickey, In the saved search formula, try using {binonhandcount} instead.

Were you able to check my previous comment? Let us know if you need further assistance on this one.

Hi @SanjeevV, You can use the Customer join fields to get the information from the Customer Record into your Transaction Saved Search.

Hi @sfsonarboy, Glad to have you with us today. Thank you for posting another question here in the community! 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, feel free join in the discussion as well.

Hi @Strategit_Shunta4, Thanks for creating another thread! Allow our gurus to review your concern and perform their investigation. Anyone who also have insights that may help, feel free to comment as well.

Hi @Strategit_Shunta4, Thanks for posting another question here in our community! Allow our gurus to check on this first, and we'll keep this thread updated. To our other members, feel free to comment your insights on this as well.

Hi @Tina_the_AP Guru, Glad to have you with us today and thank you for posting your concern here on our community! Allow our gurus to check on this one, and they'll update this thread of their findings or if they need additional information. To our other members, feel free to comment your insights on this as well!

Hi @Chad GC, Can you clarify what you meant by search field? You can send a screenshot of this so we can also test on our end. Also, is the same behavior occurring in other browsers? (Chrome, Edge, Firefox, Safari, etc) 2022.2 version added a "Page Search" preference that was enabled by default: You can try disabling this…

Hi @RichardMc, I checked my resources regarding this one and you are correct that this is not yet possible in the current version of the system. I also tried to check for any existing enhancement request related to this, but didn't find any. Feel free to submit a new one in the SuiteIdeas page. To any of our members who…

Hi @Alejandro Medina, I have checked my resources on this, and noted that there is no standard way to disable or remove the ability of users to create standalone invoices only. However, you have the options of hiding the Create Invoice category from the tabs, and the customer record so that users will not be able to go to…

Hi @User_XBYW2, Per checking, that usually happens when there the field that you are adding on the Filters of the Report is showing in both the report components. By the way, we previously had a webinar about Report Customization. You may want to check it out here:

Hi @Alejandro Medina, Under Setup > Accounting > Accounting Preferences > Order Management > Invoicing, we do have a preference called Invoice In Advance of Fulfillment. Check this box to invoice your customers for the full amount prior to the complete fulfillment of an order. With this preference, you can invoice your…

Thanks for your insights on this one @John Griffin! --- Hi @Wellyntong, It would be greatly appreciated if you can click "Yes" on the "Did this answer the question" below the comment that helped resolve your concern. By doing so, others with the same question can easily find the correct answer. You will also earn points…

Hi @SanjeevV, 1) It's standard behavior of the system that it would change the custom sales price entered if the customer is changed on the transaction. You can reach out to your developers or to your account manager if your requirement is possible. 2) If your ad-hoc process works for you, then you can continue with it. It…

Hi @Martha Hakes, Thank you for keeping this thread updated and for sharing the resolution that you found. I'll be marking your comment as the correct answer so that other members who might encounter the same concern can find the answer easier. Have a great day!

Hi @User_RHKAB, Let's see if any of our other members have insights or suggestions about this one. In the meantime you can also check the Inventory Back Order Report if it will get what you need.

Hi @Betsy Vance, Were you able to check my previous comment? If it helped in your concern. then we would greatly appreciate if you can click "Yes" on “Did this answer the question?”. Doing so will help other community members who might have the same concern find the answer easier and you will also get closer to earning…

Hi @KNason76, Thanks for posting another question here in our community! Allow me to tag our gurus who can assist you on this one: @Patrick Fresnosa-Oracle / @Clarisa De Torres-Oracle, any ideas? To our other members, feel free to comment on this thread as well.

Hi @User_XBYW2, Welcome to the community! We're glad to have you with us today and thank you for posting your concern here. Can you share what exact report you are trying to customize?

Hi @Betsy Vance, Thanks for posting another question here in our community! Is the Allow editing of legacy BOMs feature enabled in your account already? You could check this feature by navigating to : Setup > Manufacturing > Manufacturing Preferences. In the Product Definition section, verify if the Allow Editing of Legacy…

Glad I could help, @User_OPUDV! We'd appreciate if you can click "Yes" on the "Did this answer the question?" below the comments that helped in your concern. That way, other members who might have the same requirement can find the answer easier. Have a great day!

Hi @User_OPUDV, I have tested the formula I provided in Analytics Dataset and can confirm that it works similar to saved searches. For the Formula in Analytics, just make sure to set the Output Type to String. Kindly try it on your end then let us know the results.

Thanks for confirming. As mentioned earlier, TRIM functions can only remove spaces, not letter/numbers/special characters. Let me do some tests on the dataset and I'll let you know how this can be accomplished there.

Hi @User_OPUDV, Note that LTRIM and RTRIM will only remove the leading/trailing spaces. If your goal is to separate the text before and after the comma, then you can use these formula instead: Text before the comma: REGEXP_SUBSTR({fieldid}, '[^,]*') Text after the comma: REGEXP_SUBSTR({fieldid}, '[^,]*$') Use Formula…

Hi @Martha Hakes, As I understand your concern, you want to get the prices listed in the Sales/Pricing tab of the item record to show in a Saved Search: This should be possible by using the Other Prices field on the Results tab of an Item Saved Search. Here's the sample saved search I created: Criteria tab Results tab…

Hi @Betsy Vance, If you have Multi Location Inventory enabled on the account, then you should be able to see the Auto Calculated Purchase Lead Time on the Locations sublist of the item record. In the Standard form, this is found under the Purchasing/Inventory Tab. Hope this helps!

Hi @Betsy Vance, I checked it on my standard test account and it seems that it's standard behavior that some fields are greyed out when the Replenishment Method is set to MRP. Here's some screenshots that show the behavior: Hope this clarifies your concern.

Hi @User_R6WMC, Thank you for posting your concern here in our community! Per checking, it seems that you already posted a similar question here: One of our gurus is looking into it already. You can continue your discussion in that thread.