Vendor Payment Discounts and Payment Terms in Microsoft Dynamics 365 Business Central

By -

Scenario: you have a vendor that offers a 2% discount on the net amount if they pay the invoice in full within the first ten (10) days of the invoice date. Otherwise, the full invoice amount is due in 30 days without the discount. 



System Configuration

Within Business Central you will want to set up a new Payment Terms Code for this specific payment term. 
  1. Search for Payment Terms
  2. Click New to add a new line
  3. Update to reflect the information below


Once the Payment Term is set up you can assign this to a specific vendor by opening up the Vendor Card and assigning.
  1. Open Vendor Card
  2. Add Payment Terms Code to the Payments section of the Vendor Card



Verify that the Vendor Posting Group has the correct G/L Account listed for the Payment Discounts. 
  1. Open the Vendor Posting Groups
  2. Review or update the Payment Disc. Debit Acc. and Payment Disc. Credit Acc. fields with the correct Payment Discounts G/L Account. In my system account 68290 is set up for Purchase Discounts. 



Processing

Now that the configuration is completed let's walk through the steps of creating a vendor and payment with the new payment terms.
  1. Create new Purchase Invoice for vendor. The Payment Terms will default to what is set up on the vendor. Review and post invoice.





  2. Next add the vendor payment to the Payment Journal. In this case I'm going to select this vendor invoice to be paid. You can see that I'm only paying them $4,900 because the system calculated a $100 discount. 



    If I go a step further and do a Preview Posting I see that the G/L is being hit three (3) times. 


    Drilling into that entry I see $100 going to my Purchase Discounts G/L Account that was set up in the Vendor Posting Group. 


    At this point everything looks good so I can continue with processing the payment and then post the Payment Journal. 

    Written by: Kristen Hosman, Microsoft MVP


     

Comments

Post a Comment

Popular posts from this blog

Microsoft Dynamics 365 Business Central: adding new licensed users to BC

By -
Image
Adding a new licensed user isn't hard to do within Business Central (BC).  Prerequisite: license is purchased and available to assign to user. You also must be an Internal Admin or have proper security within BC to complete these tasks.  Microsoft 365 admin center Assign BC license to user. Dynamics 365 Business Central Navigate to Users page. Select Process > Update users from Microsoft 365 Update users from Microsoft 365 > Next Update users from Microsoft 365 > Next Update users from Microsoft 365. Review the updates within this window and click finish. Lastly assign user group or permission sets and assign company access.  Version: US Business Central 22.1 (Platform 22.0.58213.0 + Application 22.1.55890.56216) Written by: Kristen Hosman, Microsoft MVP
Read more

Invited External Accountant in Dynamics 365 Business Central now what?

By -
Image
This blog describes what comes next after you invite an External Accountant. If you need to invite an External Accountant than visit this blog:  Invite External Accountant in Dynamics 365 Business Central (kristenhosman.com) You've invited an External Accountant now what? What happens after you've successfully invited an External Accountant? You receive the below message in Dynamics 365 Business Central and your external accountant receives an email.  Steps your External Accountant should take Have your external accountant look for an email with a subject line: You have been invited to Microsoft Dynamics 365 Business Central. The external accountant should click on the link provided in the email. They will be redirected to a Microsoft sign in window. In my case the external accountant email isn't listed so I'm going to select use another account. Enter email. Next window suggests that a code was sent to email. Go pull code from email and enter into next window. Accept t
Read more

Dynamics 365 Business Central - Is this a feature or a bug? Filtering and posting General Journal lines

By -
Image
This blog is inspired by something I just learned from James Bowles .  Scenario: I have a General Journal with multiple lines and only want to post certain transactions/lines.  In my example I am going to filter on the Posting Date field so only the 04/30 transaction is posted. Once the posting is completed you will see the remaining lines in the journal.  Review the General Ledger Entries and you see only entry posted was the 04/30. Written by: Kristen Hosman, Microsoft MVP
Read more