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
|
|
Update The Item Inventory |
Author |
Message |
|
Posted : 2006-10-26 19:54:57 |
Hi,
I am updating items in the ItemInventory and ItemNonInventory tables via QODBC. When I change the field SalesPrice as defined in the Data Layout for QuickBooks, not all of the pricing information is changed.
Please advise the field name where I can change the Gross Price. I notice that in QuickBooks when you untick the Item Includes VAT check box, the updated price is displayed, however, as soon as you tick it, the old price is displayed.
I need a way to update both the Gross and Net prices.
I am using QuickBooks Pro 2004 UK Edition.
Thanks
Andrew |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-10-27 09:52:57 |
I just ran:
UPDATE ItemInventory set SalesPrice = 175.00 where Name='Ladder'
with my Australian version of QuickBooks and the Sales Price updated and it now shows a Gross Price $192 (which includes a 10% GST/VAT of $17.50) on my invoice screens. |
|
|
|
|