A typical Open Purchase Orders by Job Report in QuickBooks looks like this:
With QODBC the same report can be generated using stored procedure reports like this:
sp_report OpenPOsByJob show Text as Type, Blank as Total, Date, DeliveryDate as "Deliv Date", RefNumber as Num, SourceName, Item, Quantity as Qty, ReceivedQuantity as Rcvd, UnitPrice as "Cost Price", Amount parameters DateMacro = 'All'
We 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
|