BeyondERP.Newsletter
Menu

Setup step on the Checks page · Cash and bank management

Reverse, delete or void checks

Reverse posted checks, delete unused checks and void unposted checks on the bank account's check list.

Used by
Accounts payable manager, Chief executive officer, Chief financial officer and 7 more roles
Business process
Cancel supplier payments with Dynamics 365 Finance
Menu item
BankChequeTable
Main table
BankChequeTable
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 isThe list of checks for the company's bank accounts with their status, where posted checks are reversed and unused checks are deleted or voided.
What you do hereUse this page to reverse a posted check that was paid in error or lost, to delete checks that were created but never used, and to void unposted checks that can't be used, for example after a misprint.
ExampleFor example, check 1045 for 2,300.00 to a vendor is lost in the mail. Its status is Paid, so you select Payment reversal with reason LOST; the vendor invoice is open again and a new check can be issued.
Checks 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.

Setup steps on this page

Reverse, delete or void checks

Reverse posted checks, delete unused checks and void unposted checks on the bank account's check list.

Steps from Microsoft

  1. On Cash and bank management parameters, check whether Use review process for payment reversals is Yes or No.
  2. Go to Cash and bank management > Payment reversals > Checks and select the check. Only a check with status Paid can be reversed.
  3. Select Payment reversal, then enter the date and a reason. The financial reason must be set up for both the Bank and Vendor types.
  4. If reversals are reviewed, select a journal name so the reversal goes to Check reversals; otherwise it posts at once.
  5. After posting, check that the status is Cancellation and the vendor payment is unsettled from the invoice.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
StatusShows where the check is in its life: for example, Created for checks not yet used, or Paid for posted checks that can be reversed.Microsoft Learn PaidChequeStatus
Include checks without datesShows checks that have no date yet, such as checks with status Created. Turn it on when you count the checks still available for a bank account.Microsoft Learn
Reconcile (on Payment reversal)If selected during the reversal, the reversed check is marked as reconciled and doesn't appear on Account reconciliation.Microsoft Learn

Common errors and fixes

MessageWhat to do
No more checks for accountThe bank account uses the Fixed check number method and has fewer checks with status Created than the payment journal needs. On Bank accounts, select Set up > Check numbers and create more checks, then generate the payments again. Microsoft Learn
The check can't be reversed because it is clearedFrom 10.0.39, check reversal isn't allowed if the original check is marked as cleared. Undo the reconciliation first or record the correction another way. Microsoft Learn
Payment reversal asks for a reason that isn't in the listThe financial reason must be set up for both the Bank and Vendor types. Microsoft Learn

Test checklist

  1. Pay a vendor invoice by check from a test bank account and post the payment journal.
  2. On this page, select the check (status Paid) and select Payment reversal with a date and reason.
  3. With review off, check that the status is Cancellation and the bank balance rises by the check amount.
  4. Open the vendor transactions and check that the invoice is open again.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Reverse, delete or void checksUse review process for payment reversals = Yes, with a Bank check reversal journal name, and financial reasons set up for both Bank and Vendor.Learn names the two methods: immediate reversal or review in the check reversal journal. With review, a second person approves the reversal before the vendor invoice reopens.Should check reversals be reviewed before posting?Trying to delete or void a check that is already posted. A Paid check can only be reversed; delete works only for Created checks and void only for unposted checks.Test: Reverse a paid check

Feature management and licence

Licence or add-inIn this system 10 roles can open this page, among them Chief executive officer, Chief financial officer, Accounts receivable manager and Accountant.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: A posted reversal can't be undone; issue a new payment if needed.
If you change it laterOnly posted checks with status Paid can be reversed; checks can be deleted only while Created, and only unposted checks can be voided. A posted reversal increases the bank balance, unsettles the vendor payment and posts to the ledger. From 10.0.39 a check that is marked as cleared can't be reversed. Microsoft Learn
Technical architect

6Technical

Menu itemBankChequeTable Checked in Dynamics 365
FormBankChequeTable Checked in Dynamics 365
TableBankChequeTableShown as “Check table” in Record infoKey field: AccountID, ChequeNumChecked in Dynamics 365
Who can open itPrivilegesMaintain bank account checks BankChequeTableMaintainView bank account checks BankChequeTableViewDutiesEnable bank management process BankBankManagementProcessEnableInquire into bank management reference data BankBankMgmtReferenceDataInquireInquire into customer positive payments PaymCustPositivePayInquireInquire into vendor positive payments PaymVendPositivePayInquire
10 security rolesChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerAccounts receivable manager CustInvoiceAccountsReceivableManagerAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts payable positive payment clerk PaymPositivePaymentClerkTreasurer PaymTreasurerAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itTreasurer PaymTreasurerAccountant LedgerAccountantTo use itChief financial officer CompanyChiefFinancialOfficerAccounting manager LedgerAccountingManagerFinancial controller LedgerFinancialControllerAccounting supervisor LedgerAccountingSupervisorAccounts receivable manager CustInvoiceAccountsReceivableManagerGive 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=BankChequeTable
Data migrationLoad order: The checks list has no data entity in Data management, so it can't be loaded from a file or a configuration template. Checks are created from the bank account (Set up > Check numbers) and by payment journals. At go-live, create the check numbers for each bank account and bring outstanding checks in with the opening bank balance.Checked in Dynamics 365
Table definitionBankChequeTable columns and relations Microsoft data model
Everyone

8Sources