Vendor Inventory
From UG
(Difference between revisions)
(→Steps) |
(→Business Requirement) |
||
| Line 1: | Line 1: | ||
== Business Requirement == | == 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. | + | Elizabeth Arden would like to have a vendor Inventory module that can track shipments that are on hand by vendors, suppliers, and in-transit. |
| + | |||
| + | == 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 is updated in the last 7 days - green | ||
| + | :** column is updated in the last 15 days - yellow | ||
| + | :** column has no updated in the last 30 days - red | ||
| + | :* 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 == | == Steps == | ||
Revision as of 16:38, 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.
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
- Filters:
- Update log for updated information by vendor
- Column heading color code:
- column is updated in the last 7 days - green
- column is updated in the last 15 days - yellow
- column has no updated in the last 30 days - red
- 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
- Column heading color code:
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's visibility ; A vendor can only update, view, edit 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
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
