Hi,

I want to examine the order history in the database to verify that a customer doesn’t have any outstanding payments before I allow an invoice to continue. To increase performance I need to avoiding an extra round-trip or tightensecurity, I need to choose to perform this check on the server instead of the client. I need idea from someone. Please give me some tips. 

RajeshChauhan:

verify that a customer doesn’t have any outstanding payments before I allow an invoice to continue

you can do this verification in Stored Procedure in which you are storing the invoice data ( i userderstand that when you allow invoice to continue; you are storing invoice / order data in DB.. pls let me know if this is not the case). Check the OustStanding Payments with IF EXISTS (SELECT Statement in OrderHistoty Table) Query; if there are any outstandings then dont save invoice details in DB; else save the info in DB. pls let me know if this is not the case in your scenario.

hope it helps./.