Top 10 customers list

-
Have you ever been asked to produce a list of your top customers? If so you're in luck because Dynamics 365 Business Central is jam packed with reports and recently I came across the Customer - Top 10 List report which I really like. You can find the report via the "tell me what you want to do" search or within the customer list as shown below.



Report Options

Report options lets the user decide on if they'd like to change the report options, filter customers, or filter totals by date. My example below simply shows the default options with no filters.  

  

  



Comments

Post a Comment

Popular posts from this blog

Real client issue with Checklist or Get Started...whatever you want to call it in Microsoft Dynamics 365 Business Central

-
Image
Disclaimer provided by Microsoft The checklist is designed to assist customers in onboarding companies to Business Central and assist Partners in the selling process by highlighting features to explore from the checklist. Microsoft relies on partners to bring the relevant checklist items for a given customer if they think the default ones will not suffice, which in most cases they will certainly not.  The very first default checklist item for Business Manager in non-evaluation companies is the "Company details" task, whose purpose is to open a wizard and guide users through/check if their company name is correct. This wizard has a long history in the product and has previously served multiple purposes. One of these, importing of configuration packages when having created a new company, under certain circumstances. A bug caused this code path to be reached for one of my clients.  It's important to know that the Microsoft has  fixed this bug in the wizard, and the fix is in
Read more

Cash receipts journal vs bank deposit in Microsoft Dynamics 365 Business Central

-
Image
I previously blogged on how to create a bank deposit and today I'd like to compare the cash receipt journal with the bank deposit process.  Deciding which one to use to enter customer payments can be hard. I'm going to experiment with both to show you why either one can be used.  Cash Receipts Journal In the scenario I use below I've received two checks from two different customers. I have entered each check payment into the cash receipt journal and added one line for the total amount of the deposit to the bank account. Even though I have two checks they will hit the bank as one amount based on how I deposit them with the bank.  If the checks were deposited separately then I would use the Balance Account Type = Bank Account and Bal. Account No = B010; then leave off the third line in the example below.  Bank Deposit The bank deposit method is easier to explain than the Cash Receipt Journal method. The General FastTab is going to allow the user to select the correct bank ac
Read more

Dimension Corrections in Microsoft Dynamics 365 Business Central

-
Image
If you've ever coded something to the wrong dimension and noticed after posting don't just assume a journal entry is the only way to fix it. Microsoft has included a Dimension Corrections tool within Business Central and it's pretty easy to use. Let's walk through the process of updating a posted entries dimension where the user forgot to add the dimensions in this case. Same process would apply if you needed to change a posted dimension as well. Within the General Ledger Entries page, select the line for the entry that needs to be corrected, then click on Entry > Correct Dimensions.  Within the Draft Dimension Correction window go ahead and update the description if needed and mark Update Analyses Views if you're using those.  Next section Dimension Correction Changes go ahead and add the updates. In my case my entry is missing two dimensions so I'm going to add each of those in there. Since my dimensions were missing the Dimension Value Code field is blank,
Read more