Vendor Inventory

From UG

(Difference between revisions)
Jump to: navigation, search
(Steps)
(Steps)
Line 36: Line 36:
== Steps ==
== Steps ==
'''Step 1'''
'''Step 1'''
 +
* Vendor logs on to Internal application
 +
:* Require: Vendor visibility (limit access)
* Vendor logs on to the Inventory module
* Vendor logs on to the Inventory module
:* Vendor's visibility: A vendor can only add, update, and view their specific inventory
:* Vendor's visibility: A vendor can only add, update, and view their specific inventory
Line 49: Line 51:
:* Supplier International on hand
:* Supplier International on hand
:* NOTE: the combination of Item# and EM are unique
:* NOTE: the combination of Item# and EM are unique
-
:* See [[#Figure 7. Add - Vendor Inventory ]]
+
* System auto-calculates:
-
* Number of Supplier USA on hand is added to Total US on hand
+
:* If '''supplier USA on hand number X''' is added, then '''number X''' is added to '''Total US on hand'''
-
* Number of Supplier International on hand is added to ATP next 40 days
+
:* If '''supplier International on hand number Y''' is added, then '''number Y''' is added to '''ATP next 40 days'''
 +
:* Total pipeline = Total US on hand + ATP next 40 days + Total pipeline
 +
* See [[#Figure 7. Add - Vendor Inventory ]]
'''Step 2'''
'''Step 2'''
-
* Jaguar operator updates/creates a record from Ops module to move shipment from supplier to destination (In-transit); (This is what Jaguar Operator does on CT2...create shipment with all information, once the shipment moves but not delivered - In transit
+
* Jaguar operator creates a record from Ops module with all information that make a shipment is in-transit time (moved but not delivered)
:* Shipper (supplier)
:* Shipper (supplier)
:* Consignee (EM)
:* Consignee (EM)
Line 61: Line 65:
:* Item Desc
:* Item Desc
:* Qty
:* Qty
-
:* NOTE: the combination of Item# and EM are unique (this info will be checked against Vendor Inventory table in order for system to auto-update info for Inventory information)
+
* The combination of Item# and EM are unique (this info will be checked against Vendor Inventory table in order for system to auto-update info for Inventory information)
-
:* Qty value from commodity table will be updated on Vendor Inventory In-transit columns on Inventory module (Land/Air/Sea:Truck/Air/Ocean)
+
* Process of behavior between JG operator updates a shipment with needed information
-
:* Number of Qty from in-transit LAND, AIR, and SEA will be added to ATP next 40 days
+
-
 
+
-
 
+
-
'''NOTE'''
+
-
* When JG operator creates/updates a shipment
+
:* If a combination of shipper and consignee are a part of Vendor Inventory table, it should be tagged on ContTab that some items are a part of Inventory
:* If a combination of shipper and consignee are a part of Vendor Inventory table, it should be tagged on ContTab that some items are a part of Inventory
:* Then try to search commodity table
:* Then try to search commodity table
Line 74: Line 73:
:* Update  Vendor Inventory table
:* Update  Vendor Inventory table
:** If MOT is Truck update qty value -> LAND
:** If MOT is Truck update qty value -> LAND
 +
:*** If MOT Land qty value A is added, then value A is added to ATP Next 40 days field
:** If MOT is AIR update qty value -> AIR
:** If MOT is AIR update qty value -> AIR
 +
:*** If MOT Air qty value B is added, then value B is added to ATP Next 40 days field
:** If MOT is Ocean update qty value -> SEA
:** If MOT is Ocean update qty value -> SEA
 +
:*** If MOT Sea qty value C is added, then value C is added to ATP Next 40 days field
 +
:** Total US on hand + ATP next 40 days + Total pipeline
 +
'''Step 3'''
 +
* Jaguar Operator updates the shipment's actual delivery date (no longer in-transit)
 +
:* Once the shipment is delivered to destination (consignee/EM)
 +
* System run in the background updating the Inventory table
 +
:* The shipment moved and delivered, that means quantity of this shipment is delivered to consignee and no longer In-transit - quantity value will be added on consignee on hand (EM/EA on hand)
 +
:* Number of qty value from a particular in-transit MOT shipment will be deducted from in-transit MOT and added to EM on hand and deducted from ATP Next 40 days field
-
'''Step 3'''
 
-
:* Once the shipment is delivered (no longer in-transit) to destination (consignee/EM) on Inventory module
 
-
:** if the shipment moves and delivered - consignee on hand (EM/EA on hand) and no longer In-transit
 
:* Number of Qty from in-transit will be deducted and added to the destination (EM/EA) on hand on Inventory module
:* Number of Qty from in-transit will be deducted and added to the destination (EM/EA) on hand on Inventory module
:** For example, if 5000 of item# A from POCHET is on in-transit AIR to KIK, 5000 will be added to AIR, but once it is deliver to KIK, 5000 from AIR will be deducted and added to EM on hand
:** For example, if 5000 of item# A from POCHET is on in-transit AIR to KIK, 5000 will be added to AIR, but once it is deliver to KIK, 5000 from AIR will be deducted and added to EM on hand

Revision as of 16:16, 26 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, in-transit, and on hand by external manufacturers to help the inventory planner process an order shipment plan.

System Requirement

  • A portal for vendor to enter/update info for Inventory
  • Vendor's visibility
  • Inventory Report for Elizabeth Arden Planner
  • Filters:
    • Item#
    • Supplier
    • EM(External Manufacturer)
  • Result: HTML and xls
    • Item#
    • Item Desc
    • Item type
    • Supplier
    • EM(External Manufacturer)
    • US on hand
    • International on hand
    • In-transit - Land (truck mode)
    • In-transit - Air (Air mode)
    • In-transit - Sea (Ocean mode)
    • EM on hand
    • EA on hand
  • Update log for updated information by vendor
  • Column heading color code:
    • Column updated in the last 7 days - green (need to confirm with Simon)
    • Column updated in the last 15 days - yellow (need to confirm with Simon)
    • Column not updated in the last 30 days - red (need to confirm with Simon)
  • pop-up window for detail updated info
    • Updated by: user profile (vendor)
    • Updated date: dd- mon -yyyy
    • Detail updated: From last transaction to updated transaction information

Steps

Step 1

  • Vendor logs on to Internal application
  • Require: Vendor visibility (limit access)
  • Vendor logs on to the Inventory module
  • Vendor's visibility: A vendor can only add, update, and view their specific inventory
  • 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
  • System auto-calculates:
  • If supplier USA on hand number X is added, then number X is added to Total US on hand
  • If supplier International on hand number Y is added, then number Y is added to ATP next 40 days
  • Total pipeline = Total US on hand + ATP next 40 days + Total pipeline

Step 2

  • Jaguar operator creates a record from Ops module with all information that make a shipment is in-transit time (moved but not delivered)
  • Shipper (supplier)
  • Consignee (EM)
  • MOT
  • Item#
  • Item Desc
  • Qty
  • The combination of Item# and EM are unique (this info will be checked against Vendor Inventory table in order for system to auto-update info for Inventory information)
  • Process of behavior between JG operator updates a shipment with needed information
  • If a combination of shipper and consignee are a part of Vendor Inventory table, it should be tagged on ContTab that some items are a part of Inventory
  • Then try to search commodity table
    • Vendor Inventory table is running in the background that
  • Select MOT, Qty value from commodity table where consignee = " " and SKU# = " "
  • Update Vendor Inventory table
    • If MOT is Truck update qty value -> LAND
      • If MOT Land qty value A is added, then value A is added to ATP Next 40 days field
    • If MOT is AIR update qty value -> AIR
      • If MOT Air qty value B is added, then value B is added to ATP Next 40 days field
    • If MOT is Ocean update qty value -> SEA
      • If MOT Sea qty value C is added, then value C is added to ATP Next 40 days field
    • Total US on hand + ATP next 40 days + Total pipeline

Step 3

  • Jaguar Operator updates the shipment's actual delivery date (no longer in-transit)
  • Once the shipment is delivered to destination (consignee/EM)
  • System run in the background updating the Inventory table
  • The shipment moved and delivered, that means quantity of this shipment is delivered to consignee and no longer In-transit - quantity value will be added on consignee on hand (EM/EA on hand)
  • Number of qty value from a particular in-transit MOT shipment will be deducted from in-transit MOT and added to EM on hand and deducted from ATP Next 40 days field
  • Number of Qty from in-transit will be deducted and added to the destination (EM/EA) on hand on Inventory module
    • For example, if 5000 of item# A from POCHET is on in-transit AIR to KIK, 5000 will be added to AIR, but once it is deliver to KIK, 5000 from AIR will be deducted and added to EM on hand
  • US Total on hand: Number of Total USA shipments on hand including Supplier USA on hand will be updated on Inventory module
  • ATP next 40 days: Number of Total in-transit shipments including International shipment on hand will be updated as available to promise on Inventory module
  • Total pipeline : US Total on hand + ATP next 40 days on Inventory module
  • See #Figure 1. Vendor Inventory
  • See use cases figures below

Design

Item#

Item Desc

Item type

Supplier

EM(External Manufacturer)

US on hand

International on hand

  • Label: International on hand
  • Type: Datatypes#positive_integer
  • Widget: textbox
  • Size: TBD
  • Note: quantity of items that has been shipped and received at International destination other than the US

In-transit - Land (truck mode)

  • Label: Land
  • Type: Datatypes#positive_integer
  • Widget: textbox
  • Size: TBD
  • Note: quantity of items that has been shipped by truck but not been received at the destination (still on the move)

In-transit - Air (Air mode)

  • Label: Air
  • Type: Datatypes#positive_integer
  • Widget: textbox
  • Size: TBD
  • Note: quantity of items that has been shipped by truck but not been received at the destination (still on the move)

In-transit - Sea (Ocean mode)

  • Label: Sea
  • Type: Datatypes#positive_integer
  • Widget: textbox
  • Size: TBD
  • Note: quantity of items that has been shipped by ocean but not been received at the destination (still on the move)

EM on hand

  • Label: EM on hand
  • Type: Datatypes#positive_integer
  • Widget: textbox
  • Size: TBD
  • Note: quantity of items that has been shipped and received at external manufacturer (known as consignee)

EA on hand

Figures

Figure 1. Vendor Inventory

File:EAInventory.JPG

Figure 2. Vendor Creates Item Inventory

File:VendorCreateItem.JPG

Figure 3. Vendor Updates an existing Item Inventory for specific EM

File:VendorUpdateItem.JPG

Figure 4. Operator updates CT# with in-transit info

File:OperatorUpdatesIn-transit.JPG

Figure 5. Operator updates CT# with delivery info

File:OperatorUpdateDelivCT.JPG

Figure 6. Create an Inventory report

File:InventoryReport.JPG

Figure 7. Add - Vendor Inventory

File:VendorAdd.JPG

Figure 8. View page - Vendor Inventory

File:ViewPageInventory.JPG

Figure 9. Admin - Vendor Users

File:VendorUser.JPG

Personal tools