Dynamics 365 Business Central – Take Payment Discount on a Payables Invoice that was posted without payment discount

Introduction

When posting a payables invoice in Dynamics 365 Business Central you can specify payment discount that can be taken if the invoice is paid early. You define this using the option below

Please note this can also be defaulted for you onto the purchase invoice from the payment terms on the vendor.

However what happens if the “Payment Discount %” wasn’t entered onto the invoice when it was posted? How can you take payment discount?

Scenario

Lets say I’ve posted an invoice as per below for £100.00 and I wish to take 5%, or £5.00, as a payment discount. (Therefore I should only pay £95.00 and take the £5.00 as discount). However at the time of posting the invoice I didn’t specify a “Payment Discount %’

First create the payment journal selecting the Vendor as per below and click “Apply Entries”. (no need to enter an amount at this point)

Once in the “Apply Entries” window click into “Remaining Pmt. Disc. Possible” and enter £-5.00. Also click into the “Pmt. Discount Date” and change the date to a date after the date of the payment. In my case I’ll change this to 01/11/2020, as my payment date is 31/10/2020

Now when I click “Process > Set Applies-to ID” although it appears to show the full amount being applied, if you look at the foot of page the Payment discount is showing £5.00 and the Applied Amount shows £-95.00

If I click OK this shows the payment amount of £95.00

After I post the payment and check the ledger entries I can see a payment for £95.00 has cleared the full amount of the invoice

Also, drilling down on the “Remaining Amount” of the Payment you can see the additional “Detailed Ledger Entry” for the discount:

So the key things to note are, when applying the invoice ensure you enter the amount of discount you wish to take in the “Remaining Pmt. Disc. Possible” and also change the “Pmt. Discount Date” so its after the date of the payment.

Thanks for reading!

Dynamics 365 Business Central – Posting a Payment Journal with VAT

I came across a situation where a user needed to post a credit card payment via a payment journal with a VAT element so I thought I’d document on my blog 🙂

In order to do this first create a Payment Journal batch with the relevant balancing account, in my case a credit card, and also select the highlighted VAT options below:

** Please note you may have to go to the General Journal Template for Payments and tick these ON before you can select them for the batch.

With the option “Copy VAT Setup to Jnl. Lines” selected, the VAT posting groups will be copied from the GL code and VAT will be calculated.

With the option “Allow VAT Difference” selected, changes can be made to the calculated VAT amounts.

If you only have one G/L expense code to record VAT its fairly simple. You can pickup the relevant G/L code, which should default the “VAT Bus Posting Group” and “VAT Prod. Posting Group”, and the system will calculate the VAT for you. You can then just leave the “Bal Account No.” as the bank account.

Now when you post the entry you will get VAT entries as well as G/L and Bank Account Ledger Entries:

If you wish to record VAT for more than one G/L code you can list the expense codes and blank off the “Bal. Account No” on each line and then have the final line entry as the balancing credit card bank account as per below. (again the VAT posting groups have defaulted from the G/L code)

Now when you post the batch you’ll get the relevant VAT entries as well as G/L and Bank Account Ledger Entries:

If you have the “VAT Difference” option ticked on the batch you can change the “VAT Amount” at any time if this differs from the actual VAT you need to post.

I hope you find this useful if you ever need to post payments with VAT.

Thanks for reading!

Dynamics 365 Business Central – A quick walk through a Payables Payment Run using Payment Journals

Introduction

Over the last few days I’ve been working through a vendor payment run in Dynamics 365 Business Central and thought it useful to document my journey.

In this step by step post I’ll be generating payments using the “Suggest Vendor Payments” feature and then also going through the process of removing an invoice from a payment as you would in real life.

Setup

To keep things simple before I started I created two vendors, V00080 and V00090, and posted a couple of documents on each vendor. I’ll use these as the basis for my walk through.

On the vendor I set the “Payment Method” as “Cheque” as per below (I’ll likely look at another post for EFT\BACS in the future)

Setup of one of the Vendors I created for my walk through

The documents I posted onto the vendors created the following vendor ledger entries which I’ll be working with:

As you can see I have two invoices on vendor V00080 with a total of £180.00 and two invoices and one credit note on V00090 giving a total of £240.00.

Payment Journal

In order to pay these documents I’ll be using the “Payment Journal” which can be found by clicking the search option and typing “Payment Journal”

Once in the “Payment Journal” page the first thing to select is the batch. As you can see I’ve selected one called PAYMENTRUN


If we drill down on the batch you can see it determines the balancing account and also the number series to use. I’ve select “Bank Account” as the balancing account so the system will create “Bank Account Ledger Entries” that I can later reconcile via the bank reconciliation.

Once we have decided on the batch we can turn to creating the payments.

Suggested Vendor Payments

The process that completes the initial swoop looking for transactions to pay based on a set of criteria is “Suggest Vendor Payments”

On clicking “Suggest Vendor Payments” you are presented with the following options

I’ll focus on the ones I’ll be using as part of my payment run for vendors V00080 and V00090

Last Payment Date:- This is the due date cut off. I’m going to set this to 31/07/19 as I don’t want to pay any invoices after this date.

Find Payment Discounts:- I’m going to switch this on because if there are any payment discounts, I want the payments that are created to reflect them.

Summarise per Vendor:- I’m going to switch this on because I only want to create one payment journal entry per vendor rather than one entry per invoice I’m paying.

Posting Date:- I’m going to set this to 14/08/19 as this is the date I’ll be paying the invoices.

Balance Account Type:- I’m going to set this to “Bank Account” as I want the system to create bank account ledger entries so I can reconcile the payment via bank reconciliation.

Bal Account No:- I’m selecting “CHECKING” as this is the bank I’ll be paying from.

Payment Type:- I’m selecting “Computer Cheque” as on this occasion I’ll be printing cheques.

Vendor No:- I’ll be entering a range of V00080..V00090 as I only want to pay those two vendors

Therefore my options are:

When i click OK I get the following payments generated for me.

Now the system has generated the payments we can go ahead and tweak them for what we actually want to pay.

Editing the Payments

As you can see the system has generated a Payment for Vendor V00080 of £60.00 and a Payment for Vendor V00090 of £240.00

To view the invoices that have been applied on the payment you click “Process > Apply Entries”

If I select this option on the payment of £60.00 on Vendor V00080 you can see the invoices applied:

As you can see above the system has applied INV00002 but hasn’t applied INV0001. This is because INV0001 has a due date of 01/08/19 which falls outside of the due date cut off I entered into the “Last Payment Date” field in the “Suggest Vendor Payments” window. I’m happy with this so I’ll click ok and move to the next payment.

If I highlight the payment for Vendor V00090 and click “Process > Applied Entries” I get the following screen:

The first thing to note is the system has included the credit memo on the payment run. This is great and exactly what I’d expected.

Next I’m going to remove INV90001 from the payment run as I’m not ready to pay this Invoice just yet. To do this I’ll highlight the line and click “Process > Set Applies-to-ID”. Doing this blanks out the “APPLIES-TO-ID” field and also sets the “AMOUNT TO APPLY” and “APPLN. AMOUNT TO APPLY” to £0.00 on the invoice as per below

This all seems fine however when you click OK it would appear the payment amount hasn’t been updated on the Payment Journal to reflect the change I made?

It would seem I have to manually update this or the system would still post a payment for £240.00 onto the account. i.e. the posted payment would remain open and there would be an amount remaining of £30.00 on it.

I therefore edit the payment amount on the header to £210.00 to reflect the new payment amount:

Printing the Cheques

To print the cheques you just need to select “Cheque > Print Cheques”

On clicking this option you are presented with the following options:

I’m going to leave all the defaults and click “Print” and select my printer.

After doing this the flag “Cheques Printed” is checked.

Posting the Payments

Once you have printed the cheques and are ready to post you can just click “Post\Print> Post” as per below

This will create the Vendor Ledger Entries and also Bank Account Ledger Entries as our “Balancing Account Type” is set to “Bank Account”.

If I now view the “Vendor Ledger Entries” I can see the payments have been posted and applied to the invoices.

Conclusion

I hope you have found this write up on the payment run useful. I’m sure I’ve left out some options that can be used and being new to the Dynamics 365 Business Central \ NAV world I’d be very interested to hear of other peoples experiences.

Thanks or reading.