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
|
|
InvoiceLineRate and Tax |
Author |
Message |
mark |
|
Group | : Members |
Posts | : 9 |
Joined | : 2006-05-08 |
|
Profile |
|
Posted : 2006-05-10 06:04:22 |
I have an interesting problem and I'm not sure if its a QODBC issue or a querk in QB(one of many), I use the following InvoiceLine INSERT.
INSERT INTO "InvoiceLine" ("InvoiceLineItemRefListID","InvoiceLineDesc","InvoiceLineQuantity","InvoiceLineRate","InvoiceLineAmount","FQSaveToCache") VALUES ('1010000-1140755147', 'Backhoe Gang',3.00000,65.00000,207.19,1)
the insert (and following Invoice insert) work fine.. however when I view the Invoice in QB, its applied the line item sales tax to the Rate? but if the Invoice is created manually (thru QB) the item sales tax is not applied to the rate but sub-totaled at the bottom like normal.
What am I doing to make QB apply the ItemLineSalesTax to the Items Rate?
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-05-10 10:04:05 |
Curious, I've tried creating a invoice without a InvoiceLineSalesTaxCodeRefListID with the Sample Rock Castle Constructtion company file and it didn't do your querk:
INSERT INTO "InvoiceLine" ("CustomerRefListID", "RefNumber", "InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate", "InvoiceLineAmount", "FQSaveToCache") VALUES ('470001-1071525403', 'QODBCsales1', '250000-933272656', 'Council Rebate', 50.00000, 50.00, 0)
so it must be a Sales Tax setting in your QuickBooks company file. I suggest you use a InvoiceLineSalesTaxCodeRefListID as per: How do I create Invoices? to specify what Tax actually applies to the transaction. |
|
|
|
|