Knowledgebase
[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 like this:

(174 vote(s))
Helpful
Not helpful

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