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
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
In Microsoft Dynamics 365 Business Central, 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, find … Read more
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
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
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
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
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
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
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
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
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
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 Business Central using Recurring Purchase Lines to speed up data entry. The … Read more
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
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
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
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
In the latest release of Microsoft Dynamics 365 Business Central, a new feature was added to be able to select multiple items at once to add to a sales or purchase document. This eliminates the need to add items one-by-one and speeds up the process. Here’s How First, I like to check the default item … Read more
SmartList Designer Tips Next in our series of SmartList Designer blogs, we’ll look at a common request for viewing vendor details within SmartList: displaying the 1099 detail information for a given period. (If you need a refresher on SmartList Designer, or missed the first blog, you can find it here.) This will show you how … Read more
Microsoft Dynamics 365 Business Central is still the new kid on the block, but is rapidly making waves. As more and more of our clients make the leap to this versatile and robust system, we have decided to publish a series of blogs on how to use Dynamics 365 Business Central. This post will detail … Read more
SmartList Designer Tips The next SmartList Designer tip is for the inventory module in Microsoft Dynamics GP. When you view the item master data view that comes out of the box, some fields like unit price and gross margin aren’t available to display as a column. This is because that data is stored in a … Read more
After modifying the SOP Blank Invoice format in Microsoft Dynamics GP, I received this error message: “We’re sorry. We can’t open SOP Blank Invoice Form because we found a problem with its contents.” Clicking “Details” provides additional errors: Microsoft Office cannot open this file because some parts are missing or invalid. Location: Part: /word/footer2.xml, Line: … Read more
Both payees and accounting professionals love electronic funds transfer (EFT), and for good reason. It drastically reduces the time required to process payments, eliminates paper, and helps avoid fraud. There are three windows that must first be set up properly to be able to use the EFT/ACH feature in Microsoft Dynamics 365 Business Central: Company … Read more
SmartList Designer Tips Next in our series of SmartList Designer blogs, we’ll look at optimizing a basic purchasing SmartList. (If you need a refresher on SmartList Designer, or missed the first blog, you can find it here.) Let’s say that a purchasing manager wants to view all the historical transactions for a vendor. However, the … Read more