Duplicate Invoice Number

jacklcs

My client has entered the sales invoice to the system. At that time I did not create a rule to check the sales invoice duplication yet. But now I did which prompt message to the user.

How do I create a query to list out those invoice number are duplicate and request the user to change it?

please help....

RocketRod

This is one way.....

Create a Duplicates BO with two attributes. Invoice number and invoice count.
Write a process that creates a Duplicate instance for each invoice instance as step 1.
Then step 2 calculates the invoice count for each duplicate instance.
Those with a count>1 are duplicates.

Cheers Rod