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
|
|
SalesTaxCode bug? in 08/09 beta |
Author |
Message |
|
Posted : 2008-09-20 09:30:38 |
Records from SalesTaxCode (or its synonym TaxCode) can be associated with an InventoryItem via either PurchaseTaxCodeRefListId and/or SalesTaxCodeRefListId, depending on whether the SalesTaxCode record has its ItemPurchaseTaxRefListId and/or ItemSalesTaxRefListId fields set.
Note that these fields must be set to reference a record from what I assume to be predefined sets of "sales" or "purchase" specific SalesTaxCode records.
Select * from SalesTaxCode
however returns only null for these fields. Meaning that an application can not determine which SalesTaxCode records can be associated with ItemInventory::PurchaseTaxCodeRefListId and which can be associated with ItemInventory::SalesTaxCodeRefListId
Is this a bug or am I missing something?
cheers
Mike |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-09-22 09:21:29 |
The SalesTaxCode table should only be used to select whether GST or no GST taxcode applies to a invoice or bill line. |
|
|
|
|
Posted : 2008-09-23 08:35:44 |
hmmm ... I'm looking at the supplied sample company for the Australian QBi 08/09 Manufacturing Premier. For "Purchase Tax Code" and for "Tax Code" in the Inventory Item screen, there are multiple choices that can be selected from the SalesTaxCode table
not just GST or ~GST.
Also you can create new SalesTaxCode records and specify whether they are applicable to selling or purchasing or both.
But only a subset of SalesTaxCode records are applicable to "Purchase Tax Code" and only a subset are applicable to "Tax Code"
There seems to be no way through qodbc to handle this |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-09-23 10:13:27 |
I think you are getting mixed up with the ITEMSALESTAXCODE used in the USA version of QuickBooks where each customer has a different SalesTax depending on their location. The Australian version of QuickBooks 2008/09 is based upon the USA version of QuickBooks 2007. The Australian version of QuickBooks 2004, 2005/06, 2007/08 all just used the TAXCODE in each transaction line to deterimne the tax to be applied.
See the Sample Tutorial in : How can I create multiple lines in the Invoice, Purchase, Journal and other tables? for an example. |
|
|
|
|
Posted : 2008-09-23 11:21:54 |
I'm sorry Tom, I should have made it clearer and mentioned not just in the title that this is with your recently released 08/09 beta driver for QBi 08/09.
I'm definitely using your beta driver installed for Australia, and the Au version of Quickbooks. I agree that this issue did not arise for the 07/08 versions.
|
|
|
|
|