[How to] Create Bank Cheque Number allocation as per the Cheque Books shared by Bank

Dear Microsoft Dynamics 365 Community,

Welcome to my next blog on Bank Cheque Number generation in Microsoft Dynamics 365 Finance and Operations.

Business Scenario

1. A very common approach is to print only the pre-printed cheque numbers in the cheque book, which was allocated to Business by Bank.
2. Other approach is to print cheque numbers as per system defined, however this also can be modified, but system won’t generate allocation of numbers as per cheque books allocated.

Difference between 1 and 2 scenario is- in Scenario 1 company will only print cheque as per the number allocation in the cheque books and once the number is ended up, system won’t print any extra number, user need to allocate numbers again as per their new cheque book allocated by Bank.

On the flip side- in scenario 2 system wont complain anything and continue to print as per the number sequence.

Lets explore this in Dynamics 365

Configurations

Scenario 1

Example- An Indian Company was allocated their cheque numbers from 700000 to 700090 for State Bank of India, hence company wants Dynamics to understand this logic and allocate only from 700000 to 700090 numbers for that bank and once the up to 700090 is generated, system wont print any numbers after that and rather will notify users.

Navigate to Cash and Bank Management Module-> Bank Accounts-> Bank Accounts-> Setup from action pane-> Layout-> Cheque

The below form will open, now navigate to cheque number method-> there are two options

1. Fixed- This is as explained, required for our scenario 1, where cheque number has to be allocated as per bank cheque books
2. Free- This is as explained, required for scenario 2, there will be no allocation, user can modify, print any cheque numbers as per their wish

Now for scenario 1 we have selected Cheque number method as “Fixed”

Navigate to Manage payment for the same Bank account-> Related information -> Cheques

The below form will open-> Create Cheques

Now create the Cheque allocation as follows

The configurations are done for scenario 1

Let’s test

We have generated 90 cheques for that bank we have configured the cheque number allocation

Now- While generating the cheque, system wont allow to create any payment and rather there will be error by saying, there is no more cheque, because business already used upto the highest limit of the number allocation we have done.

Tp proceed with new cheque number number allocation, Consultant need to configure the cheque allocation numbers once again as per the new cheque book was allocated by Bank, same process explained above has to be followed.

The Scenario 1 is completed

Scenario 2

 Other approach is to print cheque numbers as per system defined, however this also can be modified, but system won’t generate allocation of numbers as per cheque books allocated.

 For this scenario, we just need to change the Cheque Number Method to= "Free"

The Configurations are done

Lets check how to generate the number for scenario 2

While generating payment from payment journal, user can themselves add the number in the from tab and generate, it will print the same number.

Note- as explained earlier, this is only advisable, when company does not follow to print the preprinted cheque numbers.

This is it for this blog, I hope this blog will help you to enhance your knowledge in Dynamics.

 Stay tuned for next article, take and have fun