Troubleshooting - SP_Report Changing Days Per aging using QODBC
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?
AgingAsOf can be either ReportEndDate or Today depending on how you want to use your system date or QuickBooks date.
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.