Sorting, Searching, and Filtering in Microsoft Dynamics 365 Business Central
Get link
Facebook
X
Pinterest
Email
Other Apps
-
I get the question a lot from my clients moving from Microsoft Dynamics GP to Microsoft Dynamics 365 Business Central if SmartList exists. For those of you who are not familiar with SmartList it is a tool that allows users to sort, search, and filter data within the system for reporting purposes. While "SmartList" as we know it doesn't exist, Business Central does have very similar qualities within the system that allows users to do the same, it just looks and feels different.
Lets take a look at how this functionality works within Microsoft Dynamics 365 Business Central.
Scenario:
It's month end and you're reviewing financials and see that travel is a bit high for the month. You want to pull detailed information and see what was coded to the travel expense account. You have two options:
Pull a detail trial balance - this process can be clunky as you have to add a filter for the account number and date range within the report options window. And then if you want to change the date or account number to search again it becomes a lot of work just to get what you need.
Filter within the General Ledger Entries window - this process is so much faster than option 1 and it also allows you to save "Views" for future use, which makes the process even faster.
Filter Pane
Just look for the filter icon within the View Controls area and then the Filter Pane will appear to the left of the window. TIP: If you want to hide the filter pane just click on the filter view control as well.
Once the filter pane is open, identify the column in which the account number is in. Hover over the G/L Account No. column and click on the drop down icon and select Filter. By doing this the G/L Account No. filter will now show within the filter list by section of the filer pane. Go ahead and now populate the G/L Account No. filter with the account number for Travel Expenses. You will notice once you have the account number in there and move out of the field by either clicking out or hitting the tab key your list will refresh and now your list is filtered by the account number you entered.
The next step is to filter by a date range for the month in question. Same steps as above, find the posting date column and click on the drop down icon and select Filter. For my example below I'm looking for transactions within the month of November 2019.
You now have a detailed list of all the transactions that hit the travel expense account for the month of November 2019. From here you can filter more or you can export the list to Excel (with the right user security). To export to Excel just click on Page > Open in Excel and your filtered report will open in Excel.
Views
Saving your filtered list as a View allows you to access the same filtered list over and over without having to recreate it every time. To save as a view, simply get your filtered list created and then click on the ellipsis button or the save button to the right of the All view.
Name the View something that makes sense to you. In my case I used Travel Expense. Moving forward now I can just just click on the Travel Expense View and then update the dates as needed for future months when I need to pull the same report. You can also save any modifications to the view once it's made as well when you add, remove, or update filters later on.
Ideas
Vote for this idea on the Microsoft Ideas page to have Microsoft add functionality to allow a user to save a view as the default view when the page opens.
Applying posted credit memos to posted invoices isn't a hard task to complete in Microsoft Dynamics 365 Business Central. The example I use below is for a vendor credit, but the same process applies to customers. Version: US Business Central 20.0 Open up the vendors list. Search for vendor that you'd like to apply the credit memo to an invoice for. Click on Balance field to open up Vendor Ledger Entries window. This will show all the 'open' documents on the vendor ledger. Select the line for the Credit Memo that you want to apply to a posted invoice. Click Process > Apply Entries Within the Edit - Apply Vendor Entries window select the line(s) that you'd like the credit memo applied to. Click Process > Set Applies-to ID This will put the users name into the Applies-to ID field on the line selected. To post the application select Process > Post Application. Written by: Kristen Hosman, Microsoft MVP
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
How I failed the first time It was October 2020 and my manager at the time dared me to take the Beta exam without studying to gage how hard it was. I can't turn down a good dare, so I scheduled the exam for October 20, 2020, and spent the days leading up to it reviewing the skills measured document provided by Microsoft. The day came and I felt pretty prepared to proceed with taking the exam. Because the exam was still in Beta I didn't find out until January 4, 2021, that I actually failed the exam. The passing score is 700 and I ended up with 615. Looking back at that experience I remember thinking the exam was hard and that some of the questions were written in such a way that was confusing and thinking that I'd never pass. So, I put the exam on the back burner and continued on with my life. Passing the second time It wasn't until recently (yesterday) that I decided to take the exam again. I decided that today was the day and that I was going to schedule the exam ...
Comments