Kristen Hosman’s Dynamics 365 Business Central Blog

If you're billing customers monthly or annually for subscriptions or services, and posting those invoices to a deferred revenue account, you know how quickly the manual steps can add up. I'm always looking for ways to streamline repetitive tasks inside Business Central and this is a great example of where a little setup can go a long way. The Scenario Business Central user asked: "We’re using Recurring Sales Lines to streamline invoicing. Is there a way to add a deferral code so that amortization of deferred revenue happens automatically?" Great question and the answer is yes. How It Works I tested this in Business Central and it worked as expected. Here's how to set it up: ✅ Step 1: Set the Default Deferral Template on the G/L Account Head over to your Chart of Accounts and find the revenue account you’re using for deferred income. On the G/L account card, there’s a field called Default Deferral Template, populate that with the appropriate template for your reven...

When new clients approach me for support after their Dynamics 365 Business Central go-live, it's often because their initial implementation didn’t go as smoothly as planned. They may have been left with systems that don’t fully meet their business needs, or they’re encountering unexpected challenges that disrupt their operations. These businesses are seeking expertise to help them overcome these hurdles, optimize their setup, and finally achieve the efficiency and productivity they were aiming for when they first chose Dynamics 365 Business Central. My role is to step in, diagnose the issues, and guide them towards a solution that aligns with their goals. I'm about to discuss three prevalent issues I frequently encounter with new clients that were onboarded by another partner. Here we go. Subledgers are not balancing to the general ledger. This includes bank accounts, accounts receivable, accounts payable, and inventory. The primary issue arises when direct posting is enabled ...

Scenario User posted a cash receipt with the wrong posting date.  Issue The issue here is that the allow posting to/from settings in the general ledger setup window wasn't setup, so a user was allowed to post into the future.  Below shows what the cash receipts journal showed.  And the message the user got when posting that they clicked yes on. Resolution Navigate to the Detailed Customer Ledger Entries page and filter or search for the payment. Select the line for the payment.  If you try to Unapply Entries from the Detailed Customer Ledger Entries page, you will be welcomed with this message. Stupid I know that you can't unapply this way.  Instead click on Find entries on the action bar. Then click on the Detailed Cus. Ledg. Entry line to open the Detailed Customer Ledger Entries page. Select the Application line and then select Unapply Entries on the action bar. Click Unapply then OK. Next go back to the Find Entries page and select the Bank Account Ledger En...

Like many other Microsoft products, there are several ways to accomplish a task. I was asked today by a client how to enter customer payments into Dynamics 365 Business Central (BC) and typically I would say a Cash Receipt Journal or a Bank Deposit, however I recently learned about the Register Customer Payments functionality and moving forward this will be my go-to process for entering customer payments into BC.  If you'd like to learn about the Cash Receipts Journal and Bank Deposit methods check out these two blogs: Creating a Bank Deposit in Microsoft Dynamics 365 Business Central Cash receipts journal vs bank deposit in Microsoft Dynamics 365 Business Central Now moving forward with the Register Customer Payments method.  Search for Register Customer Payments and make sure to bookmark it for quicker access in the future.  If it's the first time opening this in your company, you will be welcomed with the Payment Registration Setup window. You will need to make su...

It's standard practice in accounting to "lock" down closed or future periods to prevent users from posting. Within Dynamics 365 Business Central you have what I call a company setting and a user setting. The company setting affects all users within the company, I refer to this as the "rule" and the user setup allows you to make an exception to the rule.  General Ledger Setup Within the General Ledger Setup window, you have the Allow Posting From and Allow Posting To fields. I often recommend to users that you want to populate these fields with the current account period to restrict users from posting in the wrong period. You also have the option to set dates for the Deferral Postings as well. Keep in mind that the deferral dates may be different than the standard posting dates because you're more than likely posting into the future for the deferrals.  The General Ledger Setup is what I refer to as the "rule." User Setup If you need an exception to ...

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