cancel
Showing results for 
Search instead for 
Did you mean: 

Get Client Open Invoices

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

edy_simon
Active Contributor
0 Kudos

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