Posts

Creating a Bank Deposit in Microsoft Dynamics 365 Business Central

Image
How to create a Bank Deposit in Microsoft Dynamics 365 Business Central. Bank Deposit Look up Bank Deposits Click on New Populate the following fields in the General FastTab: No.: will generate from the No. Series setup. Click on the ellipsis to get this to populate or hit tab on your keyboard to move to the next field to activate it.  Bank Account No.: select the bank account you'd like to process the deposit for.  Total Deposit Amount: total of all checks you're going to include in the deposit. Posting Date: date you want the deposit to hit the general ledger. Post as Lump Sum: this allows you to post the bank deposit as one lump sum. For example, if you have four checks and they add up to $50,000 and you're going to deposit them at the same time so within your bank account it shows one deposit amount for the total then you sure turn this on. If you expect the four checks to show separately within your bank account, then leave it turned off.  Document Date: I recommend th

Bank account linking in Microsoft Dynamics 365 Business Central

Image
Microsoft Dynamics 365 Business Central allows you to import electronically your bank statements from your bank so you can quickly fill in the Payment Reconciliation Journal page and bank account reconciliations.  Navigate to Bank Accounts window. Select bank account and then click on Bank Statement Service > Link to Online Bank Account You will be prompt to enable Envestnoet Yodlee Bank Feeds Service if you've never enabled it before. Review the terms and conditions and accept. Review and Accept the Envestnet Yodlee Bank Feeds - Terms of use. Click Close once you've accepted the terms of use (toggle). Search for bank and select the one with the correct URL for your bank. Enter in your information that you use when you log into your banks website. Click Submit. Once connected to your bank you will see a list of your accounts that will be included to being linked in Business Central. You can uncheck any accounts you don't want linked as well. Click Save & Finish or OK

Dynamics 365 Business Central 2022 release wave 2 preview - things I'm excited for

Image
I thought I'd share some things that I'm excited about in the new Dynamics 365 Business Central 2022 release wave 2 coming in Oct 2022. To learn more about all the things planned by Microsoft check out this page:  New and planned features for Dynamics 365 Business Central, 2022 release wave 2 | Microsoft Docs . Switch companies across environments You can now from any environment or company switch companies across environments. This is such a timesaver and the way it looks in the user interface is really nice.  Switch companies across environments | Microsoft Docs Better bank reconciliation for checks I found some updates to the Bank Account Card which are going to affect the bank reconciliation process. Also see that there is a Payment Reconciliation No. Series added.  Better bank reconciliation for checks | Microsoft Docs Actions/Menus throughout Posted Bank Statement Report Financial Reporting replaces Account Schedules Financial reporting replaces account schedules | Micros

Setting up Sales and Use Tax in Microsoft Dynamics 365 Business Central

Image
What is a tax jurisdiction and tax area? There are two major steps to setting up sales and use tax in Business Central. The first is tax jurisdictions and the second is tax areas. A tax jurisdiction is a city, county, state, or other special tax that requires taxes within its limits. A tax area is a physical area, and each area can be assessed taxes by different jurisdictions.  Tax Jurisdictions You're going to want to setup a new jurisdiction per city, county, state, or other special tax. I'm going to use zip code 80470 for an example. I pulled the following information from online and it shows that for zip code 80470 there are four jurisdictions totaling 4.5% sales tax.  Source:  80470 Sales Tax Rate (2022) - Avalara Setting up Tax Jurisdictions in Business Central Search for tax jurisdictions Click on +New Complete the information in the new row. In this case I left Default Sales and Use Tax percentage as 0 since I have several tax groups codes setup. Select the line and the