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

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.

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

This has been fixed by QODBC v9, see: Release 9.0.0.249 Fixes