Troubleshooting - SP_Report Changing Days Per aging using QODBC
Problem Description:
I recently discovered QODBC and have been playing with it for a few days. It's pretty good.
The problem I have is when I try to get 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 shows 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 use the QuickBooks UI.
|