Hi @Dwight Schrute, If your startdate = {datecreated} and enddate=nvl({trandate},{today}), then you just substitute these in the formula. You will come up with something like this: ROUND(((TO_CHAR(nvl({trandate},{today}), 'J') - TO_CHAR({datecreated}, 'J'))) - ((((TRUNC(nvl({trandate},{today}), 'D')) -…

Hi @Dwight Schrute, Can you provide some examples that the results are inconsistent? One possible reason is that there are multiple Applied To Transactions, or the search is pulling information from multiple/different lines. It would be helpful if you can provide us the Criteria/Results tab of your search so we can also…

Hi @Rhys Gottwald, Yes, the system rule "Allow picking of expired items" is working as expected on my test accounts.

Hi @KNason76, Did you proceed with filing a case with NS Support? Or were you able to successfully import the CSV file? We'd appreciate it if you can keep us updated regarding this one. I'm also curious to know if there is indeed a limitation when uploading BOMs or if there's another reason why you are encountering an…

Hi @Rhys Gottwald, I did further tests on this one, but I was not able to reproduce the behavior you mentioned. I tried it in both the 2021.2 and 2022.1 versions of WMS. Per further checking, I did note a similar issue but has already been fixed, according to our records: Defect # 655891: WMS > Allow picking of expired…

Hi @User_A6IOW, Did @John Griffin's or my comment answer your question? If so, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment/s that helped in your concern. Doing so will help other community members who might have the same concern find the answer easier and you…

Hi @User_4G6AP, Were you able to test the solution provided in my previous comment? Let us know if it worked for you, or if you would need further assistance on this one.

Hi @Alexsandro_Brazil_Oracle, To remove this warning, navigate to Home > Set Preference > unmark Inventory Level Warnings. Hope this information helps! ? If it did. then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below this comment. Doing so will help other community members who…

Hey there @User_3BTAC, Kindly allow our guru/s some time to check this one for you and we will get back to you with our findings. To other users who may have insights regarding this topic, feel free to add your comments by replying to this thread.

Hi @User_3BTAC, Thank you for posting your question here! Our gurus/members will look into your concern and reply to this thread for any updates. @Mikko De La Fuente-Oracle will be assisting you on this one. To other members of the community, feel free to share your insights as well.

Hi @Gabriel Jarillo Soto, Thank you for being with us today and for posting your question here! Our gurus/members will look into your concern and reply to this thread for any updates. @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Kristoffer Viray-Oracle, any ideas? To other members of the community, feel free to…

Glad I was able to help! ? You can try either one of these formula: CASE WHEN {pricing.pricelevel} = 'Name of Price Level' THEN {pricing.unitprice} ELSE NULL END CASE WHEN {pricing.pricelevel} = 'Name of Price Level' THEN {pricing.unitprice} END

Hi @Wendy_M, In an Item Saved Search, you can use a Formula (Currency) field with this formula in the Results tab: CASE WHEN {pricing.pricelevel} = 'Name of Price Level' THEN {pricing.unitprice} ELSE 0 END Results tab: Results page: Hope this information helps! ? If it did. then we would greatly appreciate if you can click…

Hi all, We also have a video about this one. You may want to check it out here: -Ivy

Hi @User_4G6AP, If you want the search to be filtered based on the formula you entered, then you can add the Formula (Text) to the Criteria tab and Available Filters tab: When you run the search, it will show a Text field in the Filters region and you can enter the name of the Location there. Note: In the Results tab, I…

Hi @Jyothi B, Maybe you can add a formula in the Criteria tab > Summary subtab: Formula: MAX(CASE WHEN {systemnotes.type} IN ('Set','Change','Unset') AND {systemnotes.role} = 'Administrator' THEN {systemnotes.date} END) - MAX(CASE WHEN {systemnotes.field} = 'Document Status' AND {systemnotes.newvalue} = 'Approved for…

Hi @User_A6IOW, What @John Griffin mentioned is correct. I wrote a discussion regarding this topic. Here's the link if you want to check it out: ========================= If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer…

Hi @Kellyann, Using Administrator role, go to Setup > Accounting > Shipping > Packages. For more information, check SuiteAnswers 101492. Hope this information helps! ? If it did. then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below this comment. Doing so will help other…

Hi @KNason76, As per SuiteAnswers 8069, there is a limit of 25,000 records per imported file. I checked my resources and did not find any limit specific to BOMs so it might follow the 25,000 records/lines limit in general. Hope this information helps! ? If it did. then we would greatly appreciate if you can click "Yes" on…

You can add a Criteria so that the search will only show items that have Location Qty On Hand that is greater than 0. Try to add Location On Hand is greater than 0 in the Criteria tab of your search.

Just want to clarify.. Do you want the search to show only those with quantity on hand in the location?

Can you change the Summary Type of the Inventory Location to Group instead of Maximum? Does that change things?

Did you change the field in the Results tab as well?

Hi @User_4G6AP, Try using Inventory Location field instead of Inventory Detail: Location. Let us know if this will give the results that you require. ========================= If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this…

Hi there @Kitin Basilla, Glad to have you with us today. Thank you for creating another thread. ? 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 users, feel free join in the discussion as well. ?

Hi @User_GE47I, Glad to have you with us today. Thank you for creating another thread. ? Another member asked a similar question recently. You may want to check out this thread: It was stated by one of our gurus that this is a current system limitation and is documented in Enhancement #169158 Setup>Company>Printing, Fax…

Hi @User_HPB3I, Glad to have you with us today. Thank you for creating another thread. ? 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 users, feel free join in the discussion as well. ?

Hi @User_3BTAC, Glad to have you with us today. Thank you for creating another thread. ? 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 users, feel free join in the discussion as well. ?

Hi there @Rhys Gottwald, I tested this one on my end, and was able to reproduce this behavior only when doing Multi-Order Picking. Upon checking my resources on this one, I found an existing defect related to this: Defect # 648455: WMS > Allow picking of expired items? = N > Multi-order picking > Expired Lot Number still…

Hi @Rumaysa Mirza, Glad I was able to help! Hope you have a great day! ? -Ivy