Return tax information after creating invoice
Posted on 2014-03-05
I am working on creating a program in VB.NET that connects to QuickBooks. The program will track client's annual maintenance fees (AMF). Currently, we create an estimate in QuickBooks for the AMF to send to clients, but the boss does not want QuickBooks to be cluttered with unpaid estimates, so moving forward, my program will store the estimates in a SQL Server DB and then push the estimate to QuickBooks as an invoice when the estimate gets paid. All of this I can do, however where I am having a challenge, is in calculating taxes. My boss want QuickBooks to calculate the taxes and then I am to store that information with the stored estimate. His argument is that he does not want the invoice ultimately created in QuickBooks to be out by a penny or two from the estimate that we sent the client.
What I am supposed to do, is create the invoice information in my program, push the data to QuickBooks, and read back the tax information, and then delete the invoice from QuickBooks. This all works, except where I have more than one tax applied to the invoice. I am in Canada, and in my province (British Columiba) we have two sales taxes. One from the Federal government (GST), and one from the Provincial government (PST). I can read back from QuickBooks the total tax percentage, and total tax invoiced, but I am having difficulty figuring out how to read back the individual taxes. I need to know the 5% GST and the 7% PST separately, but all I can find is 12% overall tax.
Does anyone know how to read the list of taxes applied, rather than the overall total of taxes applied?
PS - I hope I made sense...