We're sorry, but this is a bug within Intuit's QuickBooks qbXML SDK for the UK and Australia.

The sp_report for Open Purchase Orders by Job report :-

sp_report OpenPOsByJob show Amount_Title, Text, Blank, TxnType, Date, DeliveryDate, RefNumber, SourceName, Item, Quantity, ReceivedQuantity, UnitPrice, Amount parameters DateMacro = 'All'

returns nothing other than "National insurance contributions" under the "Amount_title" column. The same sp_report in the USA versions of QuickBooks works correctly.

The Open Purchase Orders sp_report:

sp_report OpenPOs show Amount_Title, Blank, TxnType, Date, Name, RefNumber, DeliveryDate, Amount parameters DateMacro = 'All'

works correctly. So you will need to use it instead. If you know what supplier has jobs, then you can filter out the supplier like this:-

sp_report OpenPOs show Amount_Title, Blank, TxnType, Date, Name, RefNumber, DeliveryDate, Amount parameters DateMacro = 'All' where Name='Remarkable Hotel'

You can also extract the same information from the PurchaseOrderLine table directly like this:

SELECT PurchaseOrderLineCustomerRefFullName as Type, TxnDate as Date,  DueDate as "Deliv Date",
RefNumber as "Num", VendorRefFullName as SourceName,PurchaseOrderLineItemRefFullName as Item,
PurchaseOrderLineQuantity as Qty, PurchaseOrderLineReceivedQuantity as Rcvd,
PurchaseOrderLineRate as Cost, TotalAmount as Amount FROM PurchaseOrderLine where IsFullyReceived = 0
and PurchaseOrderLineCustomerRefFullName is not Null order by PurchaseOrderLineCustomerRefFullName