|
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
|
|
| Where can I find Stock Item Asset Value field |
| Author |
Message |
|
|
| Posted : 2007-08-03 20:50:24 |
In the QB Stock Valuation Summary report there is a column Asset Value field. This value can be non-zero even if there are zero items on hand and hence must not be derived from the unit cost multiplied by the quantity on hand. Furthermore it appears that the total inventory as shown in the company balance sheet matches this report's total for the Asset Value column. I would like to read this value from QOBDC, where can I find it? The ItemInventory table TotalValue field appears blank when I check it in VBDemo.
Many thanks,
Vincent |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-08-03 22:27:14 |
|
|
|
|
|
| Posted : 2007-08-06 04:53:18 |
Thank you Tom
I will try what you suggest but it does seem a rather sledge hammer to break a nut approach to getting just one field? Is the total asset value not recorded directly in the QB database in one of the Itemxxx tables? If not, just out of curiosity, would you know how QB derives the value for printing it in the report? Also what is the TotalValue field in the ItemInventory table?
Many thanks
Vincent |
|
|
|
|
|
| Posted : 2007-08-06 05:38:03 |
Hi Again Tom
I just tried How do I use the QuickBooks Reporting Engine with QODBC? I've heard something about sp_report ? but it takes a very long time to run. I use this report exported to a csv file in an excel file and the process is cumbersome but takes 10s to get the data up to date in excel, whereas if I run the report through sp_report it had not completed after even 5 minutes but MS Query did show the report data for the items . I do have about 1200 active parts set up in QB and we have not closed off any transactions for the preceding 12 months. (We will do so shortly after finalizing the financial year and will then move to closing off at end of every month.)
Will closing off speed things up or is there anything else we can do?
Cheers
Vincent |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-08-06 08:35:55 |
This forum is for QODBC, QuickBooks questions should be directed to QuickBooks Support. In the topic: How do I do Inventory Adjustments? I show how the Asset Value is determined in QuickBooks. Basically its from the AverageCost shown in the ItemInventory table.
It might be more useful to clearly state what you actual need here? |
|
|
|
|