You're welcome, Jay! Glad I could help! Hope you have a great day! ?

Hi @Jay Schwausch, Glad to have you back with us and thank you for posting your concern here in our community! Based on the criteria and results of your search, you want to have the quantity of items per bin, per inventory number and per location. Instead of using Item Saved Search, have you tried using Inventory Balance…

Hi @Pete PW, Based on the field help of the Average Cost field: This field displays the current average cost of the item across all locations. Using the weighted-average method, the average cost is calculated as the total units available during a period divided by the beginning inventory cost plus the cost of additions to…

Hi @CDuf, Glad to have you back with us today and thank you for creating another thread here in the community! ? Kindly allow our gurus/members to check on this, and we'll get back to you with updates. To other users who may have insights with regard to this topic, feel free to add your comments by replying to this thread.

Hi @esabis, Have you been able to try what I mentioned in my previous comment? Were you able to delete the fulfillment records? If so, 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…

Hi @Curtis Beene, Not an expert with EDI, but here are my suggestions that may help with the issues you are facing: 1. Price verification Use a custom field to display the total group price on the Item Group record. For the detailed steps, you can refer to SuiteAnswers 67794. 2. "Extra" items in the Item Fulfillment record…

You're welcome, @HoJo! ? 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. Hope you have a great day! -Ivy

Glad I could help, Johnny! ? 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. Hope you have a great day! -Ivy

Hi Johnny! Thank you for the information you provided. This definitely helped in my testing. ? Kindly try this Transaction Saved Search that I came up with: Criteria tab Results tab Formula for easy reference: Labor Costs: CASE WHEN {item.type} = 'Other Charge' THEN ABS({quantity}*{rate}) ELSE 0 END Material Costs: CASE…

Hi @HoJo, CSV Import of Work Orders is a known system limitation and is logged as Enhancement # 216851: Setup > Import/Export > Import CSV Record> Ability to import Work Orders and Assembly Builds. You can vote for this in the SuiteIdeas page. However, if your main goal is to update custom fields in the Work Order, maybe…

Hi @User_MU3UD, Thank you for posting your concern here in our community! Let me tag my colleagues who may be able to help you out on this: @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle, any ideas? To our other members who have insights about this, feel free to comment on this thread! ?

Hi Johnny, Just a gentle follow up about the screenshots of the specific fields and example scenario so that we can proceed in testing if a saved search is possible for what you need. Looking forward to your response. ?

Hi @Harry Pham, Did you map both Plan Start Date and Plan End Date in the CSV Import? This is the solution documented in SuiteAnswers 35062. Let us know if it works for you. -Ivy ========================= If you find this reply to your question as helpful, others with the same question might find it helpful as well. By…

Hi @Hormese Paul, As documented in SuiteAnswers 27996, a line on a transfer order can be closed only if the in-transit quantity is zero. This is standard behavior of the system for Transfer Orders. The ability to close transfer orders even when there are quantity's in transit is currently requested in Enhancement # 233320.…

Hi @esabis, I tried this in my test account and I was able to successfully delete a Store Pickup Fulfillment record in Picked Up status. Do you receive an error message when you try to delete this record in your account? Alternatively, you can delete Cancelled Store Pickup Fulfillment records via Inline Edit: Let us know…

Hi @esabis, Thank you for creating another thread here in our community! ? Let me test this on my end first, then I'll get back to you with my findings. In the meantime, can you check if there are any transactions in the Related Records tab of the record you are trying to delete? Has anyone else encountered the same…

Hi Lily, Welcome back to the community and thank you for posting your concern here! Please allow our gurus/members to look into this and update you for any findings. @Shamaine Chan-Oracle / @Dominica Sevilla-Oracle, need your expertise on this. ? Anyone else who has an ideas or suggestions? Feel free to comment on this…

Hi Karan, Thank you for creating another thread in our community! Please allow our gurus/members to look into this and update you for any findings. @Dominica Sevilla-Oracle / @Shamaine Chan-Oracle, any ideas about this one? Anyone else who has an insight? Feel free to reply to this thread! 

Hi @farrago, Have you checked SuiteAnswers 14305 if the Assembly Matrix items meet all the criteria/setup mentioned? I have coordinated this with our experts in this topic and they suggested to create a Support Case if the behavior persists even after trying the suggested solutions in SuiteAnswers 14305. We would also…

Hi Daniel, Since you have Applying Transaction : Type is Purchase Order in your Criteria, then it will only show those Invoiced Sales Orders with related Purchase Orders. Based on the formula in your criteria, it will only pull those with a value for either the Vendor Cost or the Amount/Quantity of the Purchase Order. Can…

Hi @farrago, Thank you for creating another thread here in our community! Are you trying to add the Parent Matrix Assembly Item to the cart? or is it the Child item? Anyone else tried something like this before? Let us know in the comments below! ?

Hi @Curtis Beene, Use a Formula (Text) field with this formula: Monday Date: TO_CHAR((trunc({trandate},'Day')+1),'MM/DD/YYYY') Date Range: TO_CHAR((trunc({trandate},'Day')+1),'MM/DD/YYYY') || ' - ' || TO_CHAR((trunc({trandate},'Day')+7),'MM/DD/YYYY') Hope this helps! ? -Ivy ========================= If you find this reply…

Hi @Johnny Cash, Kindly provide screenshots of the specific fields you want to have in your saved search. I would also help in our testing if you can provide an example of the values you want to total. Just make sure that you hide any confidential information.

Hi Daniel, Since you are searching for the sale price (rate in the Invoice) and the purchase price (rate in the Purchase Order) then there should be a sales order linking the two transactions. Here is the search I came up with: Criteria tab Results tab: Formula: PO Rate: CASE WHEN {applyingtransaction.type} = 'Purchase…

Hi @User_NYYPL, I tested this in my account, but was unsuccessful as well to achieve the desired results. Per further investigation, I found that this is not yet possible and is currently logged as Enhancement # 409727: Transaction Saved Search: Type = Work Order > Provide a separate Quantity field to pull up quantity in…

Hi @Sonics, In Saved Searches, we can only pull up the current values in transaction lines since it is not yet possible to get the system notes or changes per line in a transaction. This is logged in Enhancement # 172761: Ability to create saved search for History link available on line item of a transactions. You can vote…

Hi Blake, Currently, this is exclusive to the Employee Center role. The intention is it would be used by users with the most "regular" or common role in the company. I checked, but found no related enhancements for this yet. If you want, you can submit a new enhancement request in the SuiteIdeas page. Also, we would…

You're welcome! Glad I could help! ?

I created the sample items and the item group in my test account and here's the results of search I came up with: Is this what you were looking for? If it is then here is a screenshot of the results tab of the search: Formula (Percent): 1-(SUM({memberitem.onlineprice})/SUM({memberitem.price})) Based on my tests, the…

Can you please further explain what you need to appear on the saved search results? You can provide an example of what you want to achieve exactly. You can use screenshots, just make sure to hide any confidential information. Also, why will the Summary Type = Sum not work for you? This will help us in testing for a formula…