LS Central and Inventory Control

All of the Inventory in your store can be thought of as tied up capital. Its money spent for a future sale that hasn’t happened yet. Managing your inventory is a delicate balance because you must ensure

1. that you do not have excess inventory you cannot sell and

2. that you have enough stock to satisfy customer demands.

From the perspective of someone outside of the retail space, a sold-out item on the surface may seem like a success; a business was successfully able to sell 100% of its stock. They can simply order a higher quantity next time and the cycle will continue. A customer could even buy a substitute item if something is out of stock.

Although this this type of inventory control might appear as a successful business model, it has a drastic effect on customer loyalty. If you don’t have a product that the customer wants, they will eventually move on to a store that has what they want and never look back. Amazon, with its many options and suppliers, has become a catalyst for this kind of consumer behavior. According to the Harvard Business Review (, up to 43% will go to another store to buy the item (Note: this was published in 2004, you can imagine what the rate is now). The importance of keeping inventory at a safe level, both not holding up unnecessary capital, and ensuring you do not sell-out is paramount in today’s environment. But how do you determine the optimal amounts of products to keep on hand and when to reorder stock?

Luckily, LS Central has a robust replenishment module that tracks previous sales and can automatically create purchase orders based on previous sales or trends which are all recorded within LS Central. This is a very powerful tool within LS Central and can be customized for every item within your business or from a group of products.

Sandham Adams has extensive knowledge of LS Central which can be used to overcome this inventory control balancing act and help solve many other business issues. We’d love to tell you more. To book a demo of LS Central, please contact us at 416-225-2265.

Test Posting and Testing in Business Central Configuration

Sometimes you want to test a Business Central configuration posting before applying it in the production set of books. Or, maybe you want to try a different configuration to confirm it works and has the desired results before committing to it in the production company. When implementing a new ERP, or even when optimizing an existing one, this is an essential phase.

Business Central has a handy function that takes care of this called “Companies” your user needs the right permissions to access this feature). herewith Companies, you can copy one company to new temporary test company, test whatever you want and then delete the test company after you are finished with it.

Steps To Do This

  • Type “Companies” into the search box and select it.
  • You will be presented with a list of your existing companies. To make a new test company, click on the company you want to copy in the list, and select “Process” and “Copy”.
  • You will be prompted to enter the name of the new test company.
  • After entering the test company name, press OK to start copying.

It may take a long time to copy the company depending on the amount of associated data, so it is prudent to do this outside of business hours until you know how long it takes for your company.

When the company is finished copying, you can select the company from the ”Gear” at the top of the screen. Then, select “My Settings” and change the company using the 3 dots (…)

Test away in this test company to apply your new Business Central configuration.

When you are done with the company and want to delete it, use the same “Companies” page, click on the Company to delete and select delete. You cannot delete the company that you are actively using., so be sure to switch back to your live company first.

There may be some extension licensing restrictions when doing your testing, but these can be handled by the publisher of your extension.

If you need any assistance with your Business Central configuration or want some help with a complete implementation, contact Sandham Adams, who has the expertise to guide you through the process.

Microsoft Dynamics 365 Business Central is an Accounting System

Graham Sandham

Many years ago, a colleague reminded me that everything in a business either flows into or out of the business’s accounting system.

I think something that has been lost in the glitz and spectacular functionality of Business Central is the fact that it is a robust accounting system. Reporting and ultimately government related filing like tax returns are generated based on the information created and stored in Business Central.

It has a Chart of Accounts and a G/L (General Ledger) Entry table that stores transactions for those G/L Accounts. It generates a Balance Sheet and an Income Statement.

It also handles and stores the complicated transactions related to inventory costing for distributors and manufacturers.
When dealing with multiple currencies, Microsoft Business Dynamics 365 Business Central keeps track of the realized and unrealized gains and losses related to those transactions in different transactions.

It keeps track of banking transactions and allows bank reconciliation.

In most businesses, there are five main business activities to lesser or greater degrees:

  • Invoices go out (Sales Invoices)
  • Invoices come in (Purchase Invoices)
  • Payments come in (Cash Receipts)
  • Payments go out (Payments or Disbursements)
  • Payroll (employees need to get paid)

These are all represented by transactions that flow into the Business Central financial functionality.

Fixed assets need to be tracked, with purchasing and depreciation recorded.

Budgets and revised budgets need to be tracked against actual transactions.

At its core, Business Central is an accounting system. Its not an afterthought or add-on functionality, and as an accounting system, can be an essential part of any business.

Sandham Adams’ team of experts can help with your Microsoft Dynamics 365 Business Central (formerly Microsoft Dynamics NAV) installation or migration. Contact us for more information.

COVID-19 and the Promising Future of Cloud Software

The COVID-19 pandemic brought with it an unprecedented requirement for IT solutions that allow employees to work remotely. Online meeting software, such has zoom, has become an invaluable tool in order to keep teams working closer together.

Businesses that have become early adopters of cloud technologies have a strong advantage during this isolation period. This advantage is evident for companies serving both Business to Business (B2B) and Business to Customer (B2C) markets.

Microsoft Dynamics 365 Business Central is the latest ERP developed by Microsoft which is taking the main stage from the previous ERPs Microsoft had been developing such as Microsoft Dynamics Nav and Microsoft Dynamics GP. Business Central is a cloud-based solution, so businesses do not have to worry about their own server security- it is all handled by Microsoft. The advantages to this solution have become obvious over the last few weeks as we’ve all been staying home whenever possible. With staff and owners able to access their financial, inventory, and production information remotely, businesses can provide a far safer work environment while still allowing a business to function.

For businesses primarily operating in the retail/hospitality industry, the impact has been devastating. However, any businesses, whether big or small, which are early adopters to ecommerce solutions have a clear advantage in this difficult time. LS Central’s out of the box integration with e-commerce sites allows for business to still operate and serve customers.
For businesses still reluctant to switch to the cloud, this current COVID-19 disruption has created the greatest reason to reconsider and make the change. With so many working from home, these services have received the best stress test cloud software has ever endured. Microsoft’s Azure (the cloud computing backbone for these services) has seen a massive increase in users and continues to provide the needed stability and reliability of cloud-based solutions.

For more information on how your organization can make the change to cloud-computing using Microsoft Dynamics 365 Business Central, call the experts at Sandham Adams at (416) 225-2265.

Sorting Through Your Data Clutter With Business Intelligence Tools

“Big data” is one of the most popular business buzzwords of the recent decade. Until fairly recently, the benefits of analyzing an organization’s data, be that data big or small, was only available to very large organizations who could hire specialized external resources to sift through this data and apply specifically tuned data mining algorithms and statistical analysis techniques to the data. Not only was this time consuming and extremely costly, the results of that analysis were often inconclusive, making decisions from that analysis risky or at least not done with confidence. 

Times have changed. Data about your business and customers is now considered one of the most important assets a business can have. Modern business intelligence tools can analyze your ERP system data easily with predefined and proven data mining algorithms. Chances are your organization is sitting on a gold-mine of data that, with the right analysis, could yield huge benefits. 

What Can Business Intelligence Tools Do For My Business

So, what can you do with this data gathered from your ERP solution and how exactly do you find meaningful metrics from it? How can you better understand your customer base, increase retention, and manage your prices to drive more profit?

Nowadays, there are plenty of solutions that can pull data directly from your ERP or business management solution and utilize built-in Business Intelligence Reporting tools that run Microsoft Dynamics 365 Business Central. One great example is Power BI.

Power BI

Power BI can pull data directly from Business Central. From there, it has the ability to predict table relationships. With that capability out-of-the box, you’re already well on your way to having a meaningful dataset. Within minutes from beginning the analysis, an end-user can create a dynamic report which allows you to have real-time insights into your business. 

The dynamic reports and dashboard layout are powerful tools that allow you to create reports depending on the user’s needs or role. For example, if an executive wants to track current sales on their phone, you can quickly develop a Power BI report which will provide them with real-time metrics, allowing key decision-makers to stay ahead of the game. These dashboards can also be integrated directly into Business Central’s role centers.

In a retail environment, leveraging feedback from business intelligence tools can be an incredibly powerful resource to help with day to day decisions, keeping your business running as smoothly and optimally as possible. An easy example of this is the ability to track unit sales by territory, seasonal performance, and variance.  This kind of data is all within your organizations data inside business central. With the many online tutorials, you can quickly learn to reshape the data you have available to get the metrics you need for success. 

Another exciting new feature is the Power BI Artificial Intelligence Module which can analyze rich text data from customer reviews, or employee satisfaction reports. You can also combine multiple datasets, providing you with a better picture of how market trends affect your business. 

Reap the Benefits For Your Organization

These examples are just the tip of the iceberg – a wealth of information from these business intelligence tools provide a true decision support system that organizations have been trying to implement for decades. The technology is here at your fingertips. The time to give it a try is now!

Sandham Adams specializes in implementation and training of Microsoft Dynamics 365 Business Central and Power BI, which can help your organization benefit from these results. Contact us for a quote to help install or expand and upgrade your Microsoft Dynamics 365 Business Central solution.

Keeping Our Microsoft NAV Skills Sharp

Last November, we took our annual visit to NAV TechDays in Antwerp, Belgium.

NAV TechDays describes itself as the place where some of the best developers and leading business owners cross paths, exchange ideas, find partners and conceive projects. It is where community ties are strengthened and where boundaries will be broken. It is hosted by the people from and its owner Luc Van Dyck.

I always look forward to the keynote address that is presented by people from Microsoft that are designing and developing Microsoft Dynamics 365 Business Central (formerly Dynamics NAV). As the product evolves, there is always a lot for them to say. The keynote focused on many things, not the least of which is the newest release having no windows client (web client only) and no more of the old development environment. Development is done with Visual Studio Code and the AL language creating extensions from now on.

t Dynamics 365 Business Central (formerly Dynamics NAV). As the product evolves, there is always a lot for them to say. The keynote focused on many things, not the least of which is the newest release having no windows client (web client only) and no more of the old development environment. Development is done with Visual Studio Code and the AL language creating extensions from now on.

Central (formerly Dynamics NAV). As the product evolves, there is always a lot for them to say. The keynote focused on many things, not the least of which is the newest release having no windows client (web client only) and no more of the old development environment. Development is done with Visual Studio Code and the AL language creating extensions from now on.

I was worried about the web client not having sufficient functionality but now I can see that the web client as just as good or better than the Windows client.

During breaks I had the chance to reacquaint myself with the various vendors of add-ons and tools for NAV and Business Central including Anveo, ForNAV, Idyn, ALOps.

There is usually a shopping list from my clients who are interested in some of the add-ons that are at the exhibition hall. For example, calendar and scheduling, visual scheduling of jobs and production orders, etc.

After the keynote, the next day and a half is filled with sessions related to Microsoft Dynamics NAV and Microsoft Dynamics 365 Business Central.

I attended a great session that was presented by Gunnar Gestsson from Iceland that was related to exchanging and saving files, Azure BLOB, file services like drop box etc.

I attended a couple of sessions related to integrating the Microsoft Power Platform with Microsoft Dynamics 365 Business Central.

One of the main takeaways I have is to focus on using the Microsoft Power Platform which includes applications like Microsoft Power BI, Microsoft Power Apps, and the recently renamed Microsoft Power Automate (Flows). I believe the future will be to customize Microsoft Dynamics 365 Business Central as little as possible and rely on using the Power Platform where possible to do the heavy lifting instead of customization.

Sandham Adams specializes in assisting organizations with ERP implementations, specifically using Microsoft Dynamic 365 Business Central (formerly Dynamics NAV) services. Contact us to start a discussion about how we can help your organizations.