Data Acquisition, Monitoring and Management of Purchased Items Using Java Programing

Rionel Belen Caldo

Abstract


The Purchasing department manages all related transaction of items and services of the institution. In Lyceum of the Philippines University – Laguna (LPU-L), the Purchasing department provides services to item purchases of the school (inside or outside the campus). The method of monitoring and storage of data is done manually. Considering that purchasing transaction is becoming plentiful in just a month’s notice because of different colleges requiring items to be bought, the task of in-charge personnel is becoming laborious and tedious. With increasing purchase of items and rendering of related services, it is essential that information will be kept organized and secured. This paper proposes a system for effective data monitoring and management of transactions related to purchasing of items in Netbeans IDE platform using Java programming language with additional use of Apache POI Application Program Interface (API) to control and manipulate Excel files. Item specifications and transactions are to be stored in a Spreadsheet, as it offers easy manipulation of cells, sheets and workbooks. Ergo, it is easy to manage formulas for arithmetic use and it provides visual presentation of data through graphs and charts. The developed system is capable of handling data entered by the user and it will easily store the data in its proper excel directories, which would simplify and speed up the manual method of managing data. The system is also equipped with searching methodology and printing of summary report. This would facilitate tangible monitoring of data and its status. Most importantly, the system could further assist the decision making of the department head.

Keywords


Purchasing Department; Netbeans IDE; Java; Apache POI; Microsoft Excel; Software Engineering; Data Monitoring;

Full Text:

PDF

References


A. Writing. (2017) What are the functions of a purchasing department in an organization? [Online]. http://smallbusiness.chron.com/functions-purchasing-departmentorganization-158.html

L. Magloff. (2017) Roles of a purchasing department [Online]. Available: http://smallbusiness.chron.com/roles-purchasingdepartment-2270.html

A. Majeed, “Developing countries and Internet-of-Everything (IoE),” in Proc. 7th Annual Computing and Communication Workshop and Conference (CCWC), 2017.

S. Aslam, A. Shahid, and K.G. Lee, “An efficient hybrid shopping mall with advanced purchasing system,” in Proc. 7th International Conference on Computing and Convergence Technology (ICCCT), Jun. 2013.

V. A. Titova, Y. V. Tomilina, and T. V. Titova, “Information technology in the system of purchasing decision-making based on models of long-term and short-term marketing actions,” in Proc. 9th International Forum on Strategic Technology (IFOST), Dec. 2014.

D. Lin and S. Jingtao, “A recommender system based on contextual information of click and purchase data to items for e-commerce,” in Proc. 3rd International Conference on Cyberspace Technology (CCT 2015), Apr. 2016.

J. Catapang, L. Carurucan, and R. Caldo, “Design, development and implementation of purchasing management system,” in Proc. DLSU Research Congress, Vol. 4, March 7-9, 2016.

D. Hughey. (2009) Comparing traditional systems analysis and design with agile methodologies. [Online]. Available: http://www.umsl.edu/~hugheyd/is6840/waterfall.html

S. Portny, Management for DUMMIES, 3rd ed., Wiley Publishing, Inc., Indianapolis, Indiana, 2010.

Y. Liang and L. Yansheng, “The atomic change set of Java programming language,” in Proc. 7th International Conference on Computer Science and Education (ICCSE), 2012.

C. Beach. (2016) What is an API? [Online]. Available: https://www.quora.com/what-is-an-api-4

V. Beal. (2017) API - application program interface [Online]. Available: http://www.webopedia.com/term/a/api.html

A. Oliver, G. Stampoultzis, A. Sengupta, R. Klute, and D. Fisher. (2017). Apache POI - the Java API for Microsoft documents [Online]. Available: https://poi.apache.org/

(2017) NetBeans IDE. [Online]. Available: https://netbeans.org/


Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 License.

ISSN: 2180-1843

eISSN: 2289-8131