30 Problems/30 Fixes – Tip #17 Bank Recs
Kim Dallefeld, MCP, MCT, MCP Do you find Bank Reconciliation time-consuming? Are you doing your Bank Reconciliations in Excel? Recommendations: Do your bank reconciliations in BC. This updates data and now any user, with the allowed permissions can verify if a check to a vendor was issued and note whether it has cleared or […]
30 Problems/30 Fixes – Tip #16 Deferrals
Kim Dallefeld, MCP, MCT, MCP Recurring journals to record expenses for prepaids such as insurance is really helpful. However it would be nice if when processing the invoice for anything prepaid that Business Central would just handle all the monthly expenses. Isn’t there an easy way to handle versus remembering to post a recurring journal […]
30 Problems/30 Fixes – Tip #15 Fixed Assets
Kim Dallefeld, MCP, MCT, MCP Excel spreadsheets have errors. There is a better way to track assets and their depreciation. It’s easy to use and integrates with Business Central. Recommendation: Fixed Assets in Business Central is G-R-E-A-T! Fully integrated to buy, sell, depreciate, and dispose of assets….and much more. Take the time to […]
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 […]