CN112258256A - Method and system for processing invoice posting - Google Patents

Method and system for processing invoice posting Download PDF

Info

Publication number
CN112258256A
CN112258256A CN202011140200.9A CN202011140200A CN112258256A CN 112258256 A CN112258256 A CN 112258256A CN 202011140200 A CN202011140200 A CN 202011140200A CN 112258256 A CN112258256 A CN 112258256A
Authority
CN
China
Prior art keywords
invoice
certificate
purchase order
prefabricated
wbs
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
CN202011140200.9A
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.)
State Grid Information and Telecommunication Co Ltd
Beijing China Power Information Technology Co Ltd
Original Assignee
State Grid Information and Telecommunication Co Ltd
Beijing China Power Information Technology Co 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 State Grid Information and Telecommunication Co Ltd, Beijing China Power Information Technology Co Ltd filed Critical State Grid Information and Telecommunication Co Ltd
Priority to CN202011140200.9A priority Critical patent/CN112258256A/en
Publication of CN112258256A publication Critical patent/CN112258256A/en
Pending legal-status Critical Current

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
    • G06Q30/00—Commerce
    • G06Q30/04—Billing or invoicing
    • 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
    • G06Q20/00—Payment architectures, schemes or protocols
    • G06Q20/38—Payment protocols; Details thereof
    • G06Q20/382—Payment protocols; Details thereof insuring higher security of transaction

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Accounting & Taxation (AREA)
  • General Physics & Mathematics (AREA)
  • Finance (AREA)
  • Strategic Management (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • Development Economics (AREA)
  • Theoretical Computer Science (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • Computer Security & Cryptography (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention provides a method and a system for processing invoice posting, wherein the method comprises the following steps: constructing an invoice ledger; filling invoice information corresponding to the purchase order in an MIR7 transaction by using an invoice ledger; inquiring a WBS number corresponding to the purchase order, and determining a tax code of the prefabricated invoice certificate by using the WBS number and the tax rate; inquiring the project name corresponding to the purchase order by using the WBS number, and forming text information of the prefabricated invoice certificate by using the project name and the supplier name of the invoice ledger; comparing the invoice information with the invoice account, and finally generating a prefabricated invoice certificate after error is avoided; filling in the bill number of the pre-made invoice certificate in an MIR6 affair; and checking the prefabricated invoice certificate by using the invoice account book, performing account posting processing on the prefabricated invoice certificate after error is checked, and recording an appointed accounting certificate number in the invoice account book. The invoices are not required to be posted by a large amount of time, the invoice posting processing efficiency is improved, and the error rate of the invoice posting processing is reduced.

Description

Method and system for processing invoice posting
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a system for processing invoice posting.
Background
In the operation process of an enterprise, a large batch of invoices are usually received, and in order to ensure the normal operation of the enterprise, the received invoices need to be subjected to posting processing.
The current mode of posting the invoice is as follows: the business personnel inputs the contents of business data, invoice bill data and the like in the invoice processing system, and then the financial personnel checks the original invoice, the system financial account and the business account of the invoice and checks detailed data line by line, and the invoice is checked out only after the invoice is checked to be correct. However, for a large batch of invoices, business personnel and financial personnel need to spend a large amount of time to posting the invoices, the work content is complicated and repeated, misoperation is easy to occur, and the posting processing efficiency of the invoices is low and the error rate is high.
Disclosure of Invention
In view of this, embodiments of the present invention provide a method and a system for processing invoice posting, so as to solve the problems of low efficiency, high error rate, and the like in the current invoice posting processing manner.
In order to achieve the above purpose, the embodiments of the present invention provide the following technical solutions:
the first aspect of the embodiment of the invention discloses a method for processing invoice posting, which comprises the following steps:
constructing an invoice ledger according to invoice data of the purchase order;
utilizing the invoice ledger to fill invoice information corresponding to the purchase order in invoice certificate prefabrication MIR7 affairs in an enterprise energy planning system SAP-ERP, wherein the invoice information comprises money, tax amount, tax item and tax rate;
inquiring a work breakdown structure WBS number corresponding to the purchase order, and determining a tax code of the prefabricated invoice certificate by using the WBS number and the tax rate;
inquiring the project name corresponding to the purchase order by using the WBS number, and forming text information of the prefabricated invoice certificate by using the project name and the supplier name of the invoice ledger;
comparing the invoice information with the invoice ledger, and finally generating the prefabricated invoice certificate after error is avoided;
filling the number of the documents of the prefabricated invoice certificate in an invoice verification MIR6 transaction of the SAP-ERP;
and checking the prefabricated invoice certificate by using the invoice standing book, performing posting processing on the prefabricated invoice certificate after error is checked, and recording an appointed accounting certificate number in the invoice standing book.
Preferably, the querying a work breakdown structure WBS number corresponding to the purchase order, and determining a tax code of the prefabricated invoice certificate by using the WBS number and the tax rate includes:
acquiring a purchase order number corresponding to the purchase order;
querying a detail page of the purchase order after utilizing the purchase order;
querying a work breakdown structure WBS number from the detail page;
and determining the tax code of the prefabricated invoice certificate by combining the WBS number and the tax rate by utilizing a preset WBS number coding rule.
Preferably, the querying, by using the WBS number, an item name corresponding to the purchase order, and forming text information of the pre-made invoice certificate by using the item name and a provider name of the invoice ledger includes:
inquiring the item name corresponding to the purchase order by using the WBS number;
making a money hanging combination according to the project name and the supplier name of the invoice standing book;
and constructing the text information of the prefabricated invoice certificate by using the information after the hung money combination.
Preferably, after recording the designated accounting document number in the invoice ledger, the method further comprises:
and in the SAP-ERP voucher printing zrfm005n transaction, generating a voucher serial number of the pre-made invoice voucher after posting, and printing the voucher of the pre-made invoice after posting by using the accounting voucher number.
Preferably, after recording the designated accounting document number in the invoice ledger, the method further comprises:
in a business evidence electronic system, inquiring corresponding invoice items according to the invoice number and the invoice code information of the invoice standing book;
and performing invoice authentication on the invoice corresponding to the invoice entry.
The second aspect of the embodiment of the invention discloses a system for processing invoice posting, which comprises:
the building unit is used for building an invoice ledger according to invoice data of the purchase order;
the first filling unit is used for filling invoice information corresponding to the purchase order in an invoice certificate prefabrication MIR7 transaction in an enterprise energy planning system SAP-ERP by using the invoice standing book, wherein the invoice information comprises money, tax amount, tax item and tax rate;
the first processing unit is used for inquiring a work breakdown structure WBS number corresponding to the purchase order and determining a tax code of the prefabricated invoice certificate by using the WBS number and the tax rate;
the second processing unit is used for inquiring the project name corresponding to the purchase order by using the WBS number and forming the text information of the prefabricated invoice certificate by using the project name and the supplier name of the invoice ledger;
the generating unit is used for comparing the invoice information with the invoice ledger and finally generating the prefabricated invoice certificate after the comparison is error-free;
the second filling unit is used for filling the number of the documents of the prefabricated invoice certificate in an invoice verification MIR6 transaction of the SAP-ERP;
and the third processing unit is used for checking the prefabricated invoice certificate by using the invoice ledger, performing posting processing on the prefabricated invoice certificate after error is checked, and recording an appointed accounting certificate number in the invoice ledger.
Preferably, the first processing unit includes:
the acquisition module is used for acquiring a purchase order number corresponding to the purchase order;
the first query module is used for querying a detail page of the purchase order after the purchase order is utilized;
the second query module is used for querying a work breakdown structure WBS number from the detail page;
and the determining module is used for determining the tax code of the prefabricated invoice certificate by combining the WBS number and the tax rate according to the preset WBS number coding rule.
Preferably, the second processing unit includes:
the query module is used for querying the item name corresponding to the purchase order by using the WBS number;
the combination module is used for carrying out money hanging combination according to the project name and the supplier name of the invoice standing book;
and the construction module is used for constructing the text information of the prefabricated invoice certificate by using the information after the money hanging combination.
Preferably, the method further comprises the following steps:
and the printing unit is used for generating a voucher serial number of the pre-made invoice voucher after posting in the voucher printing zrfm005n transaction of the SAP-ERP, and printing the voucher of the pre-made invoice voucher after posting by using the accounting voucher number.
Preferably, the method further comprises the following steps:
and the authentication unit is used for inquiring corresponding invoice items according to the invoice number and the invoice code information of the invoice ledger in a business evidence electronic system and performing invoice authentication on invoices corresponding to the invoice items.
Based on the method and the system for processing invoice posting provided by the embodiment of the invention, the method comprises the following steps: constructing an invoice ledger according to invoice data of the purchase order; filling invoice information corresponding to the purchase order in an MIR7 transaction in SAP-ERP by using an invoice ledger; inquiring a WBS number corresponding to the purchase order, and determining a tax code of the prefabricated invoice certificate by using the WBS number and the tax rate; inquiring the project name corresponding to the purchase order by using the WBS number, and forming text information of the prefabricated invoice certificate by using the project name and the supplier name of the invoice ledger; comparing the invoice information with the invoice account, and finally generating a prefabricated invoice certificate after error is avoided; filling the number of the documents of the pre-made invoice certificate in MIR6 affairs of SAP-ERP; and checking the prefabricated invoice certificate by using the invoice account book, performing account posting processing on the prefabricated invoice certificate after error is checked, and recording an appointed accounting certificate number in the invoice account book. The invoices are not required to be posted by a large amount of time, the invoice posting processing efficiency is improved, and the error rate of the invoice posting processing is reduced.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
FIG. 1 is a flow chart of a method for processing invoice posting provided by an embodiment of the invention;
FIG. 2 is a flow chart of determining the tax code of a pre-manufactured invoice slip, provided by an embodiment of the invention;
FIG. 3 is a flow chart of determining textual information for a pre-made invoice slip provided by an embodiment of the present invention;
fig. 4 is a block diagram of a system for processing invoice posting 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 drawings in the embodiments of the present invention, 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.
In this application, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
As known in the background art, an enterprise needs to perform posting processing on a received invoice in an operating process, and usually, business personnel and financial personnel manually perform posting processing on the invoice respectively. However, for a large batch of invoices, business personnel and financial personnel need to spend a large amount of time to posting the invoices, the work content is complicated and repeated, misoperation is easy to occur, and the posting processing efficiency of the invoices is low and the error rate is high.
Therefore, the embodiment of the invention provides a method and a system for processing invoice posting, which are used for constructing an invoice standing book by using invoice data, filling corresponding invoice information in an invoice certificate prefabrication (MIR7) transaction in an enterprise energy planning system (SAP-ERP), and inquiring a Work Breakdown Structure (WBS) number of a purchase order. The method further includes determining a tax code of the pre-made invoice slip using the WBS number and the tax rate, and querying an item name of the purchase order using the WBS number. And forming text information of the prefabricated invoice certificate by using the project name and the supplier name of the invoice account. And comparing the invoice information with the invoice account, and finally generating a prefabricated invoice certificate after the comparison is correct. In the SAP-ERP invoice verification (MIR6) transaction, the number of sheets of the pre-made invoice voucher is filled out. And checking the prefabricated invoice certificate by using the invoice account book, performing account posting processing on the prefabricated invoice certificate after error is checked, and recording an appointed accounting certificate number in the invoice account book. The invoices are not required to be posted by a large amount of time in a manual work mode, so that the invoice posting processing efficiency is improved, and the error rate of the invoice posting processing is reduced.
Referring to fig. 1, a flowchart of a method for processing invoice posting provided by an embodiment of the present invention is shown, where the method includes:
step S101: and constructing an invoice ledger according to invoice data of the purchase order.
In the process of implementing step S101 specifically, the invoice data of the purchase order is read, and a corresponding invoice ledger is established using the invoice data.
Step S102: and filling invoice information corresponding to the purchase order in an MIR7 transaction in the SAP-ERP by using the invoice ledger.
Note that the invoice information includes amount, tax item and tax rate, and the MIR7 is a transaction code in the SAP-ERP for executing the invoice voucher preparation service.
In the process of implementing step S102 specifically, the SAP-ERP is logged in by using a specified account (account of non-financial staff) and enters into an MIR7 transaction. And in MIR7 affairs in SAP-ERP, filling invoice information such as amount, tax item, tax rate and the like corresponding to the purchase order according to the invoice ledger.
Step S103: and inquiring a WBS number corresponding to the purchase order, and determining the tax code of the prefabricated invoice certificate by using the WBS number and the tax rate.
In the process of implementing step S103 specifically, it can be understood that, in the SAP-ERP, the detail page corresponding to the purchase order is obtained by using the purchase order number corresponding to the purchase order.
And inquiring a WBS number of an item hooked with the purchase order from a detail page of the purchase order, and determining a tax code of the prefabricated invoice certificate corresponding to the purchase order by using the WBS number and the tax rate.
Step S104: and inquiring the project name corresponding to the purchase order by using the WBS number, and forming text information of the prefabricated invoice certificate by using the project name and the supplier name of the invoice ledger.
In the process of implementing step S104, in the SAP-ERP, the item name (also referred to as item text description) corresponding to the purchase order is queried by using the WBS number, and a "hang (supplier name) (item name) money" combination is performed according to the item name and the supplier name of the invoice ledger, so as to form the text information of the pre-made invoice certificate.
Note that the money hanging combination means: and substituting the acquired supplier name and the acquired project name according to a rule for filling in the text information, and combining to generate the text information of the pre-made invoice voucher, such as the electric transmission and transformation project money of the wall-mounted power company Limited.
The text information comprises the head-up of the certificate (the preformed invoice certificate) and the abstract of the certificate (the preformed invoice certificate), and the obtained information formed by combining the name of the supplier and the name of the project is the text information.
It can be understood that the generated text information is the filling item of the invoice certificate preparation business, and the text information is displayed in the certificate head-up and the certificate abstract in the finally generated prepared invoice certificate.
Step S105: and comparing the invoice information with the invoice account, and finally generating a prefabricated invoice certificate after the comparison is correct.
In the process of specifically implementing step S105, the invoice issuing information and the invoice standing book of the prefabricated invoice certificate are compared, for example, the invoice information and the information such as the amount of money, the tax amount, the tax item, and the tax rate in the invoice standing book are compared one by one, that is, the amount of money in the invoice information and the amount of money in the invoice standing book are compared, the tax amount in the invoice information and the tax amount in the invoice standing book are compared, and the information such as the amount of money, the tax amount, the tax item, and the tax rate in the invoice information and the invoice standing book are compared in the manner described above. And finally generating a prefabricated invoice certificate after the comparison is correct, and recording the invoice certificate number of the prefabricated invoice certificate in an invoice ledger.
Step S106: in the MIR6 transaction of SAP-ERP, fill out the number of sheets of the pre-made invoice voucher.
In the process of implementing step S106 specifically, the SAP-ERP is logged in by using a specified account (account of financial staff), and enters into MIR6 transaction. And inquiring the generated prefabricated invoice voucher by using the invoice voucher number recorded in the invoice ledger, and filling the number of the bills in an information column corresponding to the prefabricated invoice voucher, wherein the number of the bills is the number of original bills attached by the prefabricated invoice voucher.
Step S107: and checking the prefabricated invoice certificate by using the invoice account book, performing account posting processing on the prefabricated invoice certificate after error is checked, and recording an appointed accounting certificate number in the invoice account book.
In the process of implementing step S107 specifically, in the MIR6 transaction, the invoice ledger is used to check the information such as the amount of money, the tax amount, the tax item, and the tax rate corresponding to the pre-made invoice certificate (at this time, the MIR7 transaction is not required to be entered), after checking, the pre-made invoice certificate is subjected to posting processing, and the specified accounting certificate number is recorded in the invoice ledger.
It can be understood that after the pre-made invoice certificate is subjected to the posting process, the pre-made invoice certificate subjected to the posting process may need to be printed in the following specific printing manner:
preferably, the SAP-ERP is logged in by using the specified account, the voucher serial number of the pre-made invoice voucher after the posting process is generated in the voucher printing (zrfm005n) transaction of the SAP-ERP, the pre-made invoice voucher after the posting process is inquired by using the accounting voucher number recorded in the invoice ledger, and the voucher printing is carried out.
Preferably, in a specific application, the pre-made invoice certificate after posting needs to be correspondingly authenticated, and in a specific implementation:
logging in a business document electronic system by using a specified account, inquiring corresponding invoice items in an invoice pool according to the invoice number and the invoice code information of an invoice ledger in the business document electronic system, and performing invoice authentication on the invoice corresponding to the inquired invoice items. It will be appreciated that the certification due period for invoice certification defaults to the month (i.e., the current month) during which the certification operation was performed.
In the embodiment of the invention, the invoice ledger is constructed by using invoice data, corresponding invoice information is filled in an MIR7 transaction in SAP-ERP, and the WBS number of the purchase order is inquired. The method further includes determining a tax code of the pre-made invoice slip using the WBS number and the tax rate, and querying an item name of the purchase order using the WBS number. And forming text information of the prefabricated invoice certificate by using the project name and the supplier name of the invoice account. And comparing the invoice information with the invoice account, and finally generating a prefabricated invoice certificate after the comparison is correct. In the MIR6 transaction of SAP-ERP, fill out the number of sheets of the pre-made invoice voucher. And checking the prefabricated invoice certificate by using the invoice account book, performing account posting processing on the prefabricated invoice certificate after error is checked, and recording an appointed accounting certificate number in the invoice account book. The invoices are not required to be posted by a large amount of time, the invoice posting processing efficiency is improved, and the error rate of the invoice posting processing is reduced.
In the above embodiment of the present invention, referring to fig. 2, the process of determining the tax code of the pre-made invoice certificate in step S103 in fig. 1 shows a flowchart of determining the tax code of the pre-made invoice certificate according to the embodiment of the present invention, which includes:
step S201: and acquiring a purchase order number corresponding to the purchase order.
Step S202: the details page of the purchase order is queried after the purchase order is utilized.
In the process of implementing step S202 specifically, in the SAP-ERP, a detail page corresponding to the purchase order is obtained by using the purchase order number corresponding to the purchase order, where the detail page includes a WBS number of the purchase order.
Step S203: the WBS number is queried from the detail page.
Step S204: and determining the tax code of the prefabricated invoice certificate by using a preset WBS number coding rule and combining the WBS number and the tax rate.
It should be noted that the tax code is a code field obtained by combining a tax rate and an entry tax type (general entry tax/fixed asset deductible entry tax), wherein the entry tax type needs to be determined by using a preset WBS number coding rule, that is, a corresponding item type is determined by using the WBS number coding rule and a WBS number, so as to obtain the entry tax type.
In the process of implementing step S204 specifically, the type of the income tax is determined by using the preset WBS number coding rule in combination with the WBS number. And determining the tax code of the prepared invoice certificate by using the type of the income tax and the tax rate, wherein the determined tax code is J9, and J9 indicates that 13% of fixed assets can be covered by the income tax.
It is to be understood that, in order to better explain the above contents regarding WBS number coding rules, the following contents are exemplified, and it is to be noted that the contents of WBS number coding rules shown below are merely for illustration.
WBS number encoding rule:
the initial code is 1, the capital construction project belongs to capital project, and the option of fixed assets can cover the item tax.
The initial code is 2, the technical improvement project belongs to the capital project, and the option of fixed assets can cover the item tax.
The initial code is 3, the small-sized capital construction project belongs to capital project, and the option of fixed assets can be withheld by item tax.
The first code is 4, the major repair project belongs to the cost project, and the common income tax is selected.
The first bit of the code is 5, and the research and development project belongs to the cost project and selects the common income tax.
The first code is 6, the marketing project belongs to capital project, and the option of fixed assets can cover the tax of the project.
The code is 7 at the beginning, contains information items and marketing items, 15 th and 16 th belong to capital items of M1, and the fixed assets are selected to be withheld by item tax; attributes cost category items at positions 15 and 16 of M2, general royalties are selected.
The first bit of the code is 8, which belongs to the cost item, and common income tax is selected.
The first code is 9, which belongs to cost item, and selects common income tax.
The first position of the code is B, which belongs to cost items, and common income tax is selected.
The initial code is C, belonging to capital project, and the option of fixed assets can cover the project tax.
The first position of the code is D, the special project of the city belongs to the cost project, and the common income tax is selected.
The initial code is Y, the retail item belongs to capital items, and the option of fixed assets can cover the item tax.
In the above embodiment of the present invention, referring to fig. 3, the content of the text information composing the pre-made invoice certificate related to step S104 in fig. 1 shows a flowchart for determining the text information of the pre-made invoice certificate provided in the embodiment of the present invention, which includes the following steps:
step S301: and inquiring the item name corresponding to the purchase order by using the WBS number.
In the process of implementing step S301, in the SAP-ERP, the item name corresponding to the purchase order is queried by using the WBS number.
Step S302: and carrying out money hanging combination according to the project name and the supplier name of the invoice account.
In the process of implementing step S302, a "hang (supplier name) (item name) money" combination is performed according to the item name and the supplier name of the invoice ledger, so as to constitute the text information of the pre-prepared invoice certificate. For specific contents of the suspend combination, refer to the contents of step S104 in fig. 1 in the above embodiment of the present invention, and are not described herein again.
Step S303: and constructing text information of the prefabricated invoice certificate by using the information after the hung money combination.
In the process of implementing step S303, the information after the money hanging combination is used as a basis for filling in the text information of the pre-made invoice certificate, so as to construct the text information.
Corresponding to the method for processing invoice posting provided by the embodiment of the present invention, referring to fig. 4, an embodiment of the present invention further provides a structural block diagram of a system for processing invoice posting, where the system includes: a building unit 401, a first filling unit 402, a first processing unit 403, a second processing unit 404, a generating unit 405, a second filling unit 406, and a third processing unit 407;
the building unit 401 is configured to build an invoice ledger according to invoice data of the purchase order.
The first filling unit 402 is configured to fill, in the MIR7 transaction in the SAP-ERP, invoice information corresponding to the purchase order by using an invoice standing book, where the invoice information includes an amount, a tax item, and a tax rate.
The first processing unit 403 is configured to query a WBS number corresponding to the purchase order, and determine a tax code of the pre-made invoice certificate by using the WBS number and the tax rate.
And the second processing unit 404 is configured to query an item name corresponding to the purchase order by using the WBS number, and compose text information of the pre-prepared invoice certificate by using the item name and a supplier name of the invoice ledger.
And the generating unit 405 is used for comparing the invoice information with the invoice ledger and finally generating a prefabricated invoice certificate after the comparison is error-free.
And a second filling unit 406 for filling out the sheet number of the pre-made invoice certificate in MIR6 transaction of SAP-ERP.
And the third processing unit 407 is configured to check the prefabricated invoice certificate by using the invoice ledger, perform posting processing on the prefabricated invoice certificate after checking that there is no error, and record a specified accounting certificate number in the invoice ledger.
In the embodiment of the invention, the invoice ledger is constructed by using invoice data, corresponding invoice information is filled in an MIR7 transaction in SAP-ERP, and the WBS number of the purchase order is inquired. The method further includes determining a tax code of the pre-made invoice slip using the WBS number and the tax rate, and querying an item name of the purchase order using the WBS number. And forming text information of the prefabricated invoice certificate by using the project name and the supplier name of the invoice account. And comparing the invoice information with the invoice account, and finally generating a prefabricated invoice certificate after the comparison is correct. In the MIR6 transaction of SAP-ERP, fill out the number of sheets of the pre-made invoice voucher. And checking the prefabricated invoice certificate by using the invoice account book, performing account posting processing on the prefabricated invoice certificate after error is checked, and recording an appointed accounting certificate number in the invoice account book. The invoices are not required to be posted by a large amount of time, the invoice posting processing efficiency is improved, and the error rate of the invoice posting processing is reduced.
Preferably, in conjunction with the content shown in fig. 4, the first processing unit 403 includes an obtaining module, a first querying module, a second querying module, and a determining module, and the execution principle of each module is as follows:
and the acquisition module is used for acquiring the purchase order number corresponding to the purchase order.
And the first query module is used for querying the detail page of the purchase order after the purchase order is utilized.
And the second query module is used for querying the WBS number from the detail page.
And the determining module is used for determining the tax code of the prefabricated invoice certificate by utilizing a preset WBS number coding rule and combining the WBS number and the tax rate.
Preferably, in conjunction with the content shown in fig. 4, the second processing unit 404 includes a query module, a combination module and a construction module, and the execution principle of each module is as follows:
and the query module is used for querying the item name corresponding to the purchase order by using the WBS number.
And the combination module is used for carrying out money hanging combination according to the project name and the supplier name of the invoice standing book.
And the construction module is used for constructing the text information of the prefabricated invoice certificate by utilizing the information after the money hanging combination.
Preferably, in conjunction with the content shown in fig. 4, the system further comprises:
and the printing unit is used for generating a voucher serial number of the pre-made invoice voucher after the posting process in a zrfm005n transaction of SAP-ERP, and printing the voucher of the pre-made invoice voucher after the posting process by using the accounting voucher number.
Preferably, in conjunction with the content shown in fig. 4, the system further comprises:
and the authentication unit is used for inquiring corresponding invoice items according to the invoice number and the invoice code information of the invoice ledger in the business evidence electronic system and performing invoice authentication on the invoices corresponding to the invoice items.
In summary, the embodiments of the present invention provide a method and a system for processing invoice posting, which construct an invoice posting according to invoice data of a purchase order. And filling invoice information corresponding to the purchase order in an MIR7 transaction in the SAP-ERP by using the invoice ledger. And inquiring a WBS number corresponding to the purchase order, and determining the tax code of the prefabricated invoice certificate by using the WBS number and the tax rate. And inquiring the project name corresponding to the purchase order by using the WBS number, and forming text information of the prefabricated invoice certificate by using the project name and the supplier name of the invoice ledger. And comparing the invoice information with the invoice account, and finally generating a prefabricated invoice certificate after the comparison is correct. In the MIR6 transaction of SAP-ERP, fill out the number of sheets of the pre-made invoice voucher. And checking the prefabricated invoice certificate by using the invoice account book, performing account posting processing on the prefabricated invoice certificate after error is checked, and recording an appointed accounting certificate number in the invoice account book. The invoices are not required to be posted by a large amount of time, the invoice posting processing efficiency is improved, and the error rate of the invoice posting processing is reduced.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, the system or system embodiments are substantially similar to the method embodiments and therefore are described in a relatively simple manner, and reference may be made to some of the descriptions of the method embodiments for related points. The above-described system and system embodiments are only illustrative, wherein the units described as separate parts may or may not be physically separate, and the parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment. One of ordinary skill in the art can understand and implement it without inventive effort.
Those of skill would further appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative components and steps have been described above generally in terms of their functionality in order to clearly illustrate this interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims (10)

1. A method of processing invoice posting, the method comprising:
constructing an invoice ledger according to invoice data of the purchase order;
utilizing the invoice ledger to fill invoice information corresponding to the purchase order in invoice certificate prefabrication MIR7 affairs in an enterprise energy planning system SAP-ERP, wherein the invoice information comprises money, tax amount, tax item and tax rate;
inquiring a work breakdown structure WBS number corresponding to the purchase order, and determining a tax code of the prefabricated invoice certificate by using the WBS number and the tax rate;
inquiring the project name corresponding to the purchase order by using the WBS number, and forming text information of the prefabricated invoice certificate by using the project name and the supplier name of the invoice ledger;
comparing the invoice information with the invoice ledger, and finally generating the prefabricated invoice certificate after error is avoided;
filling the number of the documents of the prefabricated invoice certificate in an invoice verification MIR6 transaction of the SAP-ERP;
and checking the prefabricated invoice certificate by using the invoice standing book, performing posting processing on the prefabricated invoice certificate after error is checked, and recording an appointed accounting certificate number in the invoice standing book.
2. The method of claim 1, wherein said querying a Work Breakdown Structure (WBS) number corresponding to the purchase order and determining a tax code of the pre-made invoice voucher using the WBS number and the tax rate comprises:
acquiring a purchase order number corresponding to the purchase order;
querying a detail page of the purchase order after utilizing the purchase order;
querying a work breakdown structure WBS number from the detail page;
and determining the tax code of the prefabricated invoice certificate by combining the WBS number and the tax rate by utilizing a preset WBS number coding rule.
3. The method of claim 1, wherein said querying a project name corresponding to the purchase order using the WBS number and composing the textual information of the pre-invoice voucher using the project name and a supplier name of the invoice ledger comprises:
inquiring the item name corresponding to the purchase order by using the WBS number;
making a money hanging combination according to the project name and the supplier name of the invoice standing book;
and constructing the text information of the prefabricated invoice certificate by using the information after the hung money combination.
4. The method of claim 1, after recording the specified accounting document number in the invoice ledger, further comprising:
and in the SAP-ERP voucher printing zrfm005n transaction, generating a voucher serial number of the pre-made invoice voucher after posting, and printing the voucher of the pre-made invoice after posting by using the accounting voucher number.
5. The method of claim 1, after recording the specified accounting document number in the invoice ledger, further comprising:
in a business evidence electronic system, inquiring corresponding invoice items according to the invoice number and the invoice code information of the invoice standing book;
and performing invoice authentication on the invoice corresponding to the invoice entry.
6. A system for processing invoice posting, the system comprising:
the building unit is used for building an invoice ledger according to invoice data of the purchase order;
the first filling unit is used for filling invoice information corresponding to the purchase order in an invoice certificate prefabrication MIR7 transaction in an enterprise energy planning system SAP-ERP by using the invoice standing book, wherein the invoice information comprises money, tax amount, tax item and tax rate;
the first processing unit is used for inquiring a work breakdown structure WBS number corresponding to the purchase order and determining a tax code of the prefabricated invoice certificate by using the WBS number and the tax rate;
the second processing unit is used for inquiring the project name corresponding to the purchase order by using the WBS number and forming the text information of the prefabricated invoice certificate by using the project name and the supplier name of the invoice ledger;
the generating unit is used for comparing the invoice information with the invoice ledger and finally generating the prefabricated invoice certificate after the comparison is error-free;
the second filling unit is used for filling the number of the documents of the prefabricated invoice certificate in an invoice verification MIR6 transaction of the SAP-ERP;
and the third processing unit is used for checking the prefabricated invoice certificate by using the invoice ledger, performing posting processing on the prefabricated invoice certificate after error is checked, and recording an appointed accounting certificate number in the invoice ledger.
7. The system of claim 6, wherein the first processing unit comprises:
the acquisition module is used for acquiring a purchase order number corresponding to the purchase order;
the first query module is used for querying a detail page of the purchase order after the purchase order is utilized;
the second query module is used for querying a work breakdown structure WBS number from the detail page;
and the determining module is used for determining the tax code of the prefabricated invoice certificate by combining the WBS number and the tax rate according to the preset WBS number coding rule.
8. The system of claim 6, wherein the second processing unit comprises:
the query module is used for querying the item name corresponding to the purchase order by using the WBS number;
the combination module is used for carrying out money hanging combination according to the project name and the supplier name of the invoice standing book;
and the construction module is used for constructing the text information of the prefabricated invoice certificate by using the information after the money hanging combination.
9. The system of claim 6, further comprising:
and the printing unit is used for generating a voucher serial number of the pre-made invoice voucher after posting in the voucher printing zrfm005n transaction of the SAP-ERP, and printing the voucher of the pre-made invoice voucher after posting by using the accounting voucher number.
10. The system of claim 6, further comprising:
and the authentication unit is used for inquiring corresponding invoice items according to the invoice number and the invoice code information of the invoice ledger in a business evidence electronic system and performing invoice authentication on invoices corresponding to the invoice items.
CN202011140200.9A 2020-10-22 2020-10-22 Method and system for processing invoice posting Pending CN112258256A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011140200.9A CN112258256A (en) 2020-10-22 2020-10-22 Method and system for processing invoice posting

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011140200.9A CN112258256A (en) 2020-10-22 2020-10-22 Method and system for processing invoice posting

Publications (1)

Publication Number Publication Date
CN112258256A true CN112258256A (en) 2021-01-22

Family

ID=74264039

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011140200.9A Pending CN112258256A (en) 2020-10-22 2020-10-22 Method and system for processing invoice posting

Country Status (1)

Country Link
CN (1) CN112258256A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113506161A (en) * 2021-07-15 2021-10-15 远光软件股份有限公司 Invoice checking method and device, storage medium and electronic equipment
CN113781016A (en) * 2021-09-29 2021-12-10 北京中电普华信息技术有限公司 Method, system, equipment and storage medium for updating standing book information

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102780734A (en) * 2011-10-31 2012-11-14 李宗诚 ICT (Information And Communications Technology) technical support design of enterprise value chain network configuration mode
CN102903171A (en) * 2012-09-21 2013-01-30 山东电力集团公司物资供应公司 Self-service type intelligent entering checking invoice processing system and method

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102780734A (en) * 2011-10-31 2012-11-14 李宗诚 ICT (Information And Communications Technology) technical support design of enterprise value chain network configuration mode
CN102903171A (en) * 2012-09-21 2013-01-30 山东电力集团公司物资供应公司 Self-service type intelligent entering checking invoice processing system and method

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
枫竹丹青: "发票校验_预制和过账", pages 1 - 2, Retrieved from the Internet <URL:https://fenginfo.com/2480.html?wptouch_switch=desktop> *

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113506161A (en) * 2021-07-15 2021-10-15 远光软件股份有限公司 Invoice checking method and device, storage medium and electronic equipment
CN113781016A (en) * 2021-09-29 2021-12-10 北京中电普华信息技术有限公司 Method, system, equipment and storage medium for updating standing book information
CN113781016B (en) * 2021-09-29 2024-01-12 北京中电普华信息技术有限公司 Method, system, equipment and storage medium for updating account information

Similar Documents

Publication Publication Date Title
US7865411B2 (en) Accounts payable process
US20150287005A1 (en) Bar coded monetary transaction system and method
CN107451874A (en) Electronic invoice integrated conduct method and system based on block chain
CN106530021A (en) Electronic invoice making out system apparatus
CN108961021A (en) It is taken pictures using Intelligent mobile equipment and generates the method and system of voucher
WO2009079098A1 (en) System and method for electronic contracting
CN108133415B (en) Electronic credential reimbursement method, device and system
CN112258256A (en) Method and system for processing invoice posting
CN116128458B (en) Intelligent automatic auditing system for hospital expense card account reporting
WO2008045947A2 (en) Systems and methods for collaborative payment strategies
CN102044091A (en) Self-service ticketing system
KR20160003623A (en) System for remuneration for lost baggage
CN109194771A (en) A kind of neocaine bids to host method, apparatus, server and storage medium
CN110796531A (en) Web-based accounting voucher generation method and system
JP2011048849A (en) Procedure system
CN109857954A (en) It is a kind of for determine electronic invoice reimbursement state method and system
CN103337030A (en) Systems and methods for transactions processing
CN107610383A (en) Make out an invoice client, invoice information of one kind safeguards end and invoice issuing method
KR102012153B1 (en) Print service system and method based on webpage
JP4695299B2 (en) Procedure system
JP4850388B2 (en) Fixed asset processing system and method, and computer program
CN111340517A (en) Method, system and related equipment for rapidly inquiring authenticity of invoice
US7882153B1 (en) Method and system for electronic messaging of trade data
NL2020787B1 (en) Computer implemented method for managing contract negotiation
CN106251110A (en) Airborne logistics circle system

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