Thekkiniath Antony Joseph
March 30th, 1999, 01:47 AM
How to Create table for Personal Inventory System?
My concern is Central Electrochemical Research Institute. In this Institute
there are 700 employee are working. They will indent any items for there
work. As per the indent Purchase Section will rise order. After sending Order
Stores will receive the item, that time. Store people will enter the item into
DRR (Daily Receipt Register) to produce the CRV (Certified Register Voucher).
This is for confirmation from indentor, to check whether it is working fine
or not. If it is failure item will return supplier otherwise Store people
will taken into stock.
We have two types of items there are Consumables and
Non-Consumables. At the time of taking stock if it is Non-Consumble items.
We will taken into Personal Inventory Register (PIR).
What are the activities in PIR we are doing is as follows:
1. Issue to indentor
2. Transfer to somebody (at the time of tranfer to other section or
retirement)
3. Return to Stores as Servicable Item
4. Return to Stores as Unservicable Item
5. Loss
What are the reports we want is:
1. Issue report for employee wise and date wise
2. Transfer report for employee wise and date wise
3. Serviceable items report
4. Unserviceable items employee wise and date wise
5. Loss statements
6. Existing items report for each employee
Our key field is only Employee ID Number.
These are the columns we are using in Daily Receipt Register.
Daily Receipt Register Table:
Daily Receipt Number (Primary Key)
Daily Receipt Date
Mode of Delivery
Name of the Supplier (i.e. supplier code, it is linked with Supplier Table)
Name of the Indentor (i.e. employee ID, it is linked with employee table)
Order Number (it is linked with Order table)
.
.
.
Daily Receipt Register Item table:
Daily Receipt Number (Secondary Key)
Material Code (it is linked with Material table)
Quantity Received
Quantity Accepted
Quantity Rejected
Remarks
But we don't know how to create table for Personal Inventory Register.
Kindly give idea with example table.
With Love,
Joseph
E-mail to : 1. joe143ta@hotmail.com 2. joe143@softhome.net
My concern is Central Electrochemical Research Institute. In this Institute
there are 700 employee are working. They will indent any items for there
work. As per the indent Purchase Section will rise order. After sending Order
Stores will receive the item, that time. Store people will enter the item into
DRR (Daily Receipt Register) to produce the CRV (Certified Register Voucher).
This is for confirmation from indentor, to check whether it is working fine
or not. If it is failure item will return supplier otherwise Store people
will taken into stock.
We have two types of items there are Consumables and
Non-Consumables. At the time of taking stock if it is Non-Consumble items.
We will taken into Personal Inventory Register (PIR).
What are the activities in PIR we are doing is as follows:
1. Issue to indentor
2. Transfer to somebody (at the time of tranfer to other section or
retirement)
3. Return to Stores as Servicable Item
4. Return to Stores as Unservicable Item
5. Loss
What are the reports we want is:
1. Issue report for employee wise and date wise
2. Transfer report for employee wise and date wise
3. Serviceable items report
4. Unserviceable items employee wise and date wise
5. Loss statements
6. Existing items report for each employee
Our key field is only Employee ID Number.
These are the columns we are using in Daily Receipt Register.
Daily Receipt Register Table:
Daily Receipt Number (Primary Key)
Daily Receipt Date
Mode of Delivery
Name of the Supplier (i.e. supplier code, it is linked with Supplier Table)
Name of the Indentor (i.e. employee ID, it is linked with employee table)
Order Number (it is linked with Order table)
.
.
.
Daily Receipt Register Item table:
Daily Receipt Number (Secondary Key)
Material Code (it is linked with Material table)
Quantity Received
Quantity Accepted
Quantity Rejected
Remarks
But we don't know how to create table for Personal Inventory Register.
Kindly give idea with example table.
With Love,
Joseph
E-mail to : 1. joe143ta@hotmail.com 2. joe143@softhome.net