Re-Usable Items entry in system using VB

As I have already shared with you about “Re-Usable Items” practice, their purpose and benefits now I want to share my experience about an application for recording all transaction regarding “Re-Usable Items”. With the help of this application I never lose any record from my system and easily sought out any record, it can also help for compiling many types of reports in a second. 

You can use MS-Excel too for this purpose, but there are many chances of mistakes, deletions, additions etc without your knowledge because MS-Excel is manual entry program.

Let see about my application for “Re-Usable Items”

First of all I need a database for storing “Re-Usable Items” data in system, so I designed with the following fields.

1. Item Code / Material Code / Material Number / etc

2. Description / Nomenclature / Summary / etc

3. Document Number / receiving number  / etc 

4. Unit / UOM / etc

5. Item User / Item Department / etc

6. Date of first time issuance

7. Date of submission

8. Any work order / maintenance number (if available)

9. Reason / remarks / fault detail / etc

10. Item condition

11. Received Quantity 

12. Item removed from which machine / equipment / etc

You can use more field as per your requirements.

When a “Re-Usable Item” received in store then we must check all necessary fields in receiving document and few proper marking / tagging on item/spare/part. After complete verification of documents and item, an entry will pass in system with the help of VB application. 

With the help of this application user can easily:

• Gathered or compile all your inventory in database for acquiring field as you want

• Pass new entry in database

• Edit/delete any entry

• Easily sought out any item

• Easily sought out any types of items such as (re-usable, repairable, scrap, ir-repairable etc)

• Extract many types of reports on your management requirements

• Easily calculate the numbers of items by their types, conditions, departments, etc

• Monthly reporting

• Overview reporting

• Compile reports condition-wise

• Compile reports department-wise

• Compile reports item-wise

• Compile reports date-wise

• Compile reports returning status-wise

And many more functions of this application can help the store and user for their "Re-Usable Items" and saving a big amount and time of your respective company.