Skip to Content
0
Former Member
Nov 06, 2012 at 03:20 AM

Invoicing Dumping report

28 Views

Hi

Query below 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

Select p0.CardCode as Supplier_code,p0.CardName as Supplier_Name,

p0.DocNum as InvNo,p0.DocDate as Posting_date,p1.ItemCode,p1.Dscription as ItemName

,p1.Price,p0.NumAtCard as Vendor_Ref_No,p0.DocStatus as Status,p1.Project

from opch p0

inner join pch1 p1 on p0.DocEntry=p1.DocEntry

order by p0.DocNum,p1.ItemCode

What do i need to add to it so it also shows the quantity bought and the total price per line for each item ?

Thanks for your help