on 07-30-2009 2:50 PM
Hi,
I have a ClientId (CardCode) and I need to know the invoice numbers & dates of any open invoices it might have, how can I do it?
Thank,
Ignacio
Hi Ignacio,
Do you need to do it by SDK ? or you just need it adhoc.
If you dont need it regularly, you can use the SBO Query Generator.
Assuming you are talking about AR invoices
SELECT DocNum, DocDate FROM OINV WHERE STATUS='O' AND CARDCODE = 'CLIENTID'
If you need it programatically, You can use DI Recordset Object
Dim sSQL as string = "SELECT DocNum, DocDate FROM OINV WHERE STATUS='O' AND CARDCODE = 'CLIENTID'"
oRecordset.DoQuery(sSQL)
Regards
edy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.