CN113627873A - Project type enterprise financial monthly automated system based on SAP and use method - Google Patents

Project type enterprise financial monthly automated system based on SAP and use method Download PDF

Info

Publication number
CN113627873A
CN113627873A CN202110848471.8A CN202110848471A CN113627873A CN 113627873 A CN113627873 A CN 113627873A CN 202110848471 A CN202110848471 A CN 202110848471A CN 113627873 A CN113627873 A CN 113627873A
Authority
CN
China
Prior art keywords
monthly
transaction
sap
program
module
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202110848471.8A
Other languages
Chinese (zh)
Inventor
孙德君
朱峰
余雨轩
杨书席
孙华锋
孙春荣
朱锁明
杜宁
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Casco Signal Ltd
Original Assignee
Casco Signal Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Casco Signal Ltd filed Critical Casco Signal Ltd
Priority to CN202110848471.8A priority Critical patent/CN113627873A/en
Publication of CN113627873A publication Critical patent/CN113627873A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/103Workflow collaboration or project management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12Accounting
    • G06Q40/125Finance or payroll

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Strategic Management (AREA)
  • Accounting & Taxation (AREA)
  • Human Resources & Organizations (AREA)
  • Finance (AREA)
  • Entrepreneurship & Innovation (AREA)
  • General Physics & Mathematics (AREA)
  • Economics (AREA)
  • Theoretical Computer Science (AREA)
  • Marketing (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • Tourism & Hospitality (AREA)
  • Quality & Reliability (AREA)
  • Operations Research (AREA)
  • Data Mining & Analysis (AREA)
  • Development Economics (AREA)
  • Technology Law (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

The invention relates to a project type enterprise financial monthly automated system based on SAP and a use method thereof, wherein the system comprises a monthly workbench integrated with each independent monthly transaction of SAP EPR; the lunar junction workbench automatically runs each module task through a plan execution list and a group operation transferring program to complete an automatic lunar junction process; the module task comprises a pre-checking program module, a monthly transaction program module and a post-transaction checking program module which are sequentially carried out. Compared with the prior art, the invention has the advantages of high automation degree, high efficiency and high fault tolerance.

Description

Project type enterprise financial monthly automated system based on SAP and use method
Technical Field
The invention relates to the field of automatic processing of enterprise financial monthly statement information, in particular to a project type enterprise financial monthly statement automatic system based on SAP and a use method.
Background
With the continuous expansion of the scale of the company, each subsidiary company is established, and the breadth and the depth (fineness) of the operation management of the company are further expanded. The informatization construction project group utilizes an informatization means as a gripper, continuously provides important guarantee and means for achieving a group strategy of a company, provides comprehensive cooperation, cost reduction and efficiency improvement for the company, and improves the insights, the strain and the innovation of the company.
On one hand, with the continuous increase of the business volume of a company and the continuous expansion of the transaction requirements in a group, the time consumption of the traditional SAP ERP financial monthly mode is longer, the time uncertainty risk of completing checkout and issuing a report is more and more prominent, and the disadvantage is brought to the monthly overall planning work of the company; on the other hand, as the company intelligence and digitization strategy is gradually advanced, the timely and accurate requirements of the company management layer on the financial settlement are higher and higher.
In order to meet the requirements of company management and control and fine management of project operation, the cooperative monthly settlement between a headquarter and a subsidiary company of a company can be realized, the settlement of a group level can be timely and accurately completed, and a financial statement with reliable quality can be issued, a novel automatic financial monthly settlement data processing method must be developed for an information-based construction project, so that the data processing efficiency is improved.
Disclosure of Invention
The invention aims to overcome the defects of the prior art and provides an SAP-based project enterprise financial monthly automation system and a using method thereof.
The purpose of the invention can be realized by the following technical scheme:
according to a first aspect of the present invention, there is provided an SAP based project enterprise financial monthly transaction automation system, comprising a monthly workstation integrating individual monthly transactions of SAP EPR; the lunar junction workbench automatically runs each module task through a plan execution list and a group operation transferring program to complete an automatic lunar junction process; the module task comprises a pre-checking program module, a monthly transaction program module and a post-transaction checking program module which are sequentially carried out.
Preferably, the pre-checking program module is a program module for automatically detecting and finding out the business data inconsistency before the transaction is ended so as to perform intervention processing in advance.
Preferably, the automatic processing of each monthly transaction program module and the key monthly transaction program module comprise performance optimization processing of a job price reevaluation module, a result analysis module and a project settlement module.
Preferably, the job price reevaluation module includes a dynamically assigned project actual price reevaluation variant program for obtaining a WBS element list of the current cost center group generated LC costs and assigning to variants.
Preferably, the result analysis module includes a result analysis variant program for dynamic assignment, and is configured to obtain the current actual cost plus the current state change, and assign a variant.
Preferably, the item settlement module comprises a dynamically assigned market item settlement variant program, which is used for acquiring items with current states of REL and TECO and assigning variants.
Preferably, the post-transaction inspection program is a module for automatically checking and verifying the audit relationship of various types of data after the completion of the monthly transaction and returning detailed result information.
Preferably, the lunar junction workbench further comprises a notification module for triggering a message interface after completion of the lunar junction step.
Preferably, the lunar rover automatically records all operational steps, execution results, operators, execution time, execution return detail data, spool data, and inspection return detail data.
According to a second aspect of the present invention, there is provided a method for using the SAP-based project enterprise financial monthly automation system, the method comprising the steps of:
step S1: reading a monthly step configuration table according to the company code;
step S2: selecting a step to be executed in a certain year and month under a certain company code according to the interval range;
step S3: setting an automatic execution date and time;
step S4: performing a validity check including checking whether a maximum number of parallel jobs is exceeded, whether a scheduled execution list already exists;
step S5: if the check is passed, a plan execution list is created, otherwise, the operation is quitted and the reason for failure is given;
step S6: creating a group job scheduling program according to the plan execution list, monitoring the overall execution condition of the plan execution list, and capturing and throwing out the group job scheduling program when an abnormal error occurs at the level;
step S7: circularly reading the monthly balance according to the sequence of the planned execution list, wherein the monthly balance comprises monthly balance transactions and corresponding post-transaction inspection programs;
step S8: reading the specific parameter setting of the single monthly transaction under the company code;
step S9: automatically executing single monthly transaction and recording return result and detail data;
step S10: reading the operation message and the monthly running state mapping table and correcting the monthly transaction return result;
step S11: judging whether the returned result of the single monthly transaction is successful and marking the state, if so, continuing, otherwise, quitting the plan execution list, closing the group operation scheduling program, and marking the total state as failure;
step S12: circularly reading the specific parameter setting of the post-transaction checking program related to the single monthly transaction;
step S13: executing the post-transaction inspection programs in sequence; if the checking is successful, jumping to step S12, otherwise, quitting the plan execution list, closing the group operation scheduling program, and marking the total state as failure;
step S14: if all the post-transaction check programs under the single monthly transaction are executed, the step S7 is skipped;
step S15: planning the execution manifest to involve the step being performed completely marks the overall status as successful and closes the group job scheduler.
Compared with the prior art, the invention has the following advantages:
1) the method has the advantages that the complicated financial monthly settlement steps related to different companies in the group are unified into the same platform, the monthly settlement can be automatically executed simultaneously aiming at the headquarter and each subsidiary company, the convenience and the automation degree of the system are increased while the monthly settlement steps are normalized, the execution efficiency is improved, and the purpose of cooperative monthly settlement in the group is achieved;
2) compared with the original financial monthly settlement, the platform adds a pre-checking program aiming at different settlement objects such as orders, projects, cost centers and the like, and can find the problems of inconsistent data and the like in advance after the business occurs in the month, thereby carrying out related intervention processing in advance and ensuring the smooth execution of the automatic monthly settlement;
3) compared with the original financial monthly settlement, the platform is additionally provided with an automatic checking function after the completion of a single monthly settlement step, and the checking and verification of the checking relationship of the data are carried out, so that whether the execution of the multi-dimensional verification step is successful or not is realized. The original complicated process that various reports with different dimensions need to be checked manually is simplified;
4) compared with the original financial monthly knot, the platform comprises the following steps: performance optimization is performed on operation price reestimation, result analysis and project settlement, and average performance improvement rates are respectively 98.17%, 59.19% and 10.98%;
5) the platform automatically records all operation steps, execution results, operators, execution time consumption, execution return detail data, spool data, check return detail data and other audit tracks. The data can be conveniently traced and statistically analyzed by related personnel.
Drawings
FIG. 1 is a schematic diagram of a SAP based project enterprise financial monthly automation system;
FIG. 2 is a schematic view of a lunar junction workstation in use;
FIG. 3 is a schematic illustration of an execution interface;
FIG. 4 is a schematic diagram of configuration parameters;
FIG. 5 is a diagram illustrating dynamic adjustment of inspection parameters;
FIG. 6 is a diagram illustrating a return result of an operation of automatically correcting a monthly transaction in a mapping table
FIG. 7 is a diagram illustrating pre-inspection of excluded special case business objects;
FIG. 8 is a schematic diagram of a variation data for dynamically setting key monthly steps;
FIG. 9 is a flowchart of an order pre-check routine;
FIG. 10 is a flowchart of a cost center pre-check routine;
FIG. 11 is a flowchart of an order/cost center/project center check program after a monthly transaction;
FIG. 12 is a flowchart of a post-monthly transaction revenue cost table and workload checking routine;
FIG. 13 is a flowchart of a dynamic assignment variable monthly program;
FIG. 14 is a schematic view of a notification interface.
FIG. 15 is a comparison graph of execution time before and after optimization;
FIG. 16 is a detailed diagram of the pre-check return result;
FIG. 17 is a diagram of post-transaction inspection return details;
FIG. 18 is a graph comparing elapsed time before and after optimization;
FIG. 19 is a schematic view of an oplog;
FIG. 20 is a schematic diagram of execution return detail data;
FIG. 21 is a schematic spool diagram;
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, shall fall within the scope of protection of the present invention.
The embodiment aims at the financial monthly requirements of headquarters and subsidiaries of the cassecholocation signal limited company, and the project enterprise financial monthly automation system and method based on the SAP are adopted for implementation so as to meet the requirements of cassecholocation group management and control and project operation fine management, namely, the cooperative monthly requirements between the headquarters and the subsidiaries are realized, the group-level settlement can be timely and accurately completed, and the financial statement with reliable quality can be issued.
1. The invention integrates each independent financial monthly transaction in SAP ERP to a unified monthly platform, and carries out automatic processing according to each company of the group: the headquarter and each subsidiary company can automatically execute the monthly balance at the same time, automatically check the result and record detailed logs after monthly balance transaction execution, and achieve the purposes of coordinating the monthly balance in the group and improving the monthly balance efficiency. As shown in fig. 1, each module task (pre-inspection program, monthly transaction, post-transaction inspection program, notification module, etc.) is automatically run through the schedule execution list and group job invocation program; a pre-inspection program is added, and the problems of inconsistent service data and the like are found in advance before the end of the formal month, so that intervention treatment can be carried out in advance; newly adding an inspection function after the completion of the monthly step, checking and verifying the checking relationship of various data and returning a detailed result; and (3) carrying out key monthly knot treatment: performance optimization is carried out on operation price reevaluation, result analysis and project settlement, and system operation efficiency is improved; and (4) automatically recording all operation steps, execution results, operators, execution time consumption, detailed data and other audit tracks, and facilitating data tracing and statistics. The execution interface is shown in fig. 3.
2. Expandability of platform through various configurable parameters
As shown in fig. 4, the monthly steps can be flexibly increased or decreased;
as shown in fig. 5, the check function parameters may be dynamically adjusted;
as shown in fig. 6, the return result of the monthly transaction operation is automatically corrected according to the mapping table;
as shown in fig. 7, the pre-check excludes special case business objects, and increases system flexibility;
as shown in fig. 8, the critical lunar junction step variation data is set according to the dynamic.
3. As shown in fig. 2, the operation of the moon pool includes the following steps:
step S1: reading a monthly step configuration table according to the company code;
step S2: selecting a step to be executed (or a full selection step) of a certain year and month under a certain company code according to the interval range;
step S3: setting an automatic execution date and time;
step S4: and executing validity check: checking whether the maximum parallel operation number is exceeded, whether a plan execution list already exists, and the like;
step S5: if the check is passed, a plan execution list is created, otherwise, the operation is quitted and the reason for failure is given;
step S6: creating a group job scheduling program according to the plan execution list, monitoring the overall execution condition of the plan execution list, and capturing and throwing out the group job scheduling program when an abnormal error occurs at the level;
step S7: circularly reading the monthly results (monthly transactions, check functions) according to the sequence of the plan execution list;
step S8: reading the specific parameter setting of the single monthly transaction under the company code;
step S9: automatically executing single monthly transaction and recording return result and detail data;
step S10: reading the operation message and the monthly running state mapping table and correcting the monthly transaction return result;
step S11: judging whether the returned result of the single monthly transaction is successful and marking the state, if so, continuing, otherwise, quitting the plan execution list, closing the group operation scheduling program, and marking the total state as failure;
step S12: circularly reading the specific parameter setting of the checking function related to the single monthly transaction;
step S13: the checking functions are executed in sequence: checking and checking the checking relation of the data and recording the checking result and the detailed data; if the checking is successful, jumping to step S12, otherwise, quitting the plan execution list, closing the group operation scheduling program, and marking the total state as failure;
step S14: if all the check functions are executed in a single monthly transaction, the step S7 is skipped;
step S15: planning the execution manifest to involve the step being performed completely marks the overall status as successful and closes the group job scheduler.
4. The financial platform comprises the following parts:
1) the new pre-inspection program, as shown in fig. 9, includes: the service order/market cooperates with internal order/trade between companies and the internal order/spare part sales order settlement rule validity check, judges whether the order issued and technology closed has the condition that the settlement rule is maintained incorrectly or is not maintained in the validity period, and the check function is as follows:
ZF _ CHECK _ YJ13 (company code, property year, period);
ZF _ CHECK _ YJ14 (company code, property year, period);
ZF _ CHECK _ YJ19 (company code, property year, period);
ZF _ CHECK _ YJ18 (company code, property year, period);
checking validity of settlement rules of research and development/outsourcing/market projects, judging whether settlement rules of projects issued and closed by technology are maintained incorrectly, wherein the checking function is as follows:
ZF _ CHECK _ YJ15 (company code, property year, period);
ZF _ CHECK _ YJ16 (company code, property year, period);
the consistency of the actual time of the direct rate of the labor cost center group and the KP26 weight is checked, and the checking function is as follows:
ZF _ CHECK _ YJ11 (control range, cost center group, fiscal year, period);
the report cost center group KP26 indirect rate, the consistency of the segmentation structure is checked, the checking function is:
ZFI _ KP26_ CHECK (control Range, cost center group, year, duration);
ZFI _ OKEW _ CHECK (control Range, cost center group, year of wealth);
checking the consistency of the labor reporting cost center group and the non-labor reporting cost center group, wherein the checking function is as follows:
ZF _ CHECK _ YJ17 (control range, cost center group, fiscal year, period);
2) maintaining exchange rate and exchange profit and loss
Adding an EUR and USD exchange rate of the new automatic acquisition day, automatically maintaining the EUR and USD exchange rate to S _ BCE _68000174 through an interface, and optimizing an exchange loss program to be automatically executed through a monthly workbench according to configuration parameters;
3) depreciation
Optimizing the original depreciation standard program to be automatically executed through a monthly platform according to configuration parameters;
4) cyclic split
Newly adding a cycle section to be executed for batch unlocking according to the work report and the wage allocation condition at the current month; optimizing and transforming a circular allocation program into automatic execution through a monthly workbench according to configuration parameters, simultaneously judging whether an operation group 0000 is locked before operation, and suspending and polling for inspection to avoid the resource conflict phenomenon of parallel operation if the operation group 0000 is locked; after the operation, the inspection is performed, as shown in fig. 10, including:
whether the non-reporting cost center group charges are all delivered, i.e. excess/insufficient absorption is 0, the check function is:
ZF _ CHECK _ YJ3 (control range, fiscal year, period, cost center group);
checking whether the current condition of no work is reported, whether the cost center group has value for the borrower and no value for the lender, and checking a function as follows: ZF _ CHECK _ YJ12 (control range, fiscal year, period, cost center group);
5) job price reestimation
Newly adding a dynamic assignment item actual price reestimation variable program: obtaining a WBS element list generating LC cost in the current cost center group and assigning the WBS element list to a variable; optimizing the actual price reevaluation program to be automatically executed through a monthly platform according to the configuration parameters; after the operation, the inspection is performed, as shown in fig. 10, including: checking the group expense loan balance of the cost center, and if the balance is in a set threshold range;
the check function is: ZF _ CHECK _ YJ3 (control range, fiscal year, period, cost center group);
6) order settlement
The capital maintenance order settlement, the material maintenance order settlement, the market-matched internal order settlement, the service order settlement and the spare part sales order settlement are optimized to be automatically executed through a monthly platform according to configuration parameters, and after the operation is finished, the inspection is executed, as shown in fig. 11, including: if the market cooperation internal order has effective settlement rules, the monthly balance of the market cooperation internal order needs to be 0, the SALES fees of the cost center group NC-SALES and the profit list are consistent, the monthly balance of the KKAH spare part SALES order needs to be 0, the monthly balance of the service order needs to be 0, the expense loan balance of the cost center group NC3000/NC2100/NPO01/NPO02/NRD01/NRD02 is balanced, and the checking function is as follows:
ZF _ CHECK _ YJ20 (company code, from to order, property year, term);
ZFI _ CJI3_ ORDERCHK (company code, from to order, year of property, term);
ZF _ CHECK _ YJ5 (control range, fiscal year, period, cost center group, sales cost);
ZFI _ KKAH _ BJXSORDERCHK (company code, year of finance, accounting period, from to order number);
ZF _ CHECK _ YJ3 (control range, fiscal year, period, cost center group);
7) project result analysis
Adding a dynamic assignment result analysis variable program: acquiring the current actual cost + the current state change: REL- > TECO or TECO- > REL + current CJ40, CJ42 changed items and assigned variables as shown in FIG. 13; optimizing a market project result analysis program to be automatically executed through a monthly platform according to configuration parameters;
8) item settlement
Adding a dynamic assignment market project settlement variant program: the current state is the items of REL and TECO and is assigned with a variable; optimizing the programs of the balance of the outsourced projects, the balance of the research and development projects and the balance of the market projects to be automatically executed through a monthly settlement workbench according to the configuration parameters, as shown in FIG. 13;
after the operation, the inspection is performed, as shown in fig. 11, including: checking the balance of the current outsourcing project and the research and development project to be 0, and checking a cost center group: managing NC-ADMIN, selling NC-SALE and profit sheet data consistency checks that the current amount of development expenses for profit sheet is consistent with the amount of 600001 project settlement cost elements of the cost center group NC-DEV, the checking function being:
ZFI _ CJI3_ PROJCHK (control scope, company code, project, year, duration);
ZF _ CHECK _ YJ6 (control range, company code, cost center group, property year, period, corresponding administrative charge);
ZF _ CHECK _ YJ5 (control range, company code, cost center group, year of property, period, corresponding to sales cost);
ZF _ CHECK _ YJ7 (control range, company code, cost center group, fiscal year, period, corresponding development cost);
9) income cost meter
The revenue cost sheet program is optimized to be automatically executed by the checkout station according to the configuration parameters, and after running, checks are executed, as shown in fig. 12, including: the consistency check of the income cost table current period and the previous period, and the consistency check of the COSB history table (the accumulated income of the previous period and the accumulated cost of the previous period) and 042b, wherein the check functions are as follows:
ZFI _ FIR042B _ CHECK (company, control Range, year, period);
ZFI _ COSB _042B _ CHECK (control scope, company code, year of property, duration);
10) work meter
Optimizing the workload table program to be automatically executed through a monthly platform according to the configuration parameters; after the operation, the inspection is performed, as shown in fig. 12, including: the method comprises the following steps of checking consistency of unallocated profits of an asset and liability statement and net profits of a profit statement, checking consistency of end balances of cash flow statement cash and end currency funds of the asset and liability statement, checking consistency of a COSB history table and a working table, checking consistency of a COSB and an income cost table (ZCOSB), checking consistency of the COSB and the working table, wherein the checking functions are as follows:
ZF _ CHECK _ YJ8 (control range, company code, year, duration);
ZF _ CHECK _ YJ9 (control range, company code, year, duration);
ZFI _ COSB _015_ CHECK (control scope, company code, year of property, period);
ZFI _ COSB _ CURRENT _ CHECK (control Range, company code, year of property, duration);
ZFI _ COSB _015_ CURRENT _ CHECK (control Range, company code, year of property, duration);
11) notification module, as shown in fig. 14:
and after the completion of the month, triggering a message interface, and pushing the operation data KPI index to related personnel of the enterprise WeChat.
5. Summary of the invention
1) The invention unifies the complicated financial monthly settlement steps related to different companies in the group to the same monthly settlement workbench, can automatically perform monthly settlement aiming at the headquarter and each subsidiary company at the same time, increases the convenience and the automation degree of the system while standardizing the monthly settlement steps, improves the execution efficiency and realizes the purpose of cooperative monthly settlement in the group. FIG. 15 shows a comparison of before and after optimization of month execution time;
2) compared with the original financial monthly settlement, the monthly settlement workbench is additionally provided with a pre-checking program aiming at different settlement objects such as orders, projects and cost centers, and the problems of inconsistent data and the like can be found in advance after business occurs in the month, so that related intervention processing is carried out in advance, and the smooth execution of automatic monthly settlement is ensured. The pre-check return details are shown in FIG. 16.
3) Compared with the original financial monthly settlement, the monthly settlement workbench is additionally provided with an automatic checking function after the completion of a single monthly settlement step, and the checking and verification of the checking relationship of the data are carried out, so that whether the execution of the multi-dimensional verification step is successful or not is realized. The original complicated process that various reports with different dimensions need to be checked manually is simplified. Checking return details after transaction as shown in FIG. 17; compared with the original financial monthly knot, the monthly knot workbench comprises the following steps: the performance optimization is carried out on the operation price reevaluation, the result analysis and the project settlement, and the average performance improvement rates are respectively 98.17%, 59.19% and 10.98%. The comparison of time consumption before and after optimization is shown in fig. 18.
4) The lunar junction workbench automatically records all operation steps, execution results, operators, execution time consumption, execution return detailed data, spool data, inspection return detailed data and other auditing tracks. The data can be conveniently traced and statistically analyzed by related personnel. FIG. 19 is a schematic view of an operation log, and FIG. 20 is a schematic view of execution return detail data; FIG. 21 is a schematic spool diagram.
While the invention has been described with reference to specific embodiments, the invention is not limited thereto, and various equivalent modifications and substitutions can be easily made by those skilled in the art within the technical scope of the invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.

Claims (10)

1. An SAP-based project enterprise financial monthly automated system, which is characterized by comprising a monthly workbench integrating independent monthly transactions of SAP EPR; the lunar junction workbench automatically runs each module task through a plan execution list and a group operation transferring program to complete an automatic lunar junction process; the module task comprises a pre-checking program module, a monthly transaction program module and a post-transaction checking program module which are sequentially carried out.
2. An SAP-based project enterprise financial monthly automation system as claimed in claim 1, wherein said pre-inspection program modules are program modules for automatically detecting and discovering business data inconsistencies prior to monthly transactions for early intervention.
3. An SAP-based project enterprise financial monthly automation system as claimed in claim 1 wherein said automated processing of monthly transaction program modules and critical monthly transaction program modules include job price reevaluation module, results analysis module and performance optimization of project settlement module.
4. An SAP-based project enterprise financial monthly automation system as claimed in claim 3 wherein said job price reevaluation module includes a dynamically assigned project actual price reevaluation variant program for obtaining and assigning to a variant a WBS element list of LC costs generated by the current cost center group.
5. An SAP-based project enterprise financial monthly automation system as claimed in claim 3, wherein said results analysis module includes a dynamically assigned results analysis variables routine for obtaining current actual cost plus current status changes and assigning variables.
6. An SAP-based project enterprise financial monthly automation system as claimed in claim 3 wherein said project settlement module includes a dynamically assigned market project settlement variables routine for acquiring projects currently in REL and TECO states and assigning variables.
7. The automated system according to claim 1, wherein the post-transaction inspection procedure is a module for automatically checking the audit relationship of various data after completion of the monthly transaction and returning detailed result information.
8. An SAP-based project enterprise financial lunar junction automation system as claimed in claim 1, wherein said lunar junction workbench further comprises a notification module for triggering a message interface upon completion of a lunar junction step.
9. An SAP based project enterprise financial moon automation system as claimed in claim 1, wherein said moon cakes workstation automatically records all operational steps, execution results, operators, execution time, execution return detail data, spool data and inspection return detail data.
10. Use of the SAP-based project enterprise financial monthly automation system according to claim 1, characterised in that it comprises the following steps:
step S1: reading a monthly step configuration table according to the company code;
step S2: selecting a step to be executed in a certain year and month under a certain company code according to the interval range;
step S3: setting an automatic execution date and time;
step S4: performing a validity check including checking whether a maximum number of parallel jobs is exceeded, whether a scheduled execution list already exists;
step S5: if the check is passed, a plan execution list is created, otherwise, the operation is quitted and the reason for failure is given;
step S6: creating a group job scheduling program according to the plan execution list, monitoring the overall execution condition of the plan execution list, and capturing and throwing out the group job scheduling program when an abnormal error occurs at the level;
step S7: circularly reading the monthly balance according to the sequence of the planned execution list, wherein the monthly balance comprises monthly balance transactions and corresponding post-transaction inspection programs;
step S8: reading the specific parameter setting of the single monthly transaction under the company code;
step S9: automatically executing single monthly transaction and recording return result and detail data;
step S10: reading the operation message and the monthly running state mapping table and correcting the monthly transaction return result;
step S11: judging whether the returned result of the single monthly transaction is successful and marking the state, if so, continuing, otherwise, quitting the plan execution list, closing the group operation scheduling program, and marking the total state as failure;
step S12: circularly reading the specific parameter setting of the post-transaction checking program related to the single monthly transaction;
step S13: executing the post-transaction inspection programs in sequence; if the checking is successful, jumping to step S12, otherwise, quitting the plan execution list, closing the group operation scheduling program, and marking the total state as failure;
step S14: if all the post-transaction check programs under the single monthly transaction are executed, the step S7 is skipped;
step S15: planning the execution manifest to involve the step being performed completely marks the overall status as successful and closes the group job scheduler.
CN202110848471.8A 2021-07-27 2021-07-27 Project type enterprise financial monthly automated system based on SAP and use method Pending CN113627873A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110848471.8A CN113627873A (en) 2021-07-27 2021-07-27 Project type enterprise financial monthly automated system based on SAP and use method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110848471.8A CN113627873A (en) 2021-07-27 2021-07-27 Project type enterprise financial monthly automated system based on SAP and use method

Publications (1)

Publication Number Publication Date
CN113627873A true CN113627873A (en) 2021-11-09

Family

ID=78381003

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110848471.8A Pending CN113627873A (en) 2021-07-27 2021-07-27 Project type enterprise financial monthly automated system based on SAP and use method

Country Status (1)

Country Link
CN (1) CN113627873A (en)

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103473628A (en) * 2013-08-20 2013-12-25 国家电网公司 Method for controlling automatic fund transferring system
CN109978676A (en) * 2019-03-21 2019-07-05 广州翔实工程咨询有限公司 A kind of automatic settlement method, system and storage medium
CN110322190A (en) * 2019-05-28 2019-10-11 唐山钢铁集团有限责任公司 The method that steel industry intrabranch service order based on SAP automatically creates
CN111476650A (en) * 2020-03-30 2020-07-31 国网福建省电力有限公司 Financial automatic monthly payment system based on artificial intelligence technology

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103473628A (en) * 2013-08-20 2013-12-25 国家电网公司 Method for controlling automatic fund transferring system
CN109978676A (en) * 2019-03-21 2019-07-05 广州翔实工程咨询有限公司 A kind of automatic settlement method, system and storage medium
CN110322190A (en) * 2019-05-28 2019-10-11 唐山钢铁集团有限责任公司 The method that steel industry intrabranch service order based on SAP automatically creates
CN111476650A (en) * 2020-03-30 2020-07-31 国网福建省电力有限公司 Financial automatic monthly payment system based on artificial intelligence technology

Similar Documents

Publication Publication Date Title
CN111815424B (en) Information system engineering supervision project cost accounting management system
US7970729B2 (en) Enterprise architecture analysis framework database
CN108932589B (en) Enterprise informatization project implementation management system
Abran et al. Measurement of the maintenance process from a demand‐based perspective
US20050165668A1 (en) Multi-processing financial transaction processing system
US20130339095A1 (en) System and method for organizing price modeling data using hierarchically organized portfolios
CN110096544A (en) A kind of operating audit system based on ERP system
KR20160023177A (en) Business plan method for supporting business plan management
CN115310766A (en) Enterprise management system based on big data analysis
US20090049394A1 (en) Quantifying and analyzing back office and field service processes
CN117057686A (en) Intelligent management method, device, equipment and storage medium for material purchase
CN113627873A (en) Project type enterprise financial monthly automated system based on SAP and use method
Singh et al. Generalization of Software Metrics on Software as a Service (SaaS)
CN113592611A (en) Integrated management system for centralized acquisition and supervision of garbage incineration enterprises
De Marco et al. A framework methodology for selection of risk analysis techniques in construction projects
Egiyi et al. Robotic Process Automation (RPA): Its Application and the Place for Accountants in the 21st Century
Jones et al. Practical Software and Systems Measurement Continuous Iterative Development Measurement Framework
Wang et al. Analyzing Transaction Codes in Manufacturing for Compliance Monitoring
Sari et al. Optimization of the Automated Sales System as an Effort to Minimize Fraud & Improve Internal Control at The Distribution Company PT Sehat Selalu Banyak Rejeki
Panchenko FEATURES OF THE ORGANIZATION OF INTERNAL CONTROL OF FINANCIAL RESULTS
Kleosakul Applying activity-based Applying activity-based costing and activity-based management methods to estimate manufacturing costs and activities
Renaldo et al. E-learning Teaching Materials: Accounting Information Systems
Jung et al. A Forecasting Model for Rental Prices of Tower Cranes
CN117575825A (en) Financial centralized management system for industry and financial fusion
Dallu DATA ANALYTICS THE KEY TO RISK-BASED AUDITING

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination