|
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
|
|
| Error 3262 |
| Author |
Message |
| Jo |
| |
| Group | : Members |
| Posts | : 12 |
| Joined | : 2008-03-21 |
|
| Profile |
|
| Posted : 2008-11-02 18:13:42 |
|
3262
|
Requires payroll subscription |
In order to complete this request, the company data file has to be subscribed to the Intuit Payroll Service. |
I managed to get pass last issue about permission to have access. Now I get the above issue when I run the following through ACCESS
sp_report CustomTxnDetail show *
parameters DateMacro = 'ThisMonthToDate', SummarizeRowsBy = 'TotalOnly'
Very Confused we do not use payroll at all????
Any ideas
|
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-11-03 22:35:52 |
Do:
sp_report CustomTxnDetail
parameters DateMacro = 'ThisMonthToDate', SummarizeRowsBy = 'TotalOnly'
instead. |
|
|
|
| Jo |
| |
| Group | : Members |
| Posts | : 12 |
| Joined | : 2008-03-21 |
|
| Profile |
|
| Posted : 2008-11-04 09:28:52 |
| Thanks Tom,
I have tried 'ThisMonthToDate' which worked
I then tried the following:
sp_report CustomTxnDetail show Class,TxnType,Date,SalesRep,Account,RefNumber,Name,Item,Memo,Quantity,Amount
parameters Date='ThisFiscalYear', SummarizeRowsBy = 'TotalOnly'
and I get a error message reading:
ODBC--call failed.
[QODBC] Expected lexical element not found: Date (#11015).
Could you help me.
In a idea world I would like pull through to Fiscal Years for comparisons - can I do this - without it choking up? |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-11-05 10:23:45 |
All the predefined DateMacro options available to you are:
|All|Today|ThisWeek|ThisWeekToDate|ThisMonth|ThisMonthToDate|ThisQuarter|ThisQuarterToDate
|ThisYear|ThisYearToDate|Yesterday|LastWeek|LastWeekToDate|LastMonth|LastMonthToDate|LastQuarter
|LastQuarterToDate|LastYear|LastYearToDate|NextWeek|NextFourWeeks|NextMonth|NextQuarter|NextYear|
Or you can specify a start and end date like this instead:
sp_report CustomTxnDetail
parameters DateFrom = {d'2007-07-01'}, DateTo = {d'2008-06-30'}, SummarizeRowsBy = 'TotalOnly' |
|
|
|
|