[QODBC-Desktop] How to run an Open Purchase Orders by Job Report in QODBC
Posted by brad waddell on 12 March 2009 05:21 PM
Can you please tell me which tables and fields link the purchase order payments to purchase orders?
I can't seem to track that. Basically, I need to see how much has been paid against a purchase order and that the outstanding balance is.
You can refer to the below sp_report or can query the PurchaseOrderLine table as described below & can get the required details.
Typical Open Purchase Orders by Job Report in QuickBooks
Report Displayed in QODBC
Stored Procedure Command
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,
Display in QODBC
Access the Same Data from PurchaseOrderLine Table
SELECT PurchaseOrderLineCustomerRefFullName as Type, TxnDate as Date, DueDate as "Deliv Date",