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 […]
30 Problems/30 Fixes – Tip #7 Invoice Posting Control
Kim Dallefeld, MCP, MCT, MCP Situation: Permissions are all setup. Sales, purchase and service invoice postings are restricted but still need some users to be able to post just invoices. Permissions seem lacking to control this. Recommendation: User Setup has three fields to help, one for sales invoices, one for purchase invoices and one for […]
30 Problems/30 Fixes – Tip #6 Templates
Kim Dallefeld, MCP, MCT, MCP Situation: Customers, Vendors and Items are not being created accurately by staff. Recommendation: Use Templates! Templates allow the pre-definition of settings for types of customers, vendors and items so that the desired fields are setup consistently and accurately. This may not solve all your problems with master record creation but […]