BeyondERP.Newsletter
Menu

Setup step on the Item price tolerance groups page · Accounts payable

Set up Item price tolerance groups

Set up the tolerance groups for item prices that invoice matching uses.

Used by
Accounts payable clerk, Accounts payable manager, Chief financial officer and 7 more roles
Business process
Perform invoice matching in Dynamics 365 Finance
Menu item
InventItemPriceToleranceGroup
Main table
InventItemPriceToleranceGroup
Data entity
InventItemPriceToleranceGroupEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isAn invoice matching setup page for item price tolerance groups.
What you do hereUse this page to set up tolerance groups for item prices.
Item price tolerance 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

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 price tolerance groups1 screen

Set up the tolerance groups for item prices that invoice matching uses.

  1. Screen 1

    Create the item price tolerance group

    Go to Accounts payable > Invoice matching setup > Item price tolerance groups

    1. Select New
    2. Enter the group code and name
    1Item price tolerance groupBEAT
    NameItem tolerance
    Create the item price tolerance group (zoomed on the outlined fields)
    Show the full screenCreate the item price tolerance group
    page title tab to open what to set or check

How to use it

  1. Go to Accounts payable > Invoice matching setup > Item price tolerance groups.
  2. Select New to add a row.
  3. Enter the group code and the Name.
  4. Select a row and select Edit to change it, or select Delete to remove it.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it meansExampleTable column
Item price tolerance groupSTANDARDItemPriceToleranceGroupId
NameA short description of the item price tolerance group.Checked in Dynamics 365Item toleranceName

Test checklist

  1. Create an item price tolerance group and assign a test item to it.
  2. Add a Group/All row on Price tolerances with 10 percent.
  3. Invoice the item 8 percent above the order price and check no discrepancy.
  4. Invoice an item outside the group 8 percent above and check the price match icon appears.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Item price tolerance groupsOne group per set of items that share the same allowed price variance, each with a Group row on Price tolerancesPrice tolerances can be set by item group, and matching checks group rows before the All row.Creating the group without a Price tolerances row: matching falls back to the All items and All vendors default, which starts at 0 percent.

Feature management and licence

Licence or add-inInvoice matching configuration key

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: The tolerance is looked up at each matching run, so changes apply from the next run.
Technical architect

6Technical

Menu itemInventItemPriceToleranceGroup Checked in Dynamics 365
FormInventItemPriceToleranceGroup Checked in Dynamics 365
TableInventItemPriceToleranceGroupShown as “Item price tolerance groups” in Record infoKey field: ItemPriceToleranceGroupIdChecked in Dynamics 365
Data entitiesInventItemPriceToleranceGroupEntityItem price tolerance groups Microsoft data model
Who can open itPrivilegesMaintain item price tolerance groups InventItemPriceToleranceGroupMaintainView item price tolerance groups InventItemPriceToleranceGroupViewDutiesMaintain cost master CostingVersionCostMasterMaintainInquire into vendor invoice status VendInvoiceVendorInvoiceStatusInquire
10 security rolesChief financial officer CompanyChiefFinancialOfficerInventory accountant clerk InventCostCostClerkAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts payable centralized payments clerk PaymAccountsPayableCentralPaymClerkAccounts payable payments clerk PaymAccountsPayablePaymentsClerkAccounts payable clerk VendInvoiceAccountsPayableClerkAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itInventory accountant clerk InventCostCostClerkTo use itAccounts payable manager VendInvoiceAccountsPayableManagerAccounting supervisor LedgerAccountingSupervisorAccounting manager LedgerAccountingManagerAccounts payable clerk VendInvoiceAccountsPayableClerkChief financial officer CompanyChiefFinancialOfficerGive people one of these roles. On this system, 10 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=InventItemPriceToleranceGroup
Integrate withInventItemPriceToleranceGroupEntity data entity Microsoft data model
Data migrationInventItemPriceToleranceGroupEntity (Item price tolerance groups): loaded for each company, in Microsoft's default template 300 - Inventory.Load order: Microsoft's default template 300 - Inventory loads Item price tolerance groups at execution unit 1, level 30, 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 General ledger)Microsoft Learn
Table definitionInventItemPriceToleranceGroup columns and relations Microsoft data model
Everyone

8Sources