Microsoft Dynamics Business Central for Manufacturing – A Viable ERP System?

Why Should we care if we can use Dynamics Business Central for Manufacturing?Given the disruption of the past year, a lot of businesses are investigating ways to work remotely and in a hybrid work environment. There are a few technologies that manufacturing companies need to use that don’t work well remotely. One of them is ERP systems. That’s why we should care about Dynamics Business Central for Manufacturing.If you are looking to replace an ERP system because you want to ensure it facilitates remote work, cloud ERP is where you need to look. My experience is almost entirely with what is often called “SMB” or Small and Medium Business manufacturers.There are not a lot of good, modern cloud based ERP systems in the mid-market / SMB space. There are even less that really support manufacturing. That means that the best cloud systems are priced out of most manufacturers budget.Oh, In case you are wondering, Microsoft defines SMB as businesses with less than 250 computers. That’s a pretty large manufacturer.What is Business Central?In the simplest terms, Business Central is the new brand name for Microsoft Dynamics NAV. In all the ways that count this cutting edge new cloud based ERP is the old Dynamics NAV reimagined in the cloud.Microsoft did not shirk on the technology either! They have a boat load of money, and they were willing to spend a lot of it on Business Central.The full name of the product is Dynamics 365 Business Central. That 365 should look familiar, because it appears on Office 365, Microsoft 365 etc…This does mean that Business Central is part of the same suite of products you might already be using for your Outlook email, Teams communication, Microsoft Word or Excel productivity tools. And yes, that is a big advantage to Microsoft. It doesn’t mean that it will work in Manufacturing however – so that remains to be seen.How does it compare with more traditional manufacturing ERP?I recently wrote a blog comparing Dynamics Business Central for manufacturing with a pretty well respected mid-market pure manufacturing ERP called Infor Visual ERP.I worked extensively with Visual ERP for almost 20 years (ironically I never sold a copy in all that time). I ran the firm that people who had trouble with the system came to for help.When I migrated my business away from Infor Visual, I investigated a lot of products. I settled on Dynamics NAV (which later became Business Central) after significant research.By 2014 we had started switching Visual ERP customers Microsoft Dynamics NAV manufacturing. There are a few small areas that Visual might do a bit better in. That is more than overcome by two main factors that make Microsoft Dynamics Business Central for manufacturing really shine.CustomizabilityDynamics NAV and now Business Central are extremely easy to program, which let us enhance it in ways you absolutely could not with Visual. It’s so easy to program that we are essentially giving away “Missing” Visual features when we sell the product.This customization let us plug any holes we found. It also allowed us to do the one thing Visual customers always cried about. We could make small, easily maintained, incremental changes. We could adjust the system to make it work better for the customer.We avoided any kind of massive programming (although in my time I’ve seen other partners who didn’t avoid the same). We focused on making really useful changes that allowed the customer to get rapid benefits. This made a huge difference to customers. It can be a game changer when a very small change saves staff hours every week.Dynamics 365 AppSource AddonsMore or less related is the existence of addons for Microsoft Dynamics products.When we first started selling Dynamics NAV for manufacturing, there was no AppSource. AppSource is like the Google Play store or Apple Apps store. It’s a place to go and rapidly (in seconds really) install addons.In the early days these addons existed, were certified by Microsoft, but did not exist in any central location. Today things are even better. With Appsource we can really enhance Dynamics Business Central for manufacturing. I mention a couple of those modules below.Wait! I have to get AddonsThere are 2 schools of thought about ERP systems. You want to get a really good ERP system with: great accounting; inventory control; purchasing and sales; CRM; scheduling; shop floor execution etc… Imagine you wanted to get a similarly priced personal item. Say you wanted to get a vehicle and a camping trailer. You went to 2 dealerships. A Ford and the other GMC.In our fake and hypothetical Ford dealer they sell their F150 truck, with a Ford Radio, Ford Tires, and a Ford brand camping trailer. This specific ford’s rims are totally custom and don’t fit other makes of tires. Nobody makes a radio that fits their dash. The trailer is OK but not the best you’ve seen. The trailer hitch is custom built for their truck. You have no choice. But wait! It’s all in one warranty so if anything goes wrong you can blame them and they have to fix it!GMC sells their big truck by itself. You can choose which tires you get, so you want Michelin tires. You can add a radio, and decide to get the more expensive but awe inspiring Bose Radio. They don’t sell trainers, so you buy an Airstream. You would never complain about GM not making their own tires or radio, and you would never want the Ford where you had no choice but to get what they sell.Why do you want an ERP that forces you to get their proprietary versions of things instead of buying the best you can afford?Out of the Box Manufacturing Features in Business CentralDynamics Business Central manufacturing capabilities are identical to what was in Microsoft Dynamics NAV manufacturing.There are a set of core modules in the Essentials edition of Business Central. These include: sales orders, inventory and purchase orders; assembly management; jons (project accounting and management); and warehouse management.Some customers use the Essentials version exclusively. It works fine depending on your mode of manufacturing (see below).Upgrading to the Premium version adds extra capabilities. You get Bills of Materials; Routings; Machine and Work Centers; Capacity Planning; Production Orders and other purely manufacturing oriented features.Premium also adds Service management, which is used in the Engineer to Order space quite frequently, but not often in regular manufacturing.Detailed Features in Manufacturing – in the Premium VersionProduction Order Management

Agile Manufacturing

Version Management

Inventory Planning

Demand Forecasting

Machine Centre Management

Capacity Planning

Finite Loading

Production Bill of Materials

Production Scheduling

Supply Planning
Modes of Manufacturing for Business CentralI tend to think of manufacturing ERP projects in terms of the mode of manufacturing being used. There are different definitions from different organizations (mainly APICS) but these are the ones I tend to see and my take on how good Business Central for manufacturing is for these modes.Engineer to Order – ETOThis is my favorite. I worked at an ETO for a few years before starting my own business. Dynamics Business Central for Manufacturing includes a really powerful project accounting module called Jobs. Since ETO manufacturers are really project manufacturers, this jobs module is a solid foundation. There are a few additional addons that I strongly recommend (including one that we created) to make the fit even better.Overall – Business Central for ETO is really good.Make to Order and Make to Stock – Production ManufacturingMake to Order and Make to Stock are usually two separate modes of manufacturing (and they are) but I combine them into one mode I call Production Manufacturing. The out of the box manufacturing modules that are part of Business Central Premium work great for these businesses. Many of them also want the addins that I list below – which are great extra features.Job ShopsJob shops tend to come in the biggest variety and tend to actually not fit that well into either ETO or Production Manufacturing. I’d want to see the Job Shop to see whether it’s more of a micro-production shop (very common – I call these “repetitive job shops”) or whether it’s more of a custom mini-project manufacturer like a light ETO.These businesses vary a lot in what they make. A food co-packer is technically a job shop. So is a welding service business, a small machine shop etc…Whatever the case, it is a good fit for Dynamics Business Central for manufacturing.Process ManufacturingProcess Manufacturing is usually related to making one of the following:

Cosmetics

Chemicals

Nutraceuticals

Pharmaceuticals

Food manufacturing
Process manufacturing needs some heavy duty addons for Business Central to work properly. This is outside my comfort zone to be honest. The regulations and batch manufacturing processes are really unique. I have a few colleagues that I send these kinds of prospects to. Those addons for Business Central are extremely good, and handle this industry very, very well.Graphics Arts ManufacturingPrint Manufacturing is it’s own sub-type, really a form of either Job Shop or Production Manufacturing depending on what they make. These businesses don’t work as well out of the box with Dynamics Business Central for Manufacturing. They usually fall into these categories.

Commercial Print (magazines, business carts, posters, flyers etc. – a real Job Shop)

Folding Cartons (think a toothpaste box, or cereal box. Can be production or Job Shop)

Flexible Packaging (these companies make the plastic bags you get consumer goods in)

Labels (could be a wine bottle label, or a shampoo bottle, or your aspirin).

Wide Format (think huge banners, giant photographs on walls in a mall etc.)
This mode of manufacturing has a really great addon for Business Central called PrintVis. PrintVis is a Print manufacturing MIS software addon that turns Business Central into arguably the best Print MIS in the market.Add-ins Recommended by MeMy team has reviewed many addon solutions since we started working with Business Central for manufacturing. Here are our top choices:InsightWorks Shop Floor Insights (SFI)This is a manufacturing execution system for collecting job costing data (time), production reporting and materials use in real time. Comes with a nifty scheduling tool also.InsightWorks Warehouse Insights (WHI)This product is my favorite wireless barcoding solution for warehouse management. It runs on most of major brands of wireless devices used in warehouses today. I think it’s a great mid-level warehouse management solution.Netronic Visual Production SchedulerFor those who need a a graphical drag and drop scheduler, Netronic is the industry standard for Business Central. Their Visual Production Scheduler is more or less for visualizing and manually editing the schedule. The Advanced Production Scheduler is more robust and will do best fit scheduling.ConclusionWe’ve taken a look at using Dynamics Business Central for manufacturing in this article. I’ve had the opportunity to oversee the implementation of this system in more than 50 companies, and so far, so good. For that SMB manufacturer with 20 employees who work in the office and 60 that work in the shop – this is a great system. We’ve got a few customers with 500+ total employees using it very successfully. We also have a few with 10 total employees, and they are able to make it work.If you are a manufacturing company that is in the small or medium market (again – less than 250 computers) looking for ERP I strongly suggest you look at Microsoft Dynamics. I can confidently say that as an ERP Dynamics Business Central for manufacturing is a great fit.

What Are The Greatest Changes In Shopping In Your Lifetime

What are the greatest changes in shopping in your lifetime? So asked my 9 year old grandson.

As I thought of the question the local Green Grocer came to mind. Because that is what the greatest change in shopping in my lifetime is.

That was the first place to start with the question of what are the greatest changes in shopping in your lifetime.

Our local green grocer was the most important change in shopping in my lifetime. Beside him was our butcher, a hairdresser and a chemist.

Looking back, we were well catered for as we had quite a few in our suburb. And yes, the greatest changes in shopping in my lifetime were with the small family owned businesses.

Entertainment While Shopping Has Changed
Buying butter was an entertainment in itself.
My sister and I often had to go to a favourite family grocer close by. We were always polite as we asked for a pound or two of butter and other small items.

Out came a big block of wet butter wrapped in grease-proof paper. Brought from the back of the shop, placed on a huge counter top and included two grooved pates.

That was a big change in our shopping in my lifetime… you don’t come across butter bashing nowadays.

Our old friendly Mr. Mahon with the moustache, would cut a square of butter. Lift it to another piece of greaseproof paper with his pates. On it went to the weighing scales, a bit sliced off or added here and there.

Our old grocer would then bash it with gusto, turning it over and over. Upside down and sideways it went, so that it had grooves from the pates, splashes going everywhere, including our faces.

My sister and I thought this was great fun and it always cracked us up. We loved it, as we loved Mahon’s, on the corner, our very favourite grocery shop.

Grocery Shopping
Further afield, we often had to go to another of my mother’s favourite, not so local, green grocer’s. Mr. McKessie, ( spelt phonetically) would take our list, gather the groceries and put them all in a big cardboard box.

And because we were good customers he always delivered them to our house free of charge. But he wasn’t nearly as much fun as old Mr. Mahon. Even so, he was a nice man.

All Things Fresh
So there were very many common services such as home deliveries like:

• Farm eggs

• Fresh vegetables

• Cow’s milk

• Freshly baked bread

• Coal for our open fires

Delivery Services
A man used to come to our house a couple of times a week with farm fresh eggs.

Another used to come every day with fresh vegetables, although my father loved growing his own.

Our milk, topped with beautiful cream, was delivered to our doorstep every single morning.

Unbelievably, come think of it now, our bread came to us in a huge van driven by our “bread-man” named Jerry who became a family friend.

My parents always invited Jerry and his wife to their parties, and there were many during the summer months. Kids and adults all thoroughly enjoyed these times. Alcohol was never included, my parents were teetotallers. Lemonade was a treat, with home made sandwiches and cakes.

The coal-man was another who delivered bags of coal for our open fires. I can still see his sooty face under his tweed cap but I can’t remember his name. We knew them all by name but most of them escape me now.

Mr. Higgins, a service man from the Hoover Company always came to our house to replace our old vacuum cleaner with an updated model.

Our insurance company even sent a man to collect the weekly premium.

People then only paid for their shopping with cash. This in itself has been a huge change in shopping in my lifetime.

In some department stores there was a system whereby the money from the cash registers was transported in a small cylinder on a moving wire track to the central office.

Some Of The Bigger Changes
Some of the bigger changes in shopping were the opening of supermarkets.

• Supermarkets replaced many individual smaller grocery shops. Cash and bank cheques have given way to credit and key cards.

• Internet shopping… the latest trend, but in many minds, doing more harm, to book shops.

• Not many written shopping lists, because mobile phones have taken over.

On a more optimistic note, I hear that book shops are popular again after a decline.

Personal Service Has Most Definitely Changed
So, no one really has to leave home, to purchase almost anything, technology makes it so easy to do online.
And we have a much bigger range of products now, to choose from, and credit cards have given us the greatest ease of payment.

We have longer shopping hours, and weekend shopping. But we have lost the personal service that we oldies had taken for granted and also appreciated.

Because of their frenetic lifestyles, I have heard people say they find shopping very stressful, that is grocery shopping. I’m sure it is when you have to dash home and cook dinner after a days work. I often think there has to be a better, less stressful way.

My mother had the best of both worlds, in the services she had at her disposal. With a full time job looking after 9 people, 7 children plus her and my dad, she was very lucky. Lucky too that she did not have 2 jobs.

How to Analyse Financial Performance in Investment Property

When looking at a commercial property of any type you need to spend time on the financial aspects of the property before you form an opinion about the price that you think that you can achieve. The financial aspects of the property can have a major impact on the price and or the interest of purchasers. The financial aspects of a building or a property can impact the asset for many years and for this reason must be analysed and identified.We have detailed some of the major aspects of financial concern in a property purchase or sale scenario. Whilst these are not the only categories of activity and concern, they are the major ones in most circumstances.We recommend that you create a checklist from these items so that your property review and inspection process is suitably enhanced and professional.The Asset Schedules: The property will contain many fixed and moveable assets. These will normally be detailed on the asset register. A well maintained commercial property will have an up to date asset register for your review. Obtaining the asset register at the early stage of sale consideration is productive as it will tell you in detail what you are selling and later become part of the due diligence process.

Bank and Personal Guarantees: An investment property comprises leases and other documents which support tenant occupancy. A normal leasing process would involve and create some form of guarantee to be provided by the tenant to the landlord for the duration of the lease. It is important that this guarantee has both strength and substance to reimburse the landlord in situations where the tenant defaults under the terms of the lease. At the time of property sale, these guarantee documents should have some form of ability to be transferred or re-issued to the incoming purchaser. This process is called an assignment of the guarantees. You should consult with the landlord’s solicitor to identify the types of guarantees involved and the ease in which this can be achieved at time of sale.

Capital Expenditure: Major items of plant and equipment which are replaced in a commercial property are usually regarded as capital expenditure and are separately itemised for the purposes of taxation and depreciation over a period of time. Taxation laws in your location will stipulate the depreciation terms as they apply to different types of capital expenditure. For example, a computer that is purchased for the building control system will depreciate far quicker than the air handling unit which was purchased for the air conditioning plant. Well maintained property records will include a detailed capital expenditure register and the date at which the capital item was purchased. Purchasers to the property will be interested in the depreciation that this register provides against the cash flow in coming years.

Taxation and GST: Every country and property location has its own unique taxation laws and requirements relating to property and particularly investment property. In the sale process, it is important to understand that these matters have been correctly handled and are up to date. It is sometimes necessary to view the net returns for the property for the last few years that were applied to the taxation statements and lodgement process. You can also seek written confirmation from the owner of the property that all taxation matters are up to date.

Income and Rent Analysis: The income for the property is a reflection of the leases and occupancy licences therein. It is essential to understand that the rent has been collected in accordance with the leases or licences and that all rental matters are up to date. Part of this process will also involve the checking of the rent review profile and the expiry profile of all leases. A property with a volatile leases or leases that are soon to expire is likely to impact the price or the buyer interest. When reviewing tenant occupancy against leases, you should review the original documents and cross reference this to the tenancy schedule and any discussions or information provided by the landlord.

Independent Valuation: Many property owners will obtain a valuation regularly in support of their property financing package. It is not unusual for such valuations to occur annually. Importantly they are done by a qualified and registered valuer. If you view this documentation and take it into account in the pricing process for the property, it is wise to consider the true independence of the valuation when it was done and its relevance to the current market. Some valuations for financing purposes may not be in parity with the existing market conditions. It pays to sometimes seek a true independent valuation at the time of sale or in preparation for sale.

Land tax issues: Property land tax has a direct impact on the investment aspects of commercial real estate. In different locations, the recovery and payment of land tax is impacted uniquely by local legislation. In some circumstances the land tax can or cannot be recovered from the tenants within the property. This will have immediate impact on the bottom line and net return from the property; this then impacts the price. Consulting with the financial adviser for the owner of the property, or the taxation office, will achieve clarity in this taxation impact. Given that most agents and brokers are not taxation experts, you should involve other professional taxation people as appropriate.

Lease disputes: Rarely is there a property that does not have an existing lease dispute or has been impacted by a previous lease dispute. For this reason it pays to question the matters of lease dispute and resolution. If in doubt, seek a copy of correspondence and any subsequent agreement between the appropriate parties. Unresolved lease disputes can jeopardise or slow the process of property sale.

Mortgaged interests: Most commercial real estate properties will have a mortgage of some type to a financier. When a mortgage exists, it is necessary to understand how it will be handled or discharged in the process of sale. The client should consult with the mortgagee to clarify these matters for you. In a situation of distressed properties, the sale of the property may need to realise a particular price before clear title can be achieved.

Operational expenditure: The running of a commercial property will involve the operational expenditure attributed to running costs. Most of properties of particular types in the same location will have similar operational expenditure. If however a property has excessive operational expenditure which is above the averages in the area, then the property is likely to be difficult to sell. Most purchasers of properties understand the averages of property expenditure deemed to be realistic for each property. This also says that real estate agents and brokers should be well aware of the expenditure averages and analysis process that should apply in this situation. Operational expenditure is analysed on the basis of $’s per m2 or $’s per ft2 (depending on your location, monetary base, and country)

Statutory charges: These are commonly referred to as rates and taxes. These will involve matters such as water rates, land tax, council rates, and any other form of charge which is raised by the statutory bodies. Importantly the charges so raised must be analysed for parity to similar properties in the same region. Part of the rating process involves a statutory valuation of the land on which the building and property is located. Whilst some property owners like to think that their valuation is high and justifiable (and therefore gives substance to the sale price of the property), it is this valuation that is the foundation for the charging and payment of statutory charges. The astute property investor will always question this statutory valuation undertaken by rating bodies in an endeavour to restrict or lessen the amount of statutory rates and charges paid each year.

Rent reviews: A significant concern in the sale of a property is the size and stability of future rent reviews. It is the rent reviews which will underpin the cash flow and hence the attractiveness of the property to purchasers. It is essential that the real estate broker or agent read all of the leases, before any assessment of price or method of sale is given. It is quite possible that the rent reviews projected and detailed in the leases can either hinder or attract purchasers to the property.

Rent arrears: Existing rent arrears should be identified with the owner of a property. Any matters of associated legal pursuit should also be identified. It is possible that the property has had a history of rent arrears and instability. Look for these matters and question the cash flow stability. A history of financial performance from the property over the last few years is the best way to achieve this.

Current building budget: This will involve a budget of income and expenditure as it applies to the building currently in the existing financial year. A good building budget will be written and supported by sound property strategy, projections, and controls. At the time of any potential property sale, it is important to understand that the current financial performance is in line with the expected building budget. If there are any shortcomings or overflows, it is necessary to clarify the reasons for such. If you do not do this, the purchaser of the property will.

The side agreements or deeds: Property occupancy and usage can involve supplementary side agreements and deeds. This can be with tenants or neighbouring properties. Documents of this nature will have impact in the sale even though they may not be registered on the title of the property that you are to sell. Documents of this nature will usually be supported by aspects of common law. If in any such arrangements exist, you must seek further detail and clarity as to how they will be handled at the time of sale. One of the common events here is the existence of rental incentives provided to tenants at the commencement of the lease. When these situations exist, the most common method of resolve is the discharging of the arrangement by the landlord prior to settlement. This can become a term of the contract.

Sinking funds: It is not uncommon for sinking funds to exist on larger properties. The fund is essentially established to set aside money to cover the cost of major items of repairs and maintenance. This would not normally include items of a capital nature. As an example, sinking funds may be used to cover the cost of painting the exterior of a large building such as a shopping centre every five years. If a sinking fund exists, it is important to understand how it will be handled at the time of sale. Consultation with the client’s solicitor and accountant is essential to the process.

Taxation depreciation schedules: The property will have a taxation depreciation schedule. When correctly maintained, these schedules have the ability to lessen the net property income in forthcoming years. This is an immediate taxation benefit to the purchaser of the property who will assume the depreciation schedule as part of the sale and settlement. As the broker or agent in the sale you should check the existence of such documentation and identify what benefits it brings to the sale process. A well constructed and detailed depreciation schedule will make the property sale more attractive.

Short term leases: Many properties have short term leases or casual occupancy active at any point in time. It is vital to know the mechanism under which this occupancy occurs and how it will be terminated. You do not want a short-term occupancy to jeopardise the stability and processes of the sale.

Un-documented lease occupancy: Some may call this a casual lease; however a casual lease can create concern and uncertainty in the process of sale. Some tenants may claim a long-term occupancy from the existence of a previous casual lease arrangement with the landlord. Claims of this type must naturally satisfy the requirements of law to be sustained or upheld by the courts; however you should be cautious in such circumstances given that it can slow down or even jeopardise the sale process.

Warranties and guarantees: When properties are constructed, the normal process of warranties and performance guarantees apply from the construction process. At the time of sale, you need to know if any such matters apply or exist. Copy of the documentation is essential. Further to this, in an existing building where recent fit out activity has created newly constructed premises, it is likely that warranties and guarantees exist for the tenancy construction. These will transfer to the new owner of the property in most circumstances however the documentation to allow this to occur must be suitably constructed. This is a matter for the solicitor acting for the client.

Utilities costs and supply: Every commercial property will be supported by the supply of water, gas, electricity, and communication systems. The process of supply needs to be understood together with the cost of the process. Obtaining copies of recent accounts for those services will help you here. It is possible that some utilities will be supplied direct to the tenants and some others will be supplied direct to the building owner. Any differences in supply should be identified and documented. The costs of supply should be compared to the averages of other properties in the area.This brings to an end the matters relating to financial due diligence. These are the major issues that apply in the sale of commercial real estate; however you should look for any other items given that each property is unique in its performance and financial structure.Your review of these items should include the gathering of all original documentation as part of the checking process. Your notes taken of any comments and findings should be well maintained to protect you in the event of any disagreement or dispute. Given that commercial real estate involves large cash flows and extensive legal documentation, the frequency of disputes is reasonably high. The only way to protect you here is in your quality notes, a questioning mind, and good documentation.