CN112598454A - Method and system for generating purchase and sale documents by taking value-added tax invoices as data source - Google Patents
Method and system for generating purchase and sale documents by taking value-added tax invoices as data source Download PDFInfo
- Publication number
- CN112598454A CN112598454A CN202011578064.1A CN202011578064A CN112598454A CN 112598454 A CN112598454 A CN 112598454A CN 202011578064 A CN202011578064 A CN 202011578064A CN 112598454 A CN112598454 A CN 112598454A
- Authority
- CN
- China
- Prior art keywords
- data
- article
- unit
- item
- matching
- 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 27
- 238000006243 chemical reaction Methods 0.000 claims abstract description 116
- 238000005259 measurement Methods 0.000 claims abstract description 62
- 238000010586 diagram Methods 0.000 description 10
- 238000004590 computer program Methods 0.000 description 7
- 238000012545 processing Methods 0.000 description 6
- 229910052500 inorganic mineral Inorganic materials 0.000 description 5
- 239000011707 mineral Substances 0.000 description 5
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 5
- 230000006870 function Effects 0.000 description 4
- 238000013461 design Methods 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000012790 confirmation Methods 0.000 description 1
- 238000007796 conventional method Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/04—Billing or invoicing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/123—Tax preparation or submission
Landscapes
- Business, Economics & Management (AREA)
- Development Economics (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Theoretical Computer Science (AREA)
- Technology Law (AREA)
- Cash Registers Or Receiving Machines (AREA)
Abstract
The invention provides a method and a system for generating purchase and sale receipts by taking a value-added tax invoice as a data source, which are characterized in that a purchaser, goods information and a measurement unit in collected value-added tax invoice data are respectively matched with corresponding information in an established supplier/customer file, goods file and main and auxiliary measurement unit conversion file to generate first matching data, second matching data and third matching data in the purchase and sale receipts, information in the value-added tax invoice data is extracted according to a preset receipt value-taking rule for receipt items except for receipt items related to the supplier/customer, the goods information and the main and auxiliary measurement units in the purchase and sale receipts to generate fourth matching data, and finally the matched data are combined according to a sequence to generate the purchase and sale receipts. The method and the system solve the problem that in the prior art, when the purchase and sale receipt is made, the information of the supplier/customer and the goods needs to be input manually, and effectively improve the management efficiency of the purchase and sale business of the user.
Description
Technical Field
The invention relates to the field of electronic invoices, in particular to a method and a system for generating purchase and sale documents by taking value-added tax invoices as a data source.
Background
The purchase and sale bill is a core bill of the enterprise for recording the inventory purchase and sale business. Due to the diversity of business, the business purchase and sale orders of enterprises are designed to be eight-door, and even the purchase and sale orders are filled manually, which causes that the offline data acquisition of the purchase and sale orders is difficult to be converted into the structured data available by the management system. Therefore, many conventional enterprises still use paper purchase and sales documents to manually make system purchase and sales orders in management software. In addition, the enterprise finance and tax management requires matching the purchase and sale service with the invoice, establishing the connection between the invoice and the service, and the connection can be processed only by manpower; finally, the traditional management software is also mostly in a manual entry mode for processing the basic files of the customers, the suppliers and the articles. It is obvious that the conventional method is very inefficient.
The value-added tax invoice is used as the legal purchase and sale business and financial confirmation evidence of the state, has the characteristics of uniform format and acquirable structured data, and records the main business information required by purchase and sale bills of customers, suppliers, purchase and sale articles and the like on the bill surface, so the design considers that the invoice is used as a core document to create the purchase and sale bill, the customer, the supplier archive and the article archive in enterprise management software.
Disclosure of Invention
In order to solve the technical problem that the manual entry mode for processing purchase and sale receipts and basic files of customers, suppliers and articles in the prior art is low in efficiency, the invention provides a method for generating the purchase and sale receipts by taking value-added tax receipts as a data source, which comprises the following steps:
based on the income/sales item value-added tax invoice data with detailed information, calling a pre-established supplier/customer file according to a service request for generating an income/sales bill, and matching the supplier/customer information in the file with the selling/purchasing party information in the invoice data to generate first matching data of a purchase and sales bill;
selecting an article matching scale parameter and an article archive generation mode;
calling a pre-established article file according to the selected article matching scale parameter and the article file generation mode, matching the article information of the article file with the article information in the invoice data, and generating second matching data of the purchase and sale receipt;
calling a pre-established main and auxiliary metering unit conversion file for the articles in the second matching data, matching the main metering unit of the articles in the main and auxiliary metering unit conversion file with the unit of the corresponding articles in the invoice data, and generating third matching data of purchase and sale receipts;
according to a preset bill value-taking rule, extracting fourth matching data for generating purchase-sale bills from the invoice data;
and combining the first matching data, the second matching data, the third matching data and the fourth matching data in sequence to generate a purchase and sale receipt.
Further, the method for matching the customer/supplier based on the value-added tax invoice data of the purchase and sale item with detailed information calls a pre-established customer/supplier file to match the customer/supplier according to the service request for generating the purchase and sale bill, and before generating the first matching data of the purchase and sale bill, the method further comprises the following steps:
collecting the name and the tax number of a client/supplier in the historical data of the value-added tax invoice to establish a client/supplier file;
collecting the article name and specification model in the value-added tax invoice historical data to establish an article file;
setting an article matching scale parameter and an article file generation mode, wherein the article matching scale parameter comprises an article name scale and an article name plus specification model scale, and the article file generation mode comprises an automatic file generation mode and a manual file generation mode;
collecting article information and measurement units in the value-added tax invoice historical data to establish a main and auxiliary measurement unit conversion file, wherein the main and auxiliary measurement unit conversion file comprises the article information, the main measurement unit and the conversion relation between the main measurement unit and the auxiliary measurement unit, the article information comprises an article name and a specification model, and the auxiliary measurement unit is a measurement unit of the article in the value-added tax invoice historical data except the main measurement unit;
and setting a bill dereferencing rule, wherein the bill dereferencing rule is that the dereferencing of the bill items except the bill items corresponding to the first matching data, the second matching data and the third matching data in the purchase and sale bill is equal to the dereferencing of the corresponding items in the invoice data.
Further, the step of calling a pre-established supplier/customer file according to a service request for generating an income/sales bill based on the income/sales item value-added tax invoice data with detailed information, matching the supplier/customer information in the file with the sales/purchase party information in the invoice data, and generating first matching data of a purchase and sales bill comprises:
recording a supplier/customer name in a supplier/customer profile as first name data when the seller/buyer information in the invoice data matches the supplier/customer information in the supplier/customer profile, wherein the supplier/customer information includes the name and tax number of the supplier/customer and the seller/buyer information includes the name and tax number of the seller/buyer;
when the information of the seller/buyer in the invoice data does not match any item of the information of the seller/client in the archive, automatically updating the archive of the seller/client, adding the information of the seller/buyer in the invoice data as new information of the seller/client in the archive of the seller/client, and recording the new name of the seller/client as second name data;
and merging and recording the first name data and the second name data into first matching data for generating the purchase and sale bill.
Further, the step of calling a pre-established article file according to the selected article matching scale parameter and the article file generation mode, matching the article information of the article file with the article information in the invoice data, and generating second matching data of the purchase and sale receipt comprises:
when the item information of the item file is matched with the item information in the invoice data according to the selected item matching scale parameter, recording the item information in the item file as first item data, wherein the item information comprises an item name and a specification model;
when the article information of the article file is not matched with the article information in the invoice data according to the selected article matching scale parameter, updating the article file according to a selected article file generation mode, adding the article information in the invoice data as new article information in the article file, or matching the article information in the invoice data with the existing article information in the article file, and after generating a matching relationship, recording the new article information, or using the existing article information in the article file corresponding to the matching relationship as second article data;
and merging and recording the first article data and the second article data into second matching data for generating purchase and sale receipts.
Further, for the article in the second matching data, calling a pre-established master and slave metering unit conversion file, matching the master metering unit of the article in the master and slave metering unit conversion file with the unit of the corresponding article in the invoice data, and generating third matching data of the purchase and sale receipt comprises:
when the main metering unit of the article in the main and auxiliary metering unit conversion file is matched with the unit of the corresponding article in the invoice data, recording the article unit in the invoice data, wherein the article quantity and the tax-free unit price are first main metering data;
when the main metering unit of the article in the main and auxiliary metering unit conversion file is not matched with the unit of the corresponding article in the invoice data, if the conversion relation between the main metering unit of the article and the unit of the corresponding article in the invoice data exists in the main and auxiliary metering unit conversion file, calculating and determining the main metering quantity of the article and the main metering tax-free unit price in the purchase and sale bill according to the quantity of the article and the tax-free unit price in the invoice data according to the conversion relation, and taking the main metering unit of the article, the calculated and determined main metering quantity of the article and the main metering tax-free unit price of the article in the main and auxiliary metering unit conversion file as second main metering data; if the conversion relation between the main metering unit of the article and the corresponding unit of the article in the invoice data does not exist in the main and auxiliary metering unit conversion file, updating the main and auxiliary metering unit conversion file, increasing the conversion relation between the main metering unit and the metering unit in the invoice data, calculating and determining the main metering quantity of the article and the main metering tax-free unit price in the purchase and sale bill according to the increased conversion relation and the quantity of the article and the tax-free unit price in the invoice data, and taking the main metering unit of the article, the calculated and determined main metering quantity of the article and the main metering tax-free unit price of the article in the main and auxiliary metering unit conversion file as second main metering data;
and combining and recording the first main metering data and the second main metering data into third matching data for generating the purchase and sale documents.
According to another aspect of the present invention, the present invention provides a system for generating purchase and sale documents by using value-added tax invoices as a data source, the system comprising:
the first matching data unit is used for calling a pre-established supplier/customer file according to a service request for generating an incoming/outgoing bill based on incoming/outgoing item value-added tax invoice data with detailed line information, matching the supplier/customer information in the file with the selling/purchasing party information in the invoice data, and generating first matching data of a purchase and outgoing bill;
a parameter mode selection unit for selecting an item matching scale parameter and an item archive generation mode;
the second matching data unit is used for calling a pre-established article file according to the selected article matching scale parameter and the article file generation mode, matching the article information of the article file with the article information in the invoice data and generating second matching data of the purchase and sale receipt;
a third matching data unit, configured to invoke a pre-established primary and secondary metering unit conversion file for an article in second matching data, match the primary metering unit of the article in the primary and secondary metering unit conversion file with the unit of the corresponding article in the invoice data, and generate third matching data of a purchase and sale receipt;
the fourth matching data unit is used for extracting and generating fourth matching data of the purchase and sale bill from the invoice data according to a preset bill dereferencing rule;
and the purchase and sale bill generating unit is used for combining the first matching data, the second matching data, the third matching data and the fourth matching data in sequence to generate a purchase and sale bill.
Further, the system further comprises:
the file generation unit is used for collecting the client/provider name and the tax number in the value-added tax invoice historical data to establish a client/provider file; collecting the article name and specification model in the value-added tax invoice historical data to establish an article file; collecting article information and measurement units in the value-added tax invoice historical data to establish a main and auxiliary measurement unit conversion file, wherein the main and auxiliary measurement unit conversion file comprises the article information, the main measurement unit and the conversion relation between the main measurement unit and the auxiliary measurement unit, the article information comprises an article name and a specification model, and the auxiliary measurement unit is a measurement unit of the article in the value-added tax invoice historical data except the main measurement unit;
the system comprises an initial setting unit and a receipt dereferencing rule, wherein the initial setting unit is used for setting an article matching scale parameter and an article archive generation mode, and setting a receipt dereferencing rule, the article matching scale parameter comprises an article name scale and an article name plus specification model scale, the article archive generation mode comprises an automatic archive generation mode and a manual archive generation mode, and the receipt dereferencing rule is that the dereferencing of receipt items except receipt items corresponding to first matching data, second matching data and third matching data in a purchase and sale receipt is equal to the dereferencing of corresponding items in the receipt data.
Further, the first match data unit includes:
a first name data unit for recording a supplier/customer name in a supplier/customer profile as first name data when the seller/buyer information in the invoice data matches the supplier/customer information in the supplier/customer profile, wherein the supplier/customer information includes the name and tax number of the supplier/customer, and the seller/buyer information includes the name and tax number of the seller/buyer;
a second name data unit for automatically updating the supplier/customer profile when the seller/buyer information in the invoice data does not match any one of the supplier/customer information in the profile, adding the seller/buyer information in the invoice data as new supplier/customer information in the supplier/customer profile, and recording the new supplier/customer name as second name data;
and the name data merging unit is used for merging and recording the first name data and the second name data into first matching data for generating purchase and sale documents.
Further, the second match data unit includes:
a first item data unit, configured to record item information in an item archive as first item data when item information in the item archive matches item information in the invoice data according to the selected item matching scale parameter, where the item information includes an item name and a specification model;
a second item data unit, configured to update an item file according to a selected item file generation mode when item information of the item file is not matched with item information in the invoice data according to a selected item matching scale parameter, add the item information in the invoice data as new item information in the item file, or match the item information in the invoice data with existing item information in the item file, and after a matching relationship is generated, record new item information, or use the existing item information in the item file corresponding to the matching relationship as second item data;
and the article data merging unit is used for merging and recording the first article data and the second article data into second matching data for generating purchase and sale receipts.
Further, the third matching data unit includes:
a first main metering data unit, which is used for recording the item unit in the invoice data when the main metering unit of the item in the main and auxiliary metering unit conversion file is matched with the unit of the corresponding item in the invoice data, wherein the item quantity and the tax-free unit price are the first main metering data;
a second main metering data unit, configured to, when the main metering unit of the item in the main and auxiliary metering unit conversion file does not match the unit of the corresponding item in the invoice data, if a conversion relationship exists between the main metering unit of the item and the unit of the corresponding item in the invoice data in the main and auxiliary metering unit conversion file, calculate and determine, according to the conversion relationship, the main metering amount of the item and the main non-tax unit price of the item in the purchase and sale receipt according to the amount of the item and the non-tax unit price in the invoice data, and use the main metering unit of the item, the calculated and determined main metering amount of the item and the main non-tax unit price of the item in the main and auxiliary metering unit conversion file as second main metering data; if the conversion relation between the main metering unit of the article and the corresponding unit of the article in the invoice data does not exist in the main and auxiliary metering unit conversion file, updating the main and auxiliary metering unit conversion file, increasing the conversion relation between the main metering unit and the metering unit in the invoice data, calculating and determining the main metering quantity of the article and the main metering tax-free unit price in the purchase and sale bill according to the increased conversion relation and the quantity of the article and the tax-free unit price in the invoice data, and taking the main metering unit of the article, the calculated and determined main metering quantity of the article and the main metering tax-free unit price of the article in the main and auxiliary metering unit conversion file as second main metering data;
and the master metering data merging unit is used for merging and recording the first master metering data and the second master metering data into third matching data for generating purchase and sale documents.
The method and the system for generating the purchase and sale receipt by taking the value-added tax invoice as the data source establish a supplier/customer file, an article file and a main and auxiliary metering unit conversion file based on the historical data of the collected invoice, on the basis, the seller, the article information and the metering unit in the collected value-added tax invoice data are respectively matched with corresponding information in the established supplier/customer file, the article file and the main and auxiliary metering unit conversion file, when the seller, the article information and the metering unit conversion file are matched, the corresponding information in the invoice is automatically extracted to be used as first matching data, second matching data and third matching data in the purchase and sale receipt, when the seller, the customer and the metering unit conversion file cannot be matched, the supplier/customer file, the article file and the main and auxiliary metering unit conversion file are updated, a new matching relation is established, and the purchase and sale receipt except the supplier/customer, the main and auxiliary metering unit conversion file are updated, And extracting information in the value-added tax invoice data according to a preset invoice value-taking rule to generate fourth matching data by using invoice items except the invoice items related to the article information and the main and auxiliary metering units, and combining the first matching data, the second matching data, the third matching data and the fourth matching data in sequence to generate purchase and sale receipts. The method and the system for generating the purchase and sale receipt by taking the value-added tax invoice as the data source solve the problems that in the prior art, when the purchase and sale receipt is made, the supplier/customer information and the article information need to be manually input, the established supplier/customer file and the article file are firstly established based on the historical data, and then the established file is updated at any time in the process of making the purchase and sale receipt based on the new value-added tax invoice data, so that the file data is continuously enriched, and the data support is independently provided for creating the purchase and sale receipt. In addition, the invention also designs the item matching scale parameter for the user to select, and designs the conversion of the main and auxiliary measurement of the item, thereby helping the user to realize various specific scene requirements when generating the purchase and sale receipt and effectively improving the management efficiency of the purchase and sale business of the user.
Drawings
A more complete understanding of exemplary embodiments of the present invention may be had by reference to the following drawings in which:
FIG. 1 is a flow chart of a method for generating a purchase and sale document with a value-added tax invoice as a data source according to a preferred embodiment of the invention;
fig. 2 is a schematic structural diagram of a system for generating purchase and sale documents by using a value-added tax invoice as a data source according to a preferred embodiment of the invention.
Detailed Description
The exemplary embodiments of the present invention will now be described with reference to the accompanying drawings, however, the present invention may be embodied in many different forms and is not limited to the embodiments described herein, which are provided for complete and complete disclosure of the present invention and to fully convey the scope of the present invention to those skilled in the art. The terminology used in the exemplary embodiments illustrated in the accompanying drawings is not intended to be limiting of the invention. In the drawings, the same units/elements are denoted by the same reference numerals.
Unless otherwise defined, terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. Further, it will be understood that terms, such as those defined in commonly used dictionaries, should be interpreted as having a meaning that is consistent with their meaning in the context of the relevant art and will not be interpreted in an idealized or overly formal sense.
Fig. 1 is a flowchart of a method for generating purchase and sale documents by using a value-added tax invoice as a data source according to a preferred embodiment of the invention. As shown in fig. 1, the method for generating a purchase and sale document using a value-added tax invoice as a data source according to the preferred embodiment starts from step 101.
In step 101, collecting the name and tax number of a client/supplier in the historical data of the value-added tax invoice to establish a client/supplier file; collecting the article name and specification model in the value-added tax invoice historical data to establish an article file; setting an article matching scale parameter and an article file generation mode, wherein the article matching scale parameter comprises an article name scale, an article name plus specification model scale, and the article file generation mode comprises an automatic file generation mode and a manual file generation mode; collecting article information and measurement units in the value-added tax invoice historical data to establish a main and auxiliary measurement unit conversion file, wherein the main and auxiliary measurement unit conversion file comprises the article information, the main measurement unit and the conversion relation between the main measurement unit and the auxiliary measurement unit, the article information comprises article names and specification models, and the auxiliary measurement unit is a measurement unit of the articles in the value-added tax invoice historical data except the main measurement unit. When the purchase and sale receipt is generated, there is usually a main metering unit, for example, for mineral water, the main metering unit may be a box, but the unit in the invoice may be a box, a bottle, a piece, when the main metering unit does not match the invoice unit, the number, unit price and the like under the main metering unit need to be converted to meet the requirements of different users. Similarly, different users have different requirements on the item information, some users only need to know the item name, such as mineral water, and some users need to clearly know whether the mineral water is in the 350ml specification or the 1L specification, so that when the file is built, the item information comprises the item name and the specification type, and good data support is provided for the users to freely select the item matching scale when the subsequent generation, purchase and sale are independent.
In step 102, a bill value taking rule is set, wherein the bill value taking rule is that the value of the bill items except the bill items corresponding to the first matching data, the second matching data and the third matching data in the purchase and sale bill is equal to the value of the corresponding items in the invoice data. In the purchase and sale documents, the document items except the document items needing to be matched with the invoice items in the invoice data can be directly valued from the invoice in general, for example, the document number directly values the invoice number of the invoice, the document date directly values the invoice date, the tax free unit price directly values the unit price of the invoice line, and the like.
In step 103, based on the income/sales item value-added tax invoice data with detailed information, according to the service request for generating the income/sales bill, a pre-established supplier/customer file is called, the supplier/customer information in the file is matched with the sales/purchase party information in the invoice data, and first matching data of the purchase and sales bill is generated.
Preferably, the generating of the first matching data of the purchase and sale receipt comprises:
recording a supplier/customer name in a supplier/customer profile as first name data when the seller/buyer information in the invoice data matches the supplier/customer information in the supplier/customer profile, wherein the supplier/customer information includes the name and tax number of the supplier/customer and the seller/buyer information includes the name and tax number of the seller/buyer;
when the selling/purchasing party information in the invoice data does not match any one of the supplier/client information in the archive, automatically updating the supplier/client archive, adding the selling/purchasing party information in the invoice data as new supplier/client information in the supplier/client archive, and recording the new supplier/client name as second name data. By updating the supplier/client profile and recording the new supplier/client name as the second name data, all the supplier/client information in the invoice data can be recorded in the purchase and sale receipt, and the accuracy of the data is ensured.
And merging and recording the first name data and the second name data into first matching data for generating the purchase and sale bill.
In step 104, an item matching scale parameter and an item profile generation mode are selected. According to different requirements of users, the item matching scale parameter can select an item name scale, and can also select an item name plus specification type scale. The object file generation mode can select an automatic file generation mode or a manual file generation mode.
In step 105, according to the selected item matching scale parameter and the item archive generation mode, a pre-established item archive is called, item information of the item archive is matched with item information in the invoice data, and second matching data of the purchase and sale receipt is generated.
Preferably, the step of calling a pre-established article archive according to the selected article matching scale parameter and the article archive generation mode, matching the article information of the article archive with the article information in the invoice data, and generating second matching data of the purchase and sale receipt includes:
when the item information of the item file is matched with the item information in the invoice data according to the selected item matching scale parameter, recording the item information in the item file as first item data, wherein the item information comprises an item name and a specification model;
when the article information of the article file is not matched with the article information in the invoice data according to the selected article matching scale parameter, updating the article file according to a selected article file generation mode, adding the article information in the invoice data as new article information in the article file, or matching the article information in the invoice data with the existing article information in the article file, and after generating a matching relationship, recording the new article information, or using the existing article information in the article file corresponding to the matching relationship as second article data. When the selected article file generation mode is the automatic generation file generation mode, the article information in the invoice data can be automatically added to the article file to serve as new article information, or the article information in the invoice data can be matched with the existing article information in the article file, for example, when mineral water with the specification of 1.25L is not contained in the article file, the article file can be added into the article file, or the article file can be matched with the article information of 1L or more mineral water in the article file. By updating the article file and recording new article information as second-name article data, or recording the existing article information in the file as second article data after the article information in the invoice data establishes a matching relationship with the existing article information in the article file, all the article information in the invoice data can be recorded in the purchase and sale receipt, and the accuracy of the data is ensured.
And merging and recording the first article data and the second article data into second matching data for generating purchase and sale receipts.
In step 106, for the article in the second matching data, a pre-established main and auxiliary metering unit conversion file is called, the main metering unit of the article in the main and auxiliary metering unit conversion file is matched with the unit of the corresponding article in the invoice data, and third matching data of the purchase and sale receipt is generated.
Preferably, for the items in the second matching data, a pre-established master and slave metering unit conversion file is called, the master metering unit of the items in the master and slave metering unit conversion file is matched with the corresponding unit of the items in the invoice data, and the third matching data for generating the purchase and sale receipt includes:
when the main metering unit of the article in the main and auxiliary metering unit conversion file is matched with the unit of the corresponding article in the invoice data, recording the article unit in the invoice data, wherein the article quantity and the tax-free unit price are first main metering data;
when the main metering unit of the article in the main and auxiliary metering unit conversion file is not matched with the unit of the corresponding article in the invoice data, if the conversion relation between the main metering unit of the article and the unit of the corresponding article in the invoice data exists in the main and auxiliary metering unit conversion file, calculating and determining the main metering quantity of the article and the main metering tax-free unit price in the purchase and sale bill according to the quantity of the article and the tax-free unit price in the invoice data according to the conversion relation, and taking the main metering unit of the article, the calculated and determined main metering quantity of the article and the main metering tax-free unit price of the article in the main and auxiliary metering unit conversion file as second main metering data; if the conversion relation between the main metering unit of the article and the corresponding unit of the article in the invoice data does not exist in the main and auxiliary metering unit conversion file, updating the main and auxiliary metering unit conversion file, increasing the conversion relation between the main metering unit and the metering unit in the invoice data, calculating and determining the main metering quantity of the article and the main metering tax-free unit price in the purchase and sale bill according to the increased conversion relation and the quantity of the article and the tax-free unit price in the invoice data, and taking the main metering unit of the article, the calculated and determined main metering quantity of the article and the main metering tax-free unit price of the article in the main and auxiliary metering unit conversion file as second main metering data;
and combining and recording the first main metering data and the second main metering data into third matching data for generating the purchase and sale documents.
In step 107, according to a preset document value-taking rule, fourth matching data for generating purchase and sale documents is extracted from the invoice data.
And step 108, combining the first matching data, the second matching data, the third matching data and the fourth matching data in sequence to generate a purchase and sale receipt.
Table 1 is an example table of values of main document items in the method for generating purchase and sale documents by using value-added tax invoices as data sources according to the present invention.
TABLE 1
Fig. 2 is a schematic structural diagram of a system for generating purchase and sale documents by using a value-added tax invoice as a data source according to a preferred embodiment of the invention. As shown in fig. 2, the system 200 for generating a purchase and sale document using a value-added tax invoice as a data source according to the preferred embodiment includes:
a file generation unit 201 for collecting the client/provider name and tax number in the value-added tax invoice history data to establish a client/provider file; collecting the article name and specification model in the value-added tax invoice historical data to establish an article file; collecting article information and measurement units in the value-added tax invoice historical data to establish a main and auxiliary measurement unit conversion file, wherein the main and auxiliary measurement unit conversion file comprises the article information, the main measurement unit and the conversion relation between the main measurement unit and the auxiliary measurement unit, the article information comprises an article name and a specification model, and the auxiliary measurement unit is a measurement unit of the article in the value-added tax invoice historical data except the main measurement unit;
the system comprises an initial setting unit 202, which is used for setting an article matching scale parameter and an article archive generation mode, and setting a receipt dereferencing rule, wherein the article matching scale parameter comprises an article name scale and an article name plus specification model scale, the article archive generation mode comprises an automatic archive generation mode and a manual archive generation mode, and the receipt dereferencing rule is that the dereferencing of receipt items except receipt items corresponding to first matching data, second matching data and third matching data in a purchase and sale receipt is equal to the dereferencing of corresponding items in the receipt data.
A first matching data unit 203, configured to call a pre-established supplier/customer file according to a service request for generating an income/sales bill based on income/sales item value-added tax invoice data with detailed line information, match the supplier/customer information in the file with the sales/purchase party information in the invoice data, and generate first matching data of a purchase and sales bill;
a parameter mode selection unit 204 for selecting an item matching scale parameter and an item archive generation mode;
a second matching data unit 205, configured to invoke a pre-established article file according to the selected article matching scale parameter and the article file generation mode, match the article information of the article file with the article information in the invoice data, and generate second matching data of the purchase and sale receipt;
a third matching data unit 206, configured to invoke a pre-established primary and secondary metering unit conversion file for an article in the second matching data, match the primary metering unit of the article in the primary and secondary metering unit conversion file with the unit of the corresponding article in the invoice data, and generate third matching data of a purchase and sale receipt;
a fourth matching data unit 207, configured to extract fourth matching data for generating a purchase and sale receipt from the invoice data according to a preset receipt dereferencing rule;
and a purchase and sale document generating unit 208 for combining the first matching data, the second matching data, the third matching data and the fourth matching data in order to generate a purchase and sale document.
Preferably, the first matching data unit 203 comprises:
a first name data unit 232 for recording a supplier/customer name in a supplier/customer profile as first name data when the sales/purchase party information in the invoice data matches the supplier/customer information in the supplier/customer profile, wherein the supplier/customer information includes the name and tax number of the supplier/customer, and the sales/purchase party information includes the name and tax number of the sales/purchase party;
a second name data unit 232 for automatically updating the supplier/customer profile when the seller/buyer information in the invoice data does not match any one of the supplier/customer information in the profile, adding the seller/buyer information in the invoice data as new supplier/customer information in the supplier/customer profile, and recording the new supplier/customer name as second name data;
and a name data merging unit 233 for merging and recording the first name data and the second name data as first matching data for generating a purchase and sale document.
Preferably, the second matching data unit 205 comprises:
a first item data unit 251, configured to record item information in an item archive as first item data when item information in the item archive matches item information in the invoice data according to the selected item matching scale parameter, where the item information includes an item name and a specification model;
a second item data unit 252, configured to update an item file according to a selected item file generation mode when the item information of the item file is not matched with the item information in the invoice data according to a selected item matching scale parameter, add the item information in the invoice data as new item information in the item file, or match the item information in the invoice data with existing item information in the item file, and after a matching relationship is generated, record new item information, or use existing item information in the item file corresponding to the matching relationship as second item data;
and an item data merging unit 253 for merging and recording the first item data and the second item data into second matching data for generating purchase and sale orders.
Preferably, the third matching data unit 206 comprises:
a first main measurement data unit 261 for recording the item unit in the invoice data when the main measurement unit of the item in the main and auxiliary measurement unit conversion file matches the unit of the corresponding item in the invoice data, the item amount and the tax free unit price being the first main measurement data;
a second main metering data unit 262, configured to, when the main metering unit of the item in the main and auxiliary metering unit conversion file does not match the unit of the corresponding item in the invoice data, if a conversion relationship exists between the main metering unit of the item and the unit of the corresponding item in the invoice data in the main and auxiliary metering unit conversion file, calculate and determine the main metering amount of the item and the main metering tax-free unit price in the purchase and sale bill according to the conversion relationship and the number of the item and the tax-free unit price in the invoice data, and use the main metering unit of the item, the calculated and determined main metering amount of the item and the main metering tax-free unit price in the main and auxiliary metering unit conversion file as second main metering data; if the conversion relation between the main metering unit of the article and the corresponding unit of the article in the invoice data does not exist in the main and auxiliary metering unit conversion file, updating the main and auxiliary metering unit conversion file, increasing the conversion relation between the main metering unit and the metering unit in the invoice data, calculating and determining the main metering quantity of the article and the main metering tax-free unit price in the purchase and sale bill according to the increased conversion relation and the quantity of the article and the tax-free unit price in the invoice data, and taking the main metering unit of the article, the calculated and determined main metering quantity of the article and the main metering tax-free unit price of the article in the main and auxiliary metering unit conversion file as second main metering data;
and a master metering data merging unit 263, configured to merge and record the first master metering data and the second master metering data as third matching data for generating the purchase and sale document.
The steps of the system for generating the purchase and sale receipt by taking the value-added tax invoice as the data source to manufacture the purchase and sale receipt are the same as the steps adopted by the method for generating the purchase and sale receipt by taking the value-added tax invoice as the data source, the technical effect is the same, and the details are not repeated.
The invention has been described with reference to a few embodiments. However, other embodiments of the invention than the one disclosed above are equally possible within the scope of the invention, as would be apparent to a person skilled in the art from the appended patent claims.
Generally, all terms used in the claims are to be interpreted according to their ordinary meaning in the technical field, unless explicitly defined otherwise herein. All references to "a/an/the [ device, component, etc ]" are to be interpreted openly as referring to at least one instance of said device, component, etc., unless explicitly stated otherwise. The steps of any method disclosed herein do not have to be performed in the exact order disclosed, unless explicitly stated.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
Finally, it should be noted that: the above embodiments are only for illustrating the technical solutions of the present invention and not for limiting the same, and although the present invention is described in detail with reference to the above embodiments, those of ordinary skill in the art should understand that: modifications and equivalents may be made to the embodiments of the invention without departing from the spirit and scope of the invention, which is to be covered by the claims.
Claims (10)
1. A method for generating purchase and sale documents by taking value-added tax invoices as a data source is characterized by comprising the following steps:
based on the income/sales item value-added tax invoice data with detailed information, calling a pre-established supplier/customer file according to a service request for generating an income/sales bill, and matching the supplier/customer information in the file with the selling/purchasing party information in the invoice data to generate first matching data of a purchase and sales bill;
selecting an article matching scale parameter and an article archive generation mode;
calling a pre-established article file according to the selected article matching scale parameter and the article file generation mode, matching the article information of the article file with the article information in the invoice data, and generating second matching data of the purchase and sale receipt;
calling a pre-established main and auxiliary metering unit conversion file for the articles in the second matching data, matching the main metering unit of the articles in the main and auxiliary metering unit conversion file with the unit of the corresponding articles in the invoice data, and generating third matching data of purchase and sale receipts;
according to a preset bill value-taking rule, extracting fourth matching data for generating purchase-sale bills from the invoice data;
and combining the first matching data, the second matching data, the third matching data and the fourth matching data in sequence to generate a purchase and sale receipt.
2. The method as claimed in claim 1, wherein, before generating the first matching data of the purchase and sale bill, the method further comprises, based on the value-added tax invoice data of the purchase and sale item with detailed information, calling a pre-established customer/supplier profile for customer/supplier matching according to the service request for generating the purchase and sale bill:
collecting the name and the tax number of a client/supplier in the historical data of the value-added tax invoice to establish a client/supplier file;
collecting the article name and specification model in the value-added tax invoice historical data to establish an article file;
setting an article matching scale parameter and an article file generation mode, wherein the article matching scale parameter comprises an article name scale and an article name plus specification model scale, and the article file generation mode comprises an automatic file generation mode and a manual file generation mode;
collecting article information and measurement units in the value-added tax invoice historical data to establish a main and auxiliary measurement unit conversion file, wherein the main and auxiliary measurement unit conversion file comprises the article information, the main measurement unit and the conversion relation between the main measurement unit and the auxiliary measurement unit, the article information comprises an article name and a specification model, and the auxiliary measurement unit is a measurement unit of the article in the value-added tax invoice historical data except the main measurement unit;
and setting a bill dereferencing rule, wherein the bill dereferencing rule is that the dereferencing of the bill items except the bill items corresponding to the first matching data, the second matching data and the third matching data in the purchase and sale bill is equal to the dereferencing of the corresponding items in the invoice data.
3. The method according to claim 2, wherein the step of calling a pre-established supplier/customer profile according to a service request for generating an income/sales slip based on the income/sales item value-added tax invoice data with detailed line information, matching the supplier/customer information in the profile with the sales/purchase party information in the invoice data, and generating first matching data of an expense purchase slip comprises the following steps:
recording a supplier/customer name in a supplier/customer profile as first name data when the seller/buyer information in the invoice data matches the supplier/customer information in the supplier/customer profile, wherein the supplier/customer information includes the name and tax number of the supplier/customer and the seller/buyer information includes the name and tax number of the seller/buyer;
when the information of the seller/buyer in the invoice data does not match any item of the information of the seller/client in the archive, automatically updating the archive of the seller/client, adding the information of the seller/buyer in the invoice data as new information of the seller/client in the archive of the seller/client, and recording the new name of the seller/client as second name data;
and merging and recording the first name data and the second name data into first matching data for generating the purchase and sale bill.
4. The method according to claim 2, wherein the step of calling a pre-established item profile according to the selected item matching scale parameter and the item profile generation mode to match the item information of the item profile with the item information in the invoice data, and the step of generating second matching data of the purchase and sale receipt comprises the steps of:
when the item information of the item file is matched with the item information in the invoice data according to the selected item matching scale parameter, recording the item information in the item file as first item data, wherein the item information comprises an item name and a specification model;
when the article information of the article file is not matched with the article information in the invoice data according to the selected article matching scale parameter, updating the article file according to a selected article file generation mode, adding the article information in the invoice data as new article information in the article file, or matching the article information in the invoice data with the existing article information in the article file, and after generating a matching relationship, recording the new article information, or using the existing article information in the article file corresponding to the matching relationship as second article data;
and merging and recording the first article data and the second article data into second matching data for generating purchase and sale receipts.
5. The method according to claim 4, wherein for the item in the second matching data, a pre-established primary and secondary metering unit conversion file is called, the primary metering unit of the item in the primary and secondary metering unit conversion file is matched with the corresponding item unit in the invoice data, and the third matching data for generating the purchase and sale receipt comprises:
when the main metering unit of the article in the main and auxiliary metering unit conversion file is matched with the unit of the corresponding article in the invoice data, recording the article unit in the invoice data, wherein the article quantity and the tax-free unit price are first main metering data;
when the main metering unit of the article in the main and auxiliary metering unit conversion file is not matched with the unit of the corresponding article in the invoice data, if the conversion relation between the main metering unit of the article and the unit of the corresponding article in the invoice data exists in the main and auxiliary metering unit conversion file, calculating and determining the main metering quantity of the article and the main metering tax-free unit price in the purchase and sale bill according to the quantity of the article and the tax-free unit price in the invoice data according to the conversion relation, and taking the main metering unit of the article, the calculated and determined main metering quantity of the article and the main metering tax-free unit price of the article in the main and auxiliary metering unit conversion file as second main metering data; if the conversion relation between the main metering unit of the article and the corresponding unit of the article in the invoice data does not exist in the main and auxiliary metering unit conversion file, updating the main and auxiliary metering unit conversion file, increasing the conversion relation between the main metering unit and the metering unit in the invoice data, calculating and determining the main metering quantity of the article and the main metering tax-free unit price in the purchase and sale bill according to the increased conversion relation and the quantity of the article and the tax-free unit price in the invoice data, and taking the main metering unit of the article, the calculated and determined main metering quantity of the article and the main metering tax-free unit price of the article in the main and auxiliary metering unit conversion file as second main metering data;
and combining and recording the first main metering data and the second main metering data into third matching data for generating the purchase and sale documents.
6. A system for generating purchase and sale documents by taking value-added tax invoices as a data source is characterized by comprising:
the first matching data unit is used for calling a pre-established supplier/customer file according to a service request for generating an incoming/outgoing bill based on incoming/outgoing item value-added tax invoice data with detailed line information, matching the supplier/customer information in the file with the selling/purchasing party information in the invoice data, and generating first matching data of a purchase and outgoing bill;
a parameter mode selection unit for selecting an item matching scale parameter and an item archive generation mode;
the second matching data unit is used for calling a pre-established article file according to the selected article matching scale parameter and the article file generation mode, matching the article information of the article file with the article information in the invoice data and generating second matching data of the purchase and sale receipt;
a third matching data unit, configured to invoke a pre-established primary and secondary metering unit conversion file for an article in second matching data, match the primary metering unit of the article in the primary and secondary metering unit conversion file with the unit of the corresponding article in the invoice data, and generate third matching data of a purchase and sale receipt;
the fourth matching data unit is used for extracting and generating fourth matching data of the purchase and sale bill from the invoice data according to a preset bill dereferencing rule;
and the purchase and sale bill generating unit is used for combining the first matching data, the second matching data, the third matching data and the fourth matching data in sequence to generate a purchase and sale bill.
7. The system of claim 6, further comprising:
the file generation unit is used for collecting the client/provider name and the tax number in the value-added tax invoice historical data to establish a client/provider file; collecting the article name and specification model in the value-added tax invoice historical data to establish an article file; collecting article information and measurement units in the value-added tax invoice historical data to establish a main and auxiliary measurement unit conversion file, wherein the main and auxiliary measurement unit conversion file comprises the article information, the main measurement unit and the conversion relation between the main measurement unit and the auxiliary measurement unit, the article information comprises an article name and a specification model, and the auxiliary measurement unit is a measurement unit of the article in the value-added tax invoice historical data except the main measurement unit;
the system comprises an initial setting unit and a receipt dereferencing rule, wherein the initial setting unit is used for setting an article matching scale parameter and an article archive generation mode, and setting a receipt dereferencing rule, the article matching scale parameter comprises an article name scale and an article name plus specification model scale, the article archive generation mode comprises an automatic archive generation mode and a manual archive generation mode, and the receipt dereferencing rule is that the dereferencing of receipt items except receipt items corresponding to first matching data, second matching data and third matching data in a purchase and sale receipt is equal to the dereferencing of corresponding items in the receipt data.
8. The system of claim 7, wherein the first match data unit comprises:
a first name data unit for recording a supplier/customer name in a supplier/customer profile as first name data when the seller/buyer information in the invoice data matches the supplier/customer information in the supplier/customer profile, wherein the supplier/customer information includes the name and tax number of the supplier/customer, and the seller/buyer information includes the name and tax number of the seller/buyer;
a second name data unit for automatically updating the supplier/customer profile when the seller/buyer information in the invoice data does not match any one of the supplier/customer information in the profile, adding the seller/buyer information in the invoice data as new supplier/customer information in the supplier/customer profile, and recording the new supplier/customer name as second name data;
and the name data merging unit is used for merging and recording the first name data and the second name data into first matching data for generating purchase and sale documents.
9. The system of claim 7, wherein the second match data unit comprises:
a first item data unit, configured to record item information in an item archive as first item data when item information in the item archive matches item information in the invoice data according to the selected item matching scale parameter, where the item information includes an item name and a specification model;
a second item data unit, configured to update an item file according to a selected item file generation mode when item information of the item file is not matched with item information in the invoice data according to a selected item matching scale parameter, add the item information in the invoice data as new item information in the item file, or match the item information in the invoice data with existing item information in the item file, and after a matching relationship is generated, record new item information, or use the existing item information in the item file corresponding to the matching relationship as second item data;
and the article data merging unit is used for merging and recording the first article data and the second article data into second matching data for generating purchase and sale receipts.
10. The method of claim 9, wherein the third matching data unit comprises:
a first main metering data unit, which is used for recording the item unit in the invoice data when the main metering unit of the item in the main and auxiliary metering unit conversion file is matched with the unit of the corresponding item in the invoice data, wherein the item quantity and the tax-free unit price are the first main metering data;
a second main metering data unit, configured to, when the main metering unit of the item in the main and auxiliary metering unit conversion file does not match the unit of the corresponding item in the invoice data, if a conversion relationship exists between the main metering unit of the item and the unit of the corresponding item in the invoice data in the main and auxiliary metering unit conversion file, calculate and determine, according to the conversion relationship, the main metering amount of the item and the main non-tax unit price of the item in the purchase and sale receipt according to the amount of the item and the non-tax unit price in the invoice data, and use the main metering unit of the item, the calculated and determined main metering amount of the item and the main non-tax unit price of the item in the main and auxiliary metering unit conversion file as second main metering data; if the conversion relation between the main metering unit of the article and the corresponding unit of the article in the invoice data does not exist in the main and auxiliary metering unit conversion file, updating the main and auxiliary metering unit conversion file, increasing the conversion relation between the main metering unit and the metering unit in the invoice data, calculating and determining the main metering quantity of the article and the main metering tax-free unit price in the purchase and sale bill according to the increased conversion relation and the quantity of the article and the tax-free unit price in the invoice data, and taking the main metering unit of the article, the calculated and determined main metering quantity of the article and the main metering tax-free unit price of the article in the main and auxiliary metering unit conversion file as second main metering data;
and the master metering data merging unit is used for merging and recording the first master metering data and the second master metering data into third matching data for generating purchase and sale documents.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011578064.1A CN112598454A (en) | 2020-12-28 | 2020-12-28 | Method and system for generating purchase and sale documents by taking value-added tax invoices as data source |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011578064.1A CN112598454A (en) | 2020-12-28 | 2020-12-28 | Method and system for generating purchase and sale documents by taking value-added tax invoices as data source |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112598454A true CN112598454A (en) | 2021-04-02 |
Family
ID=75203708
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011578064.1A Pending CN112598454A (en) | 2020-12-28 | 2020-12-28 | Method and system for generating purchase and sale documents by taking value-added tax invoices as data source |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112598454A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108335087A (en) * | 2018-03-09 | 2018-07-27 | 吴祥荣 | Value-added tax invoice for sales data statistical approach based on EXCEL and device |
| FR3066299A1 (en) * | 2017-05-11 | 2018-11-16 | Amadeus S.A.S | A SYSTEM AND METHOD FOR PROCESSING AND ACCOUNTING RECONCILIATION OF AN INVOICE DATA FILE |
| 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 |
| CN109685586A (en) * | 2017-10-18 | 2019-04-26 | 航天信息股份有限公司 | A kind of processing method and system of VAT invoice data |
| CN110751136A (en) * | 2019-11-04 | 2020-02-04 | 北京亿信华辰软件有限责任公司武汉分公司 | Method for extracting value-added tax invoice information |
| CN111161001A (en) * | 2019-12-16 | 2020-05-15 | 远光软件股份有限公司 | Matching system and matching method for value-added tax invoice and settlement data, storage medium and equipment |
| CN111179046A (en) * | 2019-12-27 | 2020-05-19 | 航天信息软件技术有限公司 | Method and system for realizing automatic payment and posting of sales cost based on invoice data |
| CN111260453A (en) * | 2020-01-02 | 2020-06-09 | 航天信息软件技术有限公司 | Method and device for generating purchase-sale account based on purchase-sale item invoice data |
-
2020
- 2020-12-28 CN CN202011578064.1A patent/CN112598454A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| FR3066299A1 (en) * | 2017-05-11 | 2018-11-16 | Amadeus S.A.S | A SYSTEM AND METHOD FOR PROCESSING AND ACCOUNTING RECONCILIATION OF AN INVOICE DATA FILE |
| CN109685586A (en) * | 2017-10-18 | 2019-04-26 | 航天信息股份有限公司 | A kind of processing method and system of VAT invoice data |
| CN108335087A (en) * | 2018-03-09 | 2018-07-27 | 吴祥荣 | Value-added tax invoice for sales data statistical approach based on EXCEL and device |
| 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 |
| CN110751136A (en) * | 2019-11-04 | 2020-02-04 | 北京亿信华辰软件有限责任公司武汉分公司 | Method for extracting value-added tax invoice information |
| CN111161001A (en) * | 2019-12-16 | 2020-05-15 | 远光软件股份有限公司 | Matching system and matching method for value-added tax invoice and settlement data, storage medium and equipment |
| CN111179046A (en) * | 2019-12-27 | 2020-05-19 | 航天信息软件技术有限公司 | Method and system for realizing automatic payment and posting of sales cost based on invoice data |
| CN111260453A (en) * | 2020-01-02 | 2020-06-09 | 航天信息软件技术有限公司 | Method and device for generating purchase-sale account based on purchase-sale item invoice data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6712738B1 (en) | Voucher judging device, accounting processor, voucher judging program, voucher judging system and voucher judging method | |
| US7254554B2 (en) | Accounting system and method for processing transaction data | |
| US20010025262A1 (en) | Computer apparatus for monitoring and updating accountancy records | |
| CN110119977A (en) | Financial accounting voucher automatic generation method, system, medium and electronic equipment | |
| JP2007122388A (en) | Accounting system, accounting method, and program | |
| CN111861654A (en) | Printed paper purchase order processing method and device, electronic equipment and storage medium | |
| CN110930236A (en) | Voucher-based payment order generation method and device | |
| CN111028026A (en) | Invoice matching method and system | |
| AU2011353001B2 (en) | System and method for consolidating account data | |
| CN112598454A (en) | Method and system for generating purchase and sale documents by taking value-added tax invoices as data source | |
| JP2004288058A (en) | Management accounting information processing system, equipment thereof, method therefor, and computer program therefor | |
| CN112418878B (en) | Rights service data processing method, device, equipment and storage medium | |
| CN114997109A (en) | Receipt conversion method and device, computer equipment and storage medium | |
| US7882153B1 (en) | Method and system for electronic messaging of trade data | |
| US20040117287A1 (en) | Fixed assets management system and method | |
| CN104246753A (en) | Mobile terminal management server and mobile terminal management program | |
| CN114693331A (en) | Return and capital expenditure management method for dealer in retail industry | |
| CN111179046A (en) | Method and system for realizing automatic payment and posting of sales cost based on invoice data | |
| CN110807678A (en) | Method and system for generating value-added tax red invoice invoicing data | |
| JP7241362B2 (en) | Accounting processing system, accounting processing method and accounting processing program | |
| JP7215779B1 (en) | Data processing device, data processing method and program | |
| JP5915064B2 (en) | Financial statement preparation program, financial statement preparation method and financial statement preparation device | |
| Azkia Kurnia et al. | Analysis of Accounting Information Systems for Purchase and Sales in MSMEs | |
| WO2023007612A1 (en) | Data processing device, data processing method, and program | |
| JPH06139260A (en) | Sales management program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |