I am hoping someone here can tell me what I may be doing incorrectly that is creating invalid results returned on a search.
Simple Transaction Search to return total quantity of my items sold within a given time frame.
Criteria:
Mainline No
Type Sales Orders
Status Billed
Shipping line, Tax line and Cogs line all set to No
Date 9/1/2012 through 9/30/2012
Results:
Item: Name - Grouped
Item: Alternate Name (custom field every item) - Grouped
Item: Display Name - Grouped
Department - Grouped
Item Rate - Grouped
Quantity - Sum
Filter on Item: Name and Item: Alternate Name
When I run the search with no filters, my results are perfect
If I enter a specific Item: Alternate Name the search returns back only the lines with that Alternate Name
BUT :h_a_w:
If I enter the NetSuite Item (Item: Name) my results are doubled.
To make it even more maddening if I first enter the Alternate Name and get the proper correct results and then keep that filter but also enter the NetSuite Item Name the results still double.
When I drill down, only the correct number of records are returned.
Has anyone ever experienced this before or can think of a possible reason?