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
|
|
CreditCardChargeExpenseLine VAT |
Author |
Message |
dch |
|
Group | : Members |
Posts | : 3 |
Joined | : 2006-10-23 |
|
Profile |
|
Posted : 2006-10-24 03:15:37 |
Hi,
We have QB Pro 2005 (UK) with QODBC v7 - and am trying to programtically add a number of credit card charges - the problem is there is nowhere to enter the VAT details, we need to enter a load that where from before we were VAT registered but all of these default to standard VAT rate and are adding VAT because we cannot say which VAT Code should be used (although you can do this directly in Quickbooks)
Is there are way around this? Eg I would expect the CreditCardChargeExpenseLine table to have a field called ExpenseLineTaxCodeRefListID
Can anybody help or offer some advice here?
Thanks |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-10-24 14:33:55 |
That would be nice, but between what happens to Intuit's qbXML SDK in Canada, then in the UK and finally in Australia with how Tax is handled for Purchases, the CreditCardChargeExpenseLine table has no ExpenseLineTaxCodeRefListID and only allows you to enter a VAT (or GST) value in Tax1Total.
The problem is that in USA there's no inward tax tracking like GST and VAT systems that's programmed into the SDK, so the other regions have had to workaround everything. You can try creating a BillExpenseLine and then paying the bill with a credit card payment instead. |
|
|
|
dch |
|
Group | : Members |
Posts | : 3 |
Joined | : 2006-10-23 |
|
Profile |
|
Posted : 2006-10-24 17:14:41 |
Thanks Tom,
I do find it very strange that is is missing from just this table though - it is availble on CheckExpenseLine table.
It is also possible to make this work by creating an IIF import file - as I understand it Intuit want to phase out IIF in favour of their XML API - but if it is missing functionality - anyway, I realise this is not your problem :-) I was just hoping I had missed something, for now we are importing everything with IIF files instead.
Cheers |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-10-24 22:19:57 |
What you are saying is valid, I've reported to the QODBC Software Engineer under Ticket ID: BR00000025 that the TaxCodeRefListID and TaxCodeRefFullName columns are missing in the CreditCardChargeExpenseLine, CreditCardChargeItemLine, CreditCardCreditExpenseLine and CreditCardCreditItemLine table for all non-USA versions of QuickBooks.
The CheckExpenseLine, CheckItemLine tables have them, and so should these tables. I will update this post when I get a response. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-10-06 17:04:19 |
|
|
|
|