Hi @KNason76, Glad to have you with us today and thank you for posting your concern here in the community! You can try the solution that @Martha Hakes and @John Griffin provided if those will work for you. Just a note for John's solution, it would require the Advanced Bill of Materials feature to be enabled on the account…

You're very much welcome! I'm glad we were able to make it work! ?

Kindly try this formula if this will give what you need: (NVL({quantityonhand},0)+NVL({quantityonorder},0)) - (NVL({quantitybackordered},0)+NVL({quantitycommitted},0)) ====================================== If you find this reply to your question as helpful, others with the same question might find it helpful as well. By…

Hi Martha, Do you need this per Location or the total for all locations?

Hi Aniket, If you see the feature in your account, but it is not checked, then it is possible to enable it yourselves. However, we highly suggest to test out the features first in Sandbox or Development accounts first before enabling in a live Production account. For more information about enabling the Advanced…

Hi Maurice, Glad to have you with us today and thank you for posting your concern here into our community! ? Allow me to tag our Gurus who have expertise on this topic as they will be collaborating with you on this one. @Emilia Ironov-Oracle / @Micah Timbol-Oracle, any ideas? To our other members, feel free to join the…

Hi @Aniket-Silversky, Per checking my resources, it seems that this is currently the standard behavior and an enhancement request is logged for the ability to show the available quantity per lot on this screen: Enhancement # 121486 - Lot Numbered Items: Ability to show the lot quantity available on the pop up window of a…

Hi @John Jacobs, Glad to have you with us today and thank you for posting your concern here in the community! ? Allow me to coordinate this with our Gurus who can best assist you with your concern. @Erick Dela Rosa-Oracle / @Mikko De La Fuente-Oracle / @Jeff Pineda-Oracle, any ideas that can help John? To our other…

Hi @User_5P3TP, Glad to have you with us today and thank you for posting your concern here in our community! ? @Joy Noreen Magoling-Oracle and I will be assisting you with this one. Kindly allow us to check this first on our end then we will reply on this thread for any updates. To other members who may have ideas or…

Hi @dle_35705, Glad to have you with us today and thank you for posting your concern here! ? Allow me to tag our Guru who specializes on Roles & Permissions. @Michelle Jabanes-Oracle, any ideas on this? Other members who may have ideas or suggestions on this, feel free to comment on this thread.

Hi @Kenny Wise, Do you mean that the WIP checkbox is unchecked once the Work Order is released? The standard behavior of the WIP checkbox in Work Orders is that it defaults based on whether WIP is marked for the location in the item record. You can check this in the Locations sublist under the Purchasing/Inventory tab. A…

Hi @User_JZWW7, Welcome to the community and thank you for posting your concern here! ? One of our gurus who has the expertise on your concern will check this. Please give us some time to investigate this and get back to you with updates. Anyone else have a similar experience? Feel free to share your thoughts and insights…

Hi @Lewalsh11741, Glad to have you with us today and thank you for posting your concern here in our community! ? Tagging our Gurus with expertise on your concern. @Jack Daryl Espiel-Oracle / @Pauline Joy Cac-Oracle, any ideas about this? To our other members, feel free to comment your thoughts or suggestions in this thread.

I'm glad it worked for you Dallas! ? As for the Edit toggle, it does not appear when the results of the search is grouped or has a Summary Type. However, if you click on the Item Name in the search results, you will be shown the drill down results and the Edit toggle is visible there: Hope this clarifies your concern. -Ivy…

Hi @Jeannie_13902, Welcome back to the community and thank you for posting your concern here! ? Tagging our Guru @Michelle Jabanes-Oracle who has expertise on this topic. Other members, feel free to join the discussion by commenting your thoughts or suggestions.

Hi Dallas! I have checked the screenshots you provided and tested the saved search in my test account and here are my suggestions for you to get your requirement: 1. In the Criteria, add Item: Inventory Location is any of Calgary Warehouse, Edmonton Warehouse. Adding this filter will show only the two locations that you…

You're welcome, Hakam! Glad I was able to help! ?

Hi @Hakam Karawi, You can accomplish this by doing a Mass Update for your items. 1. Go to Lists > Mass Update > Mass Updates 2. Expand General Updates then click Inventory Item 3. Add Filters under the Criteria tab as necessary. If you will be updating ALL items, no need to add any filters. 4. Under the Mass Update Fields…

You're welcome, Dallas! ? I'm glad we were able to achieve what you needed. Hope you have a great weekend!

Hi @417PM, Upon checking on this, it seems that there is an enhancement related to your concern: Enhancement # 74661: Lot Tracking - We need a report that displays Lot Numbers and the Current On HAnd Count for that number on a specified past date You can vote for the enhancement in the SuiteIdeas page. Per checking, there…

Hi Dallas, I'm glad we're on the right track! The purpose of the formula in the criteria was so that the formula in the results will only consider those transactions which have the same Inventory Location and Transaction Location. So if the item does not have a transaction yet, it might not show up in the search. Anyway,…

Hi there @Dallas H! Thanks for providing that information. I gather that the previous search was a Transaction Saved Search while the current one you are working on is an Item Saved Search, which is the reason why the formula before does not work. I have tested this on my account and here's the search I came up with.…

Hi @Robert D., Thanks for creating another thread here in our community! Tagging my colleagues who will be helping you with this one. @Micah Timbol-Oracle / @Emilia Ironov-Oracle, any ideas? To our other members, feel free to join in the discussion by commenting your thoughts or suggestions. ?

I don't think we can change the filter type from drop down list to an open text, but I found a possible alternate solution using the Formula (Text) field. In the Criteria, add this: Note that the letter "a" is just a placeholder so you can type in the Inventory Number on the Results page later. In the Available Filters…

Hi there @esabis, Per checking, you can select the Customer or the Project on the Inventory Adjustment record and based on the field level help, this is is usually used if this inventory adjustment is a project-related cost but is not specifically billed as a line item. For example, when a caterer bills his or her…

You're always welcome, @dle_35705! Have a great day! ?

Hi Asher, Thanks for creating another thread here in our community! Tagging my colleagues @Jack Daryl Espiel-Oracle and @Pauline Joy Cac-Oracle who will help you out in this one. To other members, feel free to comment your insights on this thread!

Thanks for sharing the enhancement details, Joy! Hi @Vernita, If you really need them sorted by sizes, you can consider creating a custom item field which would serve as a basis of sorting the items. In my tests, here's the custom item field I created: You can use the Mass Update function to update the values in the custom…

Hi @Jeff Dickens, Glad to have you back with us today and thank you for posting your concern here in the community! Our gurus who specialize on this topic, @Jack Daryl Espiel-Oracle and @Pauline Joy Cac-Oracle, will further check this. Kindly allow them some time to investigate this and get back to you with updates. To…

Hi @dle_35705, Upon initial checking of the screenshots you provided, here are some points I have noted: Based on the Criteria you set, you also want to show Inventory Items. However, you also put "Member Item : Inventory Location" as a criteria. In doing so, the search will only consider those items with Member Items.…