Posts

Processing 1099's in Business Central v19.2 for 2021

Image
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

Processing 2021 1099's in Dynamics 365 Business Central update

Image
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

2021 Year in review

Image
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

SmartLists are in Microsoft Dynamics 365 Business Central

Image
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

Merge duplicate vendors or customers in Microsoft Dynamics 365 Business Central

Image
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

Bank reconciliation "North American" method in Microsoft Dynamics 365 Business Central

Image
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

Bank Reconciliation - auto match v19 Microsoft Dynamics 365 Business Central

Image
Just completed my first bank reconciliation in V19 #MSDyn365BC and there are some nice updates to the Bank Account Reconciliation if you're using auto match. 1. Transferring to General Journal now only does the transaction you have selected in the Bank Statement Lines pane. Tip: select all lines prior to transferring and then they all will come over, rather than doing one at a time. If you select all lines only those not matched will come over. 2. Once you post the General Journal and close the window the system takes you back to the Bank Acc. Reconciliation window and automatically matches the transactions just entered in the General Journal ...nice improvement and less clicks now to reconcile. Written by: Kristen Hosman, Microsoft MVP