Thursday, November 1, 2018

LS NAV - Replenishment - How to use

http://help.lsnav.lsretail.com/Content/LS%20Retail/Replenishment/Replenishment.htm?tocpath=Retail%7CReplenishment%7C_____0

  • Process Overview
o   Define Replenishment Rules per item per destination location
o   Define Transfer Templates
o   Run Transfer Template manually or automatically to suggest transfers from a specific location (usually Warehouse)
§  Create Transfers
§  Pick and Ship transfers to consume stock
o   Define Purchase Templates
o   Run Purchase Template Manually or automatically to suggest purchases from a specific location, (warehouse or store)
§  Create Purchase Orders
§  Receive and Put Away purchase orders to increase stock
  • What are the different Replenishment Types?
    • Set on Retail Item Card>Replenishment Control Data
    • Automatic-From Data Profile=Use Replenishment Data Profile Settings
    • Average Usage = Historical sales based on rules set in Replenishment Sales Profiles
    • Manual Estimate = Use Manual Estimated Daily sale field (used for new items with no history)
    • Stock Levels=Only use Reorder Point and Maximum Stock for simple replenishment
    • Like for Like=Replenish in the same pattern that is sold (auto-replace stock sold,sell 10, buy 10)
    • Demand Plan=Integrated to Demand Plan Module (Calculates Daily forecast based on historical sales plus other rules, requires lots of history, stable products)
  • Most commonly used menus
    • LSRetail>Replenishment>Automatic>Purchase Replenishment Journal
      • Add items to journal
      • Create Purchase Orders
    • LSRetail>Replenishment>Automatic>Replenishment Templates
      • Template = collection of filters used in Purchase Replenishment Journal
    • Retail Item Card>Replenishment Control Data
      • Define general replenishment rules for this item for all locations and all vendors
    • Retail Item Card>Replenishment Control Data>Replenishment Information Setup>Item Store List
      • Define Vendor-Item-Store specific replenishment rules
  • What are the profiles for?
    • Replenishment Item Profiles
      • After filling in info, click Update to apply replenishment settings to all relevant items (Updates their Replenishment Control Data)
    • Replenishment Data Profiles
      • Can be used on Item Category
      • Defines Replenishment defaults for entire category if none explicitly set on item
    • Replenishment Sales Profiles
      • Defines how Average Sales are calculated when using Average Usage Replenishment Calculation Type on Replen. Inf. Data
    • Replenishment Forw. Sales Profiles
      • If defined, allows additional comparison to future period to adjust for upcoming seasonal future changes based on historical sales
      • Used in Replen control data setup
  • Where do i set lead times for vendors?
    • Retail Item Card>Ordering>Safety Lead Time (30D,3M)
      • Define Default Lead times if no others defined
    • Retail Item Card>Vendors>Item Vendor Catalog
      • Define Lead times by vendor
  • How do i see slow moving items?
    • Replenishment>Stock Turnover
      • Average Stock: Shows average stock for time period selected
      • Turnover Avg Inventory: Sales / Avg Stock
      • Turnover: How many times Avg. Inventory was sold (Sales/Avg. Inventory)
      • Waiting Time: How long it would take to sell all stock in days
    • Should be modified to add custom turnover calculations, filter on turnover value, filter on item division,group,category, last date purchased, last date sold
  • How do i see obsolete stock?
    • Item Age Composition - See old stock, should be run periodically, should add filter for only old stock
    • Worst Selling Items
    • Items without Sale
  • How do i see out of stock report?
    • Retail Item Card>Replenishment Control Data>Factbox-Out of Stock>Replen Out of Stock Days
      • View should be saved, or report built using this data
  • Automated Replenishment is recommending too much/little stock. How do i fix it?
    • RCD = Replenishment Control Data
    • Review RCD>Reorder Point (Suggested amount is increased to reorder point if it exists)
    • Review RCD>Maximum Inventory (Suggested amount is increased to max inventory if below reorder point)
    • Review RCD>Store Stock Cover (Suggested amount is increased to cover this many days' worth of sales)
    • Review RCD>Sales history Adjustment (Fix anomalies or errors in history that cause miscalculations, has no financial impact)
  • Useful Reports?
    • LSRetail>Backoffice>Reports&Analysis
    • Lifecycle curve
    • Trend report
  • Does this work with Blanket Orders?
    • No.

No comments:

Post a Comment