Electricity charge voucher manufacturing method and device

Abstract

The invention provides an electric charge voucher making method and device. The method comprises the following steps: acquiring electric charge source file information; classifying the electricity charge source file information, and screening out information required by an electricity charge voucher; and converting the screened information into an electric charge voucher, and outputting and displaying the electric charge voucher. According to the scheme provided by the invention, the electric charge voucher template is manufactured through design software, and the electric charge voucher is generated through one key, so that the time is shortened by several times compared with manual manufacturing, the voucher manufacturing and auditing work efficiency is greatly improved, and the workload of manual accessory manufacturing is greatly reduced; and certificate production is automatically generated by a program, so that automatic typesetting can be realized, data errors possibly caused by manual operation are eliminated, the production error rate is reduced, and the working quality is improved.

Description

Technical Field

[0001] The present application relates to the technical field of power service management, and in particular to a method and device for producing electricity bill vouchers. Background Art

[0002] With the development of power business, electricity fee accounting, as a core component of electricity fee management, will directly affect the normal operation of the power supply department's power marketing business, and will also have a vital impact and significance on the sustainable development of power companies. In order to better promote electricity fee accounting, the marketing department of the power grid company needs to receive electricity fee accounting vouchers from various branches. In order to improve efficiency, the marketing department is responsible for receiving data and making vouchers and other related business work.

[0003] The process of classifying and recording the various expenses incurred by electricity users on the same day according to accounting subjects is called voucher production. In the traditional voucher production business, the production of voucher attachments has not been fully automated in the marketing system. The attachments of some vouchers have always been exported from the marketing system after the source data is exported, and then manually classified and filtered, the data is summed, and the table is laid out, and finally printed.

[0004] The data of vouchers and attachments are basically generated every day. Due to the huge amount of data and limited business personnel, the traditional voucher production model takes up a lot of working time of many business personnel. After the data is entered, the vouchers need to be manually typeset, and the business personnel are prone to fatigue and errors due to long working hours, which seriously affects the subsequent electricity fee accounting, issuance, and key tasks such as business norms and indicator control of local companies. Therefore, the voucher production model needs to be improved, intelligent means need to be added, and work efficiency needs to be improved. Summary of the invention

[0005] Multiple aspects of the present application provide a method and device for producing an electricity bill voucher, which can generate an electricity bill voucher with one click, improve the efficiency of electricity bill voucher production, and reduce the production error rate.

[0006] In order to achieve the above technical effects, one aspect of the present application provides a method for preparing an electricity bill voucher, comprising:

[0007] Get the electricity bill source file information;

[0008] Classify the electricity fee source file information and filter out the information required for the electricity fee voucher;

[0009] The filtered information is converted into electricity bill output and displayed.

[0010] According to a preferred embodiment of the present invention, the obtaining of electricity fee source file information further comprises:

[0011] Traverse the names of the started files to determine whether they contain the required electricity fee source files;

[0012] Get the electricity bill transfer bill and charge details from the electricity bill source file.

[0013] According to a preferred embodiment of the present invention, classifying the electricity fee source file information and filtering out the information required for the electricity fee voucher further includes:

[0014] Call different electricity bill voucher templates;

[0015] Filter and copy data information corresponding to the electricity fee voucher template from the electricity fee source file;

[0016] Classify the filtered data information according to the data required for each electricity bill voucher template.

[0017] According to a preferred embodiment of the present invention, the step of converting the filtered information into an electricity bill voucher and outputting and displaying the same further comprises:

[0018] Paste the classified data information into the corresponding electricity bill voucher template;

[0019] Arrange the data information of each electricity bill voucher template according to preset rules to form an electricity bill voucher;

[0020] Output and display the sorted electricity bill vouchers.

[0021] According to a preferred embodiment of the present invention, the step of arranging the data information of each electricity bill voucher template according to a preset rule to form an electricity bill voucher further includes:

[0022] Sort the data information of each electricity bill voucher template according to preset rules;

[0023] The sorted data information is calculated accordingly according to the formula preset in the electricity bill voucher template to obtain the result;

[0024] Adjust the electricity bill voucher template format to form an electricity bill voucher.

[0025] According to a preferred embodiment of the present invention, the step of adjusting the electricity bill voucher template format to form an electricity bill voucher further comprises:

[0026] Adjust the row and column size and font size of the electricity bill voucher template.

[0027] According to a preferred embodiment of the present invention, the method further comprises:

[0028] Update electricity bill voucher template regularly.

[0029] Another aspect of the present application provides an electricity bill voucher making device, comprising:

[0030] Data acquisition module: used to obtain electricity fee source file information;

[0031] Data screening module: used to classify the electricity fee source file information and screen out the information required for the electricity fee voucher;

[0032] Electricity bill voucher production module: used to convert the filtered information into electricity bill voucher output and display.

[0033] Another aspect of the present application provides a device for making an electricity bill voucher, the device comprising:

[0034] at least one processor; and

[0035] a memory communicatively connected to the at least one processor; wherein,

[0036] The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the method described above.

[0037] In another aspect of the present application, a computer-readable storage medium is provided, on which computer program instructions are stored. The computer program instructions can be executed by a processor to implement the above method.

[0038] In the solution provided in the embodiment of the present application, an electricity bill voucher template is produced by designing software, and an electricity bill voucher can be generated with one click, which shortens the time several times compared with manual production. The efficiency of voucher production and review is greatly improved, and the workload of manual production of attachments is greatly reduced. Moreover, the voucher production is automatically generated by the program, and automatic typesetting can be realized, eliminating data errors that may be caused by manual operation, reducing the production error rate, and improving the work quality. BRIEF DESCRIPTION OF THE DRAWINGS

[0039] In order to more clearly illustrate the technical solutions in the embodiments of the present application, a brief introduction will be given below to the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative labor.

[0040] Other features, objects and advantages of the present application will become more apparent by reading the detailed description of non-limiting embodiments made with reference to the following drawings:

[0041] Figure 1 A schematic diagram of a method for preparing an electricity bill voucher provided in one embodiment of the present application;

[0042] Figure 2 An electricity fee source file diagram provided for an embodiment of the present application;

[0043] Figure 3 An electricity bill voucher diagram provided for an embodiment of the present application;

[0044] Figure 4 A schematic diagram of the structure of an electricity bill voucher making device provided in one embodiment of the present application;

[0045] Figure 5 The present invention is a schematic diagram of the structure of a device suitable for implementing the solution in the embodiment of the present application.

[0046] The same or similar reference numerals in the drawings represent the same or similar components. DETAILED DESCRIPTION

[0047] In order to make the purpose, technical solution and advantages of the embodiments of the present application clearer, the technical solution in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.

[0048] In a typical configuration of the present application, the terminal and the equipment of the service network each include one or more processors (CPU), input / output interface, network interface and memory.

[0049] The memory may include non-permanent storage in a computer-readable medium, random access memory (RAM) and / or non-volatile memory in the form of read-only memory (ROM) or flash RAM. The memory is an example of a computer-readable medium.

[0050] Computer readable media include permanent and non-permanent, removable and non-removable media, and can be implemented by any method or technology to store information. Information can be computer program instructions, data structures, modules of programs or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, read-only compact disk (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic tape disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device.

[0051] In actual scenarios, the execution subject of the method can be a user device, or a device formed by integrating a user device and a network device through a network, or an application running on the above device. The user device includes but is not limited to various terminal devices such as computers, mobile phones, tablet computers, smart watches, and bracelets. The network device includes but is not limited to network hosts, single network servers, multiple network server sets, or cloud computing-based computer sets, which can be used to implement some processing functions when setting an alarm. Here, the cloud is composed of a large number of hosts or network servers based on cloud computing, where cloud computing is a type of distributed computing, a virtual computer composed of a group of loosely coupled computer sets.

[0052] The data of the existing voucher attachments are all present in the exported spreadsheet, which has several columns of data. Printing all of them will cause the layout (A4 paper displayed horizontally) to be crowded or incomplete on one page. During manual operation, the practices of companies in different cities are not exactly the same. Some will retain all columns, while others will delete several columns of unimportant data to make the content of the printed page reasonably distributed and displayed completely on one page. This will result in inconsistent formats of the summarized tables.

[0053] Figure 1 A schematic diagram of a method for making an electricity bill voucher is provided in accordance with an embodiment of the present application. Figure 1 As shown, the method includes:

[0054] S101, obtaining electricity charge source file information.

[0055] Specifically, the electricity bill source files include the electricity bill transfer slips, electricity bill refund slips, salesman's charging details and cashier's daily charging details of each subsidiary. It is necessary to produce at least eight electricity bill voucher electronic spreadsheets based on these electricity bill source files. For example, different electronic vouchers can be produced according to different charging items in the electricity bill source files, and different electronic vouchers can be produced according to different settlement methods or different charging types. Figure 2 An electricity fee source file diagram provided in an embodiment of the present application, such as Figure 2 As shown, the electricity fee source file is the toll collector's daily fee list, which contains multiple columns of important information such as the power supply unit, toll collector, payment method, settlement method, etc. When making an electricity fee voucher, it is necessary to generate a separate spreadsheet according to different columns and process and calculate according to the preset format.

[0056] First, name the electricity bill source file in a specific format. You can set the name in the system so that the electricity bill source file exported from the system is automatically named according to the naming requirements. Then open these electricity bill source files, use the VB programming language to edit and run the code, use the Private Sub Workbook_Open() code to start the background program, assign the source document file name exported by the system to the two-dimensional array Mar_arr(), and you can add new source document file names to the array at any time, which is easy to expand. Use the Call command to traverse the file names started, record the exported and opened source document workbook information into the dynamic array M_sheet(), match it with the correct file name in the background, and determine whether it contains the required electricity bill source file. If the required source files are not all opened, the program will pop up a window prompting "Please open the source document exported from the marketing system first."

[0057] Preferably, the software is run as a "macro" file, so it is necessary to set up the trusted software in the "Security Settings" of the spreadsheet software in advance, or select the "Enable Macro" button in the pop-up warning window each time you double-click to run the software.

[0058] S102: Classify the electricity fee source file information and filter out the information required for the electricity fee voucher.

[0059] Specifically, first call the electricity bill voucher template corresponding to the required electricity bill voucher, then call the data processing function, collect and filter out the data information required in the electricity bill voucher template from the electricity bill source file, and copy this information to the background clipboard, and finally classify the information in the clipboard according to the required data in each electricity bill voucher template.

[0060] Figure 3 An electricity bill voucher diagram provided in an embodiment of the present application, such as Figure 3 As shown, for example, if an electricity bill voucher template is internal bill_refund, the data information with the charge type of refund in the filtered data information is classified into one category.

[0061] S103: Convert the filtered information into electricity bill vouchers and output and display them.

[0062] Specifically, to paste the classified data information into the corresponding electricity bill voucher template, first identify the cell area to be pasted, define internal variables and assign values, and then select the corresponding data information in the clipboard and paste it into the area, for example Figure 3 , paste the data information with charge type as refund from the clipboard to the electricity bill voucher template of internal bill_refund, and then paste the cell area with the same row information with charge type as refund in the clipboard into the template according to the content of the column in the template of internal bill_refund.

[0063] After pasting is completed, the data information in the template is sorted, for example, in order of date, power supply unit, amount, etc. After sorting, the data information is calculated accordingly according to the preset formula in the electricity bill voucher template to obtain the result. For example, if the template needs to count the total amount, the column where the amount is located after sorting is summed and the result is counted. Finally, the entire template is adjusted according to the preset format requirements, such as setting different column widths and line spacing according to the content of the cell, adjusting the font size, etc., so that the adjusted electricity bill voucher meets the printing and binding requirements, and ensures that the number of lines per page of the printed voucher is the same. Preferably, the administrator can set whether to generate a print preview. If you choose to generate, the print preview interface will pop up.

[0064] Preferably, the electricity bill voucher template-related codes are updated regularly to ensure the accuracy of the calling template.

[0065] Table 1

[0066]

[0067] Table 1 is a comparison table of the time taken for manual production and software production, wherein documents ABCD are 4 source files, and 8 electricity bill vouchers are produced through these 4 source files. It can be seen from the table that the time taken for producing electricity bill vouchers using the software constructed using the method of the present invention is hundreds of times shorter than that for manual production, and the expected result is fully achieved.

[0068] In the method provided in the embodiment of the present invention, an electricity bill voucher template is produced by designing software, and an electricity bill voucher is generated with one click, which shortens the time several times compared with manual production, greatly improves the efficiency of voucher production and review, and greatly reduces the workload of manual production of attachments; and the voucher production is automatically generated by the program, which can realize automatic typesetting, eliminates data errors that may be caused by manual operation, reduces the production error rate, and improves the work quality.

[0069] Figure 4 A schematic diagram of a device for making an electricity bill voucher according to an embodiment of the present application is shown in FIG. Figure 4 As shown, the system comprises:

[0070] The data acquisition module 11 is used to acquire the electricity fee source file information.

[0071] The data screening module 22 is used to classify the electricity fee source file information and screen out the information required for the electricity fee voucher.

[0072] The electricity bill voucher making module 33 is used to convert the filtered information into an electricity bill voucher for output and display.

[0073] The above-mentioned device can execute the poultry breeding index evaluation method in the above-mentioned embodiment, wherein the data acquisition module 11 executes step S101; the data screening module 22 executes step S102; and the electricity bill voucher making module 33 executes step S103.

[0074] Based on the same inventive concept, an electronic device is also provided in an embodiment of the present application, and the method corresponding to the electronic device may be the method for making electricity bill vouchers in the aforementioned embodiment, and its principle of solving the problem is similar to that of the method. The electronic device provided in an embodiment of the present application includes: at least one processor; and a memory connected to the at least one processor in communication; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor so that the at least one processor can execute the methods and / or technical solutions of the aforementioned multiple embodiments of the present application.

[0075] The electronic device may be a user device, or a device formed by integrating a user device and a network device through a network, or may be an application running on the above device. The user device includes but is not limited to various terminal devices such as computers, mobile phones, tablet computers, smart watches, and bracelets. The network device includes but is not limited to network hosts, single network servers, multiple network server sets, or cloud computing-based computer sets, which can be used to implement some processing functions when setting an alarm. Here, the cloud is composed of a large number of hosts or network servers based on cloud computing, where cloud computing is a type of distributed computing, a virtual computer composed of a group of loosely coupled computer sets.

[0076] Figure 5 The structure of a device suitable for implementing the method and / or technical solution in the embodiment of the present application is shown, and the device 1200 includes a central processing unit (CPU, Central Processing Unit) 1201, which can perform various appropriate actions and processes according to the program stored in the read-only memory (ROM, Read Only Memory) 1202 or the program loaded from the storage part 1208 to the random access memory (RAM, Random Access Memory) 1203. In RAM1203, various programs and data required for system operation are also stored. CPU 1201, ROM 1202 and RAM 1203 are connected to each other through bus 1204. Input / output (I / O, Input / Output) interface 1205 is also connected to bus 1204.

[0077] The following components are connected to the I / O interface 1205: an input section 1206 including a keyboard, a mouse, a touch screen, a microphone, an infrared sensor, etc.; an output section 1207 including a cathode ray tube (CRT), a liquid crystal display (LCD), an LED display, an OLED display, etc., and a speaker, etc.; a storage section 1208 including one or more computer-readable media such as a hard disk, an optical disk, a magnetic disk, a semiconductor memory, etc.; and a communication section 1209 including a network interface card such as a LAN (Local Area Network) card, a modem, etc. The communication section 1209 performs communication processing via a network such as the Internet.

[0078] In particular, the methods and / or embodiments in the embodiments of the present application may be implemented as computer software programs. For example, the embodiments disclosed in the present application include a computer program product, which includes a computer program carried on a computer-readable medium, and the computer program includes program code for executing the method shown in the flowchart. When the computer program is executed by the central processing unit (CPU) 1201, the above functions defined in the method of the present application are executed.

[0079] Another embodiment of the present application further provides a computer-readable storage medium having computer program instructions stored thereon, wherein the computer program instructions can be executed by a processor to implement the methods and / or technical solutions of any one or more embodiments of the present application described above.

[0080] Specifically, the present embodiment may adopt any combination of one or more computer-readable media. The computer-readable medium may be a computer-readable signal medium or a computer-readable storage medium. The computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or device, or any combination thereof. More specific examples (non-exhaustive list) of computer-readable storage media include: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In this document, a computer-readable storage medium may be any tangible medium containing or storing a program that may be used by or in combination with an instruction execution system, device, or device.

[0081] Computer readable signal media may include data signals propagated in baseband or as part of a carrier wave, which carry computer readable program code. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer readable signal media may also be any computer readable medium other than a computer readable storage medium, which may send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device.

[0082] The program code embodied on the computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

[0083] Computer program code for performing the operation of the present application can be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, C++, and conventional procedural programming languages ​​such as "C" language or similar programming languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as an independent software package, partially on the user's computer and partially on a remote computer, or completely on a remote computer or server. In the case of a remote computer, the remote computer can be connected to the user's computer through any type of network including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computer (e.g., using an Internet service provider to connect through the Internet).

[0084] The flow chart or block diagram in the accompanying drawings shows the possible architecture, function and operation of the equipment, method and computer program product according to various embodiments of the present application. In this regard, each square box in the flow chart or block diagram can represent a module, a program segment or a part of a code, and the module, the program segment or a part of the code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some implementations as replacements, the functions marked in the square box can also occur in a sequence different from that marked in the accompanying drawings. For example, two square boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each square box in the block diagram and / or flow chart, and the combination of the square boxes in the block diagram and / or flow chart can be implemented with a dedicated system for hardware that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0085] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0086] In the several embodiments provided in the present application, it should be understood that the disclosed systems, devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation. For example, multiple units or page components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, devices or units, which can be electrical, mechanical or other forms.

[0087] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0088] The above-mentioned integrated unit implemented in the form of a software functional unit can be stored in a computer-readable storage medium. The above-mentioned software functional unit is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) or a processor to perform some steps of the method described in each embodiment of the present application. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), disk or optical disk and other media that can store program codes.

[0089] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit it. Although the present application has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application.

[0090] In addition, it is clear that the word "comprising" does not exclude other units or steps, and the singular does not exclude the plural. Multiple units or devices stated in a device claim can also be implemented by one unit or device through software or hardware. The words first, second, etc. are used to indicate names, and do not indicate any particular order.

Claims

1. A method for preparing an electricity bill voucher, characterized in that: include: Get the electricity bill source file information; Classify the electricity fee source file information and filter out the information required for the electricity fee voucher; The filtered information is converted into electricity bill output and displayed.

2. The method for making an electricity bill voucher according to claim 1, characterized in that: The obtaining of electricity fee source file information further includes: Traverse the names of the started files to determine whether they contain the required electricity fee source files; Get the electricity bill transfer bill and charge details from the electricity bill source file.

3. The method for making an electricity bill voucher according to claim 1, characterized in that: Classifying the electricity fee source file information and filtering out the information required for the electricity fee voucher further includes: Call different electricity bill voucher templates; Filter and copy data information corresponding to the electricity fee voucher template from the electricity fee source file; Classify the filtered data information according to the data required for each electricity bill voucher template.

4. The method for making an electricity bill voucher according to claim 3, characterized in that: The step of converting the filtered information into electricity bill voucher output and displaying it further comprises: Paste the classified data information into the corresponding electricity bill voucher template; Arrange the data information of each electricity bill voucher template according to preset rules to form an electricity bill voucher; Output and display the sorted electricity bill vouchers.

5. The method for making an electricity bill voucher according to claim 4, characterized in that: The step of arranging the data information of each electricity bill voucher template according to the preset rules to form an electricity bill voucher further includes: Sort the data information of each electricity bill voucher template according to preset rules; The sorted data information is calculated accordingly according to the formula preset in the electricity bill voucher template to obtain the result; Adjust the electricity bill voucher template format to form an electricity bill voucher.

6. The method for making an electricity bill voucher according to claim 5, characterized in that: The adjusting the electricity fee voucher template format to form the electricity fee voucher further comprises: Adjust the row and column size and font size of the electricity bill voucher template.

7. The method for making an electricity bill voucher according to claim 1, characterized in that: The method further comprises: Update electricity bill voucher template regularly.

8. An electricity bill voucher making device, characterized in that: include: Data acquisition module: used to obtain electricity fee source file information; Data screening module: used to classify the electricity fee source file information and screen out the information required for the electricity fee voucher; Electricity bill voucher production module: used to convert the filtered information into electricity bill voucher output and display.

9. A device for making electricity bill vouchers, the device comprising: at least one processor; as well as a memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the method according to any one of claims 1 to 7.

10. A computer readable medium having computer program instructions stored thereon, wherein the computer program instructions can be executed by a processor to implement the method according to any one of claims 1 to 7.

Images