sp_report PayrollTransactionsByPayee does not return TxnType = 'Pay Cheque' |
Author |
Message |
|
Posted : 2008-01-09 08:25:17 |
sp_report PayrollTransactionsByPayee show ... parameters ReportDetailLevelFilter = 'All' does not return any rows with TxnType = 'Pay Cheque' QODBC ver 8 and Quick Books Pro 2008 Canadian latest updates as of Jan. 8 2008
Please advise. Thanks, Alex |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-09 09:59:42 |
This seems to work correctly for me:
sp_report PayrollTransactionsByPayee show Text, TxnType, Date, RefNumber, Name, Memo, Account, Amount parameters DateMacro = 'ThisQuarter', IncludeAccounts = 'InUse', ReportDetailLevelFilter = 'All'
|
|
|
|
|
Posted : 2008-01-10 04:54:12 |
I tried it (just removed some fields to reduce image size) and it returned 33 rows only, no 'Pay Cheques' or 'Paychecks' at all, and we have 108 cheques on Jan 11. See picture below:
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-10 15:35:37 |
Please add the DisplayReport= 'Yes' switch and rerun the query. This will force the report to be shown in your copy of QuickBooks (most likely twice) as well as in VB Demo:
sp_report PayrollTransactionsByPayee show Text, TxnType, Date, RefNumber, Name, Account, Amount parameters DateMacro = 'ThisQuarter', IncludeAccounts = 'InUse', ReportDetailLevelFilter = 'All', DisplayReport= 'Yes'
and let me know whether any pay cheques are displayed with the report displayed within QuickBooks. Do this for both your company file and one of the QuickBooks sample company files as I will need to know whether it's just your company file or all company files.
Please also confirm the exact version and revision of QuickBooks you are now running (do Ctrl 1 while running QuickBooks to see the details) and what you were running before you upgraded QuickBooks. |
|
|
|
|
Posted : 2008-01-15 12:18:02 |
Operating system : WinXP Pro SP2 Before upgrade version: QuickBooks Pro 2007 Release R4P After upgrade version: QuickBooks Pro Release R2P (no year specified), DBengine version 9.0.2.3267, Product number: 978-236 I copied the query from your replay and run it against the company file and the sample file with the same result: no pay cheques, neither in VB Demo, nor in QuickBooks report ! I checked the FILTER in quickBooks and what sticks out is TRANSACTION TYPE = MULTIPLE TRANSACTION TYPES. (If this filter is removed in QuickBooks and set to 'Pay Cheque', then you get the cheques. Unfortunately this is not the case from the VB Demo side....) Below is a picture of the report with the Sample database. The company database is similar. Please advise Thanks a lot, Alex
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-15 14:27:06 |
I would say this is a QuickBooks bug. In the USA version of QuickBooks the report uses a Multiple Transaction Types filter that uses "Paycheck":
While in non-USA versions of QuickBooks the report uses a Selected Transaction Types filter that uses "Pay Cheque":
What is the normal filter for the report when you use QuickBooks 2008 Pro Canadian Edition? |
|
|
|
|
Posted : 2008-01-16 10:20:10 |
Quickbooks is setting TransactionType = 'Multiple Transaction Types'; what I do in Quickbooks is remove the TransactionType filter and pick 'Pay Cheque' from the dropdown box. No multiple types, just 'Pay Cheque' and that gives me the wanted report, see below:
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-16 10:44:41 |
This is an incompatibility between Intuit's qbXML SDK 6.0 now in the new QuickBooks 2008 Canadian Edition and SDK 3.0CA that's part of the Canadian version of QuickBooks 2004, 2005, 2006 and 2007.
I've reported this issue to the QODBC Software Engineer under QSupport Ticket ID: BR00000077 for further investigation. There is no time frame set for when I will receive a reply.
To speed things up, could you please post a screen dump of your supported versions when using the new QuickBooks 2008 Canadian edtion?
SELECT * FROM HostSupportedVersions
|
|
|
|
|
Posted : 2008-01-17 07:10:24 |
Thanks for your help. It is very appreciated. Here is the info you requested:
|
|
|
|
|
Posted : 2008-02-05 18:06:36 |
Is there any progress with this issue (BR00000077) ? Thanks, Alex |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-02-05 22:33:21 |
|
|
|
|
Posted : 2008-03-15 06:49:43 |
Hi Tom,
Re Is there any progress with this issue (BR00000077) ?
It's been 2 month and the customer gets really frustrated that he has to call every 2 weeks for me to manually do his bank transfer files for the payroll (never mind that I might not be available). They would probably be ok if it would be a date for the solution in sight, they are not satisfied with my answers of "not yet, I call you when it's fixed"...
Any other news ?
Thanks a lot as always. Alex |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-03-15 08:31:40 |
QODBC users should note that there are currently several known issues with using Intuit's qbXML SDK v6 with QuickBooks 2008 Canadian Edition.
Here's Intuit's reply to our bug posting regarding: No Data is Returned from Estimate table . Along with a list of other things that are broken:
Yes, this is a known issue. This bug (QBCA001426) is in the list of QB_CA_2008 issues (see below) we recently escalated to QB_CA engineering team. They are actively working on fixing them. We don't have an ETA as of yet but the release of these fixes are likely in a patch release of QB.
Thanks, - Iqbal
- QBCA001238: CreditCardCreditAdd request in SDK ignores SalesTaxCodeRef
- QBCA001280: ItemReceiptAdd message in SDK does not set sales tax code
- QBCA001356: Sales tax items cannot be added using SDK
- QBCA001384: SDK issue with PayrollWageItemQuery crashes
- QBCA001404: BirthDate is not returned for EmployeeQuery. Both BirthDate and SIN is not showing in QBUI.
- QBCA001410: Error storing field when doing EmployeeAddRq
- QBCA001412: GeneralDetailReportQuery does not return SubtotalRow where applicable
- QBCA001420: billpaymentcheckquery
- QBCA001426: EstimateQuery does not work
- QBCA001429: InventoryAdjustmentQuery does not work as expected
- QBCA001430: ItemReceiptQuery does not work as expected
- QBCA001431: BuildAssemblyQuery is not working as expected
- QBCA001432: CustomDetailReportQuery ignores ReportTxnTypeFilter
- QBCA001435: chargequery
- QBCA001436: purchaseorderquery
- QBCA001437: salesorderquery
- QBCA001438: billpaymentcreditcardquery
As far as the problem is concerned, try something like this instead:
SELECT * FROM Transaction, Employee where Transaction.EntityRefListID=Employee.ListID and Transaction.TxnType='Paycheck' and (Transaction.TxnDate >= {d'2008-01-01'} and Transaction.TxnDate < {d'2008-04-01'})
or with and Transaction.TxnType='Pay Cheque' .... don't know which way they will appear in the new QuickBooks 2008 Canadian Edition.
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-10-06 16:49:57 |
|
|
|