Paul is a valued member of our support team, providing technical support to our customers for Microsoft Dynamics NAV and Dynamics 365 Business Central across all of the functional areas.
Payment Registration in Business Central
In this blog we will look at the Payment Registration function as an alternative to the Cash Receipts Journal for Sales/Customers and the administration functions that are used. As you are probably already aware there are numerous different ways in Dynamics 365 Business Central to fulfil the same task. The usual and most frequently used method of processing manual payments from Customers is to use a Cash Reeicpt Journal then we use the Apply Entries function to manually attach the payments. In this blog, we will look at the benefits of the relatively new Payment Registration tools, and how to set it up and use it.
Using Payment Registration in Business Central
You can use the Payment Registration process which will also result in an equivalent posted Cash Receipt Journal entry, but as you will see, this requires less effort for the user and less data entry.
And another advantage is the option to post your payments individually or as lump sum, making Bank Reconciliation against Statements so much easier.
The main steps to use payment registration
There are 4 Main Steps to use the Payment Registration function as below:
- Set- Up - Enter the default journal batch and balancing account in Setup.
- Allocate your Payments against the List of Documents
- Post your Payments against the specified list of Documents
- Check that you now have a Journal entry indicating your Payment
Payment Registration in Detail
So let’s look this in more detail and see how this can work for your Company and the benefits your Company can gain from using this functionality, along with how it aligns with the other Finance relationships Business Central has to offer.
Fill this in as below:
Allocate your Payment’s
You can allocate your payments by using the tick boxes as below, so for a large Remittance Advice you can filter by Company and just tick the applicable transactions.
Post your Payment’s
You can either do this as Lump Payment which will give you one Bank Ledger Entry or individually which will give you two Bank Ledger Entries ..
Check your Journal Posting
Here you can see the individual method with 2 Bank Ledger Entries for each line
Or as a Lump Sum Payment with 1 Bank Ledger Entry, ,the benefits of using the Lump Sum method is it will make it far easier when you come to do your Bank Reconciliations.
Business Central Relationship Alignment
Now we can see how this aligns in the system with the 4 Main Functions.
You can see that the entries have all been applied as Normal and your Customer Ledger has been updated to show the transactions as “Closed” as below..
You have an entry on your Bank Ledger either one line or multiple depending on your posting as below..
And as you can see all applicable General Ledger postings have been made just exactly the same as you would get with Cash Receipt Journal posting as below..
And then finally as you can see the Bank Reconciliation will pull in your “Open” Bank Ledger entries and make it far easier to reconcile your Statements, this is because mostly Remittance Advices will contain the full amount paid to your bank, so if you use the Remittance Advices when using the Payment Registration function, then this will align with what you have on your Bank Statements, making it much easier to use the “match automatically” function to clear as may entries as possible if not all of them.
Summary of benefits
So in summary the Payment Registration function will give greater benefits to your company and these are listed below:
- Less Data Entry and easier functionality
- Quicker and easier registration of Remittance Advices
- Full Relationship diversity with other parts of Business Central Finance module
- Bank Reconciliations take less time and are less complex to reconcile
- Less time spent on menial or prohibitive tasks by your users will mean greater productivity for your Company.
I find their approach to our relationship very professional whilst being refreshingly realistic. We now consider them to be part of our teamTechnical Director, Bainbridge International