BeyondERP.Newsletter
Menu

Setup step on the Price tolerances page · Accounts payable

Define price tolerances by item, vendor or combination

A setup page for allowed unit price tolerance percentages by legal entity, item and vendor (with a default of 0 percent for all items and accounts).

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
PurchPriceTolerance
Main table
PurchPriceTolerance
Data entity
PurchPriceToleranceEntity
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 isA setup page for allowed unit price tolerance percentages by legal entity, item and vendor (with a default of 0 percent for all items and accounts).
What you do hereUse this page with two-way or three-way matching to define how far invoice prices may differ from purchase order prices before a discrepancy is shown.
ExampleFor example, if the policy allows a 5 percent net unit price tolerance for an item and the purchase order price is 1.00, an invoice price of 1.05 is accepted but 1.10 is a price matching discrepancy.
Price tolerances 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

Define price tolerances by item, vendor or combination1 screen
  1. Screen 1

    Add the item and vendor price tolerance

    Go to Accounts payable > Invoice matching setup > Price tolerances

    1. Select New
    2. Enter the item and vendor combination and the unit price tolerance
    3. Keep the All / All row as the default
    1Item relationBEAT-ITEM-001
    Account codeTable
    Account relationBEAT-000001
    Unit price tolerance2.00
    Add the item and vendor price tolerance (zoomed on the outlined fields)
    Show the full screenAdd the item and vendor price tolerance
    page title tab to open what to set or check

Steps from Microsoft

  1. Make sure the line matching policy in Accounts payable parameters is set to two-way or three-way matching.
  2. Go to Accounts payable > Setup > Invoice matching setup > Price tolerances.
  3. Enter the allowed price tolerance percentages for the legal entity, items and vendors, or for groups of them.
  4. To also flag invoices priced below the order, set Display unit price match icon in Accounts payable parameters to If greater than or less than tolerance.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Item relationBEAT-ITEM-001ItemRelation
Account codeTableAccountCode
Account relationBEAT-000001AccountRelation
Unit price tolerance2.00

Test checklist

  1. Set Line matching policy to Two-way match in Accounts payable parameters.
  2. Set the All/All row to 5 percent and add a Table/Table row for one item and vendor at 1 percent.
  3. Invoice that item from that vendor at 3 percent above the order price and check a price discrepancy is shown.
  4. Invoice another item at 3 percent above and check no discrepancy is shown.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Define price tolerances by item, vendor or combinationSet the All items and All vendors row to the company's standard percentage, and add item, vendor or group rows only for exceptionsThe All/All row is the legal entity default, starts at 0 percent and can't be deleted; matching searches from the most specific row down to All/All.Leaving the default at 0 percent, so every price increase on any invoice raises a discrepancy. Negative tolerances can't be entered; to flag under-priced invoices select If greater than or less than tolerance in Display unit price match icon.Test: Most specific price tolerance wins

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
If you change it laterWhen an invoice is checked, the system looks for the most specific tolerance first, from a single item and vendor down to all items and all vendors. The default record for all items and all vendors starts at 0 percent and can't be deleted. Microsoft Learn
Technical architect

6Technical

Menu itemPurchPriceTolerance Checked in Dynamics 365
FormPurchPriceTolerance Checked in Dynamics 365
TablePurchPriceToleranceShown as “Price tolerance setup” in Record infoKey field: RecIdChecked in Dynamics 365
Data entitiesPurchPriceToleranceEntityPrice tolerance setup Microsoft data model VendInvoicePriceToleranceEntityInvoice matching unit price tolerance setup Microsoft data model
Who can open itPrivilegesMaintain price tolerances PurchPriceToleranceMaintainView price tolerances PurchPriceToleranceViewDutiesEnable purchase order to invoice process PurchOrderToInvoiceProcessEnableInquire into vendor invoice status VendInvoiceVendorInvoiceStatusInquire
10 security rolesChief financial officer CompanyChiefFinancialOfficerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts payable centralized payments clerk PaymAccountsPayableCentralPaymClerkAccounts payable payments clerk PaymAccountsPayablePaymentsClerkPurchasing manager TradePurchasingManagerAccounts payable clerk VendInvoiceAccountsPayableClerkAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounts payable manager VendInvoiceAccountsPayableManagerPurchasing manager TradePurchasingManagerTo use itAccounting supervisor LedgerAccountingSupervisorAccounting manager LedgerAccountingManagerAccounts payable clerk VendInvoiceAccountsPayableClerkChief financial officer CompanyChiefFinancialOfficerFinancial controller LedgerFinancialControllerGive people one of these roles. On this system, 10 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=PurchPriceTolerance
Integrate withPurchPriceToleranceEntity data entity Microsoft data model
Data migrationPurchPriceToleranceEntity (Price tolerance setup): loaded for each company, in Microsoft's default template 320 - Procurement and sourcing.VendInvoicePriceToleranceEntity (Invoice matching unit price tolerance setup): loaded for each company.Load order: Microsoft's default template 320 - Procurement and sourcing loads Price tolerance setup at execution unit 1, level 320, sequence 20. 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 Product management)Microsoft Learn
Table definitionPurchPriceTolerance columns and relations Microsoft data model
Everyone

8Sources