Accounts Payable Strategy
Juliet

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

Read More…

General Journal Views in Dynamics 365 Business Central
Juliet

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

Read More…

Dynamics 365 Business Central
Juliet

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

Read More…

Dynamics 365 Business Central Copy Journal Entries
Juliet

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

Read More…

General Ledger in Dynamics 365 Business Central
Juliet

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

Read More…

Default Vendor Expense
Juliet

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 Business Central using Recurring Purchase Lines to speed up data entry. The … Read more

Read More…

New feature in Dynamics 365 BC
Juliet

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

Read More…

Dynamics 365 BC Check Printing
Juliet

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

Read More…

Error
Juliet

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

Read More…

Electronic Funds Transfer
Juliet

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

Read More…

Regular Expressions in Acumatica
Juliet

View Historical Transactions with Negative Amounts Based on Document Types (in SmartList Designer for Dynamics GP)

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

Read More…