Knowledgebase: TroubleShooting
[QODBC-Desktop] Troubleshooting - SP_Report Changing Days Per aging using QODBC
Posted by Jack - QODBC Support on 13 July 2016 02:26 PM

Troubleshooting - SP_Report Changing Days Per aging using QODBC

Problem Description:

I recently discovered QODBC and have been playing around with it for a few days now. It's pretty good.

The problem I have is when I try to get an A/P aging. The A/P aging has a default of 30 - 90 days. I need the report to show 180 -720 days. I use the example A/P aging report...

sp_report APAgingDetail show TxnType_Title, Date_Title, RefNumber_Title, Name_Title, DueDate_Title, Aging_Title, OpenBalance_Title, Text, Blank, TxnType, Date, RefNumber, Name, DueDate, Aging, OpenBalance parameters DateMacro = Today, AgingAsOf = 'Today'

...but this does not let me change the SQL statement as it is accessing a stored procedure report. The report runs fine; it's just the days that are wrong. Can anyone tell me how I can change the days per aging?
 

Solution:

AgingAsOf can be either ReportEndDate or Today depending on how you want to use your system date or QuickBooks date.

When using:

sp_report APAgingDetail show Text, Blank, TxnType, Date, RefNumber, Name, DueDate, Aging, OpenBalance parameters DateMacro = 'All', AgingAsOf = 'Today'

You can't change the Interval (days) and Through (days past due) like you can using the QuickBooks UI.



(1 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).