[QODBC-Desktop] How to see Pending Uninvoiced Sales in the Sales Order Table using QODBC
Posted by brad waddell on 12 March 2009 05:21 PM

An Example of Seeing Pending Uninvoiced Sales in the Sales Order Table

Query SalesOrder Table

To do this, you can query the SalesOrder table using a where IsFullyInvoiced = False clause like below:

      SELECT TxnNumber, CustomerRefFullName, TxnDate,
      RefNumber, TotalAmount FROM SalesOrder
     where IsFullyInvoiced = FALSE

Compare with Pending Sales Report

      sp_report PendingSales show
      TxnNumber, Name, Date, RefNumber, Amount parameters
      DateMacro = 'All' where RowType='DataRow'

Note: The report result below should match this:

(174 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).