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
When your legacy Enterprise Resource Planning (ERP) solution is having trouble keeping up with your business, it’s important to weigh your options carefully before you decide whether to upgrade to a new version or make the switch to different software. I recently worked with a client to determine the best course of action for their … Read more
Microsoft Dynamics SL has long been the go-to for project-based businesses in need of a focused solution that delivers financial management, project management and accounting, distribution, field service, payroll, e-business, and more. However, while it does do many things well, there are certain areas where it could be improved, better customized, or better supported. 1. … Read more
For too many businesses, the payment process is flawed—64 percent of B2B payments are still made with checks according to industry magazine PYMNTS.com. In the B2B world, paper is still present in the beginning, middle, and end of the payment process. From increased time it takes to process and pay a paper invoice using a … 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
When adding conditions or filters in Report Designer or Generic Inquiries in Acumatica, there are certain cases where you need to use the internal value of a list, or combo box (*). The internal values may be different than the external description you see, so we need a way to inspect them. These internal values … Read more
Bank reconciliation is the bread and butter of all accounting systems – one of the most basic functions that almost every business needs to perform. Businesses upgrade to an advanced ERP to streamline the accounts receivable and accounts payable processes as much as possible. If you’re new to Acumatica, or just want a refresher on … Read more
Are you running an old version of Acumatica? If so, you need to consider an upgrade. Acumatica stopped supporting version 6.0 at the end of January 2019. We just received notification that support will end on version 2017R2 July 31st, 2019. What does that mean for you? If you are on an Acumatica version older … 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
If you’re on Acumatica 2018 R2 and running Fixed Assets, there is a processing bug you should know about. Here’s what happens when you try to run the Transfer Report in the Fixed Assets module for Acumatica 2018 R2 build 18.203.0006. Error message: What is wrong with my Transfer Report? You are not able to … 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
All accounting professionals know the importance of a well-designed Chart of Accounts (COA). Whether you’re new to Microsoft Dynamics GP or a seasoned veteran, you’ve pulled the COA report for yourself and the other business leaders within your company. Have you ever wanted to customize it, though? Our team gets this request a lot. Commonly-Requested … Read more
My goal this year is to become more efficient. To work toward that goal, I started using a tool called Rocketbook. It’s a physical notebook that can be written in with a special pen, scanned and uploaded, then erased and reused. It allows me to take notes at client meetings, snap a picture, and then … Read more
One of our favorite systems just got better! Acumatica has some fresh new attributes and options available; these enhancements are designed to make your workflow run smoothly and allow you to be even more efficient. The latest changes make Acumatica even more intuitive and easier to use, from simple things like automatically updating input information … Read more
Every organization has unique business processes, and tailoring solutions to meet, automate, and scale those processes can be very rewarding wins for your organization. We had a rather unusual client requirement come through that we were able to accommodate in Microsoft Dynamics GP with the addition of Accountable Software’s Forms Printer application. The Problem A … Read more
Have you ever received a suspicious email about your Office 365 account? It might seem legitimate, even with a Microsoft logo, but if you look close at the links or the email address it came from, it’s not from your company. Office 365 credentials are a hot commodity these days. You need look no further … Read more
As your business grows, you may find your organization struggling with the limitations of software designed for smaller concerns. Everyone has to start somewhere, so it’s only natural that you will eventually outgrow the systems you had at the beginning. This is particularly true of accounting packages. QuickBooks, for example, is a fantastic resource for … Read more
When was the last time you revisited your payables bill processing? What if I told you how to save 200 minutes of time each week per 100 invoices? That’s over 3 hours of processing time every week! Look what A/P Inbox Assist, an Acumatica add-on, can do: Reduces AP time by approximately 50% Eliminates data … 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
Our award-winning development team is located all around the country. To stay connected and organized, we have been using an app called Smartsheet to great success. Smartsheet allows us to enter a project – from Dynamics GP upgrades to an Acumatica customization – and as it progresses, we can add notes. We can keep track … Read more
Those in the fabrication industry have unique needs—both in the form of project management, materials planning, and contracts, often needing more than a traditional manufacturing-focused ERP can provide. In an industry like yours, change is frequent—whether those are design changes, contract changes, or anything of the like, you need to remain agile enough to adapt … Read more