Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

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

Forum : UK SalesReceiptLine AmountIncludesVAT problemSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v6 Forum

 New Topic 
 
 Post Reply 
[1]  
 UK SalesReceiptLine AmountIncludesVAT problem 
 Author   Message 
  aaron wardle 
  
 Group: Members 
 Posts: 3 
 Joined: 2006-11-01 
 Profile
 Posted : 2006-11-01 08:51:31
Hi,

I've been testing this out and it looks great, I've managed to get it to insert sales receipts into quickbooks but it is adding VAT to the amount but it already has vat inncludedin the price.

I'm using QODBC Version 7 and Quickbooks pro 2006

My SQL Query is below:

INSERT into SalesReceiptLine (CustomerRefListID, AmountIncludesVAT, CustomerRefFullName, TemplateRefListID, TxnDate, BillAddressAddr1, BillAddressAddr2, BillAddressAddr3, BillAddressPostalCode, PaymentMethodRefListID, SalesReceiptLineItemRefListID, SalesReceiptLineDesc, IsToBePrinted,SalesReceiptLineAmount) values ('30000-1128850380',1,'eBay Customer', '80000-1128850609',{d'2006-10-31'},'Joe Blogs','12 Anyroad Road','My Town','XYZ 4TU','A0000-1128854793','50000-1128854530','My Product CD-ROM',1,9.99)

Any help on this would be much appreciated.

Thanks
Aaron 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-11-01 09:13:20
We normally post the price of the goods without tax and use a taxcode to get QuickBooks to work out the tax. Try looking at the non-USA QuickBooks Users example in: How do I create a Sales Receipt using QODBC?  

  Top 
  aaron wardle 
  
 Group: Members 
 Posts: 3 
 Joined: 2006-11-01 
 Profile
 Posted : 2006-11-01 09:24:05
Thanks for the quickreply, I still cant seem to get it to work, we are looking at creating some VBA code for outlook so it processes our paypal payment receipts into quickbooks as our products are sold on ebay with the tax included we would prefer to be able to insert all sales as amountincludesvat.

The examples seem to show amounts being added with no tax codes, if it amounts cant be added including tax i guess i could get the VBA code to remove the tax amount from the price and add in the amount without tax so quickbooks adds it back in.

Thanks 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-11-01 09:44:39
The "SalesReceiptLineTaxCodeRefListID" does a TaxCode lookup to what the tax percentage is in the TaxCode table and QuickBooks calculates the tax. So, yes, you should insert the before tax price amount. 

  Top 
  aaron wardle 
  
 Group: Members 
 Posts: 3 
 Joined: 2006-11-01 
 Profile
 Posted : 2006-11-01 20:42:25

Hi Tom,

Cheers for your help Tom, I'm now coding my app to subtract the vat before inserting it into quickbooks and it works perfectly now..

I'll definitly be buying a license within the next few weeks.

Thanks Aaron

 

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to