CN111161048A - Application method and device for automatic posting of fund collection - Google Patents
Application method and device for automatic posting of fund collection Download PDFInfo
- Publication number
- CN111161048A CN111161048A CN201911385142.3A CN201911385142A CN111161048A CN 111161048 A CN111161048 A CN 111161048A CN 201911385142 A CN201911385142 A CN 201911385142A CN 111161048 A CN111161048 A CN 111161048A
- Authority
- CN
- China
- Prior art keywords
- account
- company
- bank
- posting
- fund
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses an application method of fund collection automatic posting, which comprises the following steps: the group financial company provides an interface for inquiring bank transaction flow, an ERP system automatically acquires the transaction flow of all banks of the member unit through background operation programs every day, a capital department of the member unit configures an opposite side account of bank account fund collection in the ERP system and maintains the opposite side account, a financial department of the member unit executes a program for creating fund collection certificates in the ERP system and deletes the fund collection flow, and the member unit transfers the actual balance of the bank account to a virtual account set by the financial company for fund collection flow. The method solves the problems that manpower and material resources are wasted and the probability of errors is high in the prior art through manpower input.
Description
Technical Field
The invention relates to the field of fund posting, in particular to an application method and device for fund collection automatic posting.
Background
Enterprise Resource Planning, ERP, is a supply chain management thought proposed by Gartner Group Inc, which is established on the basis of information technology, and provides a management platform of decision-making operation means for Enterprise decision-making layers and employees by using a systematized management thought, wherein the ERP system supports mixed manufacturing environments of discrete type, flow type and the like, the application range is expanded from the manufacturing industry to business departments of retail industry, service industry, banking industry, telecommunication industry, government agency, school and the like, and Enterprise resources are effectively integrated by fusing database technology, graphical user interfaces, fourth-generation query languages, client server structures, computer-assisted development tools, portable open systems and the like.
In order to enhance the centralized management of enterprise group funds and improve the use efficiency of enterprise group funds, a modern large-scale group company sets up a group financial company at a dispute, the financial company can absorb deposits of member units and assist the member units to realize the business of receiving and paying transaction funds, reduce the use cost of the funds for the group enterprise, reasonably utilize the group funds, in the actual operation process, some bank accounts of the member units are provided with the business of automatic fund collection, the funds of the bank accounts are collected into the account of the group financial company, the member units ensure the accuracy of the balance of the bank accounts of the ERP system, the group needs to manually book the automatically collected business into the financial system of the ERP system every day, the large-scale enterprise has more member units and more bank accounts, the online banking system of each bank needs to inquire the assembly line of the collected funds, and then one time of financial voucher is recorded into the ERP system, a very large amount of work is generated and the error rate is high due to manual operation.
Disclosure of Invention
The invention provides an application method and device for automatic posting of fund collection, and aims to solve the problems that a large amount of manpower and material resources are wasted and the probability of errors caused by human factors is high in the prior art.
In order to achieve the purpose, the invention adopts the following technical scheme:
the invention discloses an application method of fund collection automatic posting, which comprises the following steps:
the group financial company provides an interface for inquiring the bank transaction flow, and the ERP system automatically acquires the transaction flow of all the banks of the member unit through a background operation program every day;
the member unit fund department configures and maintains an opposite side account of the bank account fund collection in the ERP system;
the financial department of the member company executes a program for creating a fund collection voucher in an ERP system and deletes a fund collection assembly line;
and the member unit transfers the actual balance of the bank account to a virtual account opened by the financial company for fund collection and flow posting.
According to the scheme, the member ERP system obtains the transaction flow of the bank account through a financial enterprise interface program provided by a financial company, the ERP system deletes the fund collection flow meeting the conditions according to the transaction flow, and the ERP system automatically posts the fund collection flow aiming at the flows, so that the automatic posting of the fund collection service is realized, a large amount of manpower and material resources are released, and the probability of errors caused by human factors is reduced.
Preferably, the group finance company provides an interface for inquiring the transaction flow of the banks, and the ERP system automatically acquires the transaction flow of all the banks of the member unit through a background operation program every morning comprises the following steps:
acquiring the information of a bank account signed by a member company and a financial company, and maintaining the information of the bank account in an ERP system by a fund department of the member company;
acquiring an ERP account of bank account information with authority query, and maintaining the ERP account in an ERP system by a capital department of a member company;
acquiring an account and a password of a financial company system corresponding to the ERP account with the inquiry authority, carrying out MD5 encryption processing on the password, and maintaining the account password information in the ERP system by a member company capital department;
polling each piece of bank account information, acquiring a corresponding account number and a password of the financial company, and assembling into an XML message meeting the system interface requirement of the financial company;
analyzing the message returned by the financial company and storing the analyzed data into a data table ZTZHMX, wherein the data table ZTZTZH comprises a bank receipt number, a self account name, an opposite side account number, an opposite side account name, an opposite side account opening row name, an execution date, a rest date, a transaction generation amount, a transaction direction, a transaction generation time and a remark.
Preferably, the step of executing the program for creating the fund collection voucher and deleting the fund collection stream in the ERP system by the financial department of the member company comprises the following steps:
inputting a selection condition, wherein the selection condition comprises a company code and an aggregation date;
selecting a bank account transaction running line meeting the selection condition from the data table ZTZHMX;
and if the counter side account information in the bank account transaction flow is a financial company fund collection account number configured in the ERP system by the member unit fund department and the transaction direction is payment, determining that the transaction flow is a fund collection transaction flow.
Preferably, the step of transferring the actual balance of the bank account to a virtual account opened by a financial company for fund collection and flow accounting by the member unit comprises:
determining a virtual bank account of a member company in the ERP system;
collecting and flowing the funds for posting, wherein posting and entry comprises borrowing: a financial company virtual account; loan: a bank running account;
and after the posting is successful, updating a POST posting mark in the data table ZTZHMX, and not executing automatic posting.
An application apparatus for automatic posting of collected funds, comprising:
providing an interface module for a group financial company to provide an interface for inquiring bank transaction flow, wherein an ERP system automatically acquires the transaction flow of all banks of member units through a background operation program every morning;
the main data configuration module is used for configuring and maintaining an opposite side account of the bank account fund collection in the ERP system by the capital department of member units;
the deleted fund collection pipelining module is used for executing a program for creating a fund collection certificate in an ERP system by a financial department of a member company and deleting the deleted fund collection pipelining;
and the fund collection flow posting module is used for transferring the actual balance of the bank account to a virtual account set by the financial company for fund collection flow posting by the member unit.
Preferably, the providing interface module includes:
the system comprises a bank account information acquisition unit, a financial company and a financial company management unit, wherein the bank account information acquisition unit is used for acquiring the bank account information signed by a member company and the financial company, and the bank account information is maintained in an ERP system by a fund department of the member company;
the ERP account acquisition unit is used for acquiring an ERP account of bank account information which is queried by a permission, and the ERP account is maintained in an ERP system by a capital department of a member company;
the account password obtaining unit is used for obtaining an account and a password of a financial company system corresponding to the ERP account with the inquiry authority, carrying out MD5 encryption processing on the password, and maintaining the account password information in the ERP system by a member company capital department;
the polling assembly unit is used for polling information of each bank account, acquiring a corresponding account number and a password of the financial company and assembling the account number and the password into an XML message meeting the interface requirement of the financial company system;
and the analysis unit is used for analyzing the message returned by the financial company and storing the analyzed data into a data table ZTZHMX, wherein the data table ZTZHMX comprises a bank receipt number, a self account name, an opposite side account number, an opposite side account name, an opposite side account opening name, an execution date, a rest date, a transaction generation amount, a transaction direction, a transaction generation time and a remark.
Preferably, the sorted fund collection pipelining module includes:
an input unit configured to input a selection condition including a company code and an aggregation date;
the selecting unit is used for selecting the bank account transaction running water meeting the selection condition from the data table ZTZHMX;
and the judging unit is used for judging that the transaction flow is the fund collection transaction flow if the account information of the opposite party in the bank account transaction flow is the fund collection account number of the financial company configured in the ERP system by the member unit fund department and the transaction direction is payment.
Preferably, the fund collection flow posting module comprises:
the determining unit is used for determining a virtual bank account of the member company in the ERP system;
the posting unit is used for gathering and posting the funds, and posting and entry includes borrowing: a financial company virtual account; loan: a bank running account;
and the updating unit is used for updating the POST posting mark in the data table ZTZHMXHX after posting is successful, and no automatic posting is executed.
An electronic device comprising a memory and a processor, the memory for storing one or more computer instructions, wherein the one or more computer instructions are executed by the processor to implement a method of application of funds aggregation automatic posting as described in any of the above.
A computer-readable storage medium having stored thereon a computer program for causing a computer to implement, when executed, a method of applying funds collection automatic posting as claimed in any one of the preceding claims.
The invention has the following beneficial effects:
the invention provides an application method of automatic posting of fund collection, wherein a member ERP obtains transaction running water of a bank account through a financial enterprise interface program provided by a financial company, an ERP system deletes the fund collection running water meeting conditions according to the transaction running water, and the ERP system automatically posts the fund collection running water aiming at the running water, thereby liberating a large amount of manpower and material resources and simultaneously reducing the probability of errors caused by human factors.
Drawings
FIG. 1 is a flowchart of an application method for implementing automatic posting of fund collections according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Before the technical solution of the present invention is introduced, a scenario to which the technical solution of the present invention may be applicable is exemplarily described.
The following are exemplary: in order to enhance the centralized management of enterprise group funds and improve the use efficiency of the enterprise group funds, a group financial company is established at a dispute by a contemporary large-scale group company, in the actual operation process, some bank accounts of member units are all provided with automatic fund collection services, the funds of the bank accounts are collected into the accounts of the group financial company, the member units are used for ensuring the accuracy of the balance of the bank accounts of the ERP system, the automatic collection services are manually booked into the financial system of the ERP every day, the large-scale enterprise group has a plurality of member units and a plurality of bank accounts of the member units, the online banking system of each bank is required to inquire the assembly line of the funds, financial vouchers are input into the ERP system in one stroke, a large amount of manpower and material resources are wasted, and meanwhile, the probability of errors caused by human factors is increased.
Example 1
As shown in fig. 1, an application method of fund collection automatic posting includes the following steps:
s100, the group financial company provides an interface for inquiring bank transaction flow, and the ERP system automatically acquires the transaction flow of all banks of the member unit through a background operation program every day;
s110, a member unit fund department configures and maintains an opposite side account of a bank account fund collection in an ERP system;
s120, the finance department of the member company executes a program for creating a fund collection voucher in the ERP system and deletes a fund collection assembly line;
s130, transferring the actual balance of the bank account to a virtual account opened by a financial company by the member unit to carry out fund collection and flow accounting.
According to the embodiment 1, the ERP system of the member unit acquires the transaction flow of the bank account through a financial enterprise interface program provided by a financial company, the ERP system deletes the fund collection flow meeting the conditions according to the transaction flow, and the ERP system automatically posts the fund collection flow aiming at the flow.
Example 2
An application method of fund collection automatic posting comprises the following steps:
acquiring the information of a bank account signed by a member company and a financial company, and maintaining the information of the bank account in an ERP system by a fund department of the member company;
acquiring an ERP account of bank account information with authority query, and maintaining the ERP account in an ERP system by a capital department of a member company;
acquiring an account and a password of a financial company system corresponding to the ERP account with the inquiry authority, carrying out MD5 encryption processing on the password, and maintaining the account password information in the ERP system by a member company capital department;
polling each piece of bank account information, acquiring a corresponding account number and a password of the financial company, and assembling into an XML message meeting the system interface requirement of the financial company;
analyzing a message returned by a financial company and storing the analyzed data into a data table ZTZHMX, wherein the data table ZTZTZH comprises a bank receipt number, a self account name, an opposite side account number, an opposite side account name, an opposite side account opening row name, an execution date, a rest date, a transaction generation amount, a transaction direction, transaction generation time and remarks;
the member unit fund department configures and maintains an opposite side account of the bank account fund collection in the ERP system;
the financial department of the member company executes a program for creating a fund collection voucher in an ERP system and deletes a fund collection assembly line;
and the member unit transfers the actual balance of the bank account to a virtual account opened by the financial company for fund collection and flow posting.
Illustratively, a group financial company provides an interface for inquiring the transaction flow of banks, an ERP system automatically acquires the transaction flow of all the banks of a member unit through a background operation program every morning, maintained bank account information comprises a company code, an account opening bank and a bank account number, maintained account number content comprises the company code, the ERP account number and inquiry authority, and maintained account number and password content comprises the company code, the ERP account number, a financial company system account number and a financial company system password.
According to the embodiment 2, the external interface for inquiring the bank transaction flow is provided by the group finance company, the ERP system automatically acquires the transaction flow of all banks of member units through the background operation program every morning, the fund collection automatic posting is realized, a large amount of manpower and material resources can be liberated, and the probability of errors caused by human factors is reduced.
Example 3
An application method of fund collection automatic posting comprises the following steps:
the group financial company provides an interface for inquiring the bank transaction flow, and the ERP system automatically acquires the transaction flow of all the banks of the member unit through a background operation program every day;
the member unit fund department configures and maintains an opposite side account of the bank account fund collection in the ERP system;
inputting a selection condition, wherein the selection condition comprises a company code and an aggregation date;
selecting a bank account transaction running line meeting the selection condition from the data table ZTZHMX;
if the counter side account information in the bank account transaction flow is a financial company fund collection account number configured in the ERP system by the member unit fund department and the transaction direction is payment, the transaction flow is determined to be a fund collection transaction flow;
and the member unit transfers the actual balance of the bank account to a virtual account opened by the financial company for fund collection and flow posting.
As can be seen from the embodiment 3, the automatic posting of the fund collection service is realized, a large amount of manpower and material resources can be liberated, and the probability of errors caused by human factors is reduced.
Example 4
An application system for automatic posting of fund collections comprises the following steps:
the group financial company provides an interface for inquiring the bank transaction flow, and the ERP system automatically acquires the transaction flow of all the banks of the member unit through a background operation program every day;
the member unit fund department configures and maintains an opposite side account of the bank account fund collection in the ERP system;
the financial department of the member company executes a program for creating a fund collection voucher in an ERP system and deletes a fund collection assembly line;
determining a virtual bank account of a member company in the ERP system;
collecting and flowing the funds for posting, wherein posting and entry comprises borrowing: a financial company virtual account; loan: a bank running account;
and after the posting is successful, updating a POST posting mark in the data table ZTZHMX, and not executing automatic posting.
Illustratively, member units open virtual accounts in a financial company, bank accounts with a national bank number of MIFC0000001 are set as financial company virtual accounts by default, the accounts cannot be used for business, the virtual accounts are used for carrying out bank account fund transfer in the company in an ERP system, and in fund collection and accounting, the member units need to transfer actual bank account balance to the virtual accounts, and fund collection does not affect the total bank account balance of the member units in the ERP system.
Embodiment 4 shows that the invention realizes automatic posting of the fund collection service, liberates a large amount of manpower and material resources, and reduces the probability of errors caused by human factors.
Example 5
An application apparatus for automatic posting of collected funds, comprising:
providing an interface module for a group financial company to provide an interface for inquiring bank transaction flow, wherein an ERP system automatically acquires the transaction flow of all banks of member units through a background operation program every morning;
the main data configuration module is used for configuring and maintaining an opposite side account of the bank account fund collection in the ERP system by the capital department of member units;
the deleted fund collection pipelining module is used for executing a program for creating a fund collection certificate in an ERP system by a financial department of a member company and deleting the deleted fund collection pipelining;
and the fund collection flow posting module is used for transferring the actual balance of the bank account to a virtual account set by the financial company for fund collection flow posting by the member unit.
An optional implementation mode is that an interface module is provided for a group finance company to provide an interface for inquiring bank transaction flow, an ERP system automatically acquires transaction flow of all banks of member units through background operation programs every morning, a main data configuration module configures counter accounts of bank account fund collection of member unit fund departments in the ERP system and maintains the counter accounts, a deleted fund collection flow module executes a program for creating fund collection certificates in the ERP system through the member company finance departments and deletes fund collection flow, and a fund collection flow passing module transfers actual bank account balance to a virtual account set up by the finance company through the member units to carry out fund collection flow passing.
Example 6
An application apparatus for automatic posting of collected funds, comprising:
the system comprises a bank account information acquisition unit, a financial company and a financial company management unit, wherein the bank account information acquisition unit is used for acquiring the bank account information signed by a member company and the financial company, and the bank account information is maintained in an ERP system by a fund department of the member company;
the ERP account acquisition unit is used for acquiring an ERP account of bank account information which is queried by a permission, and the ERP account is maintained in an ERP system by a capital department of a member company;
the account password obtaining unit is used for obtaining an account and a password of a financial company system corresponding to the ERP account with the inquiry authority, carrying out MD5 encryption processing on the password, and maintaining the account password information in the ERP system by a member company capital department;
the polling assembly unit is used for polling information of each bank account, acquiring a corresponding account number and a password of the financial company and assembling the account number and the password into an XML message meeting the interface requirement of the financial company system;
the system comprises an analysis unit, a data table ZTZHMX, a data processing unit and a data processing unit, wherein the analysis unit is used for analyzing a message returned by a financial company and storing the analyzed data into the data table ZTZTZTZHMX, and the data table ZTZTZHMX comprises a bank receipt number, a self account name, an opposite side account number, an opposite side account name, an opposite side account opening name, an execution date, a rest date, a transaction generation amount, a transaction direction, a transaction generation time and a remark;
the main data configuration module is used for configuring and maintaining an opposite side account of the bank account fund collection in the ERP system by the capital department of member units;
the deleted fund collection pipelining module is used for executing a program for creating a fund collection certificate in an ERP system by a financial department of a member company and deleting the deleted fund collection pipelining;
and the fund collection flow posting module is used for transferring the actual balance of the bank account to a virtual account set by the financial company for fund collection flow posting by the member unit.
An alternative implementation mode is that a bank account information unit is obtained to obtain bank account information signed by a member company and a financial company, a capital department of the member company maintains the bank account information in an ERP system, an ERP account unit is obtained to obtain an ERP account of the bank account information which is queried by the ERP account unit, the capital department of the member company maintains the ERP account in the ERP system, an account password unit is obtained to obtain an account and a password of the financial company system corresponding to the ERP account which is queried by the ERP account unit, the password is encrypted by MD5, the account password information is maintained in the ERP system by the capital department of the member company, a polling assembly unit polls each piece of bank account information, obtains the corresponding financial company account and password, assembles the information into an XML message which meets the interface requirement of the financial company, an analysis unit analyzes the message returned by the financial company and stores the analyzed data into a data table ZTZHMX, the data table ZTTZHMX comprises a bank receipt number, a bank account name, an opposite account number, an opposite account name, an opposite account opening row name, an execution date, a starting date, a transaction occurrence amount, a transaction direction, a transaction occurrence time and remarks, a main data configuration module configures an opposite account of a bank account fund collection of a member unit fund department in an ERP system and maintains the opposite account, a deleted fund collection pipelining module executes a program for creating a fund collection certificate and deletes fund collection pipelining in the ERP system through the member company financial department, and a fund collection pipelining module transfers actual bank account balance to a virtual account set by a financial company through a member unit to perform fund collection pipelining.
Example 7
An application apparatus for automatic posting of collected funds, comprising:
providing an interface module for a group financial company to provide an interface for inquiring bank transaction flow, wherein an ERP system automatically acquires the transaction flow of all banks of member units through a background operation program every morning;
the main data configuration module is used for configuring and maintaining an opposite side account of the bank account fund collection in the ERP system by the capital department of member units;
an input unit configured to input a selection condition including a company code and an aggregation date;
the selecting unit is used for selecting the bank account transaction running water meeting the selection condition from the data table ZTZHMX;
the judging unit is used for judging that the transaction flow is a fund collection transaction flow if the account information of the opposite party in the bank account transaction flow is a financial company fund collection account number configured in an ERP system by a member unit fund department and the transaction direction is payment;
and the fund collection flow posting module is used for transferring the actual balance of the bank account to a virtual account set by the financial company for fund collection flow posting by the member unit.
An optional implementation mode is that an interface module is provided for a group financial company to provide an interface for inquiring bank transaction flow, an ERP system automatically acquires transaction flow of all banks of member units through a background operation program every morning, a main data configuration module configures counter accounts of bank account fund collection of member unit fund departments in the ERP system and maintains the counter accounts, an input unit inputs selection conditions, the selection conditions comprise company codes and collection dates, the selection unit selects bank account transaction flow meeting the selection conditions from a data table ZTZZZHMX, a judgment unit judges that if counter account information in the bank account transaction flow is a financial company fund collection account number configured by the member unit fund departments in the ERP system and the transaction direction is payment, the transaction flow is fund collection transaction flow, and an actual bank account balance is transferred to a virtual account set by the financial company through a member unit to perform fund collection flow And (5) posting water.
Example 8
An application apparatus for automatic posting of collected funds, comprising:
providing an interface module for a group financial company to provide an interface for inquiring bank transaction flow, wherein an ERP system automatically acquires the transaction flow of all banks of member units through a background operation program every morning;
the main data configuration module is used for configuring and maintaining an opposite side account of the bank account fund collection in the ERP system by the capital department of member units;
the deleted fund collection pipelining module is used for executing a program for creating a fund collection certificate in an ERP system by a financial department of a member company and deleting the deleted fund collection pipelining;
the determining unit is used for determining a virtual bank account of the member company in the ERP system;
the posting unit is used for gathering and posting the funds, and posting and entry includes borrowing: a financial company virtual account; loan: a bank running account;
and the updating unit is used for updating the POST posting mark in the data table ZTZHMXHX after posting is successful, and no automatic posting is executed.
An alternative implementation mode is that an interface module is provided to provide an interface for a group finance company to inquire bank transaction flow, an ERP system automatically obtains the transaction flow of all banks of member units through a background operation program every morning, a main data configuration module configures counter accounts of bank account fund collection of member unit fund departments in the ERP system and maintains the counter accounts, a deleted fund collection flow module executes a program for creating fund collection certificates in the ERP system through the member company finance departments and deletes fund collection flow, a determination unit determines virtual bank accounts of the member companies in the ERP system, an posting unit posts the fund collection flow, and posting and entry includes borrowing: a financial company virtual account; loan: and the updating unit updates the POST posting mark in the data table ZTZHMX after successful posting of the bank running account, and does not execute automatic posting.
Example 9
An electronic device comprising a memory and a processor, the memory storing one or more computer instructions, wherein the one or more computer instructions are executed by the processor to implement a method of applying funds aggregation automatic posting as described above.
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working process of the electronic device described above may refer to the corresponding process in the foregoing method embodiment, and is not described herein again.
A computer-readable storage medium storing a computer program which, when executed, causes a computer to implement a method of applying funds collection automatic posting as described above.
Illustratively, a computer program may be partitioned into one or more modules/units, which are stored in a memory and executed by a processor to implement the present invention. One or more modules/units may be a series of computer program instruction segments capable of performing certain functions, the instruction segments being used to describe the execution of a computer program in a computer device.
The computer device may be a desktop computer, a notebook, a palm computer, a cloud server, or other computing devices. The computer device may include, but is not limited to, a memory, a processor. Those skilled in the art will appreciate that the present embodiments are merely exemplary of a computing device and are not intended to limit the computing device, and may include more or fewer components, or some of the components may be combined, or different components, e.g., the computing device may also include input output devices, network access devices, buses, etc.
The processor may be a Central Processing Unit (CPU), other general purpose processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf programmable gate array (FPGA) or other programmable logic device, discrete gate or transistor logic, discrete hardware components, etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The storage may be an internal storage unit of the computer device, such as a hard disk or a memory of the computer device. The memory may also be an external storage device of the computer device, such as a plug-in hard disk provided on the computer device, a Smart Memory Card (SMC), a Secure Digital (SD) card, a flash card (FlashCard), and the like. Further, the memory may also include both internal and external storage units of the computer device. The memory is used for storing computer programs and other programs and data required by the computer device. The memory may also be used to temporarily store data that has been output or is to be output.
The above description is only an embodiment of the present invention, but the technical features of the present invention are not limited thereto, and any changes or modifications within the technical field of the present invention by those skilled in the art are covered by the claims of the present invention.
Claims (10)
1. An application method of fund collection automatic posting is characterized by comprising the following steps:
the group financial company provides an interface for inquiring the bank transaction flow, and the ERP system automatically acquires the transaction flow of all the banks of the member unit through a background operation program every day;
the member unit fund department configures and maintains an opposite side account of the bank account fund collection in the ERP system;
the financial department of the member company executes a program for creating a fund collection voucher in an ERP system and deletes a fund collection assembly line;
and the member unit transfers the actual balance of the bank account to a virtual account opened by the financial company for fund collection and flow posting.
2. The method as claimed in claim 1, wherein the corporate finance company provides an interface for querying transaction flow of banks, and the ERP system automatically obtains the transaction flow of all the banks of the member unit through a background process every morning comprises:
acquiring the information of a bank account signed by a member company and a financial company, and maintaining the information of the bank account in an ERP system by a fund department of the member company;
acquiring an ERP account of bank account information with authority query, and maintaining the ERP account in an ERP system by a capital department of a member company;
acquiring an account and a password of a financial company system corresponding to the ERP account with the inquiry authority, carrying out MD5 encryption processing on the password, and maintaining the account password information in the ERP system by a member company capital department;
polling each piece of bank account information, acquiring a corresponding account number and a password of the financial company, and assembling into an XML message meeting the system interface requirement of the financial company;
analyzing the message returned by the financial company and storing the analyzed data into a data table ZTZHMX, wherein the data table ZTZTZH comprises a bank receipt number, a self account name, an opposite side account number, an opposite side account name, an opposite side account opening row name, an execution date, a rest date, a transaction generation amount, a transaction direction, a transaction generation time and a remark.
3. The method as claimed in claim 1, wherein the step of executing the procedure of creating the fund collection voucher and deleting the fund collection flow in the ERP system by the finance department of the member company comprises:
inputting a selection condition, wherein the selection condition comprises a company code and an aggregation date;
selecting a bank account transaction running line meeting the selection condition from the data table ZTZHMX;
and if the counter side account information in the bank account transaction flow is a financial company fund collection account number configured in the ERP system by the member unit fund department and the transaction direction is payment, determining that the transaction flow is a fund collection transaction flow.
4. The method as claimed in claim 1, wherein the step of transferring the balance of the bank account to the virtual account opened by the finance company for fund collection and flow posting by the member unit comprises:
determining a virtual bank account of a member company in the ERP system;
collecting and flowing the funds for posting, wherein posting and entry comprises borrowing: a financial company virtual account; loan: a bank running account;
and after the posting is successful, updating a POST posting mark in the data table ZTZHMX, and not executing automatic posting.
5. An apparatus for applying funds collection automatic posting, comprising:
providing an interface module for a group financial company to provide an interface for inquiring bank transaction flow, wherein an ERP system automatically acquires the transaction flow of all banks of member units through a background operation program every morning;
the main data configuration module is used for configuring and maintaining an opposite side account of the bank account fund collection in the ERP system by the capital department of member units;
the deleted fund collection pipelining module is used for executing a program for creating a fund collection certificate in an ERP system by a financial department of a member company and deleting the deleted fund collection pipelining;
and the fund collection flow posting module is used for transferring the actual balance of the bank account to a virtual account set by the financial company for fund collection flow posting by the member unit.
6. The apparatus as claimed in claim 5, wherein the interface module comprises:
the system comprises a bank account information acquisition unit, a financial company and a financial company management unit, wherein the bank account information acquisition unit is used for acquiring the bank account information signed by a member company and the financial company, and the bank account information is maintained in an ERP system by a fund department of the member company;
the ERP account acquisition unit is used for acquiring an ERP account of bank account information which is queried by a permission, and the ERP account is maintained in an ERP system by a capital department of a member company;
the account password obtaining unit is used for obtaining an account and a password of a financial company system corresponding to the ERP account with the inquiry authority, carrying out MD5 encryption processing on the password, and maintaining the account password information in the ERP system by a member company capital department;
the polling assembly unit is used for polling information of each bank account, acquiring a corresponding account number and a password of the financial company and assembling the account number and the password into an XML message meeting the interface requirement of the financial company system;
and the analysis unit is used for analyzing the message returned by the financial company and storing the analyzed data into a data table ZTZHMX, wherein the data table ZTZHMX comprises a bank receipt number, a self account name, an opposite side account number, an opposite side account name, an opposite side account opening name, an execution date, a rest date, a transaction generation amount, a transaction direction, a transaction generation time and a remark.
7. The apparatus as claimed in claim 5, wherein the deleted funds collection pipeline module comprises:
an input unit configured to input a selection condition including a company code and an aggregation date;
the selecting unit is used for selecting the bank account transaction running water meeting the selection condition from the data table ZTZHMX;
and the judging unit is used for judging that the transaction flow is the fund collection transaction flow if the account information of the opposite party in the bank account transaction flow is the fund collection account number of the financial company configured in the ERP system by the member unit fund department and the transaction direction is payment.
8. The apparatus of claim 5, wherein the fund collection flow posting module comprises:
the determining unit is used for determining a virtual bank account of the member company in the ERP system;
the posting unit is used for gathering and posting the funds, and posting and entry includes borrowing: a financial company virtual account; loan: a bank running account;
and the updating unit is used for updating the POST posting mark in the data table ZTZHMXHX after posting is successful, and no automatic posting is executed.
9. An electronic device comprising a memory and a processor, the memory configured to store one or more computer instructions, wherein the one or more computer instructions are executable by the processor to implement a method of fund collection automatic posting according to any one of claims 1-4.
10. A computer-readable storage medium storing a computer program, the computer program causing a computer to implement a method of applying funds collection automatic posting according to any one of claims 1 to 4 when executed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911385142.3A CN111161048B (en) | 2019-12-28 | 2019-12-28 | Application method and device for automatic posting of fund collection |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911385142.3A CN111161048B (en) | 2019-12-28 | 2019-12-28 | Application method and device for automatic posting of fund collection |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111161048A true CN111161048A (en) | 2020-05-15 |
| CN111161048B CN111161048B (en) | 2021-07-09 |
Family
ID=70558782
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911385142.3A Active CN111161048B (en) | 2019-12-28 | 2019-12-28 | Application method and device for automatic posting of fund collection |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111161048B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101877107A (en) * | 2010-04-08 | 2010-11-03 | 苏州德融嘉信信用管理技术有限公司 | Conglomerate founds collecting service system and application method thereof |
| CN101908179A (en) * | 2010-08-17 | 2010-12-08 | 中国建设银行股份有限公司 | Inter-bank capital account collection management method |
| CN102156944A (en) * | 2010-02-11 | 2011-08-17 | 中国工商银行股份有限公司 | Data processing method and system for realizing bank-enterprise interconnection |
| US20120047051A1 (en) * | 2010-08-19 | 2012-02-23 | Yao-Huai Chien | Automated centralized settlement system |
| CN102446335A (en) * | 2010-10-12 | 2012-05-09 | 金蝶软件（中国）有限公司 | Capital allocation method and system |
-
2019
- 2019-12-28 CN CN201911385142.3A patent/CN111161048B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102156944A (en) * | 2010-02-11 | 2011-08-17 | 中国工商银行股份有限公司 | Data processing method and system for realizing bank-enterprise interconnection |
| CN101877107A (en) * | 2010-04-08 | 2010-11-03 | 苏州德融嘉信信用管理技术有限公司 | Conglomerate founds collecting service system and application method thereof |
| CN101908179A (en) * | 2010-08-17 | 2010-12-08 | 中国建设银行股份有限公司 | Inter-bank capital account collection management method |
| US20120047051A1 (en) * | 2010-08-19 | 2012-02-23 | Yao-Huai Chien | Automated centralized settlement system |
| CN102446335A (en) * | 2010-10-12 | 2012-05-09 | 金蝶软件（中国）有限公司 | Capital allocation method and system |
Non-Patent Citations (4)
| Title |
|---|
| 孙水晶: "集团企业资金管理模式及方案设计研究", 《中国优秀硕士学位论文全文数据库 经济与管理科学辑》 * |
| 孙泉辉: "ERP助阵资金集中管理 ", 《电力信息化》 * |
| 屈红梅: "关于集团公司使用ERP系统管理资金的研究", 《中国优秀硕士学位论文全文数据库 经济与管理科学辑》 * |
| 王静: "ERP系统资金管理平台下的银企直联业务", 《石油知识》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111161048B (en) | 2021-07-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110263024B (en) | Data processing method, terminal device and computer storage medium | |
| US11663592B2 (en) | Automatic transaction-based verification of account ownership | |
| US7523068B2 (en) | Centralized payment processing system | |
| US10192206B2 (en) | Method and system for integrating discrete invoices into a personal financial management and bill payment system and then aggregating discrete invoices having the same payor user and the same payee business into a single payment due item for processing | |
| WO2019019447A1 (en) | Annuity data processing method and device, server and storage medium | |
| WO2019192092A1 (en) | Data processing method and apparatus, terminal device, and storage medium | |
| CN107528912A (en) | A kind of automatic method, system and relevant apparatus for realizing distributing real time system | |
| CN108830715A (en) | Disk processing method and system are returned in batch documents part | |
| CN110942392A (en) | Service data processing method, device, equipment and medium | |
| US20170316474A1 (en) | Method and system for providing invoices generated through a business invoicing system to a customer user of a personal financial management and bill payment system | |
| CN113298446A (en) | Financial insurance business process automatic management control system and application | |
| CN113570468A (en) | Enterprise payment wind control service platform | |
| CN109299913A (en) | Employee's wages scheme generation method and device | |
| US20180032978A1 (en) | Method and system for integrating discrete invoices into a personal financial management and bill payment system and then aggregating discrete invoices having the same payee business into a single payment transfer transaction | |
| US20170316392A1 (en) | Method and system for integrating business invoices into a personal financial management and bill payment system | |
| US20170316475A1 (en) | Method and system for identifying invoices that are paid through a personal financial management and bill payment system | |
| CN112258306B (en) | Account information checking method, device, electronic equipment and storage medium | |
| CN111161048B (en) | Application method and device for automatic posting of fund collection | |
| CN114611859A (en) | Method and system for intelligent recruitment of software platform | |
| CN116993523A (en) | Configurable account checking method, device, equipment and storage medium | |
| CN106910025A (en) | The method and system of big data valuation of enterprise | |
| WO2020006936A1 (en) | Fund management method and apparatus, computer device, and computer-readable storage medium | |
| CN112965986B (en) | Service consistency processing method, device, equipment and storage medium | |
| CN115858489A (en) | Transaction processing method and device based on data migration, computer equipment and medium | |
| US20220383302A1 (en) | Intelligent Distributed Ledger Consent Optimizing Apparatus for Asset Transfer |
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 | ||
| CB02 | Change of applicant information |
Address after: 310006 room 402, No. 56, Huancheng West Road, Xiacheng District, Hangzhou City, Zhejiang Province Applicant after: Products Zhongda Digital Technology Co.,Ltd. Address before: 310006 room 402, No. 56, Huancheng West Road, Xiacheng District, Hangzhou City, Zhejiang Province Applicant before: Zhejiang Products Information Technology Co.,Ltd. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |