Kristen Hosman’s Dynamics 365 Business Central Blog

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 sure you'

Scenario Client was live on Business Central and wanted one specific company moved from one tenant to another. One issue with the Environment Transfers process is that it moves the entire environment from one tenant to another; in other words, you can't select one specific company within an environment to move. Solution After thinking about how I could accomplish this it came to me, copy the Production environment to a Sandbox environment and then complete the Environment Transfer for the new Sandbox environment. Once the new environment is Active then I would copy the Sandbox environment to a Production environment. From there once the Production environment is Active, I would log in and delete the companies that are not needed in this new tenant.  It's important to take installed Extensions into account as well. For example, this client was using Expense Management by Continia. I reached out to Continia's support and they were able to provide a checklist of actions that n

If you're using Purchase Orders (PO) in Business Central and have a receiving process that requires a warehouse team to receive items off a PO then this tip is for you. Within the Purchase Orders list you can personalize to add the column Amount Received Not Invoiced. This will all Accounts Payable and the Purchasing team to know what PO's have been received but not invoiced yet. To learn how to personalize Business Central check out this blog:  Personalizing Screens In Dynamics 365 Business Central (kristenhosman.com) Reconcile AP to GL There is also a report in Business Central called Reconcile AP to GL that can be useful. The name doesn't make sense but the data it provides does.  Search for  Reconcile AP to GL and make sure to bookmark it since it's hard to remember. Filter if needed or just select Print or Preview. Review the two pages. “The AP to GL Reconcile report is a 'point in time' report. It cannot be run for prior days as it gets its data from the

Three-Way matching is an Accounts Payable process that is used to verify a vendors invoice by checking it against its corresponding purchase order and receipt. Three-Way Matching Concept Purchase order - authorizes a purchase. Typically an itemized list of types, quantities, and prices of an order as agreed to by the buyer and supplier. The PO has a unique number to associate this order and should be used by the supplier for tracking and invoicing purposes. Delivery receipt - confirms that the items on the purchase order were delivered. Typically completed by someone in the warehouse. Vendor invoice - lists how much the buyer owes the supplier. Should match the agreed upon purchase order and items received. Three-Way Matching Process Typically this process is handled by an Accounts Payable (AP) user. Vendor invoice is sent to AP and that person verifies the delivery receipt in the system prior to entering the invoice. I will go through the basics of this process. Purchase order is issu

Scenario: Client wants Field Monitoring Setup for Vendor Bank Account (288) table. Tracks when the following fields are changed: Bank Acct No. Transit No. Use for Electonic Payments Vendor Bank Account Card Field Monitoring Setup First step in setup is to complete the Field Monitoring Setup window and Starting the service. For this step I entered the Notification Recipient and the Notification Email Account. You may want this to be someone who specifically tracks the changes in the system. Once you have these fields completed you can click Start on the Action Bar. Field Monitoring Setup When you click Start you will be welcomed with the message Monitoring fields can impact performance. We recommend that you only monitor fields that contain sensitive data. In other words, don't monitor all fields on a table for example, only select the ones that really matter. Field Monitoring Setup Retention Policy Below is the out of the box Retention Policy. Update as needed. Change Log Entry Mon

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