CenterPoint® Accounting - Adjust Inventory Cost

Related Help

Adjust Inventory Cost Video - Duration 6 min 16 sec

View or Print as PDF


This option allows a user to adjust inventory cost without changing quantities.

For LIFO and FIFO valuations (including Serial and Lotted Inventory) cost layers you want to adjust can be selected. For Average Cost valuations, the cost is adjusted without entering any quantities. The Inventory and Adjustment Accounts are used to post general journal entries when the adjusted amount is posted.


Adjust Inventory Cost

  1. Select Processes > Inventory > Adjust Inventory Cost or Processes > Periodic > Adjust Inventory Cost.

  1. In the Company box, enter or select the company name that this inventory cost adjustment is for.
  2. Select the Inventory account the adjustment is for. This is a required entry. The lookup list will display only postable inventory accounts and inventory items.
  3. Select the Adjustment Account this inventory cost adjustment is for. This is a required entry. The lookup list will display only Asset, Liability, Equity, Expense, and Revenue accounts.
  4. Enter the Adjustment Date.
  5. In the Adjustment Number box, a sequence number will be assigned automatically. You can also select a sequence number. This is optional information for Inventory Cost Adjustment transactions.
  6. Click Select Costs.
  7. Enter an optional Distribution Amount and then click Distribute to distribute amounts to the cost records in the transaction grid by quantity. The distribution to grid lines is calculated as the (Row Quantity On Hand / Total Quantity on Hand) multiplied by the Distribution Amount.

  8. All grid columns are inactive (read only) except for the Adjustment Amount and the Desired Unit Cost columns.

  9. When a unit cost is entered into the Desired Unit Cost box, the system calculates:

    • Adjustment Amount = (Quantity * Desired Unit Cost) - Current Amount
    • New Amount = Current Amount + Adjustment Amount

    or

    When an Adjustment Amount is entered the system calculates:

    • New Amount = Current Amount + Adjustment Amount
    • Desired Unit Cost = New Amount / Quantity
  10. Click Post Adjustments. One General Journal entry will be posted for each cost record being adjusted. When the Adjustment Amount is greater than zero, Inventory is debited and when the Adjustment Amount is less than zero, Inventory is credited and the Adjustment Account will be posted as the Net of the cost adjusted.

Document: 3246

Concept Link IconSee Also