[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 the 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 adjusted quantity. For example, if you need to reduce 100 units of this inventory, value this field to -100.
Here is the result in QODBC Test Tool.
Note: QODBC Support Wizard is used only to test QODBC SQL queries and is not a development tool.
And this is the result in QuickBooks:
Use Field InventoryAdjustmentLineQuantityAdjustmentNewQuantity
We can also use the 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" if you have not turned ON the multiple inventory sites feature in QuickBooks.