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
|
|
ItemInventory table - Time Modified - Qty on Hand |
Author |
Message |
|
Posted : 2007-06-12 19:32:41 |
Changes on the Qty on hand by "Receive Item, Sales, etc.. " will not change the date and time stamp on the TimeModified Field ?
Thanks. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-06-13 02:40:41 |
Tell me about it, this drives us crazy and is a major flaw in Intuit's qbXML SDK for QuickBooks. You can use the InventoryAdjustmentLine table TimeModified stamp to see stock adjustments. |
|
|
|
|
Posted : 2007-06-14 12:06:34 |
But isn't InventoryAdjustment table used primarily for adjusting entries made to the inventory and not from transactions such as sales, credit memo or returns, bills , etc...?
Any other table aside from ItemInventory to get the Qty on Hand?
Thanks again. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-06-14 14:23:15 |
Yes, but if you're only after the true Qty on Hand at any point of time, without optimizer and timemodified issues, then this:
SELECT QuantityOnHand FROM ItemInventory where FullName='Hardware:Lk Doorknobs'
Can also be extracted directly out of the QuickBooks engine in real time:
sp_report InventoryValuationDetail show QuantityOnHand parameters ItemFilterFullNameWithChildren='Hardware:Lk Doorknobs' where RowType='TotalRow'
|
|
|
|
|
Posted : 2007-06-14 19:36:34 |
Thanks for the suggestion. That's just what i did - get the qty on hand real time, but the problem is I have to retreive all the items and will take quite a while for it to finished.
If only I can make use of the TimeModified field, then my life would have been easier. I designed my system to retrieve only informations that has been changed using the timemodified method. I stored all the tables I needed locally for faster retreival and update the tables only as needed - using the timemodified as basis..
|
|
|
|
|