Kristen Hosman’s Dynamics 365 Business Central Blog

Every year you need to update the 1099 form boxes in Microsoft Dynamics 365 Business Central. This year I ran into something interesting. When I tried to schedule the update, nothing happened, and I was left scratching my head as to why. I was able to figure out the issue so sharing with you all in case you run into the same thing. My current Microsoft Dynamics 365 Business Central version is 19.2.32968.33437 1099 Form Boxes I first started in the 1099 Form Boxes window, where I was being told the following: The list of 1099 form boxes is not up to date. Update: 2021. Schedule an update of the form boxes. I immediately click on the link to schedule the update and to my surprise the Job Queue Entry Card was blank. Below on the left is what I was seeing vs the right what I should be seeing. I got to thinking, I just tested this process the other week in my Sandbox environment and it worked so the only difference is that this is my Production environment, and I would've had to sc...

Processing 1099's in Business Central v19.2 If you're not on v19.2 yet, then you may run into issues printing 2021 1099's. See my previous blog on this information. Processing 1099's is pretty easy in Microsoft 365 Business Central. Here are a few pointers: Verify the vendor Name and Address on the vendor card. This is what's going to print on the 1099. Verify vendor IRS 1099 Code and Federal ID No. on the vendor card. Verify that the transactions that should've been coded as a 1099 transaction are. To do this review within the Vendor Ledger Entries window, where you can "Edit List" and update if needed. Search (aka Tell me what you want to do) for 1099 and select 'Vendor 1099 Nec 2021' report.  Calendar Year = 2021 and I always recommend a test print first to make sure everything lines up on the IRS form.  Once you've tested and everything lines up then you can remove the test print toggle and print.  Remember there are other tools to revi...

Every January accountants and CPA's start thinking about 1099's and the deadline is February 1, 2022, per the IRS website .  If you're on Microsoft Dynamics 365 Business Central version 19.1 then you'll have to wait until your environment is updated to version 19.2 to have the tax form updates within the system. If you're not sure what version you're on, then you can check via the Dynamics 365 Business Central admin center or within Business Central's help and support as well.  Those set up as the Notification Recipients should've received an email like below letting them know the update is coming. This email also lets them know if Microsoft has detected any issues, like an extension that isn't compatible with the new version. If there are issue detected, then they must be resolved prior to the update happening otherwise it won't happen.  You can find information on processing 1099's in BC here. Written by: Kristen Hosman, Microsoft MVP

Thoughts As I reflect back on this past year, I am grateful for the amazing #MSDyn365BC community of developers, consultants, and users that I have been able to work with. I am grateful for live events: the hugs, the celebrations of amazing accomplishments, and the breakthroughs. And I'm even more excited about the year before us! Here are my goals for 2022 and my year in review for 2021.  Goals for 2022: Continue helping the #MSDyn365BC community via blogging and speaking at conferences. Continue to pave a path for other Women in Tech. Continue to mentor others in the community. Written by: Kristen Hosman, Microsoft MVP

While attending todays #BCMixItUp I was asked what my thoughts are on SmartLists in Business Central compared to Dynamics GP. I honestly didn't even know that SmartList was available yet in Business Central and you could tell by how the chat blew up that many others didn't know either. We were all searching for it. While searching for it I'm pretty sure I found a bug. If you access a list using a bookmark the SmartList button doesn't show up: In order to find SmartList on a list you need to go to Tell me what you want to do and search from there. Pretty sure this is a bug and hope Microsoft fixes it soon! Now that I know SmartLists are here I'll review and post my thoughts on it soon. Written by: Kristen Hosman, Microsoft MVP

Merging duplicate master records doesn't have to be so scary. In fact, Microsoft Dynamics 365 Business Central has a great tool that makes merging vendors or customers super easy. Once you merge a vendor or customer card all the historical and open transactions are updated and merged together as well. Steps Open the vendor or customer card that you want to keep and then select Actions > Functions > Merge With.  Once the Merge Duplicate window opens, review the information in the Fields table. The information in the Current Value column is what will be the used for the vendor that is kept. If any of the information in the Alternate Value needs to be used, then you can check the Override checkbox. Notice below that I want the Payment Method Code to come over to the merged vendor.  Once you've reviewed, you're ready to merge. Simply click Merge and then Yes.  Written by: Kristen Hosman, Microsoft MVP

If you're not using the Auto Match functionality to reconcile your bank accounts then you're using the "North American" method as Microsoft calls it. This blog outlines the steps to complete the bank reconciliation using this method. I will also post a blog on how to process bank reconciliation using the Auto Match functionality.  1. Search for Bank Account Reconciliations 2. Process > New 3. Select ‘CHECKING’ 4. Update the Statement Date to the date you pulled for and update the Balance on Statement to be the ending balance for that day. 5. Process > Suggest Lines 6. Both > OK 7. Proceed with checking off the items cleared bank within the ‘Checks’ and ‘Deposits/Transfers’ sections of the Bank Rec. Worksheet. 8. Once you’ve checked everything off there may be some misc items you couldn’t find to check off. Those items will need to be investigated to see why missing from Business Central. Once you’ve entered them into the system you can go back into the Bank R...