Vendor Inventory

From UG

(Difference between revisions)
Jump to: navigation, search
(Steps)
(Steps)
Line 7: Line 7:
* Vendor logs on to the Inventory module
* Vendor logs on to the Inventory module
:* Vendor's visibility ; A vendor can only update, view, edit their specific inventory;
:* Vendor's visibility ; A vendor can only update, view, edit their specific inventory;
-
:** For example, vendor A logs on to the system, vendor A can only see vendor A's inventory.  
+
:** For example, vendor A logs on to the system, vendor A can only see inventory that belongs to vendor A.  
* Vendor adds:
* Vendor adds:
:* Item#
:* Item#

Revision as of 16:18, 24 May 2010

Contents

Business Requirement

Elizabeth Arden would like to have a vendor Inventory module that can track shipments that are on hand by vendors, suppliers, and in-transit.

Steps

Step 1

  • Vendor logs on to the Inventory module
  • Vendor's visibility ; A vendor can only update, view, edit their specific inventory;
    • For example, vendor A logs on to the system, vendor A can only see inventory that belongs to vendor A.
  • Vendor adds:
  • Item#
  • Item Desc
  • Item Type
  • Supplier (read only vendor name, mapped from vendor user's profile)
  • External Manufacturer (EM)
  • Supplier USA on hand
  • Supplier International on hand
  • NOTE: the combination of Item# and EM are unique

Step 2

  • Jaguar operator updates/creates a record to move shipment from supplier to destination (In-transit)
  • Shipper (supplier)
  • Consignee (EM)
  • MOT
  • Item#
  • Item Desc
  • Qty
  • NOTE: the combination of Item# and EM are unique
  • Qty value will be updated on Vendor Inventory In-transit columns
  • Once the shipment is delivered (no longer in-transit) to destination(consignee/EM)
  • Number of Qty from in-transit will be deducted and add to the destination (EM/EA) on hand
  • US Total on hand: Number of Total USA shipments on hand including Supplier USA on hand will be updated
  • ATP next 40 days: Number of Total in-transit shipment including International shipment on hand will be updated as available to promise
  • Total pipeline : US Total on hand + ATP next 40 days
  • See #Figure 1. Vendor Inventory

Figures

Figure 1. Vendor Inventory

File:EAInventory.JPG

Personal tools