BeyondERP.Newsletter
Menu

Setup step on the Netting rules page · Accounts payable

Set up Netting rules

Defines the netting sequence, agreement scope, credit/debit note inclusion and criteria that automatic netting applies when run in batch or by process automation.

Used by
Accounts payable clerk, Accounts payable manager, Auditor and 15 more roles
Business process
Net payments between customers and vendors in Dynamics 365 Finance
Menu item
CustVendNettingRule
Main table
CustVendNettingRule
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 netting rule defines how customer and vendor balances are netted automatically.
What you do hereUse this page to set the netting sequence (by due date or invoice balance), the netting agreement scope, whether credit and debit notes are included, and criteria such as vendor accounts, customer accounts, or invoice currency, and then activate the rule.
Netting rules 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 Netting rules5 screens

Defines the netting sequence, agreement scope, credit/debit note inclusion and criteria that automatic netting applies when run in batch or by process automation.

  1. Screen 1

    Create the netting rule

    Go to Accounts payable > Payments > Netting > Netting rules

    1. Select New and enter the Name and Description
    2. Set Netting sequence
    3. Set Active to Yes
    1Netting sequenceBy due date - from newest to oldest
    2ActiveYes
    3NameBEAT-NET
    DescriptionSame-party netting rule
    Create the netting rule (zoomed on the outlined fields)
    Show the full screenCreate the netting rule
    page title tab to open what to set or check
  2. Screen 2

    Add the netting agreement to the rule

    Go to Accounts payable > Payments > Netting > Netting rules, Netting agreements section

    1. Select the BEAT-NET rule
    2. In the Netting agreements section, select Add
    3. Choose the BEAT-NET agreement
    4. Leave Netting criteria empty
    1Netting agreementBEAT-NET
    Add the netting agreement to the rule (zoomed on the outlined fields)
    Show the full screenAdd the netting agreement to the rule
    page title tab to open what to set or check
  3. Screen 3

    Confirm the rule selects the agreement

    Go to Accounts payable > Payments > Netting > Netting rules

    1. Select the BEAT-NET rule
    2. Check Netting agreement, Active and the Netting agreements list

    Check Rule BEAT-NET shows Netting agreement Selected and Active Yes, and its only agreement line is BEAT-NET with Status Active.

    Confirm the rule selects the agreement (zoomed on the outlined fields)
    Show the full screenConfirm the rule selects the agreement
    page title tab to open what to set or check
  4. Screen 4

    Run automatic netting with the rule

    Go to Accounts payable > Payments > Netting > Customer and vendor balance netting, Netting history

    1. Select Automatic netting
    2. After it runs, select Netting history

    Check Batch BEAT-000010 for agreement BEAT-NET, dated 10/7/2026, shows customer BEAT-000001 at -100.00 and vendor BEAT-000001 at 100.00 USD, one invoice each, with Status Posted.

    Run automatic netting with the rule (zoomed on the outlined fields)
    Show the full screenRun automatic netting with the rule
    page title tab to open what to set or check
  5. Screen 5

    Check the trial balance after rule-driven netting

    Go to General ledger > Inquiries and reports > Trial balance

    1. Open the Trial balance
    2. Check accounts 120100, 140100, 210100 and 220100 and the totals

    Check Accounts 120100, 140100, 210100 and 220100 close at 0.00, and the totals are debit 8,040.00 and credit 8,040.00 with balance 0.00.

    Check the trial balance after rule-driven netting (zoomed on the outlined fields)
    Show the full screenCheck the trial balance after rule-driven netting
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Netting rules.
  2. Create a record and enter a name and description.
  3. Select a netting sequence.
  4. Select the netting agreement scope: All, or Selected with a list of agreements.
  5. Choose whether to include credit notes and debit notes.
  6. On the Netting criteria FastTab, limit the rule to certain vendors, customers or currencies if needed.
  7. Activate the netting rule.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Netting sequenceThe order invoices are netted in: by due date or by invoice balance.Microsoft Learn By due date - from newest to oldestSequence
Include credit note and debit noteWhether automatic netting includes credit notes and debit notes.Microsoft Learn IncludeCredDebtNote
Netting criteriaLimits the rule to specific vendor accounts, customer accounts or invoice currency.Microsoft Learn
NameThe name that identifies the netting rule.Microsoft Learn MONTHLYName
DescriptionA short description of the netting rule.Microsoft Learn Same-party netting ruleDescription
ActiveWhether the netting rule is active. Activate it before it is used for automatic netting.Microsoft Learn YesActive
Netting agreementWhether the rule covers all active netting agreements or only a selected list of them.Microsoft Learn MONTHLY

Test checklist

  1. Create a rule with a netting sequence, scope Selected with one test agreement, and Include credit note and debit note set as agreed; activate it.
  2. Trigger Automatic netting from Customer and vendor balances netting.
  3. Check on Netting history that the invoices were netted in the chosen sequence.
  4. Add a vendor account criterion that excludes the test vendor and check that the next run nets nothing for it.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Netting rulesWhich netting sequence should automatic netting use?Leaving the rule inactive, or setting the netting agreement scope to All without checking which agreements are active: All includes every active agreement in the automatic run.
Solution architect

5Design impact

Can it be undoneReversible: The rule only drives automatic netting runs; it can be changed or deactivated at any time, and posted netting can be reversed from Netting history.
Technical architect

6Technical

Menu itemCustVendNettingRule Checked in Dynamics 365
FormCustVendNettingRuleForm Checked in Dynamics 365
TableCustVendNettingRuleShown as “Netting rules” in Record infoKey field: RecIdChecked in Dynamics 365
Who can open itPrivilegesMaintain netting rule CustVendNettingRuleMaintainView netting rule CustVendNettingRuleViewDutiesInquire into invoice and cash policies CustInvoiceInvoiceAndCashPoliciesInquirEnable invoice and cash process CustInvoiceInvoiceAndCashProcessEnableInquire into customer payments status PaymCustomerPaymentsStatusInquireInquire into vendor payment status PaymVendorPaymentStatusInquireInquire into invoice and payment policies VendInvoiceInvoicePaymentPoliciesInquirEnable invoice and payment process VendInvoiceInvoicePaymentProcessEnable
18 security rolesAuditor AuditPolicyManagerCollections agent CollectionLetterCollectionsAgentCollections manager CollectionLetterCollectionsManagerChief financial officer CompanyChiefFinancialOfficerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts payable centralized payments clerk PaymAccountsPayableCentralPaymClerkAccounts payable payments clerk PaymAccountsPayablePaymentsClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkRental coordinator agent RentalCoordinatorAgentRental manager RentalManagerAccounts 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 VendInvoiceAccountsPayableManagerAccounting supervisor LedgerAccountingSupervisorRental manager RentalManagerRental coordinator agent RentalCoordinatorAgentAccounting manager LedgerAccountingManagerTo use itAccounts payable clerk VendInvoiceAccountsPayableClerkChief financial officer CompanyChiefFinancialOfficerFinancial controller LedgerFinancialControllerAccountant LedgerAccountantAccounts payable payments clerk PaymAccountsPayablePaymentsClerkGive people one of these roles. On this system, 18 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=CustVendNettingRule
Everyone

8Sources

To cite this step: AP-PAY-040, Set up Netting rules. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/AP-PAY-040