Knowledgebase: TroubleShooting
[QODBC-Desktop] Troubleshooting - How to adjust value of a stock item without adjusting stock quantity
Posted by Jack - QODBC Support on 02 March 2015 12:07 PM

Troubleshooting - How to adjust value of a stock item without adjusting stock quantity

Problem Description:

Can I adjust the value of a stock item without adjusting the stock quantity?

Solutions:

Yes, you can adjust the value of a stock item without adjusting the stock quantity. Here is an example:

This item has a COGS Average Cost of $69.73429:

 
http://support.flexquarters.com/esupport/newimages/StockQuantity/step1.png

Using QODBC, I adjusted the opening balance equity cost of the stock item by $250.00 using the following SQL insert statement:

INSERT INTO "InventoryAdjustmentLine" ("AccountRefFullName", "TxnDate", "RefNumber", "Memo", "InventoryAdjustmentLineItemRefFullName", "InventoryAdjustmentLineValueAdjustmentNewValue", "FQSaveToCache") VALUES ('Opening Bal Equity', {d'2007-05-23'}, '110', 'Value Adj 250', 'Wood Door:Exterior', 250.0, 0) 

 

http://support.flexquarters.com/esupport/newimages/StockQuantity/step2.png

 

This item now has a COGS Average Cost of $106.69857:

 

http://support.flexquarters.com/esupport/newimages/StockQuantity/step3.png

The value adjustment details can be seen in the Inventory Valuation Detail: 

 

http://support.flexquarters.com/esupport/newimages/StockQuantity/step4.png

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).