CA3150626A1 - Method and device for generating accounting voucher based on sap system - Google Patents
Method and device for generating accounting voucher based on sap system Download PDFInfo
- Publication number
- CA3150626A1 CA3150626A1 CA3150626A CA3150626A CA3150626A1 CA 3150626 A1 CA3150626 A1 CA 3150626A1 CA 3150626 A CA3150626 A CA 3150626A CA 3150626 A CA3150626 A CA 3150626A CA 3150626 A1 CA3150626 A1 CA 3150626A1
- Authority
- CA
- Canada
- Prior art keywords
- accounting
- voucher
- accounting voucher
- generating
- calculating
- 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
Links
- 238000000034 method Methods 0.000 title claims abstract description 36
- 238000004364 calculation method Methods 0.000 claims abstract description 19
- 230000002708 enhancing effect Effects 0.000 claims description 17
- 238000009795 derivation Methods 0.000 claims description 16
- 230000006870 function Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 230000008859 change Effects 0.000 description 3
- 230000000694 effects Effects 0.000 description 2
- 230000006872 improvement Effects 0.000 description 1
- 239000013589 supplement Substances 0.000 description 1
- 230000029305 taxis Effects 0.000 description 1
- 230000007704 transition Effects 0.000 description 1
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/12—Accounting
Abstract
The present invention discloses a method and a device for generating accounting document based on SAP, wherein the method comprises: receiving business data integrated with an accounting event as the dimension; searching configuration information corresponding to the accounting event in pre-stored configuration data according to the accounting event, and generating a first accounting document according to the configuration information, the configuration information comprises: an accounting document structure of each accounting event and a calculation rule of each field in the accounting document. The present invention can configure the input structure of the source order, and deal with various business accounting scenes, flexible accounting can be realized, and the expandability, maintainability and reusability of the prior accounting device are improved.
Description
METHOD AND DEVICE FOR GENERATING ACCOUNTING VOUCHER BASED ON
SAP SYSTEM
BACKGROUND OF THE INVENTION
Technical Field [0001] The present invention relates to the field of computer technology, and more particularly to a method and a device for generating an accounting voucher based on SAP.
Description of Related Art
SAP SYSTEM
BACKGROUND OF THE INVENTION
Technical Field [0001] The present invention relates to the field of computer technology, and more particularly to a method and a device for generating an accounting voucher based on SAP.
Description of Related Art
[0002] Current financial bookkeeping by means of SAP (System APplications) devices is divided into the two modes of manual bookkeeping and programming-mode bookkeeping.
Manual bookkeeping is completed via standard transaction codes provided by SAP.
Programming-mode bookkeeping is completed via the ABAP programming language that invokes the standard bookkeeping BAPI function provided by SAP.
Manual bookkeeping is completed via standard transaction codes provided by SAP.
Programming-mode bookkeeping is completed via the ABAP programming language that invokes the standard bookkeeping BAPI function provided by SAP.
[0003] Of the aforementioned two bookkeeping modes, the programming-mode bookkeeping is characteristic of being highly effective and flexible as compared with the manual bookkeeping, but at each new addition of a bookkeeping business or a change in a bookkeeping item, it is required to newly add corresponding codes or amend the related codes to adapt to the change in the business, however, as seen from the software design principle, such programming-mode bookkeeping violates the rules of maintainability and reusability in the software design, and tends to affect existing bookkeeping businesses.
SUMMARY OF THE INVENTION
SUMMARY OF THE INVENTION
[0004] In order to overcome the problems pending in the state of the art, the present invention Date Recue/Date Received 2022-01-31 provides a method and device for generating an accounting voucher based on SAP, and it is made possible, through the technical solutions of the present invention, to complete bookkeeping tasks merely through configurations and without the need to repeatedly write codes, whereby are authentically realized the highly effective, flexible, extensible and maintainable functions of the programming-mode bookkeeping. The technical solutions are as follows.
[0005] On the one hand, there is provided a method of generating an accounting voucher based on SAP, and the method comprises:
[0006] receiving business data integrated with accounting events as dimensions;
[0007] searching for configuration information corresponding to the accounting events in pre-stored configuration data according to the accounting events, and generating a first accounting voucher according to the configuration information, wherein the configuration information includes: accounting voucher structures of the various accounting events and calculating rules of various fields in the accounting voucher, and wherein the accounting voucher structures include: voucher headers and voucher row items.
[0008] Further, after the step of receiving business data integrated with accounting events as dimensions, the method further comprising:
[0009] employing an external interface to invoke the configuration data according to the accounting events.
[0010] Further, the method further comprises: summarizing the first accounting voucher with designated dimensions, and generating a second accounting voucher.
[0011] Further, the step of generating a first accounting voucher according to the configuration information includes:
[0012] traversing the accounting voucher structures of the various accounting events in the Date Recue/Date Received 2022-01-31 configuration information, determining the voucher headers of the first accounting voucher, and determining the voucher row items of the first accounting voucher according to configuration conditions of the voucher row items; and
[0013] traversing calculating rules of the various fields in the configuration information, and determining calculating rules of various fields in the first accounting voucher according to configuration conditions of the calculating rules.
[0014] Further, when the calculating rule is a directly allocating rule, field calculation of the first accounting voucher includes:
[0015] directly assigning random one or more field(s) in business order data to the fields of the first accounting voucher.
[0016] Further, when the calculating rule is a form enquiring rule, field calculation of the first accounting voucher includes:
[0017] basing on random one or more field(s) in the business order data to search out from a condition intermediate table one or more field(s) corresponding thereto, and assigning the same to the fields of the first accounting voucher.
[0018] Further, when the calculating rule is a deriving rule, field calculation of the first accounting voucher includes:
[0019] basing on random one or more field(s) in the business order data to employ a derivation table to derive one or more field(s) corresponding thereto, and assigning the same to the fields of the first accounting voucher.
[0020] Further, when the calculating rule is a code enhancing rule, field calculation of the first accounting voucher includes:
[0021] basing on random one or more field(s) of the business order data to assign the same to the fields of the first accounting voucher through ABAP language programming.
Date Recue/Date Received 2022-01-31
Date Recue/Date Received 2022-01-31
[0022] On the other hand, there is provided a device for generating an accounting voucher based on SAP, and the device comprises:
[0023] a data receiving module, for receiving business data integrated with accounting events as dimensions;
[0024] a voucher generating module, for generating a first accounting voucher, and including:
[0025] a configuring module, for searching for configuration information corresponding to the accounting events in pre-stored configuration data according to the accounting events, wherein the configuration information includes: accounting voucher structures of the various accounting events and calculating rules of various fields in the accounting voucher, and wherein the accounting voucher structures include: voucher headers and voucher row items; and
[0026] a calculating module, for generating the first accounting voucher according to the configuration information.
[0027] Further, the device further comprises an SAP module for employing an external interface to invoke the configuration data according to the accounting events.
[0028] Further, the calculating module further includes a summarizing module for summarizing the first accounting voucher with designated dimensions, and generating a second accounting voucher.
[0029] Further, the configuring module further includes:
[0030] an accounting voucher structure configuring module, for traversing the accounting voucher structures of the various accounting events in the configuration information, determining the voucher headers of the first accounting voucher, and determining the voucher row items of the first accounting voucher according to configuration conditions of the voucher row items; and
[0031] a calculating rule configuring module, for traversing calculating rules of the various fields in the configuration information, and determining calculating rules of various fields in Date Recue/Date Received 2022-01-31 the first accounting voucher according to configuration conditions of the calculating rules.
[0032] Further, the calculating rule configuring module includes one or more of the following sub-module(s):
[0033] a directly allocating module, for storing directly allocating rules;
[0034] a form enquiring module, for storing form enquiring rules;
[0035] a derivation calculating module, for storing deriving calculating rules; and
[0036] a code enhancing module, for storing code enhancing rules.
[0037] Further, the calculating module includes one or more of the following sub-module(s):
[0038] a direct allocation calculating module, for directly assigning values to the fields of the first accounting voucher according to the directly allocating rules, including:
[0039] directly assigning random one or more field(s) in business order data to the fields of the first accounting voucher;
[0040] a form enquiry calculating module, for assigning values to the fields of the first accounting voucher according to the form enquiring rules, including:
[0041] basing on random one or more field(s) in the business order data to search out from a condition intermediate table one or more field(s) corresponding thereto, and assigning the same to the fields of the first accounting voucher;
[0042] a derivation calculating module, for assigning values to the fields of the first accounting voucher according to the deriving rules, including:
[0043] basing on random one or more field(s) in the business order data to employ a derivation table to derive one or more field(s) corresponding thereto, and assigning the same to the fields of the first accounting voucher; and
[0044] a code enhancement calculating module, for assigning values to the fields of the first accounting voucher according to the code enhancing rules, including:
[0045] basing on random one or more field(s) of the business order data to assign the same to the fields of the first accounting voucher through ABAP language programming.
Date Recue/Date Received 2022-01-31
Date Recue/Date Received 2022-01-31
[0046] The technical solutions provided by the present invention bring about the following advantageous effects.
[0047] The present invention achieves configurable input structures of source orders, enables to cope with various business bookkeeping scenarios, realizes flexible bookkeeping, and enhances extensibility, maintainability and reusability of currently available bookkeeping devices.
[0048] In the present invention, the calculating rules of the various fields in the accounting voucher are classified into four types: directly allocating, form enquiring, deriving, and code enhancing, whereby is made possible to satisfy different calculation scenarios and to flexibly select the configurations.
[0049] The voucher generating module in the device disclosed by the present invention includes configuring modules and calculating modules, of which the configuring modules are responsible for configuring accounting voucher structures of the various accounting events and the calculating rules of the various fields in the accounting vouchers, and the calculating modules are responsible for performing calculations on the basis of the configurations made by the configuring modules; different modules are responsible for different tasks, and the responsibilities are separated.
BRIEF DESCRIPTION OF THE DRAWINGS
BRIEF DESCRIPTION OF THE DRAWINGS
[0050] To more clearly explain the technical solutions in the embodiments of the present invention, drawings required for use in the following explanation of the embodiments are briefly described below. Apparently, the drawings described below are merely directed to some embodiments of the present invention, while it is further possible for persons ordinarily skilled in the art to base on these drawings to acquire other drawings, and no creative effort will be spent in the process.
Date Recue/Date Received 2022-01-31
Date Recue/Date Received 2022-01-31
[0051] Fig. 1 is a flowchart illustrating a method of generating an accounting voucher based on SAP provided by Embodiment 1 of the present invention;
[0052] Fig. 2 is a view illustrating the relation between an accounting voucher structure and field calculating rules provided by Embodiment 1 of the present invention;
[0053] Fig. 3 is a view schematically illustrating the modules of a device for generating an accounting voucher based on SAP provided by Embodiment 1 of the present invention;
[0054] Fig. 4 is a flowchart illustrating a method of generating an accounting voucher based on SAP provided by Embodiment 2 of the present invention; and
[0055] Fig. 5 is a view schematically illustrating a generated accounting voucher provided by Embodiment 2 of the present invention.
DETAILED DESCRIPTION OF THE INVENTION
DETAILED DESCRIPTION OF THE INVENTION
[0056] To make more lucid and clear the objectives, technical solutions and advantages of the present invention, technical solutions in the embodiments of the present invention will be described more clearly and completely below with reference to the accompanying drawings in the embodiments of the present invention. Apparently, the embodiments described below are merely partial, rather than the entire, embodiments of the present invention. All other embodiments achievable by persons ordinarily skilled in the art on the basis of the embodiments in the present invention without creative effort shall all fall within the protection scope of the present invention.
[0057] Business data input in SAP devices can be divided into business data that are associated with accounting vouchers (namely data required to be used in generating accounting Date Recue/Date Received 2022-01-31 vouchers) and business data that are irrelevant to accounting vouchers (namely data not required or rarely required to be used in generating accounting vouchers). In prior-art technology the SAP device does not process the business data, and the accounting voucher is directly generated; since the business of an enterprise often changes, and generation of the accounting voucher needs to be changed with the change in the enterprise business, it is thus required to frequently alter the accounting voucher generating codes, whereby manpower is wasted. In the embodiments of the present invention, the bookkeeping function of the SAP device is separated out, and the accounting voucher is generated according to configuration rules, whereby it is made possible during use for the user to select or define configuration rules on his/her own initiative according to business features and requirements, and it is not required to amend the original codes, so the extensibility, maintainability and reusability of the device are enhanced.
[0058] Embodiment 1
[0059] As shown in Fig. 1, there is provided a method of generating an accounting voucher based on SAP, and the method comprises:
[0060] receiving business data integrated with accounting events as dimensions;
[0061] searching for configuration information corresponding to the accounting events in pre-stored configuration data according to the accounting events, and generating a first accounting voucher according to the configuration information, wherein the configuration information includes: accounting voucher structures of the various accounting events and calculating rules of various fields in the accounting voucher, and wherein the accounting voucher structures include: voucher headers and voucher row items.
[0062] As should be noted, the business data in the above method is data associated with enterprise business. Business order data mainly indicates data that is related to accounting Date Recue/Date Received 2022-01-31 and bookkeeping, can be information input by users themselves, and can also be information automatically recognized by the device through such business orders as sales orders, purchasing orders, expense orders, and carry-over orders, etc. The accounting events can be differentiated according to properties and types of business funds on account as they actually occur, such as collections, repayments, carry-over funds, income costs, consignment and joint funds, and taxes, etc., and each accounting event can be marked with a field code; in the method provided by the embodiments of the present invention, once the code of an accounting event is input, all business data under this accounting event code will be received. One accounting event inevitably corresponds to one type of accounting voucher, and the subsequent generation of the accounting voucher takes the accounting event as the generating unit. Business data integrated with accounting events as dimensions specifically includes analyzing, sorting and concluding business order data, and splitting each business order into one or more accounting event(s). The accounting voucher structures include headers and row items of accounting vouchers; as shown in Fig. 2, searching for configuration information corresponding to the accounting events is to base on the accounting events to correspond to one type of accounting voucher and to obtain the calculating rules of the various fields in this type of accounting voucher, so as to ascertain the headers and the row items to be included in the accounting voucher and the values of the headers and the row items, thus generating a first accounting voucher. The accounting voucher structures and the calculating rules of the various fields in the above method are preset, so once the accounting events have been well determined, it is possible to directly search for the configuration information required to generate the accounting voucher according to the accounting events, and the first accounting voucher can be generated by executing the configuration information. It the calculating rules corresponding to the accounting events cannot be found from the preset calculating rules, it is further possible to invoke configuration data according to the accounting events via an external interface.
[0063] The step of generating a first accounting voucher according to the configuration Date Recue/Date Received 2022-01-31 information includes:
[0064] traversing the accounting voucher structures of the various accounting events in the configuration information, determining the voucher headers of the first accounting voucher, and determining the voucher row items of the first accounting voucher according to configuration conditions of the voucher row items; and
[0065] traversing calculating rules of the various fields in the configuration information, and determining calculating rules of various fields in the first accounting voucher according to configuration conditions of the calculating rules.
[0066] As should be noted, each accounting event can correspond to one type of accounting voucher structure, the accounting voucher structures are preset in the device, the calculating rules of the fields correspond to the various fields in the accounting voucher, and likewise preset in the device, accordingly, once the accounting events have been determined, the headers and the row items of the corresponding accounting voucher and the values of the headers and the row items can then be configured and determined according to their respective configuration conditions; the voucher headers are not equipped with configuration condition, the row items of the voucher and the field calculating rules in the row items of the voucher are equipped with corresponding configuration conditions, and the corresponding row items and calculating rules can be configured only after the business data has satisfied the corresponding configuration conditions. If there is a newly added accounting event or accounting voucher field, it is then required to provide the newly added accounting event with an accounting voucher structure and to provide the newly added field with a calculating rule.
[0067] The calculating rules of the fields of the accounting voucher include one or more selected from directly allocating, form enquiring, derivatively calculating, and code enhancing.
[0068] When the calculating rule is a directly allocating rule, field calculation of the first accounting voucher includes: directly assigning random one or more field(s) in the Date Recue/Date Received 2022-01-31 business order data to the fields of the first accounting voucher.
[0069] When the calculating rule is a form enquiring rule, field calculation of the first accounting voucher includes: basing on random one or more field(s) in the business order data to search out from a condition intermediate table one or more field(s) corresponding thereto, and assigning the same to the fields of the first accounting voucher.
[0070] When the calculating rule is a deriving rule, field calculation of the first accounting voucher includes: basing on random one or more field(s) in the business order data to employ a derivation table to derive one or more field(s) corresponding thereto, and assigning the same to the fields of the first accounting voucher.
[0071] When the calculating rule is a code enhancing rule, field calculation of the first accounting voucher includes: basing on random one or more field(s) of the business order data to assign the same to the fields of the first accounting voucher through ABAP
language programming. The code enhancing rule is to realize calculation of the fields of the first accounting voucher through the mode of programming directly by the user, and the code enhancing rule mainly functions to supplement the directly allocating rule, the form enquiring rule and the deriving rule, so as to make the method disclosed by the embodiments of the present invention more widely applicable.
language programming. The code enhancing rule is to realize calculation of the fields of the first accounting voucher through the mode of programming directly by the user, and the code enhancing rule mainly functions to supplement the directly allocating rule, the form enquiring rule and the deriving rule, so as to make the method disclosed by the embodiments of the present invention more widely applicable.
[0072] In actual use, there is a need for the user to merge accounting vouchers, so the method disclosed by the embodiments of the present invention further comprises:
summarizing the first accounting voucher with designated dimensions, and generating a second accounting voucher.
summarizing the first accounting voucher with designated dimensions, and generating a second accounting voucher.
[0073] The designated dimensions in the above method are random one or more field(s) in the first accounting voucher. Summarizing the first accounting voucher with designated Date Recue/Date Received 2022-01-31
[0074] dimensions can be to summarize with client codes, to summarize with payment modes, etc.
[0075] For access with the SAP device, the configuration data is invoked by employing an external interface according to the accounting events in the embodiments of the present invention. The first accounting voucher or second accounting voucher as generated can be returned via the external interface to the SAP device to be presented therein.
[0076] As shown in Fig. 3, a device for generating an accounting voucher based on SAP as created on the basis of the above method comprises:
[0077] a data receiving module, for receiving business data integrated with accounting events as dimensions;
[0078] an SAP module, for employing an external interface to invoke configuration data according to the accounting events;
[0079] a voucher generating module, for generating a first accounting voucher, and including:
[0080] a configuring module, for searching for configuration information corresponding to the accounting events in pre-stored configuration data according to the accounting events, wherein the configuration information includes: accounting voucher structures of the various accounting events and calculating rules of various fields in the accounting voucher, and wherein the accounting voucher structures include: voucher headers and voucher row items; and
[0081] a calculating module, for generating the first accounting voucher according to the configuration information.
[0082] The calculating module further includes a summarizing module for summarizing the first accounting voucher with designated dimensions, and generating a second accounting voucher. The designated dimensions include one or more field(s) in the first accounting voucher.
Date Recue/Date Received 2022-01-31
Date Recue/Date Received 2022-01-31
[0083] The configuring module specifically includes:
[0084] an accounting voucher structure configuring module, for traversing the accounting voucher structures of the various accounting events in the configuration information, determining the voucher headers of the first accounting voucher, and determining the voucher row items of the first accounting voucher according to configuration conditions of the voucher row items; and
[0085] a calculating rule configuring module, for traversing calculating rules of the various fields in the configuration information, and determining calculating rules of various fields in the first accounting voucher according to configuration conditions of the calculating rules.
[0086] The calculating rule configuring module includes one or more of the following sub-module(s):
[0087] a directly allocating module, for storing directly allocating rules;
[0088] a form enquiring module, for storing form enquiring rules;
[0089] a derivation calculating module, for storing deriving calculating rules; and
[0090] a code enhancing module, for storing code enhancing rules.
[0091] The calculating module includes one or more of the following sub-module(s):
[0092] a direct allocation calculating module, for directly assigning values to the fields of the first accounting voucher according to the directly allocating rules, including:
[0093] directly assigning random one or more field(s) in the business order data to the fields of the first accounting voucher;
[0094] a form enquiry calculating module, for assigning values to the fields of the first accounting voucher according to the form enquiring rules, including:
[0095] basing on random one or more field(s) in the business order data to search out from a condition intermediate table one or more field(s) corresponding thereto, and assigning the same to the fields of the first accounting voucher;
[0096] a derivation calculating module, for assigning values to the fields of the first accounting voucher according to the deriving rules, including:
Date Recue/Date Received 2022-01-31
Date Recue/Date Received 2022-01-31
[0097] basing on random one or more field(s) in the business order data to employ a derivation table to derive one or more field(s) corresponding thereto, and assigning the same to the fields of the first accounting voucher; and
[0098] a code enhancement calculating module, for assigning values to the fields of the first accounting voucher according to the code enhancing rules, including:
[0099] basing on random one or more field(s) of the business order data to assign the same to the fields of the first accounting voucher through ABAP language programming.
[0100] Embodiment 2
[0101] This embodiment explains the technical solutions of the present invention in greater detail on the basis of Embodiment 1 in conjunction with a specific application scenario.
[0102] As shown in Fig. 4, a method of generating an accounting voucher based on SAP
comprises the following steps.
comprises the following steps.
[0103] SO1 - receiving business data integrated with accounting events as dimensions, as shown below, the accounting event being "SK01".
[0104] Headers
[0105] accounting event item number 1810280000000002
[0106] financial accounting item number 0070165000750101
[0107] OMS row item number 00701650007501
[0108] share order number 11000701650007501001
[0109] accounting event SK01
[0110] state date 2018.10.27
[0111] posting date 2018.10.27
[0112] sales company H007
[0113] sales store 871S
Date Recue/Date Received 2022-01-31
Date Recue/Date Received 2022-01-31
[0114] repayment company H007
[0115] repayment store 871S
[0116] bill direction 1
[0117] currency code CNY
[0118] debt mark N
[0119] order origin B2C
[0120] pos item number AF21246344
[0121] Row Items
[0122] accounting event item number 1810280000000002
[0123] serial number 2
[0124] collection transition company 5400
[0125] distribution channel 50
[0126] payment mode 4237
[0127] repayment amount 709.00
[0128] payment transaction serial number 15470880655931825266
[0129] refund direction 2018102722001445881008273270
[0130] client code 2871S
[0131] SO2 ¨ employing an external interface to invoke configuration data, and loading configuration information.
[0132] S03 ¨ traversing accounting voucher structures of the various accounting events in the configuration information, and determining a voucher structure of the first accounting voucher. Further, step S03 further includes: judging whether the first accounting voucher structure configuration is enabled, if not, traversing anew.
[0133] As should be noted, during the process of determining the voucher structure of the first accounting voucher, it can be determined whether to configure the row items of the Date Recue/Date Received 2022-01-31 accounting voucher according to preset conditions of the various row items, for instance, if the payment mode in the business bookkeeping data satisfies a certain preset payment mode condition of the row items of the accounting voucher, this row item is configured, if not, this row item is not configured. Judging the enabling of the accounting voucher structure configuration in step S03 is to judge whether the business data satisfies the configuration conditions of the row items of the accounting voucher.
[0134] The voucher structure of the first accounting voucher determined according to the accounting events includes the following:
[0135] Voucher Headers
[0136] voucher type BLART.
[0137] reference to XBLNR calculating policy.
[0138] voucher date BLDAT.
[0139] posting date BUDAT.
[0140] company code BUKRS.
[0141] currency code WAERS.
[0142] Voucher Row Items: Debt
[0143] subject HKONT.
[0144] client code KUNNR.
[0145] subject type KOART.
[0146] special general ledger ID UMSKZ.
[0147] voucher currency amount WRBTR.
[0148] allocation ZUONR.
[0149] debt and credit ID SHKZG.
[0150] Voucher Row Items: Credit
[0151] subject type KOART.
[0152] ledger subject HKONT.
[0153] supplier LIFNR.
[0154] item text SGTXT.
Date Recue/Date Received 2022-01-31
Date Recue/Date Received 2022-01-31
[0155] debt and credit ID SHKZG.
[0156] cause code RSTGR.
[0157] SO4 - traversing calculating rules of the various fields in the configuration information, and respectively determining calculating rules of various fields in the first accounting voucher. Further, step SO4 further includes: judging whether field calculating rules are enabled, if not, traversing anew.
[0158] As should be noted, each field may include plural calculating rules, it is therefore required to determine from the plural calculating rules one that is suitable for the business data;
accordingly, similar to the configuration conditions of the aforementioned row items, corresponding conditions are also provided for the configuration of the field calculating rules. The corresponding field calculating rules are configured only when the business data satisfies the configuration conditions of the field calculating rules.
Judging the enabling of the calculating rules in step SO4 is to judge whether the business data satisfies the configuration conditions of the calculating rules.
accordingly, similar to the configuration conditions of the aforementioned row items, corresponding conditions are also provided for the configuration of the field calculating rules. The corresponding field calculating rules are configured only when the business data satisfies the configuration conditions of the field calculating rules.
Judging the enabling of the calculating rules in step SO4 is to judge whether the business data satisfies the configuration conditions of the calculating rules.
[0159] According to the aforementioned voucher structure, the calculating rules of the various fields in the first accounting voucher are configured as follows:
[0160] Voucher Headers
[0161] voucher type BLART, calculating policy being directly allocating, value being: fixed value SK.
[0162] reference to XBLNR, calculating policy being directly allocating, value being: "OMS
row item number + share order number" in the business header data.
row item number + share order number" in the business header data.
[0163] voucher date BLDAT, calculating policy being directly allocating, value being: "state date"
in the business header data.
in the business header data.
[0164] posting date BUDAT, calculating policy being directly allocating, value being: "posting date" in the business header data.
[0165] company code BUKRS, calculating policy being directly allocating, value being: "sales Date Recue/Date Received 2022-01-31 company" in the business header data.
[0166] currency code WAERS, calculating policy being directly allocating, value being:
"currency code" in the business header data.
"currency code" in the business header data.
[0167] Voucher Row Items: Debt
[0168] subject HKONT, calculating policy being form enquiring, searching logic: finding out bookkeeping subject in configuration table (ZFIT101) according to "payment mode" in the business row item data.
[0169] client code KUNNR, calculating policy being form enquiring, searching logic: finding out client in configuration table (ZFIT101) according to "payment mode" in the business row item data.
[0170] subject type KOART, calculating policy being form enquiring, searching logic: finding out subject type in configuration table (ZFIT101) according to "payment mode"
in the business row item data.
in the business row item data.
[0171] special general ledger ID UMSKZ, calculating policy being form enquiring, searching logic: finding out special general ledger ID as # in configuration table (ZFIT101) according to "payment mode" in the business row item data.
[0172] voucher currency amount WRBTR, calculating policy being directly allocating, value being: "repayment amount" in the business row item data.
[0173] allocation ZUONR, calculating policy being directly allocating, value being: "pos item number + repayment store" in the headers.
[0174] debt and credit ID SHKZG, calculating policy being deriving rule, deriving logic: "bill direction" 1 in the headers corresponding to value S according to the derivation table configured by configuration engine.
[0175] Voucher Row Items: Credit
[0176] subject type KOART, calculating policy being form enquiring, searching logic: finding out subject type in configuration table (ZFIT076) according to "debt mark" and "sales mode" in the business headers.
[0177] ledger subject HKONT, calculating policy being form enquiring, searching logic: finding out ledger subject in configuration table (ZFIT076) according to "debt mark"
and "sales Date Recue/Date Received 2022-01-31 mode" in the business headers.
and "sales Date Recue/Date Received 2022-01-31 mode" in the business headers.
[0178] supplier LIFNR, calculating policy being directly allocating, value being: "sales company"
in the business headers.
in the business headers.
[0179] item text SGTXT, calculating policy being directly allocating, value being: "state date"
in the business headers + confirming sold commodities, services.
in the business headers + confirming sold commodities, services.
[0180] debt and credit ID SHKZG, calculating policy being deriving rule, deriving logic: "bill direction" 1 in the headers corresponding to value H according to the derivation table configured by configuration engine.
[0181] cause code RSTGR, calculating policy being directly allocating, value being: fixed value 02.
[0182] S05 ¨ calculating according to the calculating rules of the various fields in the first accounting voucher to generate the first accounting voucher.
[0183] Fig. 5 shows the generated first accounting voucher, and the calculating process is as follows:
[0184] Voucher Headers
[0185] voucher type BLART being fixed value SK.
[0186] reference to XBLNR being "OMS row item number + share order number" in the business header data, and value being 0070165000750111000701650007501001.
[0187] voucher date BLDAT being "state date" in the business header data, and value being 2018.10.27.
[0188] posting date BUDAT being "posting date" in the business header data, and value being 2018.10.27.
[0189] company code BUKRS being "sales company" in the business header data, and value being H007.
[0190] currency code WAERS being "currency code" in the business header data, and value being CNY.
[0191] Voucher Row Items: Debt Date Recue/Date Received 2022-01-31
[0192] subject HKONT, finding out bookkeeping subject as 70108916 in configuration table (ZFIT101) according to "payment mode" = 4237 in the business row item data.
[0193] client code KUNNR, finding out client as 70108916 in configuration table (ZFIT101) according to "payment mode" = 4237 in the business row item data.
[0194] subject type KOART, finding out subject type as D in configuration table (ZFIT101) according to "payment mode" = 4237 in the business row item data.
[0195] special general ledger ID UMSKZ, finding out special general ledger ID
as # in configuration table (ZFIT101) according to "payment mode" = 4237 in the business row item data.
as # in configuration table (ZFIT101) according to "payment mode" = 4237 in the business row item data.
[0196] voucher currency amount WRBTR being "repayment amount" in the business row item data, and value being 709.00.
[0197] allocation ZUONR being "pos item number" + "repayment store" in the headers, and value being AF21246344871S.
[0198] debt and credit ID SHKZG, "bill direction" 1 in the headers corresponding to value S
according to the derivation table configured by configuration engine.
according to the derivation table configured by configuration engine.
[0199] Voucher Row Items: Credit
[0200] subject type KOART, finding out subject type as S in configuration table (ZFIT076) according to "debt mark" =N and "sales mode" = 2 in the business headers.
[0201] ledger subject HKONT, finding out ledger subject as 2131260040 in configuration table (ZFIT076) according to "debt mark" = N and "sales mode" = 2 in the business headers.
[0202] supplier LIFNR, being "sales company" in the business headers, and value being H007.
[0203] item text SGTXT, being "state date" in the business headers +
confirming sold commodities, services, and value being 2018.10.27.
confirming sold commodities, services, and value being 2018.10.27.
[0204] debt and credit ID SHKZG, "bill direction" 1 in the headers corresponding to value H
according to the derivation table configured by configuration engine.
according to the derivation table configured by configuration engine.
[0205] cause code RSTGR, being fixed value 02.
[0206] S06 ¨ checking whether calculation of the various fields in the first accounting voucher has been completed.
Date Recue/Date Received 2022-01-31
Date Recue/Date Received 2022-01-31
[0207] S07 ¨ checking whether the voucher structure of the first accounting voucher is complete.
[0208] S08 ¨ summarizing the first voucher, merging the first accounting voucher according to designated dimensions, and generating a second accounting voucher.
[0209] S09 ¨ employing an external interface to return the second accounting voucher.
[0210] The accounting voucher generating device that executes the aforementioned accounting voucher generating method comprises the following modules:
[0211] a data receiving module, for receiving business data integrated with accounting events as dimensions;
[0212] an SAP module, for employing an external interface to invoke configuration data according to the accounting events, and returning a second accounting voucher;
[0213] a voucher generating module, for generating a first accounting voucher, and including:
[0214] a configuring module, for searching for configuration information corresponding to the accounting events in pre-stored configuration data according to the accounting events, wherein the configuration information includes: accounting voucher structures of the various accounting events and calculating rules of various fields in the accounting voucher, and wherein the accounting voucher structures include: voucher headers and voucher row items; and
[0215] a calculating module, for generating the first accounting voucher according to the configuration information.
[0216] The calculating module further includes a summarizing module for summarizing the first accounting voucher with designated dimensions, and generating a second accounting voucher. The designated dimensions include one or more field(s) in the first accounting voucher.
Date Recue/Date Received 2022-01-31
Date Recue/Date Received 2022-01-31
[0217] The configuring module specifically includes:
[0218] an accounting voucher structure configuring module, for traversing the accounting voucher structures of the various accounting events in the configuration information, determining the voucher headers of the first accounting voucher, and determining the voucher row items of the first accounting voucher according to configuration conditions of the voucher row items; and
[0219] a calculating rule configuring module, for traversing calculating rules of the various fields in the configuration information, and determining calculating rules of various fields in the first accounting voucher according to configuration conditions of the calculating rules.
[0220] The calculating rule configuring module includes the following sub-modules:
[0221] a directly allocating module, for storing directly allocating rules;
[0222] a form enquiring module, for storing form enquiring rules;
[0223] a derivation calculating module, for storing deriving calculating rules; and
[0224] a code enhancing module, for storing code enhancing rules.
[0225] The calculating module includes the following sub-modules:
[0226] a direct allocation calculating module, for directly assigning values to the fields of the first accounting voucher according to the directly allocating rules, including: directly assigning random one or more field(s) in the business order data to the fields of the first accounting voucher;
[0227] a form enquiry calculating module, for assigning values to the fields of the first accounting voucher according to the form enquiring rules, including: basing on random one or more field(s) in the business order data to search out from a condition intermediate table one or more field(s) corresponding thereto, and assigning the same to the fields of the first accounting voucher;
[0228] a derivation calculating module, for assigning values to the fields of the first accounting voucher according to the deriving rules, including: basing on random one or more field(s) in the business order data to employ a derivation table to derive one or more field(s) Date Recue/Date Received 2022-01-31 corresponding thereto, and assigning the same to the fields of the first accounting voucher;
and
and
[0229] a code enhancement calculating module, for assigning values to the fields of the first accounting voucher according to the code enhancing rules, including: basing on random one or more field(s) of the business order data to assign the same to the fields of the first accounting voucher through ABAP language programming.
[0230] The technical solutions provided by the present invention bring about the following advantageous effects.
[0231] The present invention achieves configurable input structures of source orders, enables to cope with various business bookkeeping scenarios, realizes flexible bookkeeping, and enhances extensibility, maintainability and reusability of currently available bookkeeping devices.
[0232] In the present invention, the calculating rules of the various fields in the accounting voucher are classified into four types: directly allocating, form enquiring, deriving, and code enhancing, whereby is made possible to satisfy different calculation scenarios and to flexibly select the configurations.
[0233] The voucher generating module in the device disclosed by the present invention includes configuring modules and calculating modules, of which the configuring modules are responsible for configuring accounting voucher structures of the various accounting events and the calculating rules of the various fields in the accounting vouchers, and the calculating modules are responsible for performing calculations on the basis of the configurations made by the configuring modules; different modules are responsible for different tasks, and the responsibilities are separated.
[0234] All of the aforementioned optional technical solutions are randomly combinable to form Date Recue/Date Received 2022-01-31 optional embodiments of the present invention, to which no repetition is made on a one-by-one basis.
[0235] What is described above is merely directed to preferred embodiments of the present invention, and is not meant to restrict the present invention. Any amendment, equivalent replacement and improvement makeable within the spirit and scope of the present invention shall all be covered by the protection scope of the present invention.
Date Recue/Date Received 2022-01-31
Date Recue/Date Received 2022-01-31
Claims (10)
1. A method of generating an accounting voucher based on SAP, characterized in comprising:
receiving business data integrated with accounting events as dimensions;
searching for configuration information corresponding to the accounting events in pre-stored configuration data according to the accounting events, and generating a first accounting voucher according to the configuration information, wherein the configuration information includes: accounting voucher structures of the various accounting events and calculating rules of various fields in the accounting voucher, and wherein the accounting voucher structures include: voucher headers and voucher row items.
receiving business data integrated with accounting events as dimensions;
searching for configuration information corresponding to the accounting events in pre-stored configuration data according to the accounting events, and generating a first accounting voucher according to the configuration information, wherein the configuration information includes: accounting voucher structures of the various accounting events and calculating rules of various fields in the accounting voucher, and wherein the accounting voucher structures include: voucher headers and voucher row items.
2. The method of generating an accounting voucher based on SAP according to Claim 1, after the step of receiving business data integrated with accounting events as dimensions, the method further comprising:
employing an external interface to invoke the configuration data according to the accounting events.
employing an external interface to invoke the configuration data according to the accounting events.
3. The method of generating an accounting voucher based on SAP according to Claim 1, characterized in further comprising: summarizing the first accounting voucher with designated dimensions, and generating a second accounting voucher.
4. The method of generating an accounting voucher based on SAP according to anyone of Claims 1 to 3, characterized in that the step of generating a first accounting voucher according to the configuration information includes:
traversing the accounting voucher structures of the various accounting events in the configuration information, determining the voucher headers of the first accounting voucher, and determining the voucher row items of the first accounting voucher according to configuration conditions of the voucher row items; and traversing calculating rules of the various fields in the configuration information, and determining calculating rules of various fields in the first accounting voucher according to configuration conditions of the calculating rules.
traversing the accounting voucher structures of the various accounting events in the configuration information, determining the voucher headers of the first accounting voucher, and determining the voucher row items of the first accounting voucher according to configuration conditions of the voucher row items; and traversing calculating rules of the various fields in the configuration information, and determining calculating rules of various fields in the first accounting voucher according to configuration conditions of the calculating rules.
5. The method of generating an accounting voucher based on SAP according to Claim 4, characterized in that, when the calculating rule is a directly allocating rule, field calculation of the first accounting voucher includes:
directly assigning random one or more field(s) in business order data to the fields of the first accounting voucher.
directly assigning random one or more field(s) in business order data to the fields of the first accounting voucher.
6. The method of generating an accounting voucher based on SAP according to Claim 4, characterized in that, when the calculating rule is a form enquiring rule, field calculation of the first accounting voucher includes:
basing on random one or more field(s) in the business order data to search out from a condition intermediate table one or more field(s) corresponding thereto, and assigning the same to the fields of the first accounting voucher.
basing on random one or more field(s) in the business order data to search out from a condition intermediate table one or more field(s) corresponding thereto, and assigning the same to the fields of the first accounting voucher.
7. The method of generating an accounting voucher based on SAP according to Claim 4, characterized in that, when the calculating rule is a deriving rule, field calculation of the first accounting voucher includes:
Date Recue/Date Received 2022-01-31 basing on random one or more field(s) in the business order data to employ a derivation table to derive one or more field(s) corresponding thereto, and assigning the same to the fields of the first accounting voucher.
Date Recue/Date Received 2022-01-31 basing on random one or more field(s) in the business order data to employ a derivation table to derive one or more field(s) corresponding thereto, and assigning the same to the fields of the first accounting voucher.
8. The method of generating an accounting voucher based on SAP according to Claim 4, characterized in that, when the calculating rule is a code enhancing rule, field calculation of the first accounting voucher includes:
basing on random one or more field(s) of the business order data to assign the same to the fields of the first accounting voucher through ABAP language programming.
basing on random one or more field(s) of the business order data to assign the same to the fields of the first accounting voucher through ABAP language programming.
9. A device for generating an accounting voucher based on SAP and created according to anyone of Claims 1 to 8, characterized in comprising:
a data receiving module, for receiving business data integrated with accounting events as dimensions;
a voucher generating module, for generating a first accounting voucher, and including:
a configuring module, for searching for configuration information corresponding to the accounting events in pre-stored configuration data according to the accounting events, wherein the configuration information includes: accounting voucher structures of the various accounting events and calculating rules of various fields in the accounting voucher, and wherein the accounting voucher structures include: voucher headers and voucher row items;
and a calculating module, for generating the first accounting voucher according to the configuration information.
Date Recue/Date Received 2022-01-31
a data receiving module, for receiving business data integrated with accounting events as dimensions;
a voucher generating module, for generating a first accounting voucher, and including:
a configuring module, for searching for configuration information corresponding to the accounting events in pre-stored configuration data according to the accounting events, wherein the configuration information includes: accounting voucher structures of the various accounting events and calculating rules of various fields in the accounting voucher, and wherein the accounting voucher structures include: voucher headers and voucher row items;
and a calculating module, for generating the first accounting voucher according to the configuration information.
Date Recue/Date Received 2022-01-31
10.
The device for generating an accounting voucher based on SAP according to Claim 9, characterized in further comprising: an SAP module, for employing an external interface to invoke the configuration data according to the accounting events.
Date Recue/Date Received 2022-01-31
The device for generating an accounting voucher based on SAP according to Claim 9, characterized in further comprising: an SAP module, for employing an external interface to invoke the configuration data according to the accounting events.
Date Recue/Date Received 2022-01-31
Applications Claiming Priority (3)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910702304.5A CN110570291A (en) | 2019-07-31 | 2019-07-31 | Method and device for generating accounting document based on SAP system |
| CN201910702304.5 | 2019-07-31 | ||
| PCT/CN2020/097851 WO2021017694A1 (en) | 2019-07-31 | 2020-06-24 | Method and device for generating accounting document based on sap system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CA3150626A1 true CA3150626A1 (en) | 2021-02-04 |
Family
ID=68773238
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA3150626A Pending CA3150626A1 (en) | 2019-07-31 | 2020-06-24 | Method and device for generating accounting voucher based on sap system |
Country Status (3)
| Country | Link |
|---|---|
| CN (1) | CN110570291A (en) |
| CA (1) | CA3150626A1 (en) |
| WO (1) | WO2021017694A1 (en) |
Families Citing this family (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110570291A (en) * | 2019-07-31 | 2019-12-13 | 苏宁云计算有限公司 | Method and device for generating accounting document based on SAP system |
| CN113220797A (en) * | 2020-01-21 | 2021-08-06 | 浙江大搜车软件技术有限公司 | Information configuration method, device, system, computer device and storage medium |
| CN111381984B (en) * | 2020-03-09 | 2023-04-21 | 唐山钢铁集团有限责任公司 | Method for automatically generating accounting document without billing code by SAP system interface |
| CN111581246A (en) * | 2020-05-08 | 2020-08-25 | 北京字节跳动网络技术有限公司 | Method, device, electronic equipment and computer readable medium for generating data |
| CN112559613A (en) * | 2020-12-16 | 2021-03-26 | 深圳市中农网有限公司 | Voucher data extraction method and device, computer equipment and storage medium |
| CN113158857A (en) * | 2021-04-09 | 2021-07-23 | 陈世海 | Electronic accounting voucher processing method and device, electronic equipment and medium |
| CN113239770B (en) * | 2021-04-30 | 2022-12-20 | 国网河北省电力有限公司沧州供电分公司 | Financial statement accounting method |
| CN113094401B (en) * | 2021-05-07 | 2023-08-08 | 北京京东振世信息技术有限公司 | Target source data generation method, device, equipment and storage medium |
| CN113869875A (en) * | 2021-10-12 | 2021-12-31 | 北京机械工业自动化研究所有限公司 | Dynamic business document generation method |
| CN116932091B (en) * | 2023-09-15 | 2023-12-26 | 畅捷通信息技术股份有限公司 | Configuration file generation method and device during credential generation and storage medium |
Family Cites Families (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8364563B2 (en) * | 2007-10-11 | 2013-01-29 | Car Parts, Inc. Color Systems | System and method for standardizing accounting of consumables |
| US20140114817A1 (en) * | 2012-10-23 | 2014-04-24 | Clearwater Analytics, Llc | System and method for applying diverse accounting events to account balances and generating financial reports |
| CN105404950A (en) * | 2014-11-18 | 2016-03-16 | 国网山东省电力公司 | SAP park document realization method and system based on service configuration |
| CN109615492B (en) * | 2017-09-29 | 2021-11-30 | 北京华融启明风险管理技术股份有限公司 | Accounting voucher generation method and system |
| CN107705197A (en) * | 2017-10-24 | 2018-02-16 | 四川长虹电器股份有限公司 | Automatic bookkeeping methods based on controlling element in cloud finance platform |
| CN109409326A (en) * | 2018-11-09 | 2019-03-01 | 四川长虹电器股份有限公司 | A method of it is kept accounts automatically based on VAT invoice electronic data and generates voucher |
| CN109725898A (en) * | 2018-11-30 | 2019-05-07 | 平安科技（深圳）有限公司 | Configuration method, device, computer equipment and the storage medium of voucher rule |
| CN109785092A (en) * | 2018-12-10 | 2019-05-21 | 平安科技（深圳）有限公司 | Accounting voucher generates management method, device and computer equipment, storage medium |
| CN109636557A (en) * | 2018-12-11 | 2019-04-16 | 厦门商集网络科技有限责任公司 | A kind of intelligent classification bookkeeping methods and equipment based on bank slip recognition |
| CN110570291A (en) * | 2019-07-31 | 2019-12-13 | 苏宁云计算有限公司 | Method and device for generating accounting document based on SAP system |
-
2019
- 2019-07-31 CN CN201910702304.5A patent/CN110570291A/en active Pending
-
2020
- 2020-06-24 CA CA3150626A patent/CA3150626A1/en active Pending
- 2020-06-24 WO PCT/CN2020/097851 patent/WO2021017694A1/en active Application Filing
Also Published As
| Publication number | Publication date |
|---|---|
| CN110570291A (en) | 2019-12-13 |
| WO2021017694A1 (en) | 2021-02-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CA3150626A1 (en) | Method and device for generating accounting voucher based on sap system | |
| US7640195B2 (en) | Systems and method for automatic integrated document filing when logging business transactions | |
| US7908190B2 (en) | Systems and methods for applying tax legislation | |
| US7805348B2 (en) | Systems and methods enabling investment activities via the creation and use of client-specific security files | |
| US7523068B2 (en) | Centralized payment processing system | |
| US20110196767A1 (en) | Hierarchical transaction filtering | |
| US8745690B2 (en) | Deriving service provider constraints from service consumer context | |
| US20140095248A1 (en) | Supply chain financial orchestration system with task communication using universal format | |
| US20080109467A1 (en) | Data entity centric approach for designing workflows | |
| US20060036538A1 (en) | Systems and methods for improved merchant processing | |
| CN107980147B (en) | Tracking data flows in a distributed computing system | |
| CN115841395A (en) | Method and system for generating accounting entry data and related equipment | |
| US10235719B2 (en) | Centralized GAAP approach for multidimensional accounting to reduce data volume and data reconciliation processing costs | |
| US20050240537A1 (en) | Transaction Oriented Promotion Conflict Resolution | |
| WO2017145053A1 (en) | Systems and methods for resolving conflicts in order management of data products | |
| US11341581B2 (en) | System and method for regular expression generation for improved data transfer | |
| US20160239912A1 (en) | Approval system for buyer-initiated requisition modifications | |
| US20060195393A1 (en) | Creation of recurring transactions | |
| JPWO2019138670A1 (en) | Business management system and business management method | |
| US20230334453A1 (en) | Policy orchestrator | |
| US20230334500A1 (en) | Risk reserves | |
| JP7340080B2 (en) | Credit margin calculation device, credit margin calculation method, and credit margin calculation program | |
| JP7160665B2 (en) | Credit margin calculation device, credit margin calculation method, and credit margin calculation program | |
| US20160019631A1 (en) | System that dynamically determines sold-to legal entities | |
| CA2500393A1 (en) | Method and system for the automatic storage of business management data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| EEER | Examination request |
Effective date: 20220407 |
|
| EEER | Examination request |
Effective date: 20220407 |
|
| EEER | Examination request |
Effective date: 20220407 |
|
| EEER | Examination request |
Effective date: 20220407 |
|
| EEER | Examination request |
Effective date: 20220407 |
|
| EEER | Examination request |
Effective date: 20220407 |
|
| EEER | Examination request |
Effective date: 20220407 |
|
| EEER | Examination request |
Effective date: 20220407 |
|
| EEER | Examination request |
Effective date: 20220407 |
|
| EEER | Examination request |
Effective date: 20220407 |