volumax Posted August 15, 2005 Share Posted August 15, 2005 Hi Gazzzzzza, Unfortunately there is a lot of difference between Quick Books US and UK versions, as I have found out, the main differences are in the way the data structure for the databases are setup, the main problems being the datalayout for tax in the US and VAT in the UK, in the US different States have different tax rates, it could be 7% in one but only 5% in another, in UK as you pointed out we only have 1 @ 17.5%, found this snippet while searching for answers. First US version of salesreceiptline data structure, dealing with tax ItemSalesTaxRefListID Varchar 36 True False True No String Yes ItemSalesTaxRefFullName Varchar 31 True False True No String SalesTaxPercentage Decimal 13 True False False N/A %7.5f SalesTaxTotal Decimal 11 True False False N/A %8.2f TotalAmount Decimal 11 True False False N/A %8.2f Now the UK, I belive the equivilent is this Tax1Total Decimal 11 True False True No %8.2f Tax2Total Decimal 11 True False True No %8.2f ExchangeRate Decimal 13 True False True No %6.6f AmountIncludesVAT Bit 5 True False True No |1|0|true|false| From Adams posts his next release should contain UK/European compatability, I have talked with several people from UK about the availability of SDK for UK version of Quickbooks, but it look as though Intuit are NOT going to release one, as program support for the the iif format is getting less, it looks like QBXML will take over, but again here in the UK we'll be the last to get an SDK if at all. It may sound a bit downer :D but that happens when you've been waiting over a year for Intuit UK to release an SDK, US has release i think 3 versions of the US SDK in that time, in the end I suppose its all down to money, and whether they deam it profitable to release one in the UK. So I'm just waiting for the next release of Adams contrib, that should have the long awaited UK support. All the best Andy :thumbsup: ------------------------ Cheers for the reply djs I began working with Quickbooks Pro 2001 :D But now I am working with QuickBooks Pro Edition 2004. I am based in England so it may be a slightly different version but I cannot imagine they would differ that much??! Do you guys have knowledge of that? Quote Literally, Laterally Thinking! If you cannot get through it, go round it. Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.