30 Problems/30 Fixes – Tip #14 Statistical Accounts
Kim Dallefeld, MCP, MCT, MCP Does your management team require financial reports to give details that are not just the amounts in general ledger accounts? Like sales per employee, gross profit per pound sold, or some other statistic? Recommendations: Statistical Accounts provide what you need. Yes, you need to define the accounts you require […]
30 Problems/30 Fixes – Tip #13 Allocation Accounts
Kim Dallefeld, MCP, MCT, MCP Are you finding it very ‘clunky’ to breakdown expenses across departments over and over in journal entries or purchase invoices for example? Recommendation: Allocation Accounts solve this problem and make you more efficient in the process! You can define many allocations and how you want to distribute amounts. Doing […]
30 Problems/30 Fixes – Tip #12 Dimensions
Kim Dallefeld, MCP, MCT, MCP Dimensions are great but if you spend too much time correcting dimensions that were recorded or missed then you need more controls. Use of dimensions needs to be controlled so that your data for analysis is complete. This is done by setting the dimension requirements for each general ledger account. […]
30 Problems/30 Fixes – Tip #11 Financial Report
Kim Dallefeld, MCP, MCT, MCP Having trouble using Business Central Financial Reports? Feel the formats are bland or there’s \\, not enough formats? Frankly, they just need to be better? Recommendations: 1. Learn the new features in versions 25 and 26 2. Make use of the Row and Column Definitions released for you […]
30 Problems/30 Fixes – Tip #10 Balance at Date
Kim Dallefeld, MCP, MCT, MCP When using a Date Filter on the Chart of Accounts, it is difficult to remember when to use a date range with beginning and ending dates (060125..063025) and when to use no beginning date (..063025). Why does it matter? When using beginning and end date, the Net Change column gives […]
30 Problems/30 Fixes – Tip #9 Recurring Journals
Kim Dallefeld, MCP, MCT, MCP Situation: We do accruals for sales and expenses each month but then we have to reverse them, isn’t there an easier way? Recommendation: Recurring Journals, probably with type of Reversing Variable Recurring Journals have many, many options but one of the best uses is to record accruals in one month […]
Correcting Dimensions in Business Central
Kim Dallefeld, MVP, MCT, MCP I recently had several clients wanting to update multiple general ledger transaction’s dimension values rather than doing them one at a time. Yes, Business Central does allow for this but there are some considerations that you need to keep in mind. Let’s say you want to update the department dimension […]
30 Problems/30 Fixes – Tip #5 Posted GL Description
Kim Dallefeld, MVP, MCT, MCP Problem: Accounts Payable is entering details on the lines of purchase invoices but they never show up in GL Staff is working hard and reaping no rewards for the business! Recommendation: Purchase & Payables Setup’s field Copy Line Descr. to G/L Entry should be ‘toggled’ on! This will provide […]
The Crazy Report Issue Gets Solved!
Kim Dallefeld, MPV, MCT, MCP Once upon a time for a client using BC version 25.5, one report for one user would not work function properly. This is that story….. The ACH Remittance Advice (Word format) was modified so that the Settlement Date would be part of the pdf that gets emailed. Kay tested in […]
30 Problems/30 Fixes – Tip #8 Copy Posted Journals
Kim Dallefeld, MCP, MCT, MCP Situation: Your Controller asks “Posted General Journals is a page but we have no data, why?” The answer is simple, BC is not setup to create the copy! Recommendations: 1. By default all new companies have the ‘copy posted journals’ setup for some journals 2. Versions 25 and […]