Purchase Order Report

Purchase Order Report

Good day,
our company uses service desk plus.  One of my colleagues wants to have a report on purchase orders for the past financial year.  There is a Purchase order report template, but it does not show all required fields.  I do not know the database structure, can someone please assist with the query I should enter to get the following results/fields:
I need the following fields in the report:
PO_Number
Vendor_Name 
Item
ItemPrice
Total_Price
Invoice_Number
Quantity_of_Items
Remarks
Created Date

I did found a query on this forum as follows, BUT the fields returned in for Item Price and Quantity does not correlate when I compare it with the actual Purchase order. 
I'll appreciate it if someone can assist with the correct query?

SELECT             po.POCUSTOMID AS PO_Number,         MAX(pvd.NAME) AS Vendor_Name,             cd.COMPONENTNAME AS Item,           MAX(pxt.PRICE) AS ItemPrice,              MAX(po.TOTALPRICE) AS Total_Price,              MAX(inde.INVOICEID) AS Invoice_Number,          MAX(pxt.QUANTITYORDERED) AS Quantity_of_Items,              MAX(po.REMARKS) AS Remarks, longtodate(po.DATEORDERED) AS "Created Date" 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 PurchaseOrderItem pxt ON po.PURCHASEORDERID  = pxt.PURCHASEORDERitemID  LEFT JOIN PurchaseLot plot ON pxt.PURCHASEORDERID  = plot.PURCHASEORDERitemID  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 (SELECT             Resources.RESOURCEID as RESOURCEID,             SiteDefinition.REGIONID,            Resources.SITEID as SITEID,         Resources.LOCATION as LOCATION FROM  Resources LEFT JOIN SiteDefinition ON SiteDefinition.SITEID  = Resources.SITEID   WHERE  Resources.HELPDESKID  = 1 ) 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   WHERE       po.DATEORDERED  >= 1751328000000 /*-- 2025-07-01*/ /* 2025-07-01*/   AND     po.DATEORDERED  < 1782864000000 /*-- 2026-07-01*/ /* 2026-07-01*/  GROUP BY po.POCUSTOMID,        cd.COMPONENTNAME, po.dateordered  ORDER BY 2