Electronic Funds Transfer
Juliet Constantino
Juliet Constantino

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 Constantino
Juliet Constantino

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…

Smartlist builder in Dynamics GP
Juliet Constantino
Juliet Constantino

How to Create a SmartList in Dynamics GP that Displays the Correct Email Address

SmartList Designer Tips for Dynamics GP As most Microsoft Dynamics GP users know, with every version of the system comes with the advanced reporting tool called SmartList. Out of the box, SmartList has several pre-made reports to choose from, all of which pull directly from your Dynamics GP tables, and are column-based (meaning Excel-friendly). In … Read more

Read More…

Dynamics 365 Import
Juliet Constantino
Juliet Constantino

How to define a CSV file to import bank statement information into Microsoft Dynamics 365 BC

Microsoft Dynamics 365 Business Central allows you to easily reconcile your bank accounts by importing transactions from your bank.  In order to match the transactions,  you need to have the proper format for Dynamics 365. Here’s how: The file format just needs to be defined and assigned to the bank account. In this example, I … Read more

Read More…

Bank Reconciliation in Dynamics 365
Juliet Constantino
Juliet Constantino

Dynamics 365 Business Central:  How to Complete a Simple Bank Reconciliation

Microsoft Dynamics 365 Business Central offers automatic methods to reconcile your bank statement; such as importing a file with your bank statement information. However, I often find clients need to reconcile things manually in their system. In this blog, I am going to review the manual method for bank account reconciliation. The Payment Reconciliation journal … Read more

Read More…

Modifying Invoices in Dynamics 365
Juliet Constantino
Juliet Constantino

Modifying the Sales Invoice Format in Dynamics 365 Business Central Using Microsoft Word

Most businesses require some customization to their reports and documentation; such as invoices, sales orders, etc.  With Microsoft Dynamics 365 Business Central, you don’t need a developer to help with this.  You get the options and flexibility needed using the well known interface, Microsoft Word. Modifying the Sales Invoice format: In the following example, I … Read more

Read More…

Dynamics General Ledger
Juliet Constantino
Juliet Constantino

Import General Journals into Dynamics 365 Business Central with a Configuration Package

A simple configuration package can be created and used to import General Ledger Entries into Microsoft Dynamics 365 Business Central. This can be very helpful and save time when importing historical balances. Here’s How To set this up, start by using the global search for “configuration package”: Create a New package and provide the following … Read more

Read More…

Upload Budget with Dimension
Juliet Constantino
Juliet Constantino

Upload a Budget with Dimension Detail in Dynamics 365 Business Central

When you create a budget within Dynamics 365 Business Central, you can export it to Excel and have full access to all the great spreadsheet editing capabilities. This will allow you to quickly fill out all line items in the budget, and then simply import the budget back into Dynamics 365 Business Central.  Many times, … Read more

Read More…

Dynamics 365 Personalization
Juliet Constantino
Juliet Constantino

Two Great Ways to Personalize Dynamics 365 Business Central Using Dimensions

In Microsoft Dynamics 365 Business Central, a dimension can be created by a user to help perform analysis on various documents. According to Microsoft, “dimensions are attributes and values that categorize entries so you can track and analyze them.” This helps organize data for sorting and analysis, without creating a bunch of separate GL accounts. … Read more

Read More…

Cash Payment in Dynamics GP
Juliet Constantino
Juliet Constantino

How the “Cash” Payment Method Affects Invoices in Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central functions like every double-entry accounting system: its base modules provide all you need for accounts payable and accounts receivable. One helpful tip when entering invoices is to be aware of how the payment method that you select will ultimately affect how the invoice gets processed within the system. You can … Read more

Read More…

New Features in Dynamics GP 2018 R2
Juliet Constantino
Juliet Constantino

Displaying the Vendor Document Number in the Purchasing All-in-One View

New Feature in Microsoft Dynamics GP 2018 R2 By popular user demand: The Vendor Document Number is now available on the “Purchasing All-in-One View” window. No more jumping from screen to screen and cross-referencing document numbers! This helps the user track the payments and credit documents together with the invoice they have been applied to. … Read more

Read More…

Dynamics GP Checkbook ID
Juliet Constantino
Juliet Constantino

Checkbook ID Defaults on Computer Check Batch in Microsoft Dynamics GP 2018 R2

Another new feature in the Microsoft Dynamics GP 2018 R2 release is the ability to select a default checkbook in the Payables Management setup window. The checkbook ID selected here will default in the Payables Batch Entry window when creating a “Computer Checks” batch. In previous versions, when a Payables batch was created using a … Read more

Read More…

Dynamics General Ledger
Juliet Constantino
Juliet Constantino

Post Through the General Ledger at the Transaction Level (New Feature in Microsoft Dynamics GP 2018 R2)

In previous versions of Microsoft Dynamics GP, any transaction posted from a sub-module that was not saved to a batch would automatically create a batch that had to be posted in the General Ledger. Not anymore! Users may now post through the General Ledger at the transaction level. Here’s how An additional checkbox has been … Read more

Read More…

Dynamics 365 Fixed Assets
Juliet Constantino
Juliet Constantino

Quickly Create and Depreciate a New Asset in Dynamics 365 Business Central

Managing fixed assets is a cornerstone of any good accounting software. Microsoft Dynamics 365 Business Central is no different. Here’s how to create and depreciate a new asset in a flash. Create a New Fixed Asset Go to Finance>Fixed Assets>New. Then enter the basic information (the fields in boxes below are required). Note: the subclass … Read more

Read More…

Dynamics 365 BC Training
Juliet Constantino
Juliet Constantino

Quickly Create a Detailed Financial Statement Report in Microsoft Dynamics 365 Business Central

When printing income statement reports from Microsoft Dynamics 365 Business Central, the standard report is clear, but doesn’t provide details for every G/L account within the account categories that were assigned when setting up. This video shows how to quickly and easily create a custom view that allows you to view detailed information for all … Read more

Read More…