Skip to Content
0
Former Member
Sep 20, 2012 at 04:31 AM

Query to generate invoices details

84 Views

Hi

I need help to setup a query that shows all the invoices in the system with the following data:

1-Supplier name

2-Invoice Number

3-Posting Dtae

4-list all items included / invoiced in each document (sort by invoice number then by its lines or items)

5-Item description

6-Item Unit Price

7-Vendor reference number

8-Project number

9-Status

Thanks in advance