Did you know Dynamics 365 Business Central has a small collections module built right into the solution that allows you to send reminders to customers that are past due?
Scenario
Below is a list of customers in Business Central and their past due balances. Follow along below to see how to setup reminder terms and reminder levels then process reminders that are emailed directly to your customers. In order to email from Business Central you do need to have the SMTP Setup completed as well.
Setup
1. Reminder Terms & Reminder Levels
a. Lookup "Reminder Terms"
b. Enter in information pertaining to how you'd like your reminder terms setup.
c. With the first reminder terms code selected click on Levels on the menu and enter the information pertaining to how you'd like your reminder levels setup.
3. Customer Card > Payments > Reminder Terms Code
a. Within the customer card > payments section populate the Reminder Terms Code field.
Issue Reminders
1. Reminders
a. Lookup "Reminders" From the reminders window you have two options, you can create reminders at a mass level or one by one. I have chosen to do this at a mass level.
b. Select Process > Create Reminders
c. Populate the options section and any filters that you'd like.
d. Reminders will be created based on the reminder terms/levels previously setup.
Opening one of the reminders you can see the lines that were added pertain to the past due invoice and also any additional fees that you setup within the reminder levels window.
2. Issuing Reminders
a. Reminders > Process > Issue
b. Issue Reminders
c. Send Email
Issued Reminders
You can also view all issued reminders that have been processed by looking up the Issued Reminders page. From here you can email or print the reminders as well.
Applying posted credit memos to posted invoices isn't a hard task to complete in Microsoft Dynamics 365 Business Central. The example I use below is for a vendor credit, but the same process applies to customers. Version: US Business Central 20.0 Open up the vendors list. Search for vendor that you'd like to apply the credit memo to an invoice for. Click on Balance field to open up Vendor Ledger Entries window. This will show all the 'open' documents on the vendor ledger. Select the line for the Credit Memo that you want to apply to a posted invoice. Click Process > Apply Entries Within the Edit - Apply Vendor Entries window select the line(s) that you'd like the credit memo applied to. Click Process > Set Applies-to ID This will put the users name into the Applies-to ID field on the line selected. To post the application select Process > Post Application. Written by: Kristen Hosman, Microsoft MVP
I had a client ask me if the Aged Accounts Receivable report could be modified a bit since he was having to modify it manually and it was taking him around 6 minutes each time. As I started discovery on what he wanted I asked him what his requirements were. Aged by = Document Date Length of Aging Periods = 45D Print Detail = Yes Print to Excel = Yes Include a Pivot Table with the following information: Customer name Total balance due Total over 45D due Top 3 customers Percentage of 45D due vs total balance due To get started I asked him to send me a screen shot of the Aged Accounts Receivable options window to verify how he is running the report. I also asked him to send me a copy of the Excel file with his changes in it for me to review. Next Steps Next step was for me to figure out if I was going to have a developer create a custom report or if I was brave enough to try something I've never done before. I went the brave route and started searching through Microsoft Docs fo...
Steps to reverse a bank account transaction or customer payment in this case. Have you ever entered a customer payment and needed to void it out of the system? If so, this blog is for you! Follow the steps below to learn how to unapply a payment and void/reverse the payment. These steps will void the payment and the invoice will remaining outstanding when completed. Open the Bank Account Ledger Entries window and select the line for the transaction in question. ctrl+alt+Q on keyboard to open the Find entries page, or click on find entries on the Action Bar. Click on the Detailed Cust. Ledg. Entry line Select a line that has 'Application' as the Entry Type and then Unapply Entries on the Action Bar Click Unapply Yes OK Close windows until you get back to the Bank Account Ledger Entries page. Select transaction and then Reverse Transaction from the Action Bar. Reverse Yes OK Written by: Kristen Hosman, Microsoft MVP
Comments