Skip to Content
0

query for all sales invoices with closed date SAP B1

Apr 24, 2017 at 11:41 AM

54

avatar image
Former Member

Hi there

I would like a query that would show all AR documents (invoices and credit notes) raised to date, with an indication as to whether the invoice is open or closed. If closed, I would like to show the date it was closed and how it was closed (credited, paid, cancelled, manually reconciled).

Do you have an example of something I could use to produce this?

thanks

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers