Inventory Status Table

In one warehouse, items having a same reference can have different status, for instance:

•      end items are reserved by the salesman, they are in the finished goods warehouse but are not available to be sold.

•      some rejected components must be returned to the vendor,

•      some raw materials must pass quality inspection before being available for manufacturing,

•      some components planned to be used by work order are still not out of the warehouse.

Every status that items in inventory can have must be defined in the status table. Examples:

•      AVAI: available

•      RESV: reserved to the manufacturing

•      PREP: reserved to customer order preparation

•      INSP: quality inspection

The AVAI, PREP and RESV status are managed by the system. They are automatically created in the status table and cannot be deleted.

A status code must be indicated for every inventory transaction.