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 : Amounts Include Tax in invoice not workingSearch Forum

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

 New Topic 
 
 Post Reply 
[1]  
 Amounts Include Tax in invoice not working 
 Author   Message 
  kka 
  
 Group: Members 
 Posts: 5 
 Joined: 2008-09-01 
 Profile
 Posted : 2009-01-16 18:15:30
Hi,
I still have the same problem of updating the tag <IsTaxIncluded>1</IsTaxIncluded> into the invoice table. Last time i was using QODBC v8 then Tom said that have to wait till v9 release. Now i try again still have to same problem. Can anyone please help  me to solve this problem.
I am using QODBC v9.0.0.253, QuickBooks Enterprise Solutions 2008-09 Australia version.
Thanks 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2009-01-17 09:52:15

GST is calculated automatically by QuickBooks by using a InvoiceLineTaxCodeRefListID in the InvoiceLine insert.

See the tutorial in: How can I create multiple lines in the Invoice, Purchase, Journal and other tables? 

 

  Top 
  kka 
  
 Group: Members 
 Posts: 5 
 Joined: 2008-09-01 
 Profile
 Posted : 2009-01-19 11:49:51
Hi Tom,
Thanks for you reply. I know GST is calculated automatically. What i need to do is tick the check box for "Amounts Include Tax". I always have the problem of a few cents difference for the QuickBooks invoice total VS my application invoice total. This is because of the rounding for GST when it calculated automatically in QuickBooks.
Do you have any solution for this? Please advise. Thanks 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2009-01-19 15:21:06
The best method is to charge the GST amount how QuickBooks would have charged it in the first place. Failing that, I would do all the invoice lines using the appropriate InvoiceLineTaxCodeRefListID and then just do a rounding line to correct the difference between gross/11 and the amount of GST you charged.  

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to