BeyondERP.Newsletter
Menu

Setup step on the Accounts payable parameters page · Accounts payable

Set the default vendor posting profile

Apply the approved AP posting profile to new vendor documents unless a more specific choice is made.

Used by
Accounts payable manager, Auditor, Accounting manager and 2 more roles
Business process
Process supplier invoices
Menu item
VendParameters
Main table
VendParameters
Setup steps
7 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 isThe main setup page for Accounts payable in each legal entity.
What you do hereUse this page to set default settings that apply when no more specific setting exists, parameters for various Accounts payable functionality, and the Accounts payable number sequences.
ExampleFor example, a company that wants accrued costs recorded when goods are received, before the vendor invoice arrives, selects the Post product receipts to ledger option on this page.
Accounts payable parameters 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 the default vendor posting profile1 screen

Apply the approved AP posting profile to new vendor documents unless a more specific choice is made.

  1. Screen 1

    Set the default vendor posting profile

    Go to Accounts payable > Setup > Accounts payable parameters, Ledger and sales tax tab

    1. Open the Ledger and sales tax tab
    2. In the Posting section, select the posting profile
    3. Select Save
    1Posting profileBEAT
    Set the default vendor posting profile (zoomed on the outlined fields)
    Show the full screenSet the default vendor posting profile
    page title tab to open what to set or check
Confirm procurement and AP number sequences exist1 screen
  1. Screen 1

    Confirm the payables number sequences

    Go to Accounts payable > Setup > Accounts payable parameters, Number sequences tab

    1. Open the Number sequences tab
    2. Review each reference in the grid and its Number sequence code
    3. Assign a code to any reference that has none, then select Save
    1Vendor accountAcco_99
    2Payment voucherAcco_116
    3Internal product receiptAcco_128
    4Internal invoiceAcco_132

    Check Every reference in the grid, including Vendor account, Payment voucher, Internal product receipt and Internal invoice, shows a number sequence code.

    Confirm the payables number sequences
    page title tab to open what to set or check
Enable invoice matching validation1 screen

Turn on the control that compares vendor invoice lines against purchase order and receipt data before posting, so price and quantity discrepancies are caught at entry rather than at reconciliation.

  1. Screen 1

    Turn on invoice matching validation

    Go to Accounts payable > Setup > Accounts payable parameters, Invoice validation tab

    1. Open the Invoice validation tab
    2. In the Invoice validation section, turn on Enable invoice matching validation
    3. Select Save
    1Enable invoice matching validationYes
    Turn on invoice matching validation (zoomed on the outlined fields)
    Show the full screenTurn on invoice matching validation
    page title tab to open what to set or check
Set the default line matching policy1 screen

Establish whether invoice lines are validated against the PO only, or against the PO and the product receipt, as the organisation's default control level.

  1. Screen 1

    Set the line matching policy

    Go to Accounts payable > Setup > Accounts payable parameters, Invoice validation tab

    1. Expand the Price and quantity matching section
    2. Set Line matching policy
    3. Select Save
    1Line matching policyThree-way matching
    Set the line matching policy (zoomed on the outlined fields)
    Show the full screenSet the line matching policy
    page title tab to open what to set or check
Decide whether matching policy override is allowed1 screen
  1. Screen 1

    Allow a stricter policy override

    Go to Accounts payable > Setup > Accounts payable parameters, Invoice validation tab

    1. Expand the Price and quantity matching section
    2. Set Allow matching policy override
    3. Select Save
    1Allow matching policy overrideHigher than company policy
    Allow a stricter policy override (zoomed on the outlined fields)
    Show the full screenAllow a stricter policy override
    page title tab to open what to set or check
Configure price total matching and tolerance1 screen
  1. Screen 1

    Set price total matching and its tolerances

    Go to Accounts payable > Setup > Accounts payable parameters, Invoice validation tab

    1. Expand the Price and quantity matching section
    2. Set Match price totals
    3. Check the two purchase price total tolerance fields
    4. Select Save
    1Match price totalsNone
    2Purchase price total tolerance percent0.00
    3Purchase price total tolerance0.00
    Set price total matching and its tolerances (zoomed on the outlined fields)
    Show the full screenSet price total matching and its tolerances
    page title tab to open what to set or check
Set automatic vendor settlement behavior1 screen

Control whether an unallocated vendor payment is matched to open transactions automatically after posting.

  1. Screen 1

    Set automatic settlement and settlement limits

    Go to Accounts payable > Setup > Accounts payable parameters, Settlement tab

    1. Open the Settlement tab
    2. Set Automatic settlement
    3. Enter Maximum penny difference and Maximum overpayment or underpayment
    4. Select Save
    1Automatic settlementNo
    2Maximum penny difference0.00
    3Maximum overpayment or underpayment0.00
    Set automatic settlement and settlement limits (zoomed on the outlined fields)
    Show the full screenSet automatic settlement and settlement limits
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Accounts payable > Setup > Accounts payable parameters.
  2. Select the Invoice validation tab.
  3. Select or clear Enable invoice matching validation.
  4. In Post invoice with discrepancies, choose whether invoices with matching discrepancies need approval or can post with a warning.
  5. In Automatically update invoice header match status, choose whether matching runs automatically during invoice entry.
  6. For invoice totals matching, select Match invoice totals and enter the Invoice totals tolerance percentage.
  7. Select the Line matching policy and, if needed, a value in Allow matching policy override.
  8. Set Match price totals and its tolerance, and select Match charges to match charges against the purchase order.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Enable invoice matching validationTurns on invoice matching checks for vendor invoices in this legal entity.Microsoft Learn Yes
Post invoice with discrepanciesWhether an invoice with matching discrepancies must be approved first or can be posted with a warning.Microsoft Learn PostInvoiceMatchDiscrepancies
Automatically update invoice header match statusWhether matching runs automatically while the invoice is being entered.Microsoft Learn
Invoice totals tolerance percentageThe company-wide allowed variance for invoice totals, which vendors can override.Microsoft Learn
Line matching policyThe default line matching for the legal entity: not required, two-way or three-way.Microsoft Learn Three-way matchingMatchingPolicy
Allow matching policy overrideWhether a different matching level can be set for an item, vendor, or purchase order line.Microsoft Learn Higher than company policyMatchingPolicyAllowOverride
Match price totalsCompares the running net amount of all invoices for a purchase order line with the order line amount.Microsoft Learn NoneUseExtendedPriceMatching
Match chargesCompares charges on the invoice with the charges expected from the purchase order.Microsoft Learn UseMiscChargeMatching
Cash-discount administrationWhere the difference goes when a payment doesn't match the discounted amount; Specific posts it to the vendor cash discount account.Microsoft Learn
Enable vendor approvalsSends changes to selected vendor fields through an approval workflow.Microsoft Learn VendTableChangeProposalIsEnabled
Enable settle remainderLets the remaining amount after settlement go to a ledger account or another vendor.Microsoft Learn SettlementWriteOffEnabled
Automatically submit imported invoices to workflowSends imported vendor invoices to workflow without manual steps.Microsoft Learn
Vendor accountAcco_99
Payment voucherAcco_116
Internal product receiptAcco_128
Internal invoiceAcco_132
Purchase price total tolerance percent0.00ExtendedPriceTolerancePercentage
Purchase price total tolerance0.00ExtendedPriceToleranceAmount
Automatic settlementNoAutoSettle
Maximum penny difference0.00MaxMSTDiff
Maximum overpayment or underpayment0.00MaxMSTOverUnder
Posting profileGENPostingProfile

Test checklist

  1. With Enable invoice matching validation on, post a vendor invoice whose price exceeds the tolerance: the match variance icon appears.
  2. Create a new vendor invoice and check the header posting profile equals the default posting profile.
  3. Post a payment without marking invoices and check whether it settles, according to Automatic settlement.
  4. Check new vendor accounts and vouchers take numbers from the sequences on the Number sequences tab.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set the default vendor posting profile · Ledger and sales tax tabThe vendor posting profile whose All row holds the standard trade payables summary accountThe default posting profile on the Ledger and sales tax tab appears on the header of every new vendor document; the profile's Table, Group and All rows then pick the summary account, so the default should be the profile used by most vendors.Which vendors need different AP summary accounts or posting treatment?Treating the default profile as the final posting result even when the document profile is changed or General ledger posting definitions apply.Test: AP baseline defaults flow from setup to invoice and payment
Confirm procurement and AP number sequences exist · Number sequences tabA number sequence on every Accounts payable reference on the Number sequences tab before the first vendor or invoice is createdLearn lists the Accounts payable parameters page as the place for the Accounts payable number sequences, and centralized payment settlement vouchers also draw on the payment voucher sequence set here.Test: Price total matching across two invoices
Enable invoice matching validationYesEnable invoice matching validation before testing the matching checks and discrepancy settings.Enabled in one legal entity during a pilot and never replicated to the others, so matching silently does nothing in the entities that went live later. Check this setting separately in each legal entity.Test: Matching validation test pack
Set the default line matching policyThree-way matching for stocked items; two-way where no receipt is recorded (services, some indirect spend)Choose the matching policy around the receipt process and the required controls. Test how missing receipts and discrepancy settings affect posting.What level of invoice matching control applies, and does it vary by spend category?Set to three-way in design workshops on the strength of an aspiration to receipt everything, then relaxed under go-live pressure. Base the matching policy on how receipts are recorded in practice.
Decide whether matching policy override is allowedExpecting the legal entity Line matching policy to apply everywhere when overrides exist: the Matching policy page wins in the order item and vendor, item, vendor, then legal entity.
Configure price total matching and toleranceNone unless vendors send several invoices for one purchase order line; then Percentage, or Percentage and amountLearn says price totals matching is useful when you receive multiple invoices for a single purchase order line, and not needed if you usually receive one invoice per line. It needs two-way or three-way matching.Mixing up currencies: the percentage tolerance is compared in the transaction currency, while the amount tolerance is compared in the accounting currency.
Set automatic vendor settlement behavior · Settlement tabYes when payments are posted without marking invoices, with Use priority for automatic settlements set and the priority defined; No when clerks always mark invoices in payment proposals or Settle transactionsLearn says a payment posted without settlement can be settled automatically when Automatic settlement is on, using either the default order or the priority you define. Choose the method that fits the business process.Should open vendor transactions be settled automatically when an unallocated payment is posted?Assuming automatic settlement can clear payments across legal entities. Microsoft's settlement overview limits this setting to the same legal entity.Test: Automatic versus explicitly marked vendor settlement

Number sequences

ReferenceShared or per companyNote
Vendor accountPer companyBEAT uses number sequence Acco_99. Checked in Dynamics 365
One-time supplierPer companyBEAT uses number sequence Acco_103. Checked in Dynamics 365
1099 report numberPer companyBEAT uses number sequence Acco_105. Checked in Dynamics 365
Note IDPer companyBEAT uses number sequence Acco_108. Checked in Dynamics 365
Exchange rate adjustment voucherPer companyBEAT uses number sequence Acco_112. Checked in Dynamics 365
Payment voucherPer companyBEAT uses number sequence Acco_116. Checked in Dynamics 365
Closing voucherPer companyBEAT uses number sequence Acco_120. Checked in Dynamics 365
Remittance numberPer companyBEAT uses number sequence Acco_124. Checked in Dynamics 365
Internal product receiptPer companyBEAT uses number sequence Acco_128. Checked in Dynamics 365
Internal invoicePer companyBEAT uses number sequence Acco_132. Checked in Dynamics 365
Internal credit notePer companyBEAT uses number sequence Acco_136. Checked in Dynamics 365
Product receipt voucherPer companyBEAT uses number sequence Acco_140. Checked in Dynamics 365
Invoice voucherPer companyBEAT uses number sequence Acco_144. Checked in Dynamics 365
Purchase order confirmation voucherPer companyBEAT uses number sequence Acco_148. Checked in Dynamics 365
Credit note voucherPer companyBEAT uses number sequence Acco_152. Checked in Dynamics 365
Charges voucherPer companyBEAT uses number sequence Acco_156. Checked in Dynamics 365
Prepayment voucherPer companyBEAT uses number sequence Acco_160. Checked in Dynamics 365
Prepayment application voucherPer companyBEAT uses number sequence Acco_164. Checked in Dynamics 365
Product receipt finalization voucherPer companyBEAT uses number sequence Acco_168. Checked in Dynamics 365
Royalty contractPer companyBEAT uses number sequence Acco_172. Checked in Dynamics 365
Solution architect

5Design impact

Shared or per companyLegal entity
Can it be undoneHard to reverse: A changed default affects new documents; already posted balances require reconciliation rather than retroactive profile edits.
If you change it laterSome settings don't change existing records on their own. For example, when you turn on Show due date and allow edit, you choose whether to update all existing vendor transactions now or fill the new fields only for new transactions. Microsoft Learn
Technical architect

6Technical

Menu itemVendParameters Checked in Dynamics 365
FormVendParameters Checked in Dynamics 365
TableVendParametersShown as “Vendor parameters” in Record infoChecked in Dynamics 365
Data entitiesVendorParameters
Who can open itPrivilegesMaintain accounts payable parameters VendParametersMaintainView accounts payable parameters VendParametersViewDutiesEnable purchasing process ProcPurchasingProcessEnableInquire into purchase order to invoice policies PurchOrderToInvoicePoliciesInquireEnable purchase order to invoice process PurchOrderToInvoiceProcessEnableInquire into invoice and payment policies VendInvoiceInvoicePaymentPoliciesInquirEnable invoice and payment process VendInvoiceInvoicePaymentProcessEnable
5 security rolesAuditor AuditPolicyManagerAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorPurchasing manager TradePurchasingManagerAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounts payable manager VendInvoiceAccountsPayableManagerAccounting supervisor LedgerAccountingSupervisorPurchasing manager TradePurchasingManagerTo use itAccounting manager LedgerAccountingManagerAuditor AuditPolicyManagerGive people one of these roles. On this system, 5 roles can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=VendParameters
Everyone

8Sources