[n.tiwari@manduka.com]

Hi,

For a customer search that I am trying to do, it should only pull customers that have SOs with $0 amount only. But when I run the search I get customers which has a mix of $0 and greater than $0 amount SOs in them. How do I fix this? Attached is my criteria of the customer search.

Attached Files
This is a cached copy. Click here to see the original post.

[eleran]

Add 1 more criteria

Transaction : Main Line is true

worked for me

[n.tiwari@manduka.com]

eleran Thanks for the suggestion. It significantly reduced my results but I still get the customers having sales orders amount greater than 0.

[pcutler]

Originally posted by n.tiwari@manduka.com

View Post

eleran Thanks for the suggestion. It significantly reduced my results but I still get the customers having sales orders amount greater than 0.

This search would give you all customers having $0 sales orders, who may also have non-zero sales orders. To search for customers with only $0 sales orders, you will have to use grouping and specify that the min and max amounts are $0.

[dominicb]

I'd tackle it a different way and run a transaction search instead:

Criteria:

Type: Sales Order

Main Line: True

Amount: Is 0.00

Date: (if appropriate for your case)

Results:

Customer:Name: Group

Document Number

Results:SORT BY

Customer:Name

That should give you a result set of customer names, and the option to drill down to transaction level.

[Author]

Posts