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
Posts by jconstantino
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
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
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
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
Add Multiple Items at Once to a Sales or Purchase Document in Dynamics 365 Business Central
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
Create a Quick SmartList to Pull Vendor 1099 Information in Dynamics GP
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
Three Different Methods to Post a Purchase Invoice to a Vendor Account in Dynamics 365 Business Central
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
Display Unit Price and Gross Profit along with Item Master Data (in Dynamics GP)
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
How to Resolve a Dynamics GP Microsoft Word Template Error
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
How to setup EFT for payables and generate the ACH file using Dynamics 365 Business Central
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