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