|
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
|
|
| writing to QB Premier 2007 |
| Author |
Message |
|
|
| Posted : 2008-03-24 10:58:42 |
I would like to be able to change the Price and Cost fields in all Items including Assembly. Can I do this with Alpha 5? Or, can this be done?
|
|
| |
Win XP Pro
Quickbooks 2007 Preimer
Alpha 5 ver 8 Enterprise
ODBC Ver 8
|
| | Top | |
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-03-26 12:57:58 |
The Item table is a read only table view of the ItemInventory, ItemNonInventory, ItemOtherCharge, ItemInventoryAssembly, ItemService, ItemFixedAsset, and ItemGroup tables. Your update statement needs to run against the actual table with the item in it.
If these are stock parts, see: How do I do Inventory Adjustments? for COGS adjustments. As far as the sales price and purchase price are concerned, the update statement is:
UPDATE ItemInventory set SalesPrice = 1200.00, PurchaseCost = 700 where Name = 'Acer Notebook'
|
|
|
|
|
|
| Posted : 2008-03-27 08:03:58 |
If I understand your reply, I don't want to change the COGS, I want to change the selling price and the cost field.
I want to be able to edit my prices in Alpha 5 and then write them to Quickbooks with one operation, not to have to edit them one at a time, if this is possible.
In Quickbooks, I can import selling prices by way of an Excel file on everything except an Assembly. Can an Assembly have the selling price imported through Alpha 5?
Thank you,
DAvid |
|
| |
Win XP Pro
Quickbooks 2007 Preimer
Alpha 5 ver 8 Enterprise
ODBC Ver 8
|
| | Top | |
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-03-27 08:28:45 |
Yes, the same UPDATE statement also applies to the ItemInventoryAssembly table:
UPDATE ItemInventoryAssembly set SalesPrice = 2000.00, PurchaseCost = 1100.00 where Name = 'Interior Door kit' |
|
|
|
|