Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
sp_report ARAgingSummary not returning correct values |
Author |
Message |
|
Posted : 2007-02-08 03:44:36 |
When I run this query:
sp_report ARAgingSummary show Current_Title, Amount_Title, Text, Label, Current, Amount parameters DateMacro = 'Today', AgingAsOf = 'Today'
And I compare it against QuickBooks 2007 pro A/R Aging summary report I am getting different values in the Amount_4 and Amount_5 fields.
Additional info: I am running QODBC 7 |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-02-08 09:39:08 |
It's easy to get confused here, in QODBC Today often means your system date, while in QuickBooks Today means the QuickBooks date. So when looking at the QuickBooks sample files, or company files that use a QuickBooks date and not the system date, or report dates other than the system date, you often need to use ReportEndDate
For example this Sample Rock Castle Construction report:
needs to be run with AgingAsOf = 'ReportEndDate' to match the future aging date of December 17, 2007:
sp_report ARAgingSummary show Text, Label, Current, Amount_1 as "1 - 30", Amount_2 as "31 - 60", Amount_3 as "61 - 90", Amount_4 as "> 90", Amount_5 as TOTAL parameters DateMacro = 'Today', AgingAsOf = 'ReportEndDate'
|
|
|
|
|
Posted : 2007-02-09 01:38:09 |
Thanks, that was the issue. |
|
|
|
|