4 eCommerce Implications for Distributors

January 5, 2012

ecommerce-implications-distributorsPreviously, we wrote about some of the opportunities and concerns with eCommerce and inventory management. We are now beginning to see more and more information spring up on this topic and it is obvious that distribution for eCommerce has become extremely important – and that integrated eCommerce and ERP software may be the key.

Consumer demands for eCommerce are peaking – they are demanding faster delivery times at cheaper costs – and distributors are rushing to keep up. So, it is extremely important to ensure you, as a distributor, do whatever you can to make the process more efficient. Derek Singleton, of SoftwareAdvice.com, points out in a recent article 4 ways distributors can capitalize on eCommerce, which we have summarized below:

1.     Make products easier to pick

Ensure fastest-moving products are kept at the front and are easy to access.

2.     Minimize package space

To reduce shipping costs, it is beneficial to minimize the amount of packaging on products. This has the added benefit of also being environmentally friendly – a growing concern in the business world.

3.     Boost efficiencies in delivery routes

If you do your own delivery, a proper software system can help you plan out shipments based on quantities available and help maximize truckloads. Software also exists to integrate with ERP systems to automatically select a shipper based on cost given various criteria from your ERP software.

4.     Critically analyze how orders are shipping

Orders need to be packed on an individual basis but before being shipped there are opportunities for cost-savings. Taking a periodic look at orders ready to be shipped can allow you to identify commonalities on where they are being shipped.

In the modern business environment managers must think about ways in which they can streamline their businesses using technology. These 4 points should help.


Accounting Software Outlook for 2012

December 27, 2011

As we all know, the world will end in 2012. That means that this is your last chance to improve your accounting software - buy or upgrade now to avoid the apocalypse rush!

I do have three somewhat serious predictions for 2012:

accounting-software-outlook

  1. The percentage of new cloud computing / SaaS implementations will continue to rise rapidly: this one’s a no-brainer, as we seem to have gone beyond critical mass in acceptance of the cloud by smaller businesses as well as larger companies. In fact, if the trend we saw in 2011 continues apace, then by the end of 2012 a new on-premise implementation will be as rare as a SaaS implementation was a couple of years ago.
  2. Driven to some degree by the affordability of SaaS, more small companies will invest in newer ERP and Accounting software in order to improve efficiency and thereby reduce personnel costs. This may add marginally to the unemployment woes in North America, but in reality many of these investments will fail to pay off due to inadequate implementation planning and spending.
  3. By the end of next year there’ll be a massive reduction in the (already smaller) volume of business transactions reduced to paper and sent by mail. We’ve already seen this to a degree, but the number of companies that (a) can send invoices, purchase orders and confirmations by email, and (b) that are willing to accept emails instead of hard copies, is increasing rapidly. This will mean that accounting systems that cannot easily generate and email these documents are strong candidates for upgrade or replacement in 2012.

Wishing you all a very happy new year and all the best for 2012 (as long as it lasts…)!


Wholesale & Distribution ERP Software Modules

December 8, 2011

wholesale-distribution-erp-software-modulesAs we mentioned in a previous post, it is important to ensure you are seeking out a system that is well-suited to the industry and space you operate in. For example, we recently covered what to look for in ERP software for food distribution or food wholesale. Now we’ll take a macro-level view and evaluate important ERP software modules for wholesale and distribution.

1. Financial Modules

   Basic    Important
  • AR/AP
  • General Ledger
  • Bank Management
  • Contract Pricing (Price-lists)
  • Landed cost tracking
  • Multi-currency
  • Inter-company accounting
Click here for more Advanced Accounting Modules

2. Inventory Modules

   Basic    Important
  • Order Entry & Invoicing
  • Purchase Order
  • Return Merchandise Authorization (RMA)
Click here for more Advanced Inventory Modules

3. General Modules

   Basic    Important
  • Contact management (CRM)
  • Commission Processing
  • Backorder management
Click here for more Modules/Components

This list should serve as a good starting point for identifying functionality relevant for most wholesale and distribution operations. Proper ERP software should have the majority of this functionality or more to be a true fit for distributors or wholesalers.


Negative Inventory – an ERP Software anomaly?

December 5, 2011

About half a dozen times a year, I’m asked the question: “Does your inventory management and accounting software handle negative inventory?” The answer is no, and in my opinion no software should allow this.

negative-inventoryNow, if you can take me into your warehouse and show me what negative inventory physically looks like, I might change my mind. But of course there is no such thing. (In this case I’m referring solely to item level negative inventory, as opposed to location level, a different story.)

We’ve all heard the reasons:

 - We have to ship out before we have time to receive the incoming PO in the system

 - We need to invoice the customer what we ship, even if our inventory system says out of stock (common POS issue in retail environment)

 - We can always catch up data entry later and all will be correct at that point (actually no, it won’t)

The reality is that I’ve not yet encountered a single business who’s perceived need to handle negative inventory could not be superseded by a properly implemented set of business processes.

If you don’t have time to receive an inbound purchase order into your ERP Software before shipping out to a customer, and you need a physical invoice document to accompany the shipment, realize that the invoice is just a piece of paper. A modern system can generate a document that looks like an invoice without actually posting that invoice through the system. Then later (day-end perhaps) you can process the PO receipts for the day and post all invoices.

Similarly, in a retail environment, you can sell products through the POS, but be required to account for inventory in and eliminate any negative quantities before running day-end or shift-end processes and cashing up.

Check back in a week or so for some of the negative consequences of negative inventory.


3 Signs You’ve Outgrown Your Accounting Software

November 29, 2011

accounting-software-changeThis question was posed to me a few weeks ago during a phone meeting: how do I know if I’ve outgrown my existing accounting software? (This person is currently using QuickBooks.) In just a few minutes we identified three very telling signs that pointed to a “Yes”. Do any of these apply to your business?

  1. The system is (or gets) slow: This may be a little subjective – we all think our system is slow a few weeks after we first get it and think it’s blazing fast. But if you have to wait for minutes while an invoice posts, or if generating a report takes longer than lunch, then your transaction volume and / or data file size may simply have grown beyond the capabilities of your existing system.
  2. Manual Spreadsheet Duplication: If you’re manually keying a lot of business information into Excel, either duplicating or supplementing data that’s in the accounting software, then it’s time to consider moving on. And the more time spent in your company manually updating Excel, the more true this is. (And yet some companies will rather hire extra people to handle these manual updates than spend considerably less money on a more appropriate ERP System.)
  3. Making Business Decisions based on Software Limitations: This one was the clincher on the phone call. The company is considering turning down an exclusive distribution right for what they believe will be a very lucrative product line. Why? Because these products have to be tracked by lot number for potential health recall purposes, and the only way they could do this currently would be manually, outside their accounting software. That would not only be costly, but fraught with risks.

I don’t know if this company will decide to upgrade to a proper integrated ERP Software system with lot tracking capabilities, but the fact that they’re even thinking this way is a clear indication: the answer to the question above is a resounding “Yes”.


Food Distribution / Wholesale ERP Software

November 24, 2011

In today’s post, we are going to discuss typical functionality you should expect from food distribution and wholesale software. Most ERP systems are designed with afood-distribution-wholesale-erp-software particular industry in mind. As a food distributor, be sure to find software that is designed for wholesale/distribution with the required food-related components. A proper ERP system for the food industry should contain most, if not all, of the following components:

Lot Tracking

Lot tracking is important for the food distributors because it allows them to keep track of products sold from the source to the end consumer. Lot tracking allows a distributor to discover the origin of product contamination, if it were to occur, and identify specific “lots” of product to be recalled – eliminating the need to recall all products if only certain groups were affected.

Catch Weight & Multiple Units of Measure (UOM)

Unlike most durable goods, food items are often sold using a variety of UOM. For example, product can be sold by weight, volume or in groups that contain multiple items. Your food distribution software should be able to accommodate multiple units of measure. Catch Weight accommodates inventory items that vary in weight, thereby allowing different pricing allocations for the same item depending on weight.

Flexible Customer/Contract Pricing

Contract pricing is appropriate for a variety of industries but is often well used in food distribution. Your ERP software should automatically allow for different prices customer to customer. Preferred customers may be given preferential rates, for example, and these should be easily accommodated by the software. Customer pricing allows you to set customer-specific discounts as well as discounts that come into effect when an order reaches a certain size. Contract pricing is a similar feature that will allow you to define price ranges for customers that can expire at a defined point in the future – for example, a temporary sale or promotion.

Landed Cost Tracking

Landed cost tracking allows a business to accurate record and report on all expenses tied to acquisition of items such as freight and duty. Landed cost tracking can help food distributors determine the actual cost involved in getting product to their warehouse door – not just the cost of the goods themselves. Landed cost tracking can be used to accurately track margins for effective purchasing and pricing decisions.


Implementing ERP Software on a Budget

November 15, 2011

implementing-erp-software-budgetSticker shock is common when searching out an ERP system. If you are preparing to move off of an introductory system like QuickBooks to a proper ERP system you must have be prepared to make a significant investment in your business. The good news is there are several ways to reduce the up-front costs of a new system.

Implement a Hosted (Cloud) Solution

For the uninitiated, a cloud solution is a software system that is hosted on the vendor’s servers and accessed over the internet. Hosted solutions serve to eliminate the need for maintaining your own servers along with other benefits.

Cloud solutions are typically charged on a monthly basis and can be much more affordable for start-up and smaller companies. Many upfront costs, including hardware and license fees, can be saved by implementing a cloud-based system. Instead, you will be responsible only for a monthly fee that will include all costs you would otherwise need to come up with upfront. Upgrades are also included in monthly fees resulting in the elimination for significant expenditure down the road as well.

Reduce Data Migration

As part of implementing a new software system, data from the old software must be migrated (converted). The amount of data brought over, however, is up to you so cost savings can be found if some less-important data can be done away with.

Aiding in the data migration process can also save money. Typically a consultant must spend the time required to extract the data from the current system to move over to the new system. Many hours of migration can be saved if you have your staff help prepare this data (e.g. have your staff export and organize the data in an excel sheet to then be easily imported into the new system).

Ramp Up

Many software packages have add-ons that include specific functionality that may only be wish-list features. As a result, new or small companies can often run their operations very well on the basic system without these add-ons. You can then decide to implement desired features in the future at a convenient time when your budget allows for it.

Financing

As with most capital-intensive purchases, financing or payment options are often available. A deal can be worked out to reduce initial expenditure so that you can get on the proper system now to accommodate the growth you will see in the future.

Perspective

Implementing a proper software system for your business can be an expensive undertaking. It is crucial, however, to understand the importance of such an investment and to treat it like an acquisition of any other significant business asset – such as a truck, person or machine. When viewed in this way, the cost will seem much more reasonable when compared with other business assets.


The Importance of Software Maintenance

October 13, 2011

The Institute of Electrical and Electronics Engineers (IEEE) defines software maintenance as follows:

“Software maintenance is the process of modifying a software system or component after delivery to correct faults, improve performance, or adapt to a changed environment”

This definition of maintenance is a succinct outline of the benefits of software maintenance. Much like your car, software requires periodic refreshes to ensure it continues to run smoothly, aclip_image002s well as preventative maintenance to reduce the occurrence of problems.

Correct Faults

Software maintenance packages provided by vendors offer peace-of-mind protection by keeping you covered for bugs and software problems. Like any other product, most software packages are under warranty for a specific period of time. Once these warranties expire, however, you may be required to pay out of pocket for fixes, much like you would for your vehicle. Maintenance programs allow your software to stay in warranty so you do not have to come up with cash should an error occur.

Improve Performance

Maintenance programs should include an upgrade component. Under a maintenance program, you will be entitled to free upgrades – usually onceper year. These upgrades often address issues reported by other software users and can greatly improve functionality or performance. Considering the overall cost of upgrades over time, this component of software maintenance is often all that is necessary to make the program worthwhile.

Adapt to a Changing Environment

Technology and the Business environment are the two of the fastest changing aspects of our world. It is increasingly important to make sure that your business is always taking advantage of the best that your software has to offer and that your software matches the business requirements of the time. Regular updates and maintenance will allow you to keep up with market trends and ensure your business is as efficient and effective as it can be.

Predictive Cash Flow

The last benefit, but one of the most significant from a financial perspective, is the ability to gain control over your software expenditure. If you are covered for software bugs and receive regular upgrades, your overall IT expenditures will be reduced to a single monthly (or yearly) fee – your maintenance fee. This eliminates the guessing game of IT expenditure and eliminates large unexpected upfront costs down the road.

Benefits of a maintenance program video


FDA / ISO Compliance – ERP Software to the rescue!

October 11, 2011

Compliance with FDA requirements can be a big burden on small / medium sized  medical distributors. Personnel limitations, and the need to be nimble, cause many such companies to cut corners, and get caught out when audited in inspected. Yet a well-chosen and properly implemented ERP Software system, providing appropriate Inventory Management and Lot Tracking capabilities, can go a long way in helping companies demonstrate compliance.

Michael Nealon, CFO of Southern Implants Inc. of Irvine, CA, has kindly shared his experience and learning in this blog post.

Product traceability is a huge issue with medical devices with both ISO (13485 for medical devices) and with the FDA. We need to know in very quick order where each unit of every device that either we purchased in a finished state or manufactured has been distributed.

In this regard an effective lot tracking system is essential. The lot information must follow the product through all activities – purchase receipt – manufacturing – sales – returns – consignment transfers -  physical count or other adjustments. Further, the lot information must be easily searchable.

While recalls are very rare, and we have never been in that situation, you must be able to demonstrate the ability to carry out a complete, effective recall using this information at all times.

Another important aspect of the Quality System that both ISO and the FDA assess is the company’s use of data analysis including trending as part of the management review processes. The ability of the ERP to readily produce information relevant to quality matters facilitates effective compliance in this regard. The use of fields in our order entry screens track product warranty shipments which is a very important metric that we follow and report on internally as part of our management reviews. Basic data such as trending sales of different products on a line by line basis and family groups (using category groupings) and within different markets using customer categories is frequently used.

Further, relevant to both the FDA and Health Canada we must have all products approved for sale.  We use fields within the product file of Blue Link Elite to track specifics of the approvals for each product in order to demonstrate that each product sold in either of these markets is approved.

All standard operating procedures (“SOP’s”) are developed with the requirements of both ISO and the FDA being paramount. The ability of the system to effectively control permissions is important to ensure that personnel activity is limited to those functions which they are assigned, based on the activities described in the SOP’s. Manager reviews are important and to the extent that we need to separate the rights of individuals creating transactions such as sales order and purchase orders from the individuals who approve these transactions and post them the ability to use the permissions is crucial.

Product Labeling is a very important matter for medical devices and this area is given a great deal of attention by the FDA in particular. The internal consistency of product label information in terms of product codes and product descriptions appearing on invoices and packing slips is important to ensure that there is no confusion on both our part and on the part of customers ordering, receiving and using our products. The ability to readily import, export and modify both product codes and descriptions in Blue Link Elite allows us to effectively and efficiently audit our product codes and descriptions to ensure the integrity and consistency of this information.

Our process validations, which are a key focus of our SOP’s and of the regulators review, are the product cleaning and sterilization processes. Our processes justify us assigning a particular expiry date on the products which we manufacture. We are required to have a method to track the expiry dates of both product that we manufacture and that we purchase to ensure that we do not sell products which have reached expiry or are nearing expiry. We use fields in Blue Link Elite to populate and track lot expiry dates and we easily developed reports to tell us what product lots are approaching expiry so that they can be removed from stock.

Also, in aid of minimizing the number of product items which approach lot expiry, order entry in Blue Link defaults to pick the earliest product layer (which will almost always have the earliest lot expiry) when choosing lots to fill orders.


What Functionality to Expect from an ERP Software System

September 14, 2011

An ERP software system is by definition an integrated system that facilitates a variety of business process (see What is ERP software?). With that in mind, the question becomes: what functionality can be expected from an ERP system?

Although ERP software varies from vendor to vendor, there are a number of standard features that help define the system as a true ERP system, such as:

-          Inventory Management

-          Accounting

-          Order Entry and Invoicing

-          Purchase order processing

-          Contact/Customer Relationship Management

A software package that lacks any of the above features would be hard-pressed to justify their classification as a true ERP offering. The idea behind implementing erp-system-software-functionalityERP software is to have a single system that can manage all facets of a business. If any of these core components are missing, multiple pieces of software may be required to accommodate your business operations.

Aside from the basics that most advanced ERP systems will offer, additional modules and functionality should be available to accomplish additional business-specific tasks. These modules should always be taken into consideration as they can allow for powerful functionality and expansion in the future. Some examples of advanced functionality are:

-          Lot Tracking

-          Landed Cost Tracking

-          Commission Processing

-          Multi-currency and Multi-location capabilities

Rather than installing numerous disparate systems, it is always beneficial to install a single integrated system to serve as a single access point for your business information. Instead of searching for an accounting system to integrate with your inventory system or vice versa, consider an ERP system to simplify your business.


Follow

Get every new post delivered to your Inbox.