FMTFMT

Mathew Jose, Author at FMT

Search Archive
Warehouse Cycle Counting with Business Central
What is cycle counting? Let’s be honest, setting up and processing inventory counts on a regular basis is one of the least exciting parts of running a distribution business. In reality, there is no one who enjoys undertaking this tedious activity. In fact, rather than addressing this need, many choose to ignore it, especially if they have a lack of resources and time. However, performing cycle counts on a frequent basis and aligning them correctly within your warehouse(s) is critical in achieving better metrics for inventory accuracy, turnover ratio, lead times and delivery dates. In this blog, we’ll explain how all of this can be accomplished using Microsoft Dynamics 365 Business Central (BC) with its ease of processing a count. Warehouse cycle counting is a perpetual counting system where a small subset of inventory, in a specified location, is counted on a specified day. By performing cycle counts, you are […]
Are You Using Contract Billing in Dynamics GP?
Are you familiar with the amazing functionality for Contract Billing that is hidden inside Microsoft Dynamics GP and within the Field Service module? This functionality allows you to easily manage contracts with your customers with the ability to enter multiple lines of detail with item numbers whether it’s inventoried or a service type. One of the many benefits of this module is its capability to quickly generate multiple invoices from multiple contracts as well as perform revenue recognition to move dollars out of Deferred accrual account and into actual Revenue account. As actual transactions are processed, the billing schedules and revenue recognition schedules are updated to show the current status of your contracts. The image below shows the screen in which general contract information is entered. The key fields are the contract start date, number of periods, the billing frequency, and the day of the month to bill. You can also […]
Business Central and Auditing Changes
Auditing changes in Microsoft’s Dynamics 365 Business Central, like with any ERP, is fundamental to ensuring compliance. In this blog, we’ll take a look at the differences between the 2 tools that you can use to audit changes in Business Central.   The first is native functionality, and the other is an app that you can add-on.  By the end, you’ll have a solid idea of how these options can help you audit changes in your ERP.  Let’s jump in! Business Central Change Log The Change Log functionality is built-in to Business Central.  It’ very simple to setup and get going in it.  Putting you’re controls in place quickly. The Change Log can track changes when a value is inserted, modified or deleted from a field. It also provides a nice viewable log with the user id, date/timestamp, before and after values as well being exportable to excel. The actual process […]
Tips for Year End Closing in Microsoft Dynamics GP
Closing out the year in Dynamics GP requires a very specific set of actions to complete. Please refer to the Period and Year-End Best Practices for more details from our Dynamics GP 2018 Period-End & Year-End Closing Manual. So in this blog, we’ll go over general tips for all year-end closings as well as specific tips for different GP modules. Note: Be sure to have a current backup of both the company and Dynamics databases. The first and most important task besides performing the close is making sure all users are out and you have a valid backup for each company. Backups should also be taken in between some of the closing procedures when it involves payroll or any other time consuming processes. Make sure to also safeguard your backups from any cleanup routines you may have setup in SQL server by keeping it in a different drive and folder. […]
Dynamics GP item substitution in Sales Order Processing
Guess what? When your primary items are depleted whether fulfilling a sales order or picking during BOM assembly, there is a quick and easy way to setup alternate items and use them in place as needed. This GP item substitution process will save time and money consistently by not having to delay your production workers' duties you get the original item in stock and also not risking having to make your customers wait a long time to get a product out the door to them. The first thing to do is to go into Item Maintenance and enter your primary item no that you need to add an alternate for. Next click on the Go To icon and select Alternate Items. Then you would enter the alternate item that it could be substituted with. This will allow you to select the substitute item during Sales Order entry when your primary […]
Inventory Bill of Materials in Microsoft Dynamics GP
You may not know, but there is a simple, straight-forward option in the Microsoft Dynamics GP Inventory Module for performing Bill of Materials assemblies. The Bill of Materials feature works well if your company does light manufacturing or assembly, but doesn’t need the complexities that come with the full-blown Manufacturing solution. This module offers a great way to track and account for building components as they are turned into a finished product. Utilizing this assembly transaction will also increase your finished goods stock while simultaneously reducing your component stock and performing the proper accounting entries. In this blog, we’ll walk you through how to use this simple module. In order to begin using this module: You’ll first need to setup all your items (both finished goods and components) under Item Maintenance. Next, go to Inventory > Cards > Bill of Materials and select your finished goods item. In the grid, select all […]
How to Process Fully Applied Documents for Vendors in Dynamics GP
Many Dynamics GP AP users complain about seeing old fully applied documents on the check stubs as they print a check for a vendor. What these users might not know, however, is that solving this common complaint is as easy as processing an old fully applied document through a regular check batch and posting it as a $0 batch before you actually print a live check. In this blog, we’ll show you how you can easily process fully applied documents for vendors in Dynamics GP. Go to Purchasing, select Transactions, and then click Checks Create a batch and save it. Enter the Vendor ID range (that you want to process fully applied docs) and hit Insert Check off ‘Print Previously Applied Documents’ Click Build Batch Wait until the Batch Total is no longer zero, then click Edit Check. Use the second arrow on the bottom left to scroll to the […]
©
2021
 FMT Consultants, LLC.
|
Privacy Policy
X
FMT

Contact Us

X
FMT

Newsletter Sign-up

menu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram