[QODBC-Desktop] How to Create an Inventory Adjustment using QODBC
Posted by Wilson (QODBC Support) on 07 February 2012 05:58 AM
Manually modify your Item Inventory quantity
How to Create an Inventory Adjustment using QODBC
Although QuickBooks automatically adjusts your inventory quantities after every purchase and sale, sometimes you still need to adjust them yourself from time to time. QuickBooks allows QODBC to access item inventory adjustment records by modifying table InventoryAdjustmentLine. This article will show you how to create an Inventory Adjustment record using QODBC.
There are two fields InventoryAdjustmentLineQuantityAdjustmentQuantityDifference and InventoryAdjustmentLineQuantityAdjustmentNewQuantity in the table "InventoryAdjustmentLine". Both of them can be used to insert records.
Use Field InventoryAdjustmentLineQuantityAdjustmentQuantityDifference
Here is the sample statement:
INSERT INTO InventoryAdjustmentLine (AccountRefListID, InventorySiteRefListID,InventoryAdjustmentLineItemRefListID,InventoryAdjustmentLineQuantityAdjustmentQuantityDifference)
The value in this field stands for the adjust quantity. For example, if you need to reduce 100 units of this inventory, value this field -100.
Here is the result in QODBC Test Tool.
Note: QODBC Support Wizard is used to test QODBC SQL queries only and is not a development tool.
And this is the result in QuickBooks:
Use Field InventoryAdjustmentLineQuantityAdjustmentNewQuantity
We can also use field InventoryAdjustmentLineQuantityAdjustmentNewQuantity to do the same job. Here is the sample code:
INSERT INTO InventoryAdjustmentLine (AccountRefListID, InventorySiteRefListID,InventoryAdjustmentLineItemRefListID, InventoryAdjustmentLineQuantityAdjustmentNewQuantity )
Value "6600" in the field stands for the quantity after adjustment, that's the only difference.
Here is the result in QODBC Test Tool:
Here is the result in QuickBooks:
You can ignore the field "InventorySiteRefListID" in case you have not turned ON the multiple inventory sites feature in QuickBooks.