Hi @Sivasubramaniam, Unfortunately, it is not yet possible to convert existing items to matrix items. This functionality is requested in Enhancement # 53032. You can vote for this enhancement in the SuiteIdeas page.

I entered a PO dated today for NEW VENDOR 1. Only the line for NEW VENDOR 1 was excluded from the search, which is the expected result since NEW VENDOR 1 no longer meets the Summary Criteria:

Hi @Curtis Beene, For your 1st concern, I just tested the search by adding a new Vendors to the item record. Noted that these new vendors show up in the saved search as expected since there are no transactions yet using the vendor. If the Vendor is not added to the Vendor subtab of the specific item record, it will not be…

Hi @Curtis Beene, Are these Vendors included in the Vendors subtab of the Item record? We can only pull up those which are linked in the Item record. If you drill into the search by clicking the Item link/column, then it will show all POs from all vendors. Note that the filter we set in the Criteria tab > Summary subtab…

Hi @Biomerics_Admin, Glad to have you with us today and thank you for posting another question here in our community. ? Please allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To our other members, feel free to share your insights or…

Hi Diane, Glad to have you with us today. Thank you for posting another question here in our community. Please allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To our other members, feel free to share your insights or suggestions by…

Let me know if it shows exactly what you needed, or if you need further assistance with this one. By the way, 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…

Hi Dallas, In the pop up for selecting the date, you need to select "within" then click (Relative) Try this out and let me know if this is what you needed. I actually wasn't sure what you meant by "30,60, & 90 days away from expiring". If you needed the search to return only those with exactly 30, 60, & 90 days away from…

Thanks for your insights on this one, @JohnCirocco! --- Hi @Sonics, What John metioned is the suggested process of handling items you need to return to vendors. You can also find out more information about this process by going to SuiteAnswers 11181. If you find this or John's answer was helpful, we would greatly…

Hi @Curtis Beene, I tested this in my account and here's the Item Saved Search I came up with: Criteria tab > Standard subtab Criteria tab > Summary subtab Results tab Here's the formula used in the Criteria Summary and the Results: CASE WHEN {othervendor} = {transaction.mainname} THEN {transaction.shipdate} END Kindly…

Hi Dallas, I think you can do this by creating an Inventory Balance Saved Search. Here's the Criteria that I tested: Results tab: For the Quantity, you can choose if you want to show On Hand or Available (or both). Then, I added a Formula (Numeric) field that calculates the number of days until it is expired. This is…

Hi @Pervaz R. Allauddin, Thank you for providing that information. Upon further checking my resources about this, I noted that this currently a known system limitation and is documented under Enhancement # 649395: Saved Search and CSV Import Mapping > Copy to Account > Dependencies > An unexpected error has occurred and…

Hi @Tim S Jaha, Thank you for posting another question here in our community! Let me tag our gurus who can help you out on this one: @Dominica Sevilla-Oracle / @Ely Gulen-Oracle, any ideas to share? To our other members, feel free to share your insights and suggestions as well.

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

Hi @Eunice_C, This behavior is because the Show Internal IDs preference is checked under the user's Home > Set Preferences. With this preference enabled, it will show the Internal IDs even in Saved Searches which do not include Internal ID in the Results tab. To remove the Internal ID in the search of the custom role,…

Hi @Eklon Eleuterio, Thank you for posting another question here in the community! ? Tagging our experts on this: @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Kristoffer Viray-Oracle, any ideas? To our other members, feel free to comment your insights and suggestions as well.

Hi @User_H7YLR, Welcome to the community and thank you for posting your concern here! ? Let me tag our gurus who can assist you with this one: @Dominica Sevilla-Oracle / @Ely Gulen-Oracle, any ideas? To our other members, feel free to share your insights and suggestions on this as well.

Hi @Tybrneryan, Were you able to test what I provided in my previous comment? Let us know if it works for you, or if you need further assistance on this one. -Ivy

Hi @User_6YI1X, Try to add these in either Formula (Text) or Formula (Date) fields in your search: Formula 1: CASE WHEN {appliedtotransaction.shipmethod} = 'Marine Freight LLC {Trailers}' THEN {custbody15} END Formula 2: CASE WHEN {appliedtotransaction.shipmethod} = 'Customer Pick Up {Trailers}' THEN {custbody73} END Let…

Thanks for the quick revert, @Tybrneryan! I was able to come up with a saved search for your requirement but we need to use MS Excel or something similar in order to Pivot the results. This is because the formula I used contains a window function DENSE_RANK() which is allowed only in conjunction with a SELECT list of…

Hi @Tybrneryan, I am currently testing this on my account, and I just wanted to know if you need the dates from a specific type of transaction? Like Item Fulfillment perhaps? Or is it just any transaction?

Hi there @User_6YI1X, Glad to have you with us today and thank you for posting another question here in our community! Allow me to tag our Gurus who may be able to help you out with your concern: @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Kristoffer Viray-Oracle, any ideas about this one? To our other members,…

Hi @Pervaz R. Allauddin, What are you doing to copy the search from Sandbox to Production? Have you tried to recreate the search in Production from scratch, then just copy the formula? Are there any renamed records in Production? Also, can you share a screenshot of the exact error message that you receive?

Hi @User_8B06I, You're welcome! We're always glad to help! ? If it's not too much trouble, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment that helped in your concern. This will also help other community members who might have the same concern find the answer easier.…

Hi @User_8B06I, I tested this one on my test account, but was unable to reproduce the behavior you mentioned. Only 1 PO is created on my end. I further checked on this, and found other SuiteAnswers article that may help: 71840 - Drop Ship Sales Order created two Purchase Orders 34057 - Requirements to Create One Drop Ship…

Hi there @User_8B06I, Welcome to the community and thank you for posting your concern here! ? Can you please check what type of items are in the PO? Are they Inventory Items or Non-Inventory Items? Also, are these Special Order items or Drop Ship items? You may also want to check SuiteAnswers 18557: A Sales Order with two…

Hi @Alexsandro_Brazil_Oracle, Thank you for posting your concern here in the community! I checked on this one and it seems like this is a known system limitation and there is an existing enhancement logged for this: Enhancement # 173819: OneWorld:Setup > Accounting > Accounting List > New > Term. Customer is requesting for…

Hi @Martha Hakes, Thank you for posting another question here in our community! ? Allow our gurus some time to check on this one for you and we'll get back to you with our findings. To our other members, feel free to comment your insights and ideas on this thread!

Hi @HoJo, The Last Purchase Price field in the item record is a read-only field that displays the most recent purchase price of the item. This price is determined by the most recent transaction for the item that added positive inventory, such as a purchase receipt, inventory transfer or inventory adjustment. (This does not…

Hi @User_N5LAE, Welcome to the community and thank you for posting your concern here! Let me tag our Gurus who have the expertise on this one: @Erick Dela Rosa-Oracle / @Mikko De La Fuente-Oracle, any ideas? To our other members, feel free to share your insights and suggestions as well.