BeyondERP.Newsletter
Menu

Page · Cost management

Revaluation for moving average

A list page where you adjust the moving average cost of products, with one line per item, site and warehouse that shows the posted quantity, posted value, posted unit cost and the new unit cost.

Used by
Inventory accountant
Business process
Adjust on hand inventory moving average value in Dynamics 365 Finance
Menu item
InventAdjInventOnHandMovingAverage
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA list page where you adjust the moving average cost of products, with one line per item, site and warehouse that shows the posted quantity, posted value, posted unit cost and the new unit cost.
What you do hereUse this page to adjust the moving average cost of a product to a new unit price as of today's date.
ExampleFor example, a product with a posted unit cost of 12.00 can be revalued by entering 16.00 in the Unit cost field, which posts an adjustment of 4.00 to the cost revaluation for moving average account.
Revaluation for moving average page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Steps from Microsoft

  1. Go to Cost management > Inventory accounting > Revaluation for moving average.
  2. Select the product that you want to adjust the moving average cost for.
  3. In the Unit cost field, enter the new unit cost.
  4. Select Post to post the adjustment.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Unit costThe new moving average unit cost for the product. The other fields on the line are calculated from it.Microsoft Learn

Test checklist

  1. Check Cost revaluation for moving average accounts are set on the Inventory tab of the Posting page.
  2. Open the page for a moving average item and check posted quantity, posted value and posted unit cost.
  3. Enter a new Unit cost and post the adjustment.
  4. Open Settlements for voucher and check the difference posted to the Cost revaluation for moving average account.
  5. Run the inventory value report with Range = Transaction time and check the new average unit cost from the revaluation date.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneHard to reverse: A revaluation posts to the Cost revaluation for moving average account as of today's date and can't be backdated. To correct it you post another revaluation, also as of today; the cost doesn't flow back through earlier transactions. Microsoft Learn
If you change it laterA moving average revaluation can only be made as of today's date. It can't be backdated to correct the moving average cost of a product. Microsoft Learn
Technical architect

5Technical

Menu itemInventAdjInventOnHandMovingAverage Checked in Dynamics 365
FormInventAdjInventOnHand Checked in Dynamics 365
Who can open itPrivilegesAdjust on-hand cost values InventAdjInventOnHandMaintainDutiesMaintain inventory valuation InventClosingInventoryValuationMaintain
1 security roleInventory accountant InventCostAccountant
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itInventory accountant InventCostAccountantGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Select, Delete, Adjustment, Post, PrintChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=InventAdjInventOnHandMovingAverage
Everyone

7Sources