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:
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).
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:
Currently the inventory quantities in the ItemInventory table cannot be updated directly, you must do Inventory Adjustments to change stock levels.
This example creates one inventoryadjustment with three lines. Note the FQSaveToCache field, set to True except on the last one. Note: QuickBooks must be in single user mode for this to work.
As far as jump-ins are concerned, jump-ins are like indexes and are what should be used in your where clauses in your SQL SELECT statements to locate rowsets without QODBC doing a table scan:
JUMPIN FIELDS FOR:
Example: Select * from ItemInventory Where FullName = "Door"
FIELD NAME
JUMPIN TYPE
IsActive
ActiveStatus
FullName
FullName
TimeModified
TimeModifiedOnly
ListID
ListID
To view the jump-ins for any table you can use the stored procedure: