-
Item Saved Search | Different Price Level & Currency in 1 Row
Greetings Community, we would want to show Item Record > Sales / Pricing Tab > "Different Price Level in CAD & USD" like this (highlighted Green) And we would like to use Item Saved Search. And we already got bit ahead by selecting Columns like: Name Formula (Currency) > {pricelevel2} Formula (Currency) > {pricelevel6}…
-
Need help with formulas for Item Saved Search
Hello Community, hope you can help I have a Saved Item Search that includes quantity sold for a specific time period but it is not returning the correct numbers The standard Sales By Item report advises the quantity sold during the same period = 1405 yet the formulas are showing 1430 for location PW and 0 in both Scrap…
-
How to remove duplicate Records showing in Item Saved Search Results?
Item Saved Search Issue - Saved search shows duplicate records Criteria - All items with Status = Active/Extension What is causing duplicate records - Reports shows all the items with active/extension status If the service item has any change example - Bill Rate, Pay Rate, Hourly cost, then the name of service item would…