| Customer currency problem |
| Author |
Message |
|
|
| Posted : 2009-06-09 00:49:12 |
Viewing the QB Customer table from within Access, it shows three custom fields on QB customers, although I only have two. The first shows with the name CustomFieldOther, the second and third with the names I have given them. If the second or third custom fields have anything in them, that customer's CurrencyRefListID and CurrencyRefFullName show null, if the custom fields are null, the currency fields show ok.
I've tried doing a rebuild in QB, and creating a new link to the customer table, with the same result.
Using QB 2006 UK Accountant and QODBC build 9.0.0.253.
Any ideas? |
|
|
|
|
|
| Posted : 2009-06-09 10:59:12 |
I'm not to sure whether you have tried unlinking and relinking the customer table. I know that MS Access doesn't like table changes. You really need to check the column information using VB Demo and upload some examples (see: How do I upload images to my forum post? ) of the problem.
You might need to uninstall QODBC v9 and go back to QODBC v8 to revert back to the old (pre-SDK 6.1) column mappings.
|
|
|
|
|
|
| Posted : 2009-06-09 19:19:01 |
Thank you for replying so promptly. I tried creating a new link to the customer table, same result.
I haven't changed the custom fields for years, so I didn't think it could be that. I've just tried linking to the customer table in a new blank Access file, same problem, so I don't think it can be a table change issue. Images of the customer table in Access and the custom fields in QB attached.
|
|
|
|
|
|
| Posted : 2009-06-10 14:45:17 |
| Ok, please download the latest version of QODBC v9.00.00.259 (see: How can I get the latest version of QODBC? ) and install it over your current install and then using VB Demo (see: How do I use the VB Demo for testing? ) please run the following two statements:
Select Name, CurrencyRefListID, CurrencyRefFullName from Customer VERIFY
Select Name, CurrencyRefListID, CurrencyRefFullName, CustomFieldCompanyreg, CustomFieldVFBatchNo from Customer
and post the resulting query images back here for the QODBC Software Engineer to see. |
|
|
|
|
|
| Posted : 2009-06-10 19:01:03 |
|
|
|
|
|
| Posted : 2009-06-11 10:53:35 |
| Ok, but I can't see an error to prove it. Please post a QuickBooks screen of one of the common customers showing the currency and custom fields indeed have something in them. |
|
|
|
|
|
| Posted : 2009-06-11 17:56:23 |
All customers have a currency - there's no way to avoid that.
My first attachment shows the QB customer screen for Exe-tc Competition Suspension with sterling currency and 123456 in the company reg custom field. You can see from the VBDemo screenshots that the error is absolutely consistent - if there are custom fields, no currency shows.
I attach a portion of a QB customer list report - you can see that they all have a currency.
|
|
|
|
|
|
| Posted : 2009-06-12 10:03:29 |
| I've emailed the QODBC Software Manager this forum link to review. But I would guess this may well be a Intuit SDK 3.1 bug itself. I will let you know his comments. |
|
|
|
|
|
| Posted : 2009-08-20 09:03:27 |
| I was wondering whether you have any news about this 'hole' in the customer table? |
|
|
|
|
|
| Posted : 2009-08-20 14:34:30 |
| Sorry. the QODBC Software Engineer at FLEXquarters.com Limited no longer responds to my email. You will need to take this up directly with FLEXquarters in USA. |
|
|
|
