Variable Allocation using Statistical Accounts in Business Central is a new feature, recently added. It is set to revolutionize how businesses manage their financial allocations. For those familiar with Dynamics GP (Great Plains), you’ll find a sense of familiarity, as this feature works similarly to the Variable Allocation functionality in Dynamics GP. This integration is … Read more
Posts by jconstantino
Assign Separate General Ledger Accounts for Payables and Receivables in Business Central
In this blog we will guide you through the process of assigning separate General Ledger Accounts for Payables and Receivables. In the dynamic world of accounting and finance, maintaining clarity and organization in your ledger is essential. This blog post is designed to walk you through the process of segregating your payables and receivables in … Read more
Unlock the full potential of Fixed Allocations in Business Central
Whether you’re a seasoned user of Business Central or new to its expansive suite of tools, understanding how to effectively utilize Fixed Allocations can significantly streamline your financial management processes. In this post, we will guide you step-by-step through the nuances of working with Fixed Allocations, ensuring you can harness this powerful feature to optimize … Read more
Standardizing Bank Reconciliation in North America for Microsoft Dynamics 365
Business value Bank reconciliation in North American versions is now done through the standard Bank Reconciliation page, which has been improved to support the same tasks as the Bank Rec. Worksheet did in those versions. The Bank Rec. Worksheet page that was specific to North American versions will be removed in April 2023. Feature details … Read more
Vendor Payment Process in Business Central
First, we’ll take a look at how to generate an aging report so we can see which invoices are outstanding and what their due dates are, and then we’ll look at how to actually complete the payment process to print and post checks for those invoices using the Suggest Vendor Payments screen. Viewing Outstanding Invoices The first step … Read more
General Journal Views in Microsoft Dynamics 365 Business Central
Microsoft Dynamics 365 Business Central strives to make accessing information as simple as possible. Business Central offers several different methods for viewing financial data within your system. This includes super-powered intuitive reporting, but also just setting up your day-to-day views to maximize efficiency. This is the first in a series of three blogs designed to … Read more
How to Use Default Dimensions in D365 Business Central
In Microsoft Dynamics 365 Business Central, default dimensions are what we use to categorize entries so you can track and analyze them on documents throughout the system. Dimensions can, for example, indicate the project or department an entry came from on a sales order. You can set up default dimensions for anything. You may, though, … Read more
How to Quickly View Chart of Accounts Balances by Dimension as of a Specific Date (in Dynamics 365 Business Central)
Even out of the box, Microsoft Dynamics 365 Business Central is intuitive and easy to use. Setting up and keeping an eye on your chart of accounts has never been easier. But it gets better: you can customize the way the chart of accounts is displayed using dimensions and filters. From the chart of accounts … Read more
How to Issue a Refund to a Customer in Business Central
In Microsoft Dynamics 365 Business Central, it’s easy to send a refund to a customer and the customer doesn’t need to be set up as a vendor record. If a credit memo document was posted for the customer, the refund can be applied to that credit memo. Or the refund can just go against the … Read more
Use Recurring General Journals to Record Monthly Payable Invoices in Business Central
Something you may not know in Microsoft Dynamics 365 Business Central: monthly payables invoices can be set up in the Recurring General Journals window. The amounts can remain fixed or variable based on your needs. They will need to be posted each month and then they will remain out there for the next month with … Read more
A Faster Way to Enter Payables Invoices in Business Central
Microsoft Dynamics 365 Business Central always aims to make our lives easier. Did you know that in addition to the Purchase Invoice window, you can also enter payables invoices directly into the General Journal window? Even if the expenses need to be distributed across multiple G/L accounts, this method can be used. Another great feature … Read more
How to Reprint a Previously-Posted Bank Reconciliation (Business Central Quick Tip)
“Help! I’ve previously posted and printed a batch in Dynamics 365 Business Central but I need to reprint some of the reports from my bank reconciliation!” No fear! Crestwood is here. Below are the steps to reprint a previously-posted bank reconciliation. First, navigate to the top ribbon and select Cash Management > Bank Accounts. Highlight … Read more
Reversing Date Calculation in Dynamics 365 Business Central
There is now more control available on the reversing date for recurring general journals in Microsoft Dynamics 365 Business Central. This is a new feature in the latest release. To start, navigate to Recurring General Journals and select the batch you would like to work with. You will need to personalize your window first to … Read more
Adding Default Dimensions to Vendor in Dynamics 365 Business Central
Microsoft Dynamics 365 Business Central was designed with simplifying processes and saving time in mind. The ability to add “Dimensions” to anything from a customer to project to vendor is just one great feature that helps speed up your processes. Dimensions are used to filter out certain data, and track any metric you choose. Instead … Read more
How to Copy General Journals in Business Central (2020 Wave 2 New Feature)
By popular demand, in the Microsoft Dynamics Business Central 2020 Wave 2 release (v.17), General journals can now be copied after they are posted! They can easily be re-used or reversed out. Here’s how! First, search for general journal templates. Then create a new template or update an existing one. Enable the checkbox “Copy to … Read more
Using Filters as an Ad Hoc Reporting Tool in Business Central (Comparable to SmartList in GP!)
In Microsoft Dynamics 365 Business Central, you can use filters in just about every window to create an ad hoc report that can then be shared amongst roles. For example, let’s say you want to create a filter to show any customer with a currently due balance that start with the letter A. First, navigate … Read more
Purchase Order Processing and the Various General Ledger Entries in Dynamics 365 Business Central
There are two options in the Inventory Setup window that need to be considered when defining the various posting accounts in Microsoft Dynamics 365 Business Central. We will go through how these options create different GL entries during the purchase order process so you can make the selection that is best for your procedures. The … Read more
How to Easily Set Up Taxes in Dynamics 365 Business Central
New users of Microsoft Dynamics 365 Business Central may be confused by the way the Tax Setup windows look, but it couldn’t be simpler! The following is a summary of the Tax Setup windows: Tax Setup Window – the company tax settings. This is completed during the Assisted Setup and sets up the sales tax … Read more
Using Item Extended Text in Dynamics 365 Business Central
Microsoft Dynamics 365 Business Central allows users to add a field to any document called “Item Extended Text.” Item Extended Text is a great way to display any additional information about an item on various document forms. The user can choose which documents to display the additional text on along with a date range if … Read more
Assign Default Expense Accounts for Vendors Using Purchasing Codes in Dynamics 365 Business Central
There is a feature in other accounting systems such as Microsoft Dynamics GP to assign a default expense/purchasing account to a vendor. This account then defaults as the debit when invoices are entered for that vendor. Good news! The same solution exists in Dynamics 365 Business Central using Recurring Purchase Lines to speed up data … Read more
Copy Purchase Invoices to Speed Up Data Entry in Dynamics 365 Business Central
In Microsoft Dynamics 365 Business Central, when creating a new Purchase invoice, you can easily copy a previous posted or unposted invoice from any vendor. This is especially helpful if the same G/L accounts or amounts will be re-used. To create a New Purchase Invoice, enter the Vendor Name then go to the Actions>Functions and … Read more
How to Define a Default Expense Account for Vendors in Dynamics 365 Business Central
In Microsoft Dynamics 365 Business Central, in order to define a default G/L expense account for different vendors, the vendor will need to have a specific General Business Posting Group assigned to it. [This is the next blog in a series of tips for using Dynamics 365 Business Central. For the previous Business Central tip … Read more
View Vendor and Customer Names and Item Descriptions in Ledger Entries in Dynamics 365 Business Central
A new feature was added to Microsoft Dynamics 365 Business Central to allow users to display vendor names, customer names, and item descriptions in ledger entries. This can be enabled in the following windows: Copy Vendor Name to Entries via a checkbox on the Purchases & Payables Setup page for Vendors Copy Customer Name to … Read more
How to Print Payables Checks in Dynamics 365 Business Central
When printing checks in Microsoft Dynamics 365 Business Central, there are a couple settings to be aware of. The following steps will guide you through selecting the correct check stock and printing the checks during payment journal processing. Step One: Double-Check the Check Stock First, select the proper format to match your pre-printed check stock. … Read more