BeyondERP.Newsletter
Menu

Setup step on the Netting agreements page · Accounts payable

Set up Netting agreements

Defines the customer and vendor account pairs, netting journal name, bridging main account and dimensions used to net balances for an effective period.

Used by
Accounts payable clerk, Accounts payable manager, Auditor and 15 more roles
Business process
Use netting agreements to settle customer balances with vendor balances in Dynamics 365 Finance
Menu item
CustVendNettingAgreement
Main table
CustVendNettingAgreement
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 agreement maintains the pairs of customer accounts and vendor accounts that can be netted during an effective time period.
What you do hereUse this page to set up and activate the agreement (journal name, bridging main account, financial dimensions, customer/vendor pairs) that must exist before netting transactions are created; it also supports intercompany netting.
Netting agreements 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 agreements8 screens

Defines the customer and vendor account pairs, netting journal name, bridging main account and dimensions used to net balances for an effective period.

  1. Screen 1

    Create the netting agreement

    Go to Accounts payable > Payments > Netting > Netting agreements

    1. Select New and enter the Name and Description
    2. In the Parties section, select Add line
    3. Enter the customer, the vendor and the date range
    1NameBEAT-NET
    DescriptionSame-party netting
    Customer accountBEAT-000001
    Vendor accountBEAT-000001
    Start date10/7/2026
    To date12/31/2026
    Create the netting agreement (zoomed on the outlined fields)
    Show the full screenCreate the netting agreement
    page title tab to open what to set or check
  2. Screen 2

    Set up the netting journal name

    Go to General ledger > Journal setup > Journal names

    1. Select New and enter the Name and Description
    2. Set Journal type
    3. Set Voucher series and Posting layer
    1Journal typeCustomer and vendor netting
    2Voucher seriesAcco_116
    3Posting layerCurrent
    4NameBEAT-NET
    Set up the netting journal name (zoomed on the outlined fields)
    Show the full screenSet up the netting journal name
    page title tab to open what to set or check
  3. Screen 3

    Link the journal and activate the agreement

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

    1. Select the BEAT-NET agreement
    2. In the General section, set Journal name and Account
    3. Select Activate
    1Journal nameBEAT-NET
    2Account110100
    3StatusActive
    Link the journal and activate the agreement (zoomed on the outlined fields)
    Show the full screenLink the journal and activate the agreement
    page title tab to open what to set or check
  4. Screen 4

    Run the netting and confirm the balances cleared

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

    1. Select Create netting for the BEAT-NET agreement
    2. Set Show to Cleared

    Check BEAT-NET appears in the Cleared list with customer BEAT-000001 and vendor BEAT-000001 both at an open balance of 0.00 USD.

    Run the netting and confirm the balances cleared (zoomed on the outlined fields)
    Show the full screenRun the netting and confirm the balances cleared
    page title tab to open what to set or check
  5. Screen 5

    Review the netting history

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

    1. Select Netting history
    2. Expand journal batch BEAT-000008

    Check Batch BEAT-000008 for agreement BEAT-NET, dated 10/7/2026, shows customer BEAT-000001 at -100.00 and vendor BEAT-000001 at 100.00 USD.

    Review the netting history (zoomed on the outlined fields)
    Show the full screenReview the netting history
    page title tab to open what to set or check
  6. Screen 6

    Check the trial balance after netting

    Go to General ledger > Inquiries and reports > Trial balance

    1. Open the Trial balance
    2. Find main account 110100 and the totals

    Check Account 110100 shows debit 720.00, credit 1,120.00 and closing balance -400.00, and the totals are debit 8,040.00 and credit 8,040.00 with balance 0.00.

    Check the trial balance after netting
    page title tab to open what to set or check
  7. Screen 7

    Reverse the first netting

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

    1. Select Netting history
    2. Select the BEAT-000008 rows
    3. Select Reverse netting

    Check The BEAT-000008 rows for BEAT-NET (customer -100.00, vendor 100.00 USD, 0 contained invoices) show Status Reversed.

    Reverse the first netting (zoomed on the outlined fields)
    Show the full screenReverse the first netting
    page title tab to open what to set or check
  8. Screen 8

    Check the trial balance after reversal and re-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 reversal and re-netting (zoomed on the outlined fields)
    Show the full screenCheck the trial balance after reversal and re-netting
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to Netting agreements.
  2. Create a record and enter a name and description.
  3. Select the netting journal name.
  4. Select the main account to use as the bridging account.
  5. Select the financial dimension values.
  6. On the Parties FastTab, add a vendor account and a customer account as a pair.
  7. Activate the netting agreement.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Journal nameThe journal, of the Customer and vendor netting type, used to post netting.Microsoft Learn NettingJournalName
Main accountThe bridging account used for netting.Microsoft Learn
Customer legal entityFor intercompany netting, the company of the customer in the pair.Microsoft Learn CreditCompany
NameThe name that identifies the netting agreement.Microsoft Learn MONTHLYName
DescriptionA short description of the netting agreement.Microsoft Learn Same-party nettingDescription
Customer accountThe customer account in the customer and vendor pair that is netted.Microsoft Learn BEAT-000001CreditAccountNum
Vendor accountThe vendor account in the customer and vendor pair that is netted.Microsoft Learn BEAT-000001DebitAccountNum
Start date10/7/2026StartDate
To date12/31/2026ExpireDate
AccountThe financial dimension values used when the netting journal is posted.Microsoft Learn 110100LedgerDimension
StatusWhether the netting agreement is active. It must be activated before netting transactions can be created.Microsoft Learn ActiveAgreementStatus

Test checklist

  1. Create a Customer and vendor netting journal name and a bridging main account.
  2. Create an agreement with one customer and vendor pair, select the journal name and main account, and activate it.
  3. On Customer and vendor balances netting, select the pair, choose Create netting, select one open invoice on each side and post.
  4. Check that the netting amount is the smaller of the two balances and that both invoices are settled by that amount.
  5. Use Reverse netting on Netting history and check that both invoices are open again.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Netting agreementsA journal name of type Customer and vendor netting and a dedicated bridging main account, then one active agreement per customer and vendor pair that is the same partyThe netting journal is posted automatically, so the journal name and bridging account must exist before the agreement, and only active agreements can be netted.Should netting stay inside one legal entity or also net intercompany balances?Running netting after the payment run. Transactions already included in a payment journal aren't netted, so net first, then create the payment journal for the remaining amounts.Test: Manual netting through an agreement
Solution architect

5Design impact

Can it be undoneReversible: The agreement can be changed for later netting runs. A posted netting can be reversed from Netting history with Reverse netting, which unsettles the invoices and reverses the netting journal.
If you change it laterEach intercompany netting posting creates three vouchers: two in the company that holds the agreement and one in the other company. Microsoft Learn
Technical architect

6Technical

Menu itemCustVendNettingAgreement Checked in Dynamics 365
FormCustVendNettingAgreement Checked in Dynamics 365
TableCustVendNettingAgreementShown as “Netting agreement” in Record infoChecked in Dynamics 365
Who can open itPrivilegesMaintain netting agreement CustVendNettingAgreementMaintainView netting agreement CustVendNettingAgreementViewDutiesInquire 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 pageButtons: Deactivate, Activate, Netting overviewChecked in Dynamics 365
Developer

7Developer

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

8Sources

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