Hi there @Burgess-Mel, Thanks for posting your question here in our community. Allow our gurus to check on this one and we'll get back to you with updates or if we need additional information. @Leonard Mallare-Oracle, any ideas? To our other members, feel free to comment your insights on this one as well.

Hi @User_M8RDQ, Welcome to the community! We're glad to have you with us today and thanks for posting your concern here. Allow our gurus/members to check on this one first, then we'll get back to you with our findings or if we need further information. Let me tag @Elychelle Gulen-Oracle & @Dominica Sevilla-Oracle who will…

Hi there @User_QN43D, Welcome to the community and thank you for posting your concern here. Let's see if any of our members have experience with the tools you mentioned. Tagging @JohnCirocco, @Tiru Chembeti, @John Griffin, @CDuf to see if they have anything to share. To other members, feel free to join the discussion as…

Hi there @nag_m, Thank you for posting your concern here in our community. @Michelle Jabanes-Oracle / @James Virtudazo-Oracle, any ideas regarding this one? To our other members, feel free to comment your insights on this thread as well.

Hi Dirk, Unfortunately, there is no workaround for this that I know of. Since we are using the Customer Search, then we are limited to only the available joining fields that it has. Apologies for the limited assistance I can provide on this one. To our other members who might have an idea regarding this one, feel free to…

Hi @User_CS3KK, Have you had the chance to test this out? Let us know if it worked for you or if you need further assistance on this one.

I remember having this discussion with you before. What did you have entered in the Criteria Summary tab of the search? For your reference, you can check our previous discussion here:

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. @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Kristoffer Viray-Oracle, any ideas? To other…

Hi @Dallas H, Glad to have you with us today. Thank you for creating another thread. ? First thing I noticed is that you are trying to pull a "Date" but you are using a Formula (Numeric) field. Normally, if you want a "Date" as a result, you would use Formula (Date). Also, you can try removing the NVL function since 0 is…

Hi Anne, Assuming that there is currently 1 quantity with cost of $1.00, then a new item receipt for 1 quantity is created with a cost of $1.20, then the average cost will be $1,10. If the item's costing method is set to Average, then yes, it will use the average cost of the item. The video link I provided is a replay of…

Hi @Eklon Eleuterio, 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 members, feel free join in the discussion as well. ?

Thanks for providing the exact formula, @Gabriel Jarillo Soto! @Tybrneryan, let us know if it worked for you. ?

Hi @User_NC62U, Can you try using the Transaction Accounting Line: Amount fields instead? Let us know if this will work for you.

Hi there @Rumaysa Mirza, Can you provide some screenshots of the Criteria tab and Results tab of the Saved Search you are creating? Also, can you clarify please what you meant by Item Name? Do you have items in your expense reports or were you referring to the Expense Category? It would be helpful as well to show us an…

Hi @Tybrneryan, Can you try using WHEN instead of OR?

Hi Dirk, I'm not really sure which lines are appearing more than once since you have hidden part of the item name, but have you tried grouping the results of the search? Also, you could check the Item Pricing subtab on your customer record, because that's where the customer search is getting it's values from. The Customer…

Hi there @User_CS3KK, I have tested this one on my account, and here's the Transaction Saved Search I came up with: Criteria tab: Results tab: Note: You can add other fields as necessary. Formula used (optionall): Used in Sales Orders: CASE WHEN {type} = 'Sales Order' THEN {quantity} END Used in Work Orders: CASE WHEN…

Hi @User_C6XDE, There might be some negative quantity in your bins. Please check SuiteAnswers 27872 for a search that will help identify if this is the case. If that doesn't work, then I suggest filing a support case so it could be further investigated in your account. (We are not able to reproduce quantity mismatches that…

Hi Dirk, I tested this one on my test account and was able to reproduce the behavior that you reported. It seems that using a Pricing Saved Search on the Customer Dashboard does not filter the results based on the customer. However, I did try using a Customer Saved Search, and it works as intended. Here are the details of…

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

Hi @SanjeevV, Glad I was able to help! ? As you confirmed that your main concern for this thread (regarding the Saved Search) has been resolved already, I suggest that you post a new question regarding your other concern about financial reports. (You can add a link to this thread if you want.) This is so that members who…

Hi there @SanjeevV, Thanks for posting your concern here in our community! In the Criteria tab, try adding a Formula (Numeric) field with this formula: CASE WHEN {quantity}-{quantitybilled}=0 THEN 1 ELSE 0 END equal to 0 Let us know if this works for you. -Ivy ========================= If you find this reply to your…

Hi @Amjad Kasem, Good to see you here again in our community! Allow our gurus/members to check this for you and we'll update you here in this thread. @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Kristoffer Viray-Oracle, any ideas? To our other members, feel free to share your insights on this one as well.

Hi @Dirk Nieuwkamp, Generally speaking, Saved Searches offer a lot more flexibility in using formulas than Reports wherein you can only do simple formulas. Also, reports are limited to using existing fields (standard and custom) only, and since we don't have a native field that gets the latest bill rate, then we can't get…

Hi @Anne Dolce, Basically, the unit cost will depend on the Costing Method that is set on the item record. We previously had a webinar about this topic, and you can watch the replay here: An example of the calculation of the cost using Average Costing is provided at around ~10:40 in the video. Hope this information helps!…

You're welcome, Ben! Glad I was able to point you in the right direction. ? By the way, we would greatly appreciate if you can click "Yes" on “Did this answer the question?” below my previous comment that helped in your concern. Doing so will help other community members who might have the same concern find the answer…

Hi @User_C6XDE, If you have Item as a column in your Results tab, then the search will get the location on the item line. Did you put any Date filters on the search? That might be causing the mismatch since the quantity on the Item Record always shows the current quantity. About the other search, you can try the steps…

Hi @Ben Belzer, The process you described sounds a lot like Outsourced Manufacturing. We do have this feature available in NetSuite and you can refer to SuiteAnswers 91095 (and related topics) to know more. I also found this thread related to the Outsourced Manufacturing process if you want to check it out. Anyway,…

Hi Dirk, For your first bullet point, it is a known system limitation to be able to specify a date range on an Item Saved Search. This is logged under Enhancement # 177982. About getting the item rate of the latest bill, I did some tests on my end, but was unsuccessful in getting your requirement. The roadblock I…

Awesome! Glad that we were able to figure that out and thanks for sharing the solution that worked on your end. ?