BeyondERP.Newsletter
Menu

Job page · Inventory 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
Maintain inventory levels
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

Business processMaintain inventory levels
Menu pathInventory management › Periodic tasks › Closing and adjustment
Used next byAdjustments report Microsoft Learn Inventory value Microsoft Learn
Related pagesPotential conflicts - inventory and general ledger Microsoft Learn
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.

When to run it

When to run itAt month end, as part of the period-end close and before the financial period is closed, for every inventory model except moving average.
How oftenUsually monthly; transaction volume should guide how often. Run recalculation in between when adjustments are needed.
Batch settingsRun it in the background during off-peak hours, as Microsoft recommends, to spread the computing load.
What the output showsA close or recalculation record on the Overview tab with the settlement adjustments and a ledger voucher. Many log warnings usually mean receipts that aren't financially updated, for example vendor invoices not yet posted.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Periodic tasks > Closing and adjustment.
  2. To close a period, start inventory close with the period end date as the closing date. It settles issues against receipts by each item's inventory valuation method and can update the general ledger.
  3. Before you close, view the list of items that can't be settled, and post open receipts financially where you can.
  4. For adjustments during the period, run inventory recalculation instead. It adjusts values but doesn't settle transactions.
  5. When the update finishes, select it on the Overview tab, then select Details and Voucher to review the posted ledger voucher.
  6. Read the inventory close log for warnings about issues that couldn't be fully settled.

Source: Microsoft Learn

Test checklist

  1. The close appears on the Overview tab with the closing date you entered.
  2. The ledger voucher shows the settlement adjustments.
  3. A transaction dated before the closing date can no longer be posted.
  4. The log has no unexpected warnings about issues that couldn't be settled.

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 undonePartly: You can reverse a completed inventory close, but only the most recently closed period can be reopened. To reverse an earlier close, reverse each later close first, starting with the latest. 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 itAccounting manager LedgerAccountingManagerInventory accountant clerk InventCostCostClerkInventory accountant InventCostAccountantGive 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