Keep Track of Field Asset Inventory

Registered by Paul Yasi

This module will need to track a number of things related to inventory of field assets, such as customer premises equipment that may be sold to the customer or provided on a rental or free with service basis.
+ show the number of devices left in in-house inventory
+ show what devices are assigned to a customer service, including device type
+ show if a device has been returned by a customer and may be put back into in-house inventory as a refurbished item or RMA or broken and discarded.

Blueprint information

Status:
Complete
Approver:
None
Priority:
Undefined
Drafter:
None
Direction:
Needs approval
Assignee:
None
Definition:
Superseded
Series goal:
None
Implementation:
Not started
Milestone target:
None
Completed by
Paul Yasi

Related branches

Sprints

Whiteboard

*** master_inventory table of the types of items inventoried
| id | description | status | weight
*** inventory_items table of each item, may add new items in bulk with few details
| id | master_inventory_id | creation_date | serial_number | status| sale_type | user_services_id | shipping_tracking_number | shipping_date | return_date | return_notes | bad_date | bad_notes |
**** new items are inserted in bulk as a bunch of new rows with a status of new
**** when an item is to be shipped that status changes to infield and it gets assigned to a user_services_id, shipping_tracking_number, and shipping_date, and maybe serial number or MAC address
**** when a customer service person removes a service with an included or rented item notify them that they should inform the customer to return the item
**** when an item is returned it's status changes to returned, the return_date and return notes are added, if sale is included or rent then note sent to halt recovery fee, and a new duplicate item is created with a used status

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.