Click here to Skip to main content
15,882,063 members
Articles / Programming Languages / VBScript
Article

Inventory Management System -Aluminum Parts For Windows, Doors etc.

Rate me:
Please Sign up or sign in to vote.
1.55/5 (9 votes)
24 Feb 20072 min read 61.4K   2.2K   15   9
Visual Basic 6.0 with MS Access Project. Designed for those industries who deals with aluminum parts. Such aluminum parts are used in building glass windows and are available in number of sections. This system handle Stock, Order and Consignment data.

Screenshot - main.jpg

Introduction

Overview

Its basically designed for those industries who deals with aluminum parts. Such aluminum parts are used in building glass windows and are available in number of sections. This system handle Stock, Order and Consignment data. The window shown above is the main window. It appears when the software is started and after logging on the system.

System Analysis

This system can be divided into following portions

Stock Information
Order
Consignment
Password

Information about each is explained in the following text.

Stock Information

This portion of the system can be accessed by clicking the Current Stock button on the main window. This portion depicts the current status of the stock. Aluminum Sections are available the four colors (black, bronz, dull and champain) and five lengths.

This picture shows that there are 148 different aluminum sections available in the stock and user is currently viewing section # AL-17 which is record number 3. Using this portion one can find: Information about specific section, All the sections that contains letter AL as section #. etc. Printable reports can be achieved by clicking Report button. Such reports can be about any specific section or group of sections or all the available status of Stock.

Screenshot - stock.jpg


Order

This portion of the system can be accessed by clicking the Order button on main window. Its deals with order information. Each Order is assigned a unique Order number.

Screenshot - order.jpg

This picture is depicting information about the order # 5. This order was submitted on 7th July, 1999 and there was 5% discount on that order. The total charges taken by the company has also shown. To get the info about the items that comprises this order click the Order No. 5 Items page as shown in picture. After doing so the above picture now looks as below one. It shows that order # 5 is comprises of two items. Item # 1 info is currently visible. All the sections # that are available in the stock is contained in the Section No drop down box. When Adding Items only red entities are to be entered. To check the available number of lengths in the Stock for a specific section #, click the check button. Items can be added only when number of lengths required in any order is less then the lengths available in the stock. Using this portion, one can find: Information about any specific order or any specific item, All the orders relating to any specific date or month, All the orders having discount 5% etc., and many more...

Consignment

This portion of the system is identical with order portion as far as GUI is concern. Its deals with information like when the consignment had arrived and about the items, updating of Stock etc.

Password

Total security is provided in this system. To log on the system one has to provide the password. Once entered in the system, one can change the password by clicking the Password button provided on the main window.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


Written By
Web Developer
United States United States
Mr. Asim Abbasi is President and CEO of Takveen, Inc. NJ (www.takveen.com), which is a firm providing information technology related ‘Optimal Solutions’ to the industry. He is also attached with three top-notch computer schools of NJ teaching Oracle Database Administration in Unix/Windows Server environments. Before coming to NJ, he used to teach Oracle in heart of NC, Raleigh while working as Chief Technologist with a business solutions development firm.

Back in Pakistan Mr. Abbasi worked as Chief Programmer with US based multi-national software development company. Prior to that he was Lecturer/Lab Manager at Center for Advanced Studies in Physics (CASP) - Government College University (www.gcu.edu.pk) teaching Telecommunications & Computer Systems and Applications.

Mr. Abbasi has been attached intensely with the IT field for past 13 years and has written dozens of softwares and tons of code from programming microcontrollers using Assembly language to writing 3-tier multi-language web applications backed by Oracle. From developing custom wireless TCP/IP communication protocols to converting human driven business processes to machine driven automated self-healing systems. In short, when it comes to optimal computer solutions and designs Mr. Abbasi has the authority.

He did B.Sc. Electrical Engineering from University of Engineering & Technology, Lahore, Pakistan (www.uet.edu.pk). He is Oracle Certified Professional Database Administrator (OCP), Microsoft Certified Professional (VB) and lots of other computer certifications. Besides certifications, he has lots of publications and has filed 1 patent with United States Patent & Trade Mark Office regarding system and method for controlling devices wirelessly using protocol based communication through voice.

When asked Mr. Abbasi, he said that it all erupted with a saying of my engineering professor, “Think yourself ….”


http://www.takveen.com

Comments and Discussions

 
QuestionPASSWORD Pin
Member 1615094028-Nov-23 14:03
Member 1615094028-Nov-23 14:03 
Questionpass Pin
Member 1454756931-Jul-19 22:38
Member 1454756931-Jul-19 22:38 
GeneralWhere is password Pin
Member 464898427-Oct-09 9:15
Member 464898427-Oct-09 9:15 
Questionwhere is password? Pin
riki6223-Jul-08 16:52
riki6223-Jul-08 16:52 
AnswerRe: where is password? Pin
hasan.amca15-Apr-17 2:38
hasan.amca15-Apr-17 2:38 
Questionand where is the password? Pin
Selecters29-Oct-07 11:40
Selecters29-Oct-07 11:40 
AnswerRe: and where is the password? Pin
Selecters29-Oct-07 11:45
Selecters29-Oct-07 11:45 
GeneralRe: and where is the password? Pin
caguas20-Aug-14 8:46
caguas20-Aug-14 8:46 
GeneralRe: and where is the password? Pin
Vaibhav Jain Dec202214-Dec-22 23:13
Vaibhav Jain Dec202214-Dec-22 23:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.