Inventory Re-Valuation Tests

From Opentaps Wiki

Jump to: navigation, search

Use demo data where DefaultGlAccountType for Company/INVENTORY_ACCOUNT == 140000 and Company/INVENTORY_VAL_ADJ == 515000


Contents

1. Adjust Non-Serialized Downward

Action Go to Financials > Reports > Inventory Valuation Report, run the report and note the result. Go to Financials > Reports > Transaction Summary, run the report and note the results. Go to Financials > Transactions > Adjust Inventory Values. Find some inventory items. Ajust the value of a non-serialized inventory item (which has a value > 0) downward by $2.34

Result Run the inventory valuation report - the result should have increased by 2.34 * the inventory item's QOH. Run the transaction summary - account 140000's credit total should increase by the same amount, and account 515000's debit total should increase by the same amount.

2. Adjust Non-Serialized Upward

Action Ajust the value of a non-serialized inventory item (which has a value > 0) upward by $3.45

Result Run the inventory valuation report - the result should have decreased by 3.45 * the inventory item's QOH. Run the transaction summary - account 140000's debit total should increase by the same amount, and account 515000's credit total should increase by the same amount.

3. Adjust Non-Serialized No Change

Action Ajust the value of a non-serialized inventory item (which has a value > 0) to the SAME value

Result The inventory valuation report and transaction summary should not change.

4. Adjust Available Serialized

Action Ajust the value of a serialized inventory item (which has a value > 0 and status INV_AVAILABLE) upward by $4

Result The inventory valuation report balance should increase by $4. Account 140000's credit total should increase by $4, and account 515000's debit total should increase by $4.

5. Adjust Non-Available Serialized

Action Ajust the value of a serialized inventory item (which has a value > 0 and status other thanINV_AVAILABLE) upward by $7

Result The inventory valuation report and transaction summary should not change.



© Open Source Strategies, Inc. Development of this documentation site is sponsored by Open Source Strategies, Inc.
Help support opentaps with a subscription to this documentation site.