This is a typical requirement from my client-
Client encourgaes sales to a particular part of the country. All our dealers belonging to any city or location are encouraged to sell to their end-customers of that part of the country. Dealers do specify the final customer location in their purchase orders, that we are capturing in the sales office field during sales order creation. Now, capturing the sales office as a criteria we are offering rebates and the system works fine.
However, sometimes dealers falsely declare the special rebate location in their PO but off load the material somewhere else. To check this part, our client have deputed people to confirm the material physically reaches the location that specified at the sales order; and on confirmation from these people only the rebate amount is paid to the dealers. Can some one suggest the way to map this, any idea will be highly appreciated.