BeyondERP.Newsletter
Menu

Setup page · Accounts receivable

Netting agreements

Netting agreements hold the pairs of customer and vendor accounts that can be netted during an effective time period.

Used by
Accounts receivable clerk, Accounts receivable 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
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isNetting agreements hold the pairs of customer and vendor accounts that can be netted during an effective time period.
What you do hereUse this page to set up and activate agreements with the netting journal name, bridging main account, financial dimensions and customer-vendor pairs before netting transactions are created.
ExampleCreating an intercompany netting agreement where the customer and vendor are in different legal entities, after allowing intercompany netting in Cash and bank management parameters.
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.

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 meansTable column
Customer legal entityFor intercompany netting, the legal entity of the customer account.Microsoft Learn CreditCompany
Vendor legal entityFor intercompany netting, the legal entity of the vendor account.Microsoft Learn DebitCompany

Test checklist

  1. Create a journal name of type Customer and vendor netting and a bridging main account.
  2. Create an agreement with that journal name and main account, add a customer and vendor pair on the Parties FastTab, and activate it.
  3. On Customer and vendor balances netting, select the pair, select Create netting, mark an open customer invoice and vendor invoice and post.
  4. Check that both invoices are settled for the smaller of the two balances and that the netting journal has two lines.
  5. Open Netting history, select Reverse netting and check that both invoices are open again.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Feature management and licence

Feature to turn onCustomer and vendor netting (Mandatory, on by default)

Microsoft Learn

Solution architect

5Design impact

Can it be undoneHard to reverse: The agreement itself can be edited, but netting already posted under it is only undone with Reverse netting on the Netting history page, which unsettles the customer and vendor invoices and reverses the netting journal. Microsoft Learn
If you change it laterFor intercompany agreements, each netting posting creates three vouchers: two in the legal entity that holds the agreement and one in the other legal entity. 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 itRental manager RentalManagerAccounts receivable manager CustInvoiceAccountsReceivableManagerRental coordinator agent RentalCoordinatorAgentCollections manager CollectionLetterCollectionsManagerAccounting supervisor LedgerAccountingSupervisorTo use itAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable payments clerk PaymAccountsReceivablePaymentsClerkAccounts receivable centralized payments clerk PaymAccountsReceivableCentralPaymClerkFinancial controller LedgerFinancialControllerAccountant LedgerAccountantGive 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