INVENTORY MANAGEMENT SYSTEM
Client
Yentrix, Inc. USA.
Platform
IBM AS/400
Languages used
CL/400, RPG/400.
Role
Developer
Duration
Aug’03 to Till Date.
Description This is an Inventory Management System developed to maintain Stock details for a Company. The main Objective of this system are,
• Maintaining Stock Details in Master Maintanence • Calculating
and Maintaining Stock Details in
• Issuing Transaction & • Receiving Transaction . The Inventory Master Maintanence screen deals with entire Stock maintanence of the Store. Master Maintanence has the provision for adding a new stock to the store. Editing the Stock details, displaying it, Logical deletion of the stock are the other provisions in it. Using Subfile ((Size = Page) Load On Demand method) Master Maintanence Screen has been designed and coded. Once the client is satisfied with the quotation what we sent, issues the purchase order for the specific product, which is the start point for the business. After receiving the Purchase order, the availability of the specific product is checked in the stock master maintenance table (i.e, in the store). If the product is there then the transaction is made and entries are put in stock Issuing transaction table and Master maintanence table is updated simultaneously. If the product is not there in our store then the order is placed, Once we receive the product then the transaction is made and entries are put in stock Receiving transaction table and Master maintanence table is updated simultaneously. Validations for all the fields have been done. Reports are generated based on many parameters. Using message subfile the error message has been passed while entering the invalid field values. Message file has been created for maintaining & passing error messages. Concepts like Subfiles, single record format has been used for display files. Data area concept has been used for generating stock numberand material receipt number automatically. Data structure concept has been used for moving date. Prompt screen for stock number have been designed (Transactions) using Window Subfile concept.