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