BeyondERP.Newsletter
Menu

Setup page · Cost management

Inventory value reports

A setup page where you define inventory value report configurations that control the columns, rows and data that inventory value reports include.

Used by
Inventory accountant, Accounting manager
Business process
Define costing policies
Menu item
InventValueReportSetup
Main table
InventValueReport
Data entity
InventInventoryValueReportLayoutEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you define inventory value report configurations that control the columns, rows and data that inventory value reports include.
What you do hereUse this page to create and maintain the report configurations that you select each time you generate an Inventory value or Inventory value report storage report.
Inventory value reports 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 processDefine accounting policies › Define costing policies
Menu pathCost management › Inventory accounting policies setup › Inventory value reports
Used next byInventory value report storage Microsoft Learn Inventory value 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.

Setup steps on this page

Set up Inventory value reports

Use this page to create and maintain the report configurations that you select each time you generate an Inventory value or Inventory value report storage report.

Steps from Microsoft

  1. Go to Cost management > Inventory accounting policies setup > Inventory value reports.
  2. Select New on the Action Pane to create a report, or select an existing report in the list pane and select Edit.
  3. In the ID field, enter a short unique identifier, and in the Name field, enter a descriptive name.
  4. For a new report configuration, select Save on the Action Pane to make the remaining fields available.
  5. On the General FastTab, set the Date interval, Range and Dimension set fields.
  6. On the Columns FastTab, select the columns and inventory dimensions that the report includes.
  7. On the Rows FastTab, select the resource types to show and the Detail Level.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
IDA short identifier for the report configuration, which must be unique among all inventory value report configurations.Microsoft Learn ReportId
NameA descriptive name for the report configuration.Microsoft Learn Name
Date intervalA predefined date interval for the report, which can be overridden when the report is run.Microsoft Learn DefaultDateInterval
RangeSpecifies whether the posting date or the transaction time is used when records are retrieved for the report.Microsoft Learn SelectDateRange
Dimension setThe set of general ledger dimensions to run the data for, such as Main account. The set can have no more than two dimensions.Microsoft Learn DimensionFocus

Test checklist

  1. Create a configuration with a unique ID, save, then set Range = Posting date and a Dimension set of Main account.
  2. Turn on Inventory and WIP columns and select site in the View column of Inventory dimensions.
  3. Generate an Inventory value report storage report for month end with this ID.
  4. Compare the inventory amount by main account with the trial balance for the same date.
  5. Check that a dimension without Financial inventory enabled shows a blank column.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Inventory value reportsFor ledger reconciliation configurations: Range = Posting date, Inventory column on, Include not posted to ledger off, and a Dimension set of Main account (no more than two dimensions).The general ledger can't be reconciled to inventory with Transaction time sorting; the report must use Posting date. Unposted amounts must be excluded from a reconciliation.Selecting warehouse or batch in the View column and expecting values: only dimensions with Financial inventory enabled in the storage or tracking dimension group show values; the others print blank.

Feature management and licence

Feature to turn onLarge Volume Historical Inventory Value Report Generation (Optional)

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: A configuration is read each time a report is generated, so changes affect new reports only. The ID is fixed once saved. Stored reports that you later delete may not be regenerable for old dates, so export them first. Microsoft Learn
If you change it laterThe ID of a report configuration cannot be changed after a new configuration is saved. Microsoft Learn
Technical architect

6Technical

Menu itemInventValueReportSetup Checked in Dynamics 365
FormInventValueReportSetup Checked in Dynamics 365
TableInventValueReportShown as “INVENTORY VALUE REPORTS” in Record infoKey field: ReportIdChecked in Dynamics 365
Data entitiesInventInventoryValueReportLayoutEntityInventory value report layouts Microsoft data model
Who can open itPrivilegesManage inventory value reports InventValueReportMaintainDutiesMaintain inventory valuation InventClosingInventoryValuationMaintainReview inventory valuation process performance InventValueInvValuationProcessPerfRevie
2 security rolesInventory accountant InventCostAccountantAccounting manager LedgerAccountingManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounting manager LedgerAccountingManagerInventory accountant InventCostAccountantGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): CopyChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=InventValueReportSetup
Integrate withInventInventoryValueReportLayoutEntity data entity Microsoft data model
Data migrationInventInventoryValueReportLayoutEntity (Inventory value report layouts): loaded for each company.Microsoft Learn
Table definitionInventValueReport columns and relations Microsoft data model
Everyone

8Sources