BeyondERP.Newsletter
Menu

Setup page · Inventory management

Item groups

A setup page where you create item groups, which divide inventory items into groups based on their characteristics.

Used by
Auditor, Chief financial officer, Inventory accountant and 9 more roles
Business process
Maintain inventory levels
Menu item
InventItemGroup
Main table
InventItemGroup
Data entity
InventProductGroupEntity
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 create item groups, which divide inventory items into groups based on their characteristics.
What you do hereUse this page to set the ledger accounts for each group's inventory postings, to report on products by group, and to set default forecast and sales tax settings.
ExampleFor example, when a stocked product is delivered for a sales order, the item group's packing slip issue and offset accounts receive the accounting entries.
Item groups 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 › Setup › Inventory › Item groups
Set up firstItem allocation keys Microsoft Learn Set up Item allocation keys
Used next bySet up Posting
Related pagesItem model groups 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.

Step by step, with screenshots

Set up Item groups1 screen

Use this page to set the ledger accounts for each group's inventory postings, to report on products by group, and to set default forecast and sales tax settings.

  1. Screen 1

    Create an item group

    Go to Inventory management > Setup > Inventory > Item groups

    1. Select New
    2. Enter the item group code and name
    3. Select Save
    4. On the Sales order, Purchase order and Inventory tabs, select the main account for each account type
    5. Assign the item group to released products
    1Item groupBEAT
    2NameTrade goods
    3Cost of units, delivered130100
    4Revenue410100
    Create an item group (zoomed on the outlined fields)
    Show the full screenCreate an item group
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Inventory management > Setup > Inventory > Item groups.
  2. Create a new item group.
  3. On the Sales order, Purchase order, Inventory and Production FastTabs, select the main accounts to use for each account type.
  4. On the Setup FastTab, select the Default item allocation key for forecasts.
  5. Select the default Item sales tax group for sales and purchases.
  6. Save the item group.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Default item allocation keyThe allocation key proposed when you create forecasts for the item group.Microsoft Learn StandardItemAllocateId
Item sales tax groupThe default item sales tax group for items in the group.Microsoft Learn
Item groupRAWMATItemGroupId
NameThe descriptive name of the item group.Checked in Dynamics 365Trade goodsName
Cost of units, delivered130100
Revenue410100

Test checklist

  1. Create an item group and fill the Purchase order, Sales order and Inventory accounts
  2. Assign the item group to a stocked released product
  3. Post a purchase order product receipt and invoice for the product
  4. Open the voucher and check the accounts match the item group setup

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Item groupsAt least one item group in every legal entity, with item groups split by the ledger accounts and financial reporting the items needLearn states every legal entity must have at least one item group, and that item groups exist to define sets of ledger accounts and to report financial information by group.Creating item groups only for reporting and leaving their ledger accounts empty. Production setup lists ledger accounts for item groups as a prerequisite, and inventory receipts and issues post through these accounts.
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneReversible: You can change the accounts, the default item allocation key and the item sales tax group at any time. New postings use the new accounts; vouchers already posted keep their accounts. Microsoft Learn
Technical architect

6Technical

Menu itemInventItemGroup Checked in Dynamics 365
FormInventItemGroup Checked in Dynamics 365
TableInventItemGroupShown as “Item groups” in Record infoKey field: ItemGroupIdChecked in Dynamics 365
Data entitiesInventProductGroupEntityItem groups Microsoft data model DimAttributeInventItemGroupEntityItem groups Microsoft data model
Who can open itPrivilegesMaintain item groups InventItemGroupMaintainView item groups InventItemGroupViewDutiesInquire into general ledger policies LedgerGeneralLedgerPoliciesInquireEnable general ledger process LedgerGeneralLedgerProcessEnableInquire into general ledger policies RentalLedgerGeneralLedgerPolicieInquireEnable general ledger process RentalLedgerGeneralLedgerProcessEnable
12 security rolesAuditor AuditPolicyManagerChief financial officer CompanyChiefFinancialOfficerInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerRental coordinator agent RentalCoordinatorAgentRental manager RentalManagerRental purchasing manager RentalPurchasingManagerRental sales manager RentalSalesManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRental sales manager RentalSalesManagerRental manager RentalManagerAccounting manager LedgerAccountingManagerRental purchasing manager RentalPurchasingManagerAccounting supervisor LedgerAccountingSupervisorTo use itInventory accountant clerk InventCostCostClerkInventory accountant InventCostAccountantRental coordinator agent RentalCoordinatorAgentAuditor AuditPolicyManagerFinancial controller LedgerFinancialControllerGive people one of these roles. On this system, 12 roles can open this page.Checked in Dynamics 365
Actions on the pageOptionsChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=InventItemGroup
Integrate withInventProductGroupEntity data entity Microsoft data model
Data migrationInventProductGroupEntity (Item groups): loaded for each company, in Microsoft's default template 300 - Inventory.Load order: Microsoft's default template 300 - Inventory loads Item groups at execution unit 1, level 40, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to dependency bands 30 to 90)Microsoft Learn
Table definitionInventItemGroup columns and relations Microsoft data model
Everyone

8Sources