US-12626228-B2 - Enterprise resource planning system having financial management function using computer-implemented calendar

Abstract

A pay sheet planning system includes a first information management unit that stores and manages, as a database, resolution information, on the basis of a resolution information input signal input through an input device of the manager computer; and a second information management unit that stores and manages, as a database, slip information, on the basis of resolution information, corresponding to a slip registration target selection signal input through the input device of the manager computer, in the resolution information that is generated, stored and managed through the first information management unit.

Inventors

• JaeYoung Kim

Assignees

• SEOJIN Consulting network solution Co,. Ltd.

Dates

Publication Date

20260512

Application Date

20231109

Priority Date

20230704

Claims (4)

1. 1 . An enterprise resource planning system having a financial management function using a computer-implemented calendar, the system being implemented on a manager computer, comprising: a memory of the manager computer storing an enterprise resource planning (ERP) program; and at least one processor of the manager computer operatively coupled to the memory, the processor being configured to execute the ERP program to implement; a first information management unit configured to store and manage, as a database, resolution information that is generated to include a resolution creation date, a company name, a site name, a work type name, a resolution type selected as one of income or expenditure, an account subject, a customer name, a supply price, a value-added tax, a total amount, a payment method, and a resolution cost expected-execution date, based on a resolution information input signal that is received through an input device of the manager computer; a second information management unit configured to store and manage, as a database, slip information that is generated to include a slip registration date, a company name, a site name, a work type name, a slip type selected as one of income or expenditure, an account subject, a customer name, a supply price, a value-added tax, a total amount, a payment method, and a slip cost expected-execution date, based on resolution information corresponding to a slip registration target selection signal that is input through the input device of the manager computer, in the resolution information stored by the first information management unit; a third information management unit configured to store and manage, as a database, real-time cash information that is generated from at least one of bank account information regarding a balance in at least one pre-registered bank account that is linked to a financial institution server to be provided upon request, and cash-on-hold information that is generated based on a cash-on-hold information input signal that is input through the input device of the manager computer; a resolution management calendar providing unit configured to output and provide, to an output device of the manager computer, a calendar that displays the resolution information stored by the first information management unit in correspondence with a resolution creation date or a resolution cost expected-execution date for each date in the calendar; a slip management calendar providing unit configured to output and provide, to the output device of the manager computer, a calendar that displays the slip information stored by the second information management unit in correspondence with a slip registration date or a slip cost expected-execution date for each date in the calendar; and a petty cash management calendar providing unit configured to output and provide, to the output device of the manager computer, a calendar that displays petty cash information including information regarding a cash balance as of a previous day, a today's income cash amount, a today's expenditure cash amount, and a cash balance as of today, in correspondence with the slip registration date or the slip cost expected-execution date for each date in the calendar, based on slip information in which the payment method is set to cash transfer, the slip information being stored by the second information management unit, and on the real-time cash information stored by the third information management unit.
2. 2 . The system according to claim 1 , wherein the at least one processor is further configured to execute the ERP program to implement: a bill management calendar providing unit configured to output and provide, to the output device of the manager computer, a calendar that displays promissory information including information regarding a bill as of the previous day, a today's bill payment amount, and a bill balance as of today, in correspondence with the slip registration date or the slip cost expected-execution date for each date in the calendar, based on slip information stored by the second information management unit in which the payment method is set to bills; a card management calendar providing unit configured to output and provide, to the output device of the manager computer, a calendar that displays card information including information regarding a card balance as of the previous day, a today's card payment slip issue amount, a today's card payment amount, and a card balance as of today, in correspondence with the slip registration date or the slip cost expected-execution date for each date in the calendar, based on slip information stored by the second information management unit in which the payment method is set to cards; a credit management calendar providing unit configured to output and provide, to the output device of the manager computer, a calendar that displays credit information including information regarding a credit balance as of the previous day, a today's credit payment slip issue amount, a today's credit payment amount, and a credit balance as of today, in correspondence with the slip registration date or the slip cost expected-execution date for each date in the calendar, based on slip information stored by the second information management unit in which the payment method is set to credit; and a profit/loss management calendar providing unit configured to output and provide, to the output device of the manager computer, a calendar that displays profit/loss information including information regarding a total income corresponding to a total amount of slips of an income type, information regarding a total expenditure corresponding to a total amount of slips of an expenditure type, and information regarding a margin between the total income and the total expenditure, in correspondence with the slip registration date or the slip cost expected-execution date for each date in the calendar, based on slip information stored by the second information management unit.
3. 3 . The system according to claim 2 , wherein the resolution management calendar providing unit comprises: a first calendar generator that generates a resolution management calendar including a plurality of first date sections having a first date display area and a first information display area, and a first total information section having a first monthly total information display area for the resolution information; a first output standard information generator that generates resolution management calendar output standard information including information regarding a first resolution information output standard for determining which one of a resolution registration date and a resolution cost expected-execution date the resolution information is to be displayed on the basis of, information regarding a second resolution information output standard for determining which resolution type of an income and an expenditure the resolution information is to be displayed on the basis of, and information regarding a third resolution information output standard for determining which one of a site name, a work type name, an account subject and a customer name a specification of the resolution information is to be displayed on the basis of, for each first date section and each first total information section, on the basis of a resolution management calendar output standard setting signal that is input through the input device of the manager computer; a first information display that displays, while making resolution information that satisfies the second resolution information output standard in the resolution information that is generated, stored and managed through the first information management unit correspond to each date in the resolution management calendar according to the first resolution information output standard, specification information on a total number of the resolution information corresponding to each date, a total amount, or a site name, a work type name, an account subject or a customer name-based total amount according to the third resolution information output standard, in each first information display area in the plurality of first date sections, on the basis of the resolution management calendar output standard information that is generated through the first output standard information generator; a first total information display that correspondingly displays monthly resolution total information including information on a total number and a total amount of monthly resolution information in the first monthly total information display area in the first total information section, on the basis of the resolution information displayed in each of the plurality of first date sections through the first information display; and a first report link that, on the basis of an area selection signal in the resolution management calendar that is input through the input device of the manager computer, provides, in a case where an area corresponding to the area selection signal in the resolution management calendar is the first information display area in the first date section for a specific date, a separate pop-up window for outputting a resolution status report for the specific date using resolution information displayed in the area, provides a separate pop-up window for outputting a resolution status report for a specific month in a case where the area corresponding to the area selection signal in the resolution management calendar is the first monthly total information display area in the total information section, and provides, in a case where the area corresponding to the area selection signal in the resolution management calendar is the first date display area in the first date section for the specific date, a separate pop-up window for inputting/outputting resolution information that allows confirmation of a specification of resolution information displayed in the area and generation of resolution information based on the resolution information input signal that is input through the input device of the manager computer, wherein the slip management calendar providing unit comprises: a second calendar generator that generates a slip management calendar including a plurality of second date sections having a second date display area and a second information display area, and a second total information section having a second monthly total information display area for the slip information; a second output standard information generator that generates slip management calendar output standard information including information regarding a first slip information output standard for determining which one of a slip registration date and a slip cost expected-execution date the slip information is to be displayed on the basis of, information regarding a second slip information output standard for determining which slip type of an income and an expenditure the slip information is to be displayed on the basis of, and information regarding a third slip information output standard for determining which one of a site name, a work type name, an account subject and a customer name a specification of the slip information is to be displayed on the basis of, for each second date section and each second total information section, on the basis of a slip management calendar output standard setting signal that is input through the input device of the manager computer; a second information display that displays, while making slip information that satisfies the second slip information output standard in the slip information that is generated, stored and managed through the second information management unit correspond to each date in the slip management calendar according to the first slip information output standard, specification information on a total number of the slip information corresponding to each date, a total amount, or a site name, a work type name, an account subject or a customer name-based total amount according to the third slip information output standard, in each second information display area in the plurality of second date sections, on the basis of the slip management calendar output standard information that is generated through the second output standard information generator; a second total information display that correspondingly displays monthly slip total information including information on a total number and a total amount of monthly slip information in the second monthly total information display area in the second total information section, on the basis of the slip information displayed in each of the plurality of second date sections through the second information display; and a second report link that, on the basis of an area selection signal in the slip management calendar that is input through the input device of the manager computer, provides, in a case where an area corresponding to the area selection signal in the slip management calendar is the second information display area in the second date section for a specific date, a separate pop-up window for outputting a slip ledger report for the specific date using slip information displayed in the area, provides a separate pop-up window for outputting a slip ledger status report for a specific month in a case where the area corresponding to the area selection signal in the slip management calendar is the second monthly total information display area in the total information section, and provides, in a case where the area corresponding to the area selection signal in the slip management calendar is the second date display area in the second date section for the specific date, a separate pop-up window for inputting/outputting slip information that allows confirmation of a specification of slip information displayed in the area and generation of slip information based on resolution information corresponding to the slip registration target selection signal input signal that is input through the input device of the manager computer, and wherein the petty cash management calendar providing unit comprises: a third calendar generator that generates a petty cash management calendar including a plurality of third date sections having a third date display area and a third information display area, and a third total information section having a third monthly total information display area for the petty cash information; a third output standard information generator that generates petty cash management calendar output standard information including information regarding a first petty cash information output standard for determining which one of a slip registration date and a slip cost expected-execution date, in the slip information in which the payment method is set to cash transfer, the petty cash information is to be displayed on the basis of, and information regarding a second petty cash information output standard for determining which one of entire bank accounts and a specific bank account among at least one bank account managed by the third information management unit the petty cash information is to be displayed on the basis of, on the basis of a petty cash management calendar output standard setting signal that is input through the input device of the manager computer; a third information display that displays, while making slip information that satisfies the second petty cash information output standard in the slip information that is generated, stored and managed through the second information management unit, in which the payment method is set to cash transfer, correspond to each date in the petty cash management calendar according to the first petty cash information output standard, the petty cash information corresponding to each date in each third information display area in the plurality of third date sections, on the basis of the petty cash management calendar output standard information that is generated through the third output standard information generator; a third total information display that correspondingly displays monthly petty cash total information including information on a total amount of specifications of the monthly petty cash information in the third monthly total information display area in the third total information section, on the basis of the petty cash information displayed in each of the plurality of third date sections through the third information display; and a third report link that, on the basis of an area selection signal in the petty cash management calendar that is input through the input device of the manager computer, provides, in a case where an area corresponding to the area selection signal in the petty cash management calendar is the third information display area in the third date section for a specific date, a separate pop-up window for outputting a cashbook report for the specific date using petty cash information displayed in the area, provides a separate pop-up window for outputting a cashbook report for a specific month in a case where the area corresponding to the area selection signal in the petty cash management calendar is the third monthly total information display area in the third total information section, and provides, in a case where the area corresponding to the area selection signal in the petty cash management calendar is the third date display area in the third date section for the specific date, the same pop-up window as the pop-up window provided through the second report link.
4. 4 . The system according to claim 3 , wherein the bill management calendar providing unit comprises: a fourth calendar generator that generates a bill management calendar including a plurality of fourth date sections having a fourth date display area and a fourth information display area, and a fourth total information section having a fourth monthly total information display area for the bill information; a fourth output standard information generator that generates bill management calendar output standard information including information regarding a first bill information output standard for determining which one of a slip registration date and a slip cost expected-execution date, in the slip information in which the payment method is set to bills, the bill information is to be displayed on the basis of, and information regarding a second bill information output standard for determining which bill type of an income related to bills-receivable and an expenditure related to bills-payable in the slip information the bill information is to be displayed on the basis of, for each fourth date section and each fourth total information section, on the basis of a bill management calendar output standard setting signal that is input through the input device of the manager computer; a fourth information display that displays, while making slip information that satisfies the second bill information output standard in the slip information that is generated, stored and managed through the second information management unit, in which the payment method is set to bills, correspond to each date in the bill management calendar according to the first bill information output standard, bill information corresponding to each date in each fourth information display area in the plurality of fourth date sections, on the basis of the bill management calendar output standard information that is generated through the fourth output standard information generator; a fourth total information display that correspondingly displays monthly bill total information including information on a total amount of specifications of monthly bill information in the fourth monthly total information display area in the fourth total information section, on the basis of the bill information displayed in each of the plurality of fourth date sections through the fourth information display; and a fourth report link that, on the basis of an area selection signal in the bill management calendar that is input through the input device of the manager computer, provides, in a case where an area corresponding to the area selection signal in the bill management calendar is the fourth information display area in the fourth date section for a specific date, a separate pop-up window for outputting a bill ledger report for the specific date using bill information displayed in the area, provides a separate pop-up window for outputting a bill ledger report for a specific month in a case where the area corresponding to the area selection signal in the bill management calendar is the fourth monthly total information display area in the fourth total information section, and provides, in a case where the area corresponding to the area selection signal in the bill management calendar is the fourth date display area in the fourth date section for the specific date, the same pop-up window as the pop-up window provided through the second report link, wherein the card management calendar providing unit comprises: a fifth calendar generator that that generates a card management calendar including a plurality of fifth date sections having a fifth date display area and a fifth information display area, and a fifth total information section having a fifth monthly total information display area for the card information; a fifth output standard information generator that generates card management calendar output standard information including information regarding a first card information output standard for determining which one of a slip registration date and a slip cost expected-execution date, in the slip information in which the payment method is set to cards, the card information is to be displayed on the basis of, information regarding a second card information output standard for determining which slip type of an income and an expenditure in the slip information the card information is to be displayed on the basis of, and information regarding a third card information output standard for determining which one of entire cards and a specific card, in card identification information of slip information in which the payment method is set to cards, the card information is to be displayed on the basis of, for each fifth date section and each fifth total information section, on the basis of a card management calendar output standard setting signal that is input through the input device of the manager computer; a fifth information display that displays, while making slip information that satisfies the second card information output standard and the third card information output standard in the slip information that is generated, stored and managed through the second information management unit, in which the payment method is set to cards, correspond to each date in the card management calendar according to the first card information output standard, the card information corresponding to each date in each fifth information display area in the plurality of fifth date sections, on the basis of the card management calendar output standard information that is generated through the fifth output standard information generator; a fifth total information display that correspondingly displays monthly card total information including information on a total amount of specifications of monthly card information in the fifth monthly total information display area in the fifth total information section, on the basis of the card information displayed in each of the plurality of fifth date sections through the fifth information display; and a fifth report link that, on the basis of an area selection signal in the card management calendar that is input through the input device of the manager computer, provides, in a case where an area corresponding to the area selection signal in the card management calendar is the fifth information display area in the fifth date section for a specific date, a separate pop-up window for outputting a credit card purchase status report or a credit card sales status report for the specific date using card information displayed in the area, provides a separate pop-up window for outputting a credit card purchase status report or a credit card sales status report for a specific month in a case where the area corresponding to the area selection signal in the card management calendar is the fifth monthly total information display area in the fifth total information section, and provides, in a case where the area corresponding to the area selection signal in the card management calendar is the fifth date display area in the fifth date section for the specific date, the same pop-up window as the pop-up window provided through the second report link, on the basis of the area selection signal within the card management calendar that is input by the input device of the manager computer, wherein the credit management calendar providing unit comprises: a sixth calendar generator that generates a credit management calendar including a plurality of sixth date sections having a sixth date display area and a sixth information display area, and a sixth total information section having a sixth monthly total information display area for credit information; a sixth output standard information generator that generates credit management calendar output standard information including information regarding a first credit information output standard for determining which one of a slip registration date and a slip cost expected-execution date the slip information in which the payment method is set to credit is to be displayed on the basis of, and information regarding a second credit information output standard for determining which slip type of an income and an expenditure in the slip information credit information is to be displayed on the basis of, for each sixth date section and each sixth total information section, on the basis of a credit management calendar output standard setting signal that is input through the input device of the manager computer; a sixth information display that displays, while making slip information that satisfies the second credit information output standard in the slip information that is generated, stored and managed through the second information management unit, in which the payment method is set to credit, correspond to each date in the credit management calendar according to the first credit information output standard, the credit information corresponding to each date in each sixth information display area in the plurality of sixth date sections, on the basis of the credit management calendar output standard information that is generated through the sixth output standard information generator; a sixth total information display that correspondingly displays monthly credit total information including information on a total amount of specifications of monthly credit information in the sixth monthly total information display area in the sixth total information section, on the basis of the credit information displayed in each of the plurality of sixth date sections through the sixth information display; and a sixth report link that, on the basis of an area selection signal in the credit management calendar that is input through the input device of the manager computer, provides, in a case where an area corresponding to the area selection signal in the credit management calendar is the sixth information display area in the sixth date section for a specific date, a separate pop-up window for outputting a credit purchase ledger report or a credit sales ledger report for the specific date using credit information displayed in the area, provides a separate pop-up window for outputting a total unpaid state report for a specific month in a case where the area corresponding to the area selection signal in the credit management calendar is the sixth monthly total information display area in the sixth total information section, and provides, in a case where the area corresponding to the area selection signal in the credit management calendar is the sixth date display area in the sixth date section for the specific date, the same pop-up window as the pop-up window provided through the second report link, on the basis of the area selection signal within the credit management calendar that is input through the input device of the manager computer, and wherein the profit/loss management calendar providing unit comprises: a seventh calendar generator that generates a credit management calendar including a plurality of seventh date sections having a seventh date display area and a seventh information display area, and a seventh total information section having a seventh monthly total information display area for credit information; a seventh output standard information generator that generates profit/loss management calendar output standard information including information regarding a first profit/loss information output standard for determining which one of a slip registration date and a slip cost expected-execution date in the slip information the profit/loss information is to be displayed on the basis of, information regarding a second profit/loss information output standard for determining which one of a date-based display and a month-based date-cumulative display the profit/loss information is to be displayed on the basis of, information regarding a third profit/loss information output standard for determining whether to display an increase/decrease ratio compared to the previous day in at least one of a total income, a total expenditure, and a difference between the total income and the total expenditure in the slip information, information regarding a fourth profit/loss information output standard for determining whether to display information on at least one of an increase/decrease ratio of the total expenditure to the total income and an increase/decrease ratio of the difference between the total income and the total expenditure in the slip information, and information regarding a fifth profit/loss information output standard for determining which of a supply price, a value-added tax, or a total amount of the supply value and the value-added tax in the slip information the total income, the total expenditure, and the difference between the total income and total expenditure are to be displayed on the basis, for each seventh date section and each seventh total information section, on the basis of a credit management calendar output standard setting signal that is input through the input device of the manager computer; a seventh information display that displays, while making profit/loss information generated by computing the slip information that is generated, stored and managed through the second information management unit according to the third profit/loss output standard to the fifth profit/loss information output standard correspond to each date in the profit/loss management calendar according to the first profit/loss information output standard and the second profit/loss information output standard, the profit/loss information corresponding to each date in each seventh information display area in the plurality of seventh date sections, on the basis of the profit/loss management calendar output standard information that is generated through the seventh output standard information generator; a seventh total information display that correspondingly displays monthly profit/loss total information including information on a total amount of specifications of monthly profit/loss information in the seventh monthly total information display area in the seventh total information section, on the basis of the profit/loss information displayed in each of the plurality of seventh date sections through the seventh information display; and a seventh report link that, on the basis of an area selection signal in the profit/loss management calendar that is input through the input device of the manager computer, provides, in a case where an area corresponding to the area selection signal in the profit/loss management calendar is the seventh information display area in the seventh date section for a specific date, a separate pop-up window for outputting a profit/loss ledger report for the specific date using profit/loss information displayed in the area, provides a separate pop-up window for outputting a profit/loss status report for a specific month in a case where the area corresponding to the area selection signal in the profit/loss management calendar is the seventh monthly total information display area in the seventh total information section, and provides, in a case where the area corresponding to the area selection signal in the profit/loss management calendar is the seventh date display area in the seventh date section for the specific date, the same pop-up window as the pop-up window provided through the second report link, on the basis of the area selection signal within the profit/loss management calendar that is input through the input device of the manager computer.

Description

TECHNICAL FIELD The present invention relates to an enterprise resource planning system having a financial management function using a computer-implemented calendar. BACKGROUND ART Enterprise resource planning (ERP) is a type of management information system (MIS), which refers to an integrated information system that integrates all elements of a company and efficiently manages all human and material resources within the company used for business activities to strengthen competitiveness of the company. Such an enterprise resource planning system is applied in various industrial fields such as accounting, costing, sales, purchasing, materials, production, quality, facilities, funds, investment, and project management, which results in a marked increase in management and financial efficiency and improvement of work efficiency and management performance. In this relation, the applicant of the present invention has proposed a technique for effectively managing and supervising workers' attendance through an enterprise resource planning system applied to work sites through “Enterprise Resource Planning System Connected with Entrance and Exit Data of Laborer” of Republic of Korea Patent No. 10-0802510. Then, the applicant has continuously developed techniques for diversely expanding the scope of functionality of such an enterprise resource planning system applied to work sites, and has tried to develop a technique for providing financial management functions using calendars capable of easily viewing a variety of financial information at a glance and enhancing a manager's work efficiency and convenience in processing or printing management information. In addition, the applicant has tried to develop a technique for providing various enterprise resource management functions using calendars to solve the problems of low visibility related to information provision, high difficulty in using information and low accessibility in the conventional enterprise resource planning system. DISCLOSURE Technical Problem To solve the above problems, an object of the present invention is to provide a technique, in enterprise resource planning through various financial management functions related to resolutions, slips, petty cash, bills, cards, credits, profit/loss, and the like, capable of easily recognizing information through provision of the functions using a computer-implemented calendar and effectively and diversely utilizing the information. Technical Solution In order to achieve the above object, according to an aspect of the present invention, there is provided an enterprise resource planning system provided by an enterprise resource planning (ERP) program that is installed and implemented on a manager computer, including: a first information management unit that stores and manages, as a database, resolution information that is generated to include a resolution creation date, a company name, a site name, a work type name, a resolution type selected as one of income or expenditure, an account subject, a customer name, a supply price, a value-added tax, a total amount, a payment method, and a resolution cost expected-execution date, on the basis of a resolution information input signal that is input through an input device of the manager computer; a second information management unit that stores and manages, as a database, slip information that is generated to include a slip registration date, a company name, a site name, a work type name, a slip type selected as one of income or expenditure, an account subject, a customer name, a supply price, a value-added tax, a total amount, a payment method, and a slip cost expected-execution date, on the basis of resolution information, corresponding to a slip registration target selection signal that is input through the input device of the manager computer, in the resolution information that is generated, stored and managed through the first information management unit; a resolution management calendar providing unit that outputs and provides, to an output device of the manager computer, a calendar that displays the resolution information that is generated, stored and managed through the first information management unit in correspondence with a resolution creation date or a resolution cost expected-execution date for each date in the calendar; and a slip management calendar providing unit that outputs and provides, to the output device of the manager computer, a calendar that displays the slip information that is generated, stored and managed through the second information management unit in correspondence with a slip registration date or a slip cost expected-execution date for each date in the calendar. The enterprise resource planning system having a financial management function using the computer-implemented calendar includes: a third information management unit that stores and manages, as a database, real-time cash information that is generated from at least one of bank account i