Better Distribution Inventory Management with NAV

Microsoft’s continued commitment and development of Enterprise Resource Planning Systems (ERP) has resulted in the release of Microsoft Dynamics NAV 2017. Dynamics NAV is a robust business solution from Microsoft that continues to be enhanced which is quick to implement, easy to use and has the power to support your business ambitions.  Key for Dynamics NAV 2017 is integration and simplicity. This latest ERP solution offers significant enhancements to the core application.   Achieving better Inventory Management with Microsoft Dynamics NAV 2017 and can help you gain efficiency, streamline your supply chain and meet customers’ demands.

Below are some of the key Inventory Management Functionality  that Wholesale Distributor have with Dynamics NAV 2017:

Alternative Vendors:  Manage purchase of the same item from several different vendors. Set up alternative vendors for an item, specify typical lead times used by a specific vendor to deliver that item, and associate price and discount agreements for that item with each vendor.

Assembly Management:  Specify a list of sellable items, raw materials, sub-assemblies and/or resources as Assembly Bill of Materials that comprises a finished item or a kit. Use assembly orders to replenish assembly items to stock or capture the customer’s special requirements to the kit’s bill of materials directly from the sales quote, blanket and order line in the assembly-to-order processes.

Analysis Reports Provide company decision-makers, especially those with overall responsibility for sales, purchases, and product portfolio management, with an efficient and flexible way to get meaningful information out of the system to inform day-to-day decisions. Built on item entries, this granule provides a customizable, analytic view that enables people to add and combine analysis objects—customers, items, and vendors—according to their needs.

Basic Inventory:  Set up items that you carry in your stock and specify their unit of measures, costing method, inventory posting group, unit cost and price and other properties. Post item transactions, such as sales, purchase, negative and positive adjustments from item journals. Quantity and cost records of the posted transactions are stored in the inventory ledger that is the basis for inventory valuation and other costing calculations. Integrated with General Ledger and with the posting processes in Sales and Receivables and Purchase and Payables, this granule is required for the configuration of all other Inventory granules.

Bin:  Organize your warehouse by assigning items to bins, the smallest unit in the warehouse logical structure. Bin assignment is done as the item journals or directly on the document lines (does not apply to order lines).

Cycle Counting:  Manage cycle counting, a basic method of verifying inventory record data used to maintain and increase inventory accuracy. Set up cycle counting on the item or SKU level.

Item Attributes: Use item attributes to add custom data, such as color, country of manufacture, size, or product dimensions, to applicable items, supplementing built-in global item fields. You can define your own type of attribute options, including list, text, integer, and decimal, along with unit of measure for the two latter numeric types. Attribute names and option list entries can also be translated to support multiple language requirements.

You can also block attributes or attribute option values from being used in the future, for example, if they are no longer applicable. When you add items to sales and purchase documents, or just organize your items, you can view and filter on the attribute values to limit the list of items to choose from or take action on.

Item Budgets:  Make sales and purchase budgets on the customer, vendor, and item levels, and in both amounts and quantities. Prepare and record a sales budget that can serve as input to decision makers in other operational areas, such as purchasing and logistics. Decision-makers gain information about future expected demand they can use for business discussions with the customers.

After budgets are made, track the actual sales performance by means of calculating the variance. The ability to move budgeted figures between the system and Excel provides additional flexibility to the budgeting process.

Item Categories: Use item categories to group items into a hierarchical structure and you can define your own custom categories, assigning attributes to each category. When you add items to a category, the items inherit the attributes of the category, ensuring a common set of attributes on items in the same category, and saving you time. If required, you can still assign item specific attributes to particular items.

Item Charges:  Manage item charges. Include the value of additional cost components such as freight or insurance into the unit cost or unit price of an item.

tem Cross References:  Quickly and precisely identify the items a customer is ordering on the basis of item numbers other than your own. Cross-reference information from customers, vendors, and manufacturers, as well as generic numbers, universal product codes (UPCs), and European article numbers (EANs) that can be stored and easily accessed.

Item Substitutions:  Link items with the same or similar characteristics so that if a customer orders an item that is unavailable, you can offer substitute items and avoid losing the sale. Or, provide an extra service to your customer by offering lower-cost alternatives.

Item Tracking:  Manage and track serial and lot numbers. Assign serial or lot numbers manually or automatically, and receive and ship multiple quantities with serial/lot numbers from a single order line entry.

Location Transfers:  Track inventory as it is moved from one location to another and account for the value of inventory in transit and at various locations.

Multiple Locations:  Manage inventory in multiple locations that may represent a production plant, distribution centers, warehouses, show rooms, retail outlets and service cars.

Non Stock Items:  Offer items to customers that are not part of your regular inventory but that you can order from the vendor or manufacturer on an one-off basis. Such items are registered as nonstock items but otherwise are treated like any other item.

Pick:  Enable warehouse workers to create a pick from the released order. Pick is managed from a separate user interface when shipping items in an order-by-order environment.

Stock-Keeping Units:  Manage stock-keeping units (SKUs). Identical items with the same item number can be stored in different locations and managed individually at each location. Add cost prices, replenishment, manufacturing information, and so on, based on the location.

Learn more about Inventory Management in Microsoft Dynamics NAV