Query Report - Purchase Orders with additional fields

Query Report - Purchase Orders with additional fields

Hello,

I found this query on the forums:

SELECT po.POCUSTOMID "PO Number",po.PONAME "PO Name",po.TERMS "PO Terms",LONGTODATE(po.DATEORDERED) "Ordered Date",pos.STATUSNAME "PO Status",poa.FIRST_NAME "Purchase Requester",po.SHIPTO "Ship To",paao.NAME "Vendor Name",inde.INVOICEID "Invoice Number", LONGTODATE(inde.DATERECEIVED) "Invoice Date", LONGTODATE(pdet.PAYMENTDATE) "Payment Date", pdet.AMOUNTPAID "Amount Paid",pxt.PRICE "Item Price", po.TOTALPRICE "Total Price",po.SALESTAX "Sales Tax",po.SHIPPINGPRICE "Shipping Price",pxt.QUANTITYORDERED "Quantity of Items",cd.COMPONENTNAME "Item ",cd.PARTNO "Item Part Number",po.remarks "Remarks"  FROM PurchaseOrder po LEFT JOIN POStatus pos ON po.STATUSID=pos.STATUSID LEFT JOIN SDUser por ON po.REQUESTERID=por.USERID LEFT JOIN AaaUser poa ON por.USERID=poa.USER_ID LEFT JOIN VendorDefinition pvd ON po.VENDORID=pvd.VENDORID LEFT JOIN SDOrganization paao ON pvd.VENDORID=paao.ORG_ID LEFT JOIN Purchaseorderext pxt ON po.PURCHASEORDERID=pxt.PURCHASEORDERID  LEFT JOIN PurchaseLot plot On pxt.PURCHASEORDEREXTID=plot.PURCHASEORDEREXTID LEFT JOIN Resources resource ON plot.PURCHASELOTID=resource.PURCHASELOTID LEFT JOIN ComponentDefinition cd ON pxt.COMPONENTID=cd.COMPONENTID LEFT JOIN InvoiceDetails inde ON po.PURCHASEORDERID=inde.PURCHASEORDERID LEFT JOIN ComponentType productType ON cd.COMPONENTTYPEID=productType.COMPONENTTYPEID LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID LEFT JOIN ResourceAssociation rToAsset ON rOwner.RESOURCEOWNERID=rToAsset.RESOURCEOWNERID LEFT JOIN DepartmentDefinition deptDef ON rOwner.DEPTID=deptDef.DEPTID LEFT JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID LEFT JOIN SiteDefinition siteDef ON resLocation.SITEID=siteDef.SITEID LEFT JOIN SDOrganization aaov ON siteDef.SITEID=aaov.ORG_ID LEFT JOIN PaymentDetails pdet ON po.PURCHASEORDERID=pdet.PURCHASEORDERID

It generates a report that details every item on every PO on a seperate line. It's perfect for my requirements, but I also have additional fields in my POs that i would like added on to the report as extra columns. Is this possible please?
The additional fields I would like are called:

Cost Center
ITSPurchasing?
Project
Payment Method
TopDesk ID
Other Payment Method
Report Categories
Next Recurrence

Thanks
Ian
              New to ADManager Plus?

                New to ADSelfService Plus?