Tuesday 21 November 2017

Stock Management in Microsoft Dynamics NAV 2017

Stock Management 2017:

In NAV you can setup multiple location which allows companies to manage business operations within one database.

Location:
a place that handles physical placement and quantities of items.

Stock keeping unit:
An item or a variant of an item at a specific location.

Managing multiple locations:
At location level on a stock keeping unit card we can add:
1. Replenishment information(restoration of stock to former level)
2. Addresses
3. Financial posting information.


Ex.
Item 70003
Navigate -> Stockkeeping Units

To view transaction of item we go to Item Ledger Entries. .
Item Statistics - Different piece of statistic for this item based on criteria entered.

We can setup unlimited no. of UOM.

UOM: is a definite magnitude of a quantity.

  • It is used as a measurement of same kind of quantity. .
  • A unit of measure is assigned to all inventory items and must be defined before a product can be entered. 
  • Each product will have a stocking unit of measure, sales ordering unit of measure and a purchasing unit of measure.

Unit of measure can also have automatic conversions to other units of measures by way of a conversion factor

Ex. for item 80100 - Printing paper

Base UOM - Box
Sales UOM - Pack
Purch. UOM - PALLET

All the UOM values are inter-related to each other.
Each uom is related to Base UOM on item card through conversion factor.

Item variants - We use this in item card if we've large no. of identical items. (same item, different colour)

Item Cross Reference:
Cross reference can be setup against items. It can be a barcode or a specific code used by vendor or customers.

When the quantity required on the sales order exceeds the quantity i.e. available in inventory, a message will apear for the user that substitute exists for this item, (if any substitutes available).

Item availability can be viewed in numerous ways in item card,

  • By Event 
  • Period Variant
  • Location
  • BOM Level
  • Timeline.

These Item availability i.e. displayed based on different factors actually defines the basis of stock management.

No comments:

Post a Comment