BeyondERP.Newsletter
Menu

Page · Cost management

Closing and adjustment

A periodic task page where you run inventory close and inventory recalculation, and make adjustments to on-hand inventory and inventory transactions.

Used by
Inventory accountant, Inventory accountant clerk, Accounting manager
Business process
Finalize and close inventory in Dynamics 365 Finance
Menu item
InventClosing
Main table
InventClosing
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 periodic task page where you run inventory close and inventory recalculation, and make adjustments to on-hand inventory and inventory transactions.
What you do hereUse this periodic task to settle issue transactions against receipt transactions using each item's inventory valuation method, and to update the general ledger with the adjustments.
ExampleFor example, if inventory close is run for the period that ends on January 31, transactions dated before January 31 can no longer be posted.
Closing and adjustment 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 > Closing and adjustment.
  2. Run inventory close for the period end date, or run inventory recalculation if you need adjustments during the period.
  3. When the update finishes, on the Overview tab, select the update to review.
  4. Select Details, and then select Voucher to see the posted ledger voucher.

Source: Microsoft Learn

Test checklist

  1. Before closing, view the list of items that can't be settled and post any missing vendor invoices.
  2. Run inventory close for the month end, preferably off-peak, and check the log for unsettled issue warnings.
  3. On the Overview tab select the close, then Details > Voucher, and check the adjustment voucher posted to the original transactions' ledger accounts.
  4. Try to post an inventory journal dated before the closing date and check it is blocked.
  5. In a test company, reverse the close and check posting in the period is possible again.

Source: Microsoft Learn

Solution architect

4Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: After a close you can't post before the closing date. A close can be reversed, but only the most recently closed period can be reopened: to reverse an earlier close you must reverse each later close one at a time, newest first. Reversal can also post to the general ledger. Microsoft Learn
If you change it laterAfter inventory close you can't post in periods before the closing date unless you reverse the close, and only the most recently closed period can be reopened. Microsoft Learn
Technical architect

5Technical

Menu itemInventClosing Checked in Dynamics 365
FormInventClosing Checked in Dynamics 365
TableInventClosingShown as “Inventory closing” in Record infoKey field: AdjustmentType, Active, Voucher, TransDate, CancellationChecked in Dynamics 365
Who can open itPrivilegesView inventory closing journals InventClosingViewDutiesMaintain inventory valuation InventClosingInventoryValuationMaintainInquire into inventory valuation status InventValueInvValuationStatusInquire
3 security rolesInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccounting manager LedgerAccountingManager
Checked in Dynamics 365
Roles to set it up and use itTo use itInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccounting manager LedgerAccountingManagerGive people one of these roles. On this system, 3 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=InventClosing
Table definitionInventClosing columns and relations Microsoft data model
Everyone

7Sources