Inventory and Call Off

From UG

Revision as of 14:03, 26 May 2014 by Andrei (Talk | contribs)
Jump to: navigation, search


Contents

About

Mantis:

  • Parent: 0004392
  • Category: ASN: Inventory and Call Off

Business Info

Definitions

  • Inventory - Supplier's information about items ready to ship.
  • Per Marc, Inventory is a quantity of items related to a purchase order that are "manufactured" and "ready" at a supplier's warehouse.
  • This is Portal-specific data
  • 1 "Inventory Record" = unique PO / SKU combination
  • Inventory can be "replenished". This means the supplier can add more quantities at any point in time.
  • Call Off - Action of a Planner with "Call Off" rights to request/reserve some quantity of the PO from Inventory.
  • Per Marc, Planner users can select a quantity from "Inventory" and ask the supplier to create an ASN for that "Quantity".
  • Pending Call Off
  • Inventory Shipper
  • Call Off Planner

Business Needs

  • The simple way of auto-update a list of open POs
  • Notify/filtering a due date status of PO (e-mail, DB reports)
  • Provide visibility of Supplier inventory levels
  • Create "Call Off" based on Inventory record
  • Log call off request in inventory
  • Create ASN from "Call Off"
  • Analytics in Flashlight

Solution

Solution Summary

System should provide the following steps/processes:

  • Open POs - Purchase Order upload per "PO Issued by"
  • Inventory - Creating Inventory record by Supplier
  • Call Off - Requesting quantity of PO by Planner
  • Notifications and reports

Admin

  • Add Inventory Shipper Role
  • Add "Call Off" rights as option of Planner User
  • Ability to enable/disable "Inventory and Call Off" feature in Portal
  • Per Portal, manage a table of allowed Inventory Shippers by "PO issued by"

ASN

  • Inventory tab
  • Fields
  • Supplier
  • Pick up Location
  • PO #
  • Item code
  • Description
  • Price
  • PO Issued By
  • Packaging?
  • Ship to?
  • Filters
  • Controls
  • Functions
  • Call Off tab
  • Fields
  • Filters
  • Controls
  • Functions

Dashboard Reports

  • "Impending" Supplier Due Date report
  • "At Risk" Supplier Due Date report
  • "Past Due" Supplier Due Date report

SOWs

SOW 1 Add Inventory Shipper Role

mantis: 4457

  • This is a new kind of User Role and designed to work with ASN Inventory.
  • Inventory Shipper Role is implemented as an option of CT2 Generic Shipper User.
  • This user should be linked to one or more ASN Portals.
  • It is allowed to work in Inventory with all or some "PO issued by" (managed in ASN Portal admin)
  • Inventory Shipper functions are:
  • create Inventory record from open PO
  • confirm cargo ready (available) date (?) and enter other fields (pallets, packaging, gross weight, dims, ship to)
  • replenish Inventory record (add more quantities at any point in time)
  • proceed "Call Off":
  • open "Call Off" record
  • confirm Cargo Ready Date
  • updates all fields required (need validations)
  • create ASN from "Call Off"
  • NOTE: Allow item QTY changes! (???)
  • close Inventory record (moving to another tab)



SOW 2 Add "Call Off" rights as option of Planner User


mantis: 4458

  • This is new option for CT2 Generic Planner user
  • ...



SOW 3 Inventory and Call Off panel


mantis: 4459

  • This is separate section of ASN2 to provide:
  • List of open POs
  • Inventory information on Supplier's level
  • Call Off functionality on Planner's level
  • ability to create ASN from "Call Off" record
  • Inventory panel should be managed to enable from ASN Portal admin by "PO issued by".
  • If enabled, the Inventory Shippers need to be selected to create inventories (No selection -> All shippers can create inventories).



SOW 4 Purchase Order upload


mantis: 4437

  • This feature provides upload PO information into the ASN Portal.
  • Information comes via e-mail. New accounts for incoming email were created:
  • Production environment: upload@jaguarfreight.com
  • All Dev environments: po.upload@gmail.com
  • To upload Inventory PO list user have to send email to the given email with following parameters:
  • Subject must contain key phrase "PO Upload" and name of PO Issued By Company, separated by colon ":"
  • e.g "PO Upload: CEI Roanoke"
  • Excel file (Excel v 97-2003 xls only currently supported) should be attached to this email.
  • The following columns in this XLS document (Gemline example) should be handled (others should be missed):
Name (mapping link) XLS Column XLS Name Note/Example
PO Number
(a.k.a Commodity PO)
A Order No Alphanumeric.
Gemline example: 20296.
PO Line B Line No Gemline example: 2.
Release # C Release No Alphanumeric. Makes unique pair with PO Number.
Multiple PO Numbers are allowed with different Release Number.
Gemline example: 7.
D
(no mapped yet)
E Supplier Name Code.
Gemline example: TCD.
POIB F Buyer ID Gemline example: GEM.
PO Issue Date.
NEW field
I Created Need to be added.
Gemline example: 04/14/2014.
SKU
(a.k.a Commodity SKU)
J Part No Alphanumeric.
Gemline example: 90301R1B.
Description
(a.k.a Commodity Item Description)
K Part Description Gemline example: ISAAC MIZRAHI AVA WRISTLET-NAVY.
SKU QTY
(a.k.a Commodity Item Qty)
M Quantity Numeric.
Gemline example: 1500.
Destination Due Date N Planned Receipt Date Gemline example: 06/03/2014.
Origin / Supplier Due Date T Wanted Delivery Date Gemline example: 04/30/2014.
MOT
(a.k.a Transport Mode)
BR Ship Via Code ASN Portal Transport Mode.
Gemline examples: OCN, AIR.
Incoterms
(FOB - location)
BU Delivery Terms Incoterms is FOB.
See list of overseas ports (Location) under the table.
Gemline example: SHA.
HTS CC Tech Coordinator Harmonized Tariff Schedule (of the United States).
Gemline example: 4202.32.2000.
  • Location (a list of the overseas ports that Gemline is using, or sometimes/potentially could use):
Code - Terms - Port
  • CHG - FOB - Chittagong
  • CLO - FOB - Colombo
  • DJI - FOB - Djibouti
  • FUZ - FOB - Fuzhou
  • GUA - FOB - Guangzhou
  • HCM - FOB - Ho Chi Minh City
  • HK - FOB - Hong Kong
  • KEE - FOB - Keelung
  • NED - FOB - New Delhi
  • NGB - FOB - NINGBO
  • QIN - FOB - Qingdao
  • SHA - FOB - Shanghai
  • SHE - FOB - Shekou
  • SHZ - FOB - Shenzhen
  • SIH - FOB - Sihanoukville
  • SRI - FOB - Sri Lanka
  • THA - FOB - Thailand
  • TPS - FOB - Tanjung Perak
  • XIA - FOB - Xiamen
  • YAN - FOB - Yantian
  • System is handling receiving emails every 3 minutes. After successful uploading file, system will reply to the sender with report email. In case of any error, the system will also reply to sender the information of error cause. This reply will be sent also to the Jaguarfreight users that are in the BCC list of Client Application notifications.
  • Once POs uploaded they should be displayed on Open POs tab
  • Visibility rules - TBD.
  • Validations - TBD.



SOW 5 Supplier Due Date: indicate, filter, notify


mantis: 4460

  • Supplier Due Date
= when does this need to be ready at the supplier
= date by which an INVENTORY record needs to be created.
  • Add "Due date" group indicator as column in the table of Open POs:
  • Green. Due date is in XXX weeks
  • Yellow. Due date is in YYY weeks
  • Orange. Due date is in ZZZ days
  • Red. Due is "past due"
  • Add ability to filter by group of due date
  • Add ability to send "Due date" e-mail notifications
  • Green/Yellow "due date": no need to notify.
  • Orange "due date": "PO / Item is due in xx days and no inventory record was created. Please provide a status update urgently."
  • Red "due date". "PO / Item is due tomorrow and no inventory record was created. This order is late. Please update."
  • Add "Due date" dashboard report
  • ...



SOW 6 Inventory tab


mantis: ???

  • Inventory
  • ...
  • closed Inventory
  • ...



SOW 7 Call Off tab


mantis: ???

  • Call Off
  • ...



SOW 8 Logging and show history


mantis: ???

  • Logging
  • ...



SOW 9 Flagging and Watchlist


mantis: ???

  • Flagging
  • Watchlist
  • ...



SOW 10 Supplier Event Validation


mantis: 4586

  • Object of validation: Supplier Due Date
  • PO Statuses
  • Pending
  • Impending
  • At Risk
  • Past Due
  • Validation logic
  • E-mail notifications
  • Log / display the validation info



SOW 11 Dashboards for PO Statuses


mantis: 4587

  • PO Statuses
  • Pending
  • Impending
  • At Risk
  • Past Due



Personal tools