Requirements of ERP for Wholesale Distribution & Logistic Service Providers


1.Wholesale Distribution & Logistic Service Providers

Monitoring carrier performance, maintaining visibility into supply chains, and providing accurate and up-to-date information about shipments and supply chain performance is the challenge for distributors, freight forwarders, logistic service providers and 3PLs. Having a handle on what is in every warehouse, every truck and every shipment at a given time as well as being on top of what is in the pipeline, is crucial. Business Process Management features allow you to set up rules and conditions, and to receive alerts or notifications when certain conditions are met. ERP’s built in CRM functionality can help you manage and streamline customer order management. Better tracking and visibility will enable you to anticipate customer demands and analyze customer profitability so that you can focus on increasing and retaining your most profitable customers. Fully integrated supply chain functionality will enable you to optimize logistics networks, manage transportation and warehousing operations, and provide other value-added services to customers.

Requirements of erp for Distribution and Logistics


Every aspect of your business can be interconnected with the ERP system, including purchase planning and requisitions, delivery schedules and shipments, contracts and billing. Finances, billing, procurement and administration can be unified within the same program, providing consolidated information for quicker and more accurate analysis, and more efficient processes.

2.      Industry Targeted Functionality

  •   Fleet Management
  •   Warehouse Management System (WMS) to optimize inventory service levels, delivery schedules and routings
  •   Hand-held connectivity
  •   Shipping cost collection and burdening
  •   Integrated UPS and FedEx capabilities
  •   Multiple location views to track inventory and transactions in real-time
  •   Support for RFID requirements
  •   Delivery scheduling and routing
  •   Value-added services, such as vendor/customer-managed inventory coupled with detailed shipping and invoicing
  •   Forecasting and market trend analysis for demand-based inventory replenishment
  •   Sales opportunity management
  •   Sales reps, targets and commission management

3.      Issues & Solutions

3.1.Delivery Scheduling to Chain Stores Using a Fleet

Planning and Execution of Delivery Scheduling to Chain Store Branches Using a Fleet of Vehicles. ERP’s Delivery Scheduling module enables you to:

  •     Set up distribution routes and arrange order delivery by date and route
  •     Manage a fleet of vehicles, defining weight and volume capacity
  •     Automatically assign vehicles by date and distribution route, controlling for weight/volume limitations
  •     Prepare order picklists according to distribution routv Produce sales invoices and shipping documents per distribution route

3.2.Order Delivery Using External Logistical Center Resources

Customers’ orders are rerouted for delivery from the logistical center. When orders are delivered, picklists are imported directly from the logistical center, thereby updating order and inventory balances and generating shipping documents and customer invoices.

3.3.Automatic Scheduling of Part Delivery

ERP includes a program for automatic assignment of sales orders to distribution routes. The Schedule Deliveries program assigns sales orders to distribution routes based on the order supply date, delivery routing, delivery days defined for the customer, and the company’s working hours. For an order to be included by the Schedule Deliveries program, it must have a status flagged in the Schedule Deliveries column of the Statuses for Orders form.

3.4.Billing Customers for an Order before Shipping

Billing customers on the basis of a sales order, before goods are shipped, while checking the customer’s current credit balance

To bill a customer for an order prior to shipment, while checking the current credit balance, in a manner that allows you to later open a customer shipment document linked to the sales order:

  •  Open a multi-shipment invoice and link it to the sales order. The order remains open and the usage of customer credit is transferred from the order to the invoice.
  •  Open a customer shipment document for the customer to a consignment warehouse, on the basis of the order. The order is closed, and the shipment does not use the customer’s credit, since it is recorded to a consignment warehouse. This allows you to easily track the goods that were “shipped” but not supplied to the customer, according to the contents of the consignment warehouse. It also prevents any duplication in the balance sheet – both for the customer debit and for inventory – since the consignment warehouse is not flagged for inventory valuation.
  •  After payment is received from the customer, open a second customer shipment document based on the first. This document, which will not be flagged as billable, transfers the goods from the consignment warehouse to the customer.

3.5.Using Handheld Devices in the Field to Determine Customers

Companies whose sales reps circulate in the field with handheld devices can provide their reps with comprehensive data regarding a customer’s debts. Once a day, the device can be loaded with up-to-date detailed information regarding open invoices, post-dated checks, etc.

3.6.Managing Price Lists & Discounts by Customer Group

Managing price lists and discounts by a customer group while maintaining a single entry for price lists and discounts for a given customer group.

Define a representative customer for each customer group. Changes and updates to price terms or discounts for the representative customer take effect immediately for all customers in that group.

3.7.Linking Various Parts to a Vendor

ERP contains a Parts per Vendor form for listing the various parts provided by a specific vendor. When selecting the vendor in purchase documents, Choose lists include only those products that vendor provides, and not the entire part catalogue.

3.8.Customer Bonuses

The bonus system in ERP enables you to offer customers bonus parts when they order a certain quantity of a specific part or parts belonging to the same part family. There are two types of bonuses:

  • Regular bonuses are given upon purchase of a certain part by some or all customers.
  • Special bonuses are defined for specific customers and are given to those customers only.

You can define progressive bonuses based on quantity purchased, so as to increase the customers’ incentive to purchase large quantities.

3.9.Purchase Planning (MRP) for Commercial Companies

Material Requirements Planning (MRP) for Distributors enables the planning of required issues for sales orders and forecast orders (without addressing BOMs or production/assembly operations of any kind).

Such planning “explodes” requirements for the assembled product to the next level down in the BOM. For instance, it will generate purchase requisitions for the component parts of a bicycle.

3.10. Blanket Purchase Orders

ERP enables you to record blanket purchase orders, which offer special pricing terms in exchange for a commitment to purchase a specified quantity of parts within a set time frame. The blanket order acts as a basis for the production of multiple purchase orders. The system provides a means of tracking the remaining quantity in the blanket order, as well as the monetary value of the order balance.

3.11.Recording Vendor Availability for Items in a Purchase Order

ERP enables you to maintain a status for each line item in a purchase order from the vendor, providing a means of tracking and supervision of the estimated time to receipt of ordered items to the company warehouse.

3.12.Warehouse Management System (WMS)

This module supports optimization of the three basic operations of warehouse management:

  •   Directed Picking
  •    Directed Replenishment
  •    Directed Putaway

These are all subject to constraints defined in advance by the warehouse manager.

You can also use this module to plan other routine warehouse tasks, such as inventory count, return to vendor, warehouse transfer, etc. For each warehouse operation recorded in this module, an appropriate inventory transaction document (e.g., shipping, sales invoice, or warehouse transfer document) is created, using built-in programs.

The module interfaces with automated data collection (ADC) systems, and supports input of inventory data via handheld devices and other data collection tools.

3.13. Managing Special Offers for Your Customers

ERP’s Special Offers module enables users to offer incentives to customers that purchase a designated amount of goods within a defined period.

In the first stage, you assign a name, start and end dates, and ERP to the offer (i.e., if two offers are defined for the same part or part family, the offer ERP determines which one will be attached first to invoiced sales when the campaign is over). Later on, you can define a target quantity for the part, which the customer must purchase in order to be eligible for offer benefits. Alternatively, you can define a target sum; customers who purchase target parts equaling this sum during the defined offer period will be eligible for benefits.

Customer compensation can be according to any one of the following models:

  • Offered Products: Select a part number and quantity to which the customer will be entitled if they meet the offer target.
  • Credit in Percentage of total purchases during the offer period: Determine the credit % which the customer will receive.
  • Fixed Monetary Credit for purchases made during the offer period: Indicate the amount of credit which the customer will receive.

3.14.Locating Parts by Part Specifications

For companies that deal with diverse parts characterized by a variety of parameters (e.g., spare car parts), ERP offers a module that allows you to define specifications for each part, and to locate the part from within the lines of a sales order using a Part Specifications Explorer. For example, you can locate a spare car part by the car’s make and model, the side damaged, etc.

3.15.Consignment Warehouse Replenishment

ERP’s Replenish Consignment Warehouses program calculates current and projected inventory levels in consignment warehouses and determines the quantities of each part that are needed to replenish the supply, according to a set of inventory parameters defined by the user. Furthermore, the program can be set up to open the necessary orders automatically.

3.16. Analyzing sales data for similar parts

Companies that manufacture and distribute products often maintain identical parts with different characteristics. For instance, for the electrical industry, this may be identical products with different voltages (110V vs. 220V); in the fashion industry, this may be shirts of different colors, fabrics and/or sizes. These products need to be maintained separately in inventory, yet should be analyzed in executive reports as the same product.

ERP allows you to define a common base product for parts with similar characteristics. In this manner, for example, you can analyze sales data for a 110V part separately, or for the base product, which takes into account sales of both the 110V part and its parallel 220V part. This makes it easier to determine how many units of a particular product were sold or will be sold, regardless of differences in a particular feature (voltage, color, fabric, size, etc.).

3.17. Analyzing sales data for similar parts that differ

The Problem:

In factories that process a large quantity of parts, it is too difficult to maintain the various levels of safety stock manually. The solution described here allows you to calculate safety stock for each part in a controlled automatic manner. The calculation is performed on the basis of actual material usage during a defined period, and includes the possibility of adding coefficients or manually revising recommended quantities.

The Solution:

ERP provides a form that displays the usage of raw materials during the desired period, and recommends the appropriate level of safety stock on the basis of this data, as well as various coefficients. Usage data are taken from issues to the plant floor, warehouse transfers and customer sales.You can manually revise the recommended safety stock after approving the results displayed in the form. You can also perform a general update of the safety stock on the basis of the form data.




Leave a Reply

Your email address will not be published. Required fields are marked *