|
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
|
|
| New to Quick Books and QODBC and need a little help with a Quick Start Query |
| Author |
Message |
|
|
| Posted : 2008-09-24 07:24:23 |
I have lots of Development and programming experience, but none with QB and QODBC. I am working on an application where I need the Qty on Hand, Last Cost, and Selling Price of an inventory item. I have the key value or Part Number. I can't quite see from the Schema if there is a table that would contain all of this information and how it should be called. Table Name, Columns etc.
If I could get a start in the right direction then I can get this piece done quickly and will have time to work through the rest of the application later.
Thanks |
|
| |
Bill Fox
Workflo Systems
|
| | Top | |
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-09-24 08:17:42 |
|
|
|
|
|
| Posted : 2008-09-25 01:24:20 |
| That is looking at the customers and Invoices. I want to find the Quantity on hand, Selling Price and Last Cost of an Inventory item given a Part Number. This query has nothing to do with Customers or Customer Invoices. |
|
| |
Bill Fox
Workflo Systems
|
| | Top | |
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-09-25 07:56:39 |
Try:
SELECT Fullname, Name, SalesDesc, PurchaseCost, AverageCost, SalesPrice, ReorderPoint,
QuantityOnHand, QuantityOnOrder, QuantityOnSalesOrder
FROM ItemInventory UNOPTIMIZED
WHERE Fullname = 'Hardware:Brass hinges'
just change the Fullname value to the part you're interested in. |
|
|
|
|
|
| Posted : 2008-09-25 08:51:05 |
Thanks
That will come pretty close to what I need.
|
|
| |
Bill Fox
Workflo Systems
|
| | Top | |
|
|
|