CN106204175A - For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip - Google Patents

For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip Download PDF

Info

Publication number
CN106204175A
CN106204175A CN201510232271.4A CN201510232271A CN106204175A CN 106204175 A CN106204175 A CN 106204175A CN 201510232271 A CN201510232271 A CN 201510232271A CN 106204175 A CN106204175 A CN 106204175A
Authority
CN
China
Prior art keywords
amount
invoice
tax
discount
row
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201510232271.4A
Other languages
Chinese (zh)
Inventor
耿立家
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Aisino Corp
Original Assignee
Aisino Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Aisino Corp filed Critical Aisino Corp
Priority to CN201510232271.4A priority Critical patent/CN106204175A/en
Publication of CN106204175A publication Critical patent/CN106204175A/en
Pending legal-status Critical Current

Links

Abstract

The invention discloses a kind of method and system for opening many tax rates VAT invoice without amount of tax to be paid sales slip, including: obtaining and include the sales slip amount of money, sales slip data set containing tax mark and limit of making out an invoice and include the sales slip detailed data collection of multiple commodity detail row, each commodity detail row includes trade name, unit price, quantity, the amount of money and the tax rate;Judge whether whether unit price be equal to the sales slip amount of money equal to the amount of money, each amount of money sum with the long-pending of quantity;According to containing tax mark, unit price, quantity and tax rate given price tax total, invoice amount, the invoice amount of tax to be paid and invoice unit price, each valency tax that adds up respectively total, invoice amount and the invoice amount of tax to be paid add up to the invoice amount of tax to be paid to obtain detailed total valency tax total, detailed total invoice amount and detail;According to limit and the predetermined commodity detail line number fractionation sales slip detailed data collection of making out an invoice.Which save time and human cost, be prepared in advance again and meet the ticket data to be developed of invoice data specification.

Description

For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip
Technical field
The present invention relates to electronic invoice technical field, in particular it relates to a kind of for open without amount of tax to be paid sales slip Has the method and system of many tax rates VAT invoice.
Background technology
The forgery prevention for value-added tax taxation control system of Administration of State Bureau is that ordinary enterprises provides and opens VAT invoice Function, user can the most item by item typing invoice data to complete invoice issuing, it is also possible to will Ticket data to be developed imports this system interface to complete invoice issuing.But opened by typing invoice data Ticket, had both added time and human cost, may make mistakes again logging data when.Lead if used Enter data to make out an invoice, then need first to be ready to meet the ticket data to be developed of invoice data specification, but at present Also do not have a kind of reasonable method to be prepared in advance and meet the ticket data to be developed of invoice data specification.
Summary of the invention
In enterprise business, in the operation system of enterprise, the most first generate sales slip data, So can consider sales slip data to be passed to forgery prevention for value-added tax taxation control system interface to complete invoice issuing. But owing to enterprise is different in registration type, the productive and business scope of Administration of State Bureau, the sale odd number of different enterprises According to having many different attributes, it is imparted to anti-false tax-controlled system and carries out invoice if not doing correct process and open Tool, can cause normally making out an invoice because various data check relations are not inconsistent;Even if or opened invoice, Possibly also owing to the data item such as the amount of money of invoice data, the amount of tax to be paid are deposited with the data item of calculating in enterprise marketing list In difference, bring problem to the financial management of enterprise.
The present invention is in the case of taking into full account above-mentioned present situation, it is provided that a kind of for open without amount of tax to be paid sales slip Have the method and system of many tax rates VAT invoice, its can time-consuming and human cost, again can be in advance Get out meet the ticket data to be developed of invoice data specification.
The present invention provides a kind of method for opening many tax rates VAT invoice without amount of tax to be paid sales slip, the party Method includes:
Step S1, the sales slip data set obtaining ticket to be developed and sales slip detailed data collection, described pin Sell forms data collection and include the sales slip amount of money, containing tax mark and limit of making out an invoice, described sales slip detailed data collection Including multiple commodity detail row, each commodity detail row include trade name, unit price, quantity, the amount of money and The tax rate;
Step S2, calculate the product of unit price and quantity in each described commodity detail row and judge this product Whether equal to the amount of money in this commodity detail row, if equal, then go to step S3;
Step S3, carry out the amount of money in all described commodity detail row cumulative obtaining detailed Amount in Total, Judge that this detail Amount in Total, whether equal to the described sales slip amount of money, if equal, then goes to step S4;
Step S4, according to described unit price containing tax mark, in each described commodity detail row, quantity and The tax rate calculate and in each described commodity detail row add valency tax total, invoice amount, the invoice amount of tax to be paid and Invoice unit price, and valency tax total, invoice amount and the invoice tax of all described commodity detail row that adds up respectively Volume is cumulative to add detailed total valency tax total, detailed total in described sales slip detailed data concentration respectively Invoice amount and the detailed total invoice amount of tax to be paid;And
Step S5, according to described in make out an invoice the predetermined commodity detail line number on limit and described VAT invoice, Described sales slip detailed data collection is split into multiple ticket data collection to be developed.
The present invention also provides for a kind of system for opening many tax rates VAT invoice without amount of tax to be paid sales slip, should System includes:
Acquisition module, for obtaining sales slip data set and sales slip detailed data collection, the institute of ticket to be developed State sales slip data set and include the sales slip amount of money, containing tax mark and limit of making out an invoice, described sales slip detail number Include that multiple commodity detail row, each commodity detail row include trade name, unit price, quantity, gold according to collection Volume and the tax rate;
Detailed amount of money correction verification module, for calculating unit price and the product of quantity in each described commodity detail row And judge that whether this product is equal to the amount of money in this commodity detail row;
Sales slip amount of money correction verification module, for carrying out adding up by the amount of money in all described commodity detail row To detailed Amount in Total, it is judged that whether this detail Amount in Total is equal to the described sales slip amount of money;
Invoice data computing module, for according to described containing tax mark, in each described commodity detail row Unit price, quantity and the tax rate calculate and add in each described commodity detail row valency tax total, invoice amount, The invoice amount of tax to be paid and invoice unit price, and the valency tax of all described commodity detail row that adds up respectively adds up to, invoice gold Volume and the invoice amount of tax to be paid are cumulative respectively adds detailed total valency tax conjunction to concentrate at described sales slip detailed data Meter, detailed total invoice amount and the detailed total invoice amount of tax to be paid;And
Split module, after completing described calculating at described invoice data computing module and add up, depend on According to the described predetermined commodity detail line number made out an invoice on limit and described VAT invoice, by bright for described sales slip Thin data set splits into multiple ticket data collection to be developed.
By technique scheme, owing to the method according to the invention and system make use of enterprise operation system In sales slip data, and sales slip data processed obtains meeting invoice data specification wait out Invoice data, therefore, it is possible to time-consuming and human cost, improves the invoice issuing efficiency of enterprise, reduces Enterprise's risk issued invoice lack of standardization, promotes that enterprise's legacy specification is managed and normal invoice issuing, enters One step is strengthened and specification VAT invoice manages, and improves the Financial Control Level of enterprise.
Other features and advantages of the present invention will be described in detail in detailed description of the invention part subsequently.
Accompanying drawing explanation
Accompanying drawing is used to provide a further understanding of the present invention, and constitutes the part of description, with Detailed description below is used for explaining the present invention together, but is not intended that limitation of the present invention.? In accompanying drawing:
Fig. 1 be according to one embodiment of the present invention for open many tax rates value-added tax without amount of tax to be paid sales slip The flow chart of the method for invoice;And
Fig. 2 be according to one embodiment of the present invention for open many tax rates value-added tax without amount of tax to be paid sales slip The block diagram of the system of invoice.
Detailed description of the invention
Below in conjunction with accompanying drawing, the detailed description of the invention of the present invention is described in detail.It should be appreciated that Detailed description of the invention described herein is merely to illustrate and explains the present invention, is not limited to this Bright.
The commodity detail tax rate that many tax rates refer on a VAT invoice can be multiple;Without tax Volume sales slip is the one of enterprise marketing list, and financial management uses the actual invoice amount of tax to be paid opened, enterprise Need not just calculate in sales slip the amount of tax to be paid before invoice issuing.The feature of this sales slip data be Sales slip master data neither identifies the tax rate, does not the most identify the amount of tax to be paid;Sales slip detailed data identifies The different tax rates, but do not identify the amount of tax to be paid.
As it is shown in figure 1, according to one embodiment of the present invention for open many tax rates without amount of tax to be paid sales slip The method of VAT invoice comprises the following steps:
Step S1, the sales slip data set obtaining ticket to be developed and sales slip detailed data collection, sales slip Data set includes the sales slip amount of money, containing tax mark and limit of making out an invoice, sales slip detailed data collection includes multiple Commodity detail row, each commodity detail row includes trade name, unit price, quantity, the amount of money and the tax rate.
Generally, in the operation system of enterprise, add mark of making out an invoice can to the sales slip in sales slip tables of data Will, in order to clearly search and process the sales slip not issued invoice.Therefore, it can according to sales slip " mark of making out an invoice ", the sales slip tables of data of enterprise operation system is searched the sale not issued invoice Single key data, forms sales slip data set.It is for instance possible to use SQL statement or other computers Program statement obtains sales slip data set, and exemplary SQL statement form is: " SELECT sells Odd numbers, the sales slip amount of money, containing tax mark, inventory mark, Chinese character anti-false logo, limit of making out an invoice FROM sales slip tables of data WHERE is made out an invoice mark=' not making out an invoice ' ".Above SQL statement lattice Formula is only exemplary, and in practical operation, inventory mark and Chinese character anti-false logo are not necessary to obtain Take, namely in sales slip data set, do not include inventory mark and the situation of Chinese character anti-false logo Under, can follow-up sales slip detailed data collection is split time, by the predetermined business on VAT invoice Product detail line number is defined to such as 7 row (this changes) according to the VAT invoice of tax bureau's offer, with The restriction that the commodity detail line number maximum that each ticket data to be developed is concentrated specifies less than the tax bureau Condition.Table 1 gives exemplary sales slip data set.
Sell odd numbers The sales slip amount of money Containing tax mark Inventory mark Chinese character anti-false logo Make out an invoice limit
XSD0001 14400.00 Y Y Y 10000.00
Table 1
Furthermore it is possible to use SQL statement or other computer program statements to obtain sales slip detail number According to collection, exemplary SQL statement form is: " SELECT sequence number, trade name, by discount mark, Discount ratio, unit price, quantity, the amount of money, tax rate FROM sales slip commodity detailed data table WHERE Sell odd numbers=' present sales odd numbers ' ".Wherein, by discount mark and discount ratio not necessarily, When enterprise does not carries out discount sales to commodity, sales slip detailed data is concentrated and can not be included by discount mark Will and discount ratio.Table 2 shows the exemplary sales list detail number of the sales slip XSD0001 of table 1 According to collection.
Sequence number Trade name Unit price Quantity The amount of money The tax rate By discount mark Discount ratio
1 Commodity 1 1000.00 1 1000.00 11%
2 Commodity 2 750.00 2 1500.00 6%
3 Discounting commodity 1 300.00 2 600.00 11% Y 20%
4 Discounting commodity 2 400.00 1 400.00 11% Y 20%
5 Commodity 3 700.00 2 1400.00 11%
6 Commodity 4 400.00 4 1600.00 6%
7 Discounting commodity 3 400.00 13 5200.00 6% Y 20%
8 Discounting commodity 4 600.00 3 1800.00 6% Y 20%
9 Commodity 5 500.00 5 2500.00 11%
Table 2
Step S2, calculate the product of unit price and quantity in each commodity detail row and whether judge this product Equal to the amount of money in this commodity detail row, if equal, then go to step S3.
Such as, during the execution of step S2, can concentrate at sales slip detailed data, from first bar To end data circulation, obtaining line number, the amount of money, quantity and the unit price of every commodity detail row one by one, these are several Individual data item, and calculate " unit price * quantity ", it is judged that result of calculation and the amount of money in this commodity detail row The most equal, if unequal, then point out such as that " line number is the sales slip detail number of ' current line number ' According to concentration, unit price * quantity is unequal with the amount of money ", and terminate algorithm flow;If equal, then go to step S3。
Step S3, carry out the amount of money in all commodity detail row cumulative obtaining detailed Amount in Total, sentence This detail Amount in Total disconnected, whether equal to the sales slip amount of money, if equal, then goes to step S4.
Such as, during the execution of step S3, can concentrate at sales slip detailed data, from first bar To end data circulation, obtaining the value data item of every commodity detail row one by one, accumulative addition calculation is raw Become detailed Amount in Total, and judge that this detail Amount in Total is the most equal with the sales slip amount of money, if not phase Deng, then after pointing out such as " the ∑ sales slip detail amount of money is unequal with the sales slip amount of money ", terminate algorithm stream Journey;If equal, then go to step S4.
Step S4, basis calculate containing the unit price in tax mark, each commodity detail row, quantity and the tax rate And in each commodity detail row, add valency tax total, invoice amount, the invoice amount of tax to be paid and invoice unit price, and The valency tax of all commodity detail row of adding up respectively adds up to, invoice amount and the invoice amount of tax to be paid be with detailed at sales slip Data set adds detail total valency tax total, detailed total invoice amount and the detailed total invoice amount of tax to be paid.
Wherein, in the case of the mark containing tax represents containing tax (such as, representing containing tax with letter Y) (also I.e. unit price in commodity detail row is containing duty receipt valency), use below equation to calculate each commodity detail row Valency tax total, invoice amount, the invoice amount of tax to be paid and invoice unit price:
Valency tax total=unit price * quantity;
Invoice amount=valency tax adds up to/(the 1+ tax rate);
The invoice amount of tax to be paid=valency tax total-invoice amount;
Invoice unit price=unit price/(the 1+ tax rate);
In the case of the mark containing tax represents without tax (such as, representing containing tax with letter N) (namely business Unit price in product detail row is free from duty receipt valency), use below equation to calculate the valency of each commodity detail row Tax total, invoice amount, the invoice amount of tax to be paid and invoice unit price:
Invoice amount=unit price * quantity;
The invoice amount of tax to be paid=invoice amount * tax rate;
Valency tax total=invoice amount+invoice amount of tax to be paid.
Calculate valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of each commodity detail row with And detailed total valency tax add up to, detailed add up to invoice amount and detailed add up to after the invoice amount of tax to be paid exemplary Table 4 hereinafter asked for an interview by sales slip detailed data collection.
Step S5, according to making out an invoice the predetermined commodity detail line number on limit and VAT invoice, will sell Single detailed data collection splits into multiple ticket data collection to be developed.
Limit of making out an invoice is the restriction to the amount of money of making out an invoice, the VAT invoice of such as 10,000 yuan, the highest opens The ticket amount of money is 10,000 yuan.Predetermined commodity detail line number on VAT invoice is that enterprise can send out at value-added tax The maximum commodity detail line number listed on ticket.That is, each ticket data collection to be developed finally given is bright Thin total invoice amount can not be more than making out an invoice limit, and its commodity detail line number not can exceed that on VAT invoice Predetermined commodity detail line number.Split the ticket data collection exemplary to be developed obtained and ask for an interview table 5 hereinafter With table 6.
So far, just completing the process of sales slip data, the ticket data collection each to be developed generated is exactly The key data of one ticket to be developed, other number needed drawing a bill in these key datas and sales slip Complete sending out can be formed according to key element (such as, sales organization, purchasing unit title etc.) after merging Ticket data, the interface that the invoice data that this is complete is sent to tax-supervise system to be provided just can complete invoice Open.
Preferably, sales slip data set can also include inventory mark and Chinese character anti-false logo, should Chinese character anti-false logo defines the predetermined commodity detail line number on VAT invoice.Wherein, inventory mark Will for representing whether the VAT invoice opening band inventory, such as, can represent with inventory mark Y Open the VAT invoice of band inventory, represent with inventory mark N and open the VAT invoice without inventory. Chinese character anti-false logo illustrates enterprise's registration type in Administration of State Bureau, such as, can look forward to Chinese character anti-false Industry mark Y represents that this enterprise is Chinese character anti-false enterprise, represents this enterprise with Chinese character anti-false logo N Shi Fei Chinese character anti-false enterprise.Opening regulation according to existing Administration of State Bureau VAT invoice, non-Chinese character anti-false is looked forward to The commodity detail line number that industry is opened on VAT invoice not can exceed that 8, and Chinese character anti-false enterprise is in increment The commodity detail line number opened on tax invoice not can exceed that 7.So, aforesaid step S5 can be wrapped Include following steps:
Step S51, represent the VAT invoice opening band inventory at inventory mark in the case of, according to opening Sales slip detailed data collection is split into multiple ticket data collection to be developed, the most each ticket to be developed by ticket limit The detailed of data set adds up to invoice amount less than or equal to making out an invoice limit.Owing to being the value-added tax opening band inventory Invoice, it is possible to do not consider Chinese character anti-false logo.Such as, this step can be carried out as follows: first First, it is judged that sales slip detailed data concentrate detailed add up to invoice amount whether less than or equal to making out an invoice limit, If being less than or equal to, sales slip detailed data collection is not split;If being more than, then need sales slip Detailed data collection splits, then concentrate from sales slip detailed data to be split, bright from first bar commodity successively Thin row circulates to end bar commodity detail row, take the invoice amount in every commodity detail row accumulation calculating its Amount in Total, the Amount in Total obtained when accumulation calculating to certain commodity detail row is more than making out an invoice limit Time, the entire service detail row before this commodity detail row is split to a ticket data collection to be developed In, the rest may be inferred, sales slip detailed data collection splits into multiple ticket data collection to be developed so that each The detailed total invoice amount that ticket data to be developed is concentrated is not more than invoice limit.
Step S52, in the case of inventory mark represents and opens without the VAT invoice of inventory, foundation Sales slip detailed data collection is split into multiple poll to be developed by limit of making out an invoice and Chinese character anti-false logo According to collection, the most each ticket data collection to be developed detailed adds up to invoice amount less than or equal to making out an invoice limit and every The predetermined commodity detail row that the commodity detail line number of individual ticket data collection to be developed is not more than on VAT invoice Number.That is, non-Chinese character anti-false enterprise at most can only open 8 commodity detail line numbers on VAT invoice, Chinese character anti-false enterprise at most can only open 7 commodity detail line numbers on VAT invoice.
It addition, when enterprise is to its commodity discount sales, will be in the sales slip detailed data table of enterprise Have by discount mark and discount ratio the two data item, to show which commodity is discounting commodity, give a discount Ratio is how many, consequently facilitating the financial management of enterprise.It is therefore preferred that sales slip detailed data collection Each commodity detail row in also include by discount mark and discount ratio, and after the sales slip amount of money is discount The amount of money, the amount of money in each commodity detail row is the amount of money before discount, so:
In aforesaid step S3, it is necessary to utilize after discount amount of money * (1-discount rate before the amount of money=discount Example) calculate the amount of money after the discount of the commodity detail row comprising discount commodity, by the amount of money after this discount with not The amount of money in other commodity detail row comprising discount commodity carries out adding up and obtains detailed Amount in Total, and sentences Whether disconnected detailed Amount in Total is equal to the sales slip amount of money.Namely have in the sales slip detailed data table of enterprise During discounting commodity, after needing first to calculate the discount of this commodity detail row, the amount of money adds up the most again.
And, in aforesaid step S4, concentrate each commodity detailed calculating sales slip detailed data Before valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of row, in addition it is also necessary to according to discount ratio Rearrange each commodity detail row with the tax rate, calculate and there are identical discount ratio and the commodity of same tax rate Total line number of detailed row and total discount amount thereof, and there are identical discount ratio and the commodity of same tax rate A discount row is inserted, in the trade name of this discount row after last column commodity detail row of detailed row Embody total line number and the discount ratio of the commodity detail row with identical discount ratio and same tax rate, The amount of money of this discount row is total discount amount * (-1).For example, it is possible to by identical discount ratio and identical tax The commodity detail row of rate divides at one group, and is arranged in order by group, and discount ratio is that empty one group represents this group Commodity in commodity detail row are non-discounting commodity, this group commodity detail row can be arranged in foremost (certainly, come sales slip detailed data collection is the most also feasible);It is not empty to discount ratio Each group commodity detail row, need to add up respectively total line number of each group of commodity detail row, calculate each group of commodity Total discount amount of detailed row, the wherein amount of money * discount rate in total this group commodity detail row of discount amount=∑ Example, and after last column commodity detail row of each group of commodity detail row, insert a discount row, this folding The trade name of button row can be " discount line number Y (X.XXX%) ", and wherein " Y " is raw for calculating Each group become has total line number of the commodity detail row of identical discount ratio and same tax rate, and " X " is discount Ratio, or the trade name of this discount row can also be that other can embody this group and have identical discount rate Total line number of the commodity detail row of example and same tax rate and other titles of discount ratio, the gold of this discount row Volume is to calculate total discount amount * (-1) generated to represent that commodity are given a discount.Table 3 gives by discount Ratio and the tax rate rearrange the commodity detail row in table 2 and insert the exemplary sales list after discount row Detailed data collection.
Table 3
Table 4 gives and calculates the valency tax total of each commodity detail row, invoice gold on the basis of table 3 Volume, the invoice amount of tax to be paid and invoice unit price and detailed total valency tax add up to, detail adds up to invoice amount and detail Add up to the exemplary sales list detailed data collection after the invoice amount of tax to be paid.
Table 4
And, when sales slip detailed data concentration includes by discount mark and discount ratio, in step Also needing in S52 process discount row, ticket data the most to be developed is concentrated has identical discount rate Do not roll over after last column commodity detail row of example and a line of same tax rate or multirow commodity detail row Button row then inserts a discount row after this last column commodity detail row and (wherein, inserts discount row Operating identical with the operation of insertion discount row described before, so here is omitted), if described There is after last column commodity detail row discount row then update this discount row and (wherein, update discount row Operate identical, so the most also repeating no more with the operation of insertion discount row described before), Yi Jigeng The detailed total valency tax of new this ticket data to be developed concentration adds up to, detail adds up to invoice amount and detailed total The invoice amount of tax to be paid.The discount data that this makes it possible to concentrate every ticket data to be developed processes again, So that the data of every ticket data to be developed concentration are the most accurate, it is to avoid occur according to this poll to be developed According to the data calculated in the data item sales slips with enterprise such as the amount of money on the invoice that collection is opened, the amount of tax to be paid The situation that item there are differences, improves the Financial Control Level of enterprise.Sales slip detailed data with table 4 As a example by collection, after utilizing this step to split, obtain two ticket data collection to be developed, ask for an interview table 5 He Shown in table 6.Inventory mark owing to being given in table 1 is Y, namely opens the VAT invoice of band inventory, So only considering when splitting to make out an invoice this factor of limit without considering Chinese character anti-false logo.
Table 5
Table 6
It addition, from the point of view of according to existing effective sale forms data statistical result, in the increment opening band inventory In the case of tax invoice, the detailed total invoice amount that usual sales slip detailed data is concentrated is less than making out an invoice Limit, therefore when sales slip detailed data concentration also includes discounting commodity, in the fractionation of step S51 During discount data can not be processed.If detailed total that sales slip detailed data is concentrated is sent out The ticket amount of money is more than making out an invoice limit, then in the split process of step S51, and can be according to above-mentioned steps S52 Split process in the processing procedure of discount data is processed the folding that will be listed on inventory when making out an invoice The process of the insertion discount row in step S52 and renewal discount row (i.e. can be applied similarly by button data In step S51).
According to one embodiment of the present invention, the present invention also provides for a kind of for open without amount of tax to be paid sales slip The system of many tax rates VAT invoice, this system include acquisition module 21, detailed amount of money correction verification module 22, Sales slip amount of money correction verification module 23, invoice data computing module 24 and fractionation module 25.
Wherein, acquisition module 21, for obtaining sales slip data set and the sales slip detail number of ticket to be developed According to collection, sales slip data set includes the sales slip amount of money, containing tax mark and limit of making out an invoice, sales slip detail number Include that multiple commodity detail row, each commodity detail row include trade name, unit price, quantity, gold according to collection Volume and the tax rate.Such as, acquisition module 21 can be according to " mark of making out an invoice " of sales slip, at business event The sales slip tables of data of system is searched the sales slip key data not issued invoice, forms sales slip data Collection and sales slip detailed data collection, such as, acquisition module 21 can use SQL statement or other calculating Machine program statement obtains sales slip data set, and exemplary SQL statement form is: " SELECT sells Sell odd numbers, the sales slip amount of money, containing tax mark, limit FROM of making out an invoice sales slip tables of data WHERE Make out an invoice mark=' not making out an invoice ' ", and obtain sales slip detailed data collection, exemplary SQL statement Form is: " SELECT sequence number, trade name, unit price, quantity, the amount of money, tax rate FROM is sold Sell single commodity detailed data table WHERE and sell odd numbers=' present sales odd numbers ' ".
Detailed amount of money correction verification module 22, for calculating in each commodity detail row the product of unit price and quantity also Judge that whether this product is equal to the amount of money in this commodity detail row.Such as, detailed amount of money correction verification module 22 Can concentrate at sales slip detailed data, from first bar to end data circulation, obtain every commodity one by one bright The thin line number of row, the amount of money, quantity and these data item of unit price, and calculate " unit price * quantity ", it is judged that Result of calculation is the most equal with the amount of money in this commodity detail row, if unequal, then points out such as " OK Number being that the sales slip detailed data of ' current line number ' is concentrated, unit price * quantity is unequal with the amount of money ", and tie Bundle algorithm flow;If equal, then prompting sales slip amount of money correction verification module 23 carries out the school of the sales slip amount of money Test.
Sales slip amount of money correction verification module 23, for carrying out cumulative obtaining by the amount of money in all commodity detail row Detailed Amount in Total, it is judged that whether this detail Amount in Total is equal to the sales slip amount of money.Such as, sales slip gold Volume correction verification module 23 can be concentrated at sales slip detailed data, from first bar to end data circulation, one by one Obtaining the value data item of every commodity detail row, accumulative addition calculation generates detailed Amount in Total, and sentences This detail Amount in Total disconnected is the most equal with the sales slip amount of money, if unequal, then points out such as " ∑ pin Sell single detailed amount of money unequal with the sales slip amount of money " after, terminate algorithm flow;If equal, then prompting is sent out Ticket data computing module 24 carries out the calculating of invoice data.
Invoice data computing module 24, for according to containing the unit price in tax mark, each commodity detail row, Quantity and the tax rate calculate and add valency tax total, invoice amount, the invoice amount of tax to be paid in each commodity detail row With invoice unit price, and the valency tax of all commodity detail row that adds up respectively adds up to, invoice amount and the invoice amount of tax to be paid To concentrate at sales slip detailed data, the detailed total valency tax of interpolation adds up to, detail adds up to invoice amount and detail Add up to the invoice amount of tax to be paid.Wherein, represent containing tax (such as, representing containing tax with letter Y) at the mark containing tax In the case of (namely the unit price in commodity detail row is containing duty receipt valency), invoice data computing module 24 uses Valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of the below equation each commodity detail row of calculating:
Valency tax total=unit price * quantity;
Invoice amount=valency tax adds up to/(the 1+ tax rate);
The invoice amount of tax to be paid=valency tax total-invoice amount;
Invoice unit price=unit price/(the 1+ tax rate);
In the case of the mark containing tax represents without tax (such as, representing containing tax with letter N) (namely business Unit price in product detail row is free from duty receipt valency), invoice data computing module 24 uses below equation to calculate Valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of each commodity detail row:
Invoice amount=unit price * quantity;
The invoice amount of tax to be paid=invoice amount * tax rate;
Valency tax total=invoice amount+invoice amount of tax to be paid.
Split module 25, after completing described calculating at invoice data computing module 24 and add up, According to making out an invoice the predetermined commodity detail line number on limit and VAT invoice, sales slip detailed data collection is torn open It is divided into multiple ticket data collection to be developed.That is, the detailed conjunction of each ticket data collection to be developed finally given Meter invoice amount can not be more than making out an invoice limit, and it is pre-that its commodity detail line number not can exceed that on VAT invoice Determine commodity detail line number.
After splitting module 25 and splitting, the ticket data collection each to be developed generated is exactly one The key data of ticket to be developed, by drawing a bill in these key datas and sales slip, other data needed are wanted Element can form complete invoice data after merging, and the invoice data that this is complete is sent to tax-supervise system and carries The interface of confession just can complete opening of invoice.
Preferably, the sales slip data set acquired in acquisition module 21 can also include inventory mark and Chinese character anti-false logo, Chinese character anti-false logo defines that the predetermined commodity on VAT invoice are detailed Line number, splits module 25 and is additionally operable to: represent the feelings of the VAT invoice opening band inventory at inventory mark Under condition, according to making out an invoice, described sales slip detailed data collection is split into multiple ticket data collection to be developed by limit, The detailed of the most each ticket data collection to be developed adds up to invoice amount less than or equal to making out an invoice limit;At inventory mark In the case of will represents and opens without the VAT invoice of inventory, according to making out an invoice limit and Chinese character anti-false enterprise Sales slip detailed data collection is split into multiple ticket data collection to be developed, the most each poll to be developed by mark Detailed according to collection adds up to invoice amount less than or equal to making out an invoice limit and the commodity of each ticket data collection to be developed The predetermined commodity detail line number that detailed line number is not more than on VAT invoice.Split performed by module 25 This operation can be similar to the operation described in above-mentioned steps S51 and step S52, and here is omitted.
Preferably, in each commodity detail row of the sales slip detailed data collection acquired in acquisition module 21 Can also include by discount mark and discount ratio, and the sales slip amount of money is the amount of money after discount, each commodity The amount of money in detailed row is the amount of money before discount.In this case, sales slip amount of money correction verification module 23 is also For: after utilizing discount, before the amount of money=discount, amount of money * (1-discount ratio) calculates and comprises discount commodity The amount of money after the discount of commodity detail row, by bright to the amount of money after this discount and other commodity not comprising discount commodity The amount of money in thin row carries out cumulative obtaining described detailed Amount in Total, and judges that whether etc. detailed Amount in Total In the sales slip amount of money.Namely when having discounting commodity in the sales slip detailed data table of enterprise, sales slip gold After volume correction verification module 23 needs first to calculate the discount of this commodity detail row, the amount of money adds up the most again. Invoice data computing module 24 be additionally operable to calculate the valency tax total of each commodity detail row, invoice amount, Before the invoice amount of tax to be paid and invoice unit price, rearrange each commodity detail row according to discount ratio and the tax rate, Calculate total line number of the commodity detail row with identical discount ratio and same tax rate and total discount amount thereof, And have identical discount ratio and same tax rate commodity detail row last column commodity detail row it One discount row of rear insertion, embodies in the trade name of this discount row and has identical discount ratio with identical Total line number of the commodity detail row of the tax rate and discount ratio, the amount of money of this discount row is total discount amount * (-1).Operation performed by invoice data computing module 24 can be similar to exist by discount mark and folding Operation described in abovementioned steps S4 during button ratio the two data item, here is omitted.And, After splitting module 25 and completing described fractionation, represent at inventory mark and open the value-added tax without inventory In the case of invoice, invoice data computing module 24 is additionally operable to: if ticket data to be developed is concentrated has phase With discount ratio and a line of same tax rate or multirow commodity detail row last column commodity detail row it After do not have discount row then after this last column commodity detail row insert a discount row, if last at this There is after a line commodity detail row discount row and then update this discount row, and update this ticket data to be developed The detailed total valency tax concentrated adds up to, detail adds up to invoice amount and detail adds up to the invoice amount of tax to be paid.Thus The discount data that every ticket data to be developed is concentrated can be processed, again so that every to be developed The data that ticket data is concentrated are the most accurate, it is to avoid the invoice opened according to this ticket data collection to be developed occur On the amount of money, the feelings that there are differences of the data item that calculated in the data item such as the amount of tax to be paid and the sales slip of enterprise Condition, improves the Financial Control Level of enterprise.Insert and update the operation of discount row and before according to this The bright operation described in method is similar to, and here is omitted.
It addition, from the point of view of according to existing effective sale forms data statistical result, in the increment opening band inventory In the case of tax invoice, the detailed total invoice amount that usual sales slip detailed data is concentrated is less than making out an invoice Limit, therefore when sales slip detailed data concentration also includes discounting commodity, enter splitting module 25 After row splits, discount data can not be reprocessed by invoice data computing module 24.If sold The detailed total invoice amount that list detailed data is concentrated more than making out an invoice limit, is then carried out in fractionation module 25 After fractionation, invoice data computing module 24 can also carry out operation similar to the above to discount data, I.e. insert and update discount row and update detailed total valency tax total, the detailed conjunction that ticket data to be developed is concentrated Meter invoice amount and the detailed total invoice amount of tax to be paid.
The preferred embodiment of the present invention is described in detail above in association with accompanying drawing, but, the present invention does not limit Detail in above-mentioned embodiment, in the technology concept of the present invention, can be to the present invention Technical scheme carry out multiple simple variant, these simple variant belong to protection scope of the present invention.
Additionally, combination in any can also be carried out between the various different embodiment of the present invention, as long as its Without prejudice to the thought of the present invention, it should be considered as content disclosed in this invention equally.

Claims (8)

1., for the method opening many tax rates VAT invoice without amount of tax to be paid sales slip, the method includes:
Step S1, the sales slip data set obtaining ticket to be developed and sales slip detailed data collection, described pin Sell forms data collection and include the sales slip amount of money, containing tax mark and limit of making out an invoice, described sales slip detailed data collection Including multiple commodity detail row, each commodity detail row include trade name, unit price, quantity, the amount of money and The tax rate;
Step S2, calculate the product of unit price and quantity in each described commodity detail row and judge this product Whether equal to the amount of money in this commodity detail row, if equal, then go to step S3;
Step S3, carry out the amount of money in all described commodity detail row cumulative obtaining detailed Amount in Total, Judge that this detail Amount in Total, whether equal to the described sales slip amount of money, if equal, then goes to step S4;
Step S4, according to described unit price containing tax mark, in each described commodity detail row, quantity and The tax rate calculate and in each described commodity detail row add valency tax total, invoice amount, the invoice amount of tax to be paid and Invoice unit price, and valency tax total, invoice amount and the invoice tax of all described commodity detail row that adds up respectively To concentrate at described sales slip detailed data, the detailed total valency tax of interpolation adds up to volume, detail adds up to invoice amount The invoice amount of tax to be paid is added up to detail;And
Step S5, according to described in make out an invoice the predetermined commodity detail line number on limit and described VAT invoice, Described sales slip detailed data collection is split into multiple ticket data collection to be developed.
Method the most according to claim 1, wherein, in step s 4,
In the case of the described mark containing tax represents containing tax, below equation is used to calculate each described commodity bright Valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of thin row:
Valency tax total=unit price * quantity;
Invoice amount=valency tax adds up to/(the 1+ tax rate);
The invoice amount of tax to be paid=valency tax total-invoice amount;
Invoice unit price=unit price/(the 1+ tax rate);
In the case of the described mark containing tax represents without tax, below equation is used to calculate each described commodity Valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of detailed row:
Invoice amount=unit price * quantity;
The invoice amount of tax to be paid=invoice amount * tax rate;
Valency tax total=invoice amount+invoice amount of tax to be paid.
Method the most according to claim 1, wherein, described sales slip data set also includes inventory Mark and Chinese character anti-false logo, described Chinese character anti-false logo defines on described VAT invoice Predetermined commodity detail line number, the most described step S5 comprises the following steps:
Step S51, represent the VAT invoice opening band inventory at described inventory mark in the case of, depend on Described sales slip detailed data collection is split into multiple ticket data collection to be developed, wherein according to described limit of making out an invoice Each described ticket data collection to be developed detailed add up to invoice amount be less than or equal to described in make out an invoice limit;
Step S52, in the case of described inventory mark represents and opens without the VAT invoice of inventory, Described sales slip detailed data collection is split by limit of making out an invoice described in Yi Ju and described Chinese character anti-false logo Becoming multiple ticket data collection to be developed, the detailed of the most each described ticket data collection to be developed adds up to invoice amount The commodity detail line number of limit of making out an invoice described in being less than or equal to and each described ticket data collection to be developed is not more than Predetermined commodity detail line number on described VAT invoice.
Method the most according to claim 3, wherein, also includes in each described commodity detail row By discount mark and discount ratio, and the described sales slip amount of money is the amount of money after discount, and each described commodity are bright The amount of money in thin row is the amount of money before discount, then:
In step s3, after utilizing discount, before the amount of money=discount, amount of money * (1-discount ratio) calculates bag The amount of money after the discount of the commodity detail row containing discount commodity, by the amount of money after this discount with do not comprise discount commodity Other commodity detail row in the amount of money carry out cumulative obtaining described detailed Amount in Total, and judge to be stated clearly Thin Amount in Total, whether equal to the described sales slip amount of money, if equal, then goes to step S4;
In step s 4, calculating the valency tax total of each described commodity detail row, invoice amount, sending out Before the ticket amount of tax to be paid and invoice unit price, rearrange described in each always according to described discount ratio and the described tax rate Commodity detail row, calculate have identical discount ratio and same tax rate commodity detail row total line number and Total discount amount, and do business at last of commodity detail row with identical discount ratio and same tax rate Insert a discount row after product detail row, the trade name of this discount row embodies there is identical discount Total line number of the commodity detail row of ratio and same tax rate and discount ratio, the amount of money of this discount row is institute State total discount amount * (-1);And
In step S52, if described ticket data to be developed is concentrated has identical discount ratio and same tax rate A line or multirow commodity detail row last column commodity detail row after do not have discount row then at this A discount row is inserted, if after described last column commodity detail row after rear a line commodity detail row There is discount row and then update this discount row, and update the detailed total valency tax that this ticket data to be developed is concentrated Add up to, detail adds up to invoice amount and the detailed total invoice amount of tax to be paid.
5., for opening a system for many tax rates VAT invoice without amount of tax to be paid sales slip, this system includes:
Acquisition module, for obtaining sales slip data set and sales slip detailed data collection, the institute of ticket to be developed State sales slip data set and include the sales slip amount of money, containing tax mark and limit of making out an invoice, described sales slip detail number Include that multiple commodity detail row, each commodity detail row include trade name, unit price, quantity, gold according to collection Volume and the tax rate;
Detailed amount of money correction verification module, for calculating taking advantage of of unit price and quantity in each described commodity detail row Long-pending, it is judged that whether this product is equal to the amount of money in this commodity detail row;
Sales slip amount of money correction verification module, for carrying out adding up by the amount of money in all described commodity detail row To detailed Amount in Total, it is judged that whether this detail Amount in Total is equal to the described sales slip amount of money;
Invoice data computing module, for according to described containing tax mark, in each described commodity detail row Unit price, quantity and the tax rate calculate and add in each described commodity detail row valency tax total, invoice amount, The invoice amount of tax to be paid and invoice unit price, and the valency tax of all described commodity detail row that adds up respectively adds up to, invoice gold The detailed total valency tax of interpolation adds up to, detail is closed to concentrate at described sales slip detailed data for volume and the invoice amount of tax to be paid Meter invoice amount and the detailed total invoice amount of tax to be paid;And
Split module, after completing described calculating at described invoice data computing module and add up, depend on According to the described predetermined commodity detail line number made out an invoice on limit and described VAT invoice, by bright for described sales slip Thin data set splits into multiple ticket data collection to be developed.
System the most according to claim 5, wherein, described invoice data computing module is used for:
In the case of the described mark containing tax represents containing tax, below equation is used to calculate each described commodity bright Valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of thin row:
Valency tax total=unit price * quantity;
Invoice amount=valency tax adds up to/(the 1+ tax rate);
The invoice amount of tax to be paid=valency tax total-invoice amount;
Invoice unit price=unit price/(the 1+ tax rate);
In the case of the described mark containing tax represents without tax, below equation is used to calculate each described commodity Valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of detailed row:
Invoice amount=unit price * quantity;
The invoice amount of tax to be paid=invoice amount * tax rate;
Valency tax total=invoice amount+invoice amount of tax to be paid.
System the most according to claim 5, wherein, described sales slip data set also includes inventory Mark and Chinese character anti-false logo, described Chinese character anti-false logo defines on described VAT invoice Predetermined commodity detail line number, described fractionation module is used for:
Represent in the case of opening the VAT invoice of band inventory at described inventory mark, according to described in make out an invoice Described sales slip detailed data collection is split into multiple ticket data collection to be developed by limit, the most each described in treat Data set detailed of drawing a bill add up to invoice amount be less than or equal to described in make out an invoice limit;
In the case of described inventory mark represents and opens without the VAT invoice of inventory, open described in foundation Described sales slip detailed data collection is split into multiple waiting out by ticket limit and described Chinese character anti-false logo Invoice data collection, the detailed of the most each described ticket data collection to be developed adds up to invoice amount less than or equal to institute The commodity detail line number stating make out an invoice limit and each described ticket data collection to be developed is not more than described value-added tax Predetermined commodity detail line number on invoice.
System the most according to claim 7, wherein, also includes in each described commodity detail row By discount mark and discount ratio, and the described sales slip amount of money is the amount of money after discount, and each described commodity are bright The amount of money in thin row is the amount of money before discount:
Described sales slip amount of money correction verification module is additionally operable to: (1-rolls over to utilize after discount amount of money * before the amount of money=discount Button ratio) calculate the amount of money after the discount of the commodity detail row comprising discount commodity, by the amount of money after this discount Carry out adding up with the amount of money in other commodity detail row not comprising discount commodity and obtain described detailed total The amount of money, and judge that whether described detailed Amount in Total is equal to the described sales slip amount of money;
Described invoice data computing module be additionally operable to calculate each described commodity detail row valency tax add up to, Before invoice amount, the invoice amount of tax to be paid and invoice unit price, again arrange according to described discount ratio and the described tax rate Arranging each described commodity detail row, calculating has the commodity detail row of identical discount ratio and same tax rate Total line number and total discount amount thereof, and there is the commodity detail row of identical discount ratio and same tax rate Insert a discount row after last column commodity detail row, the trade name of this discount row embodies tool There are total line number and the discount ratio of the commodity detail row of identical discount ratio and same tax rate, this discount row The amount of money be described total discount amount * (-1);And
After described fractionation module completes described fractionation, represent at described inventory mark and open without inventory VAT invoice in the case of, described invoice data computing module is additionally operable to: if described poll to be developed According to concentrating, there is identical discount ratio and a line of same tax rate or last column of multirow commodity detail row Discount row is not had then to insert a discount after this last column commodity detail row after commodity detail row OK, if there is discount row after described last column commodity detail row, this discount row, Yi Jigeng are updated The detailed total valency tax of new this ticket data to be developed concentration adds up to, detail adds up to invoice amount and detailed total The invoice amount of tax to be paid.
CN201510232271.4A 2015-05-08 2015-05-08 For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip Pending CN106204175A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201510232271.4A CN106204175A (en) 2015-05-08 2015-05-08 For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201510232271.4A CN106204175A (en) 2015-05-08 2015-05-08 For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip

Publications (1)

Publication Number Publication Date
CN106204175A true CN106204175A (en) 2016-12-07

Family

ID=57459794

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201510232271.4A Pending CN106204175A (en) 2015-05-08 2015-05-08 For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip

Country Status (1)

Country Link
CN (1) CN106204175A (en)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108596179A (en) * 2018-03-28 2018-09-28 南京邮电大学 A kind of VAT invoice amount of money method of inspection
CN111127122A (en) * 2018-10-30 2020-05-08 营利度富信息系统(上海)有限公司 Order splitting and merging algorithm of invoice management system
CN112270580A (en) * 2020-10-26 2021-01-26 浙江吉利控股集团有限公司 Invoice issuing method, device, equipment and storage medium
CN112613930A (en) * 2020-12-17 2021-04-06 航天信息股份有限公司 Method and system for automatically generating information to be invoiced
CN113450166A (en) * 2021-06-30 2021-09-28 山东浪潮通软信息科技有限公司 Sales invoice processing method and corresponding business management system
CN115018488A (en) * 2022-06-07 2022-09-06 广东企企通科技有限公司 Bill splitting and billing processing method and device and electronic equipment

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108596179A (en) * 2018-03-28 2018-09-28 南京邮电大学 A kind of VAT invoice amount of money method of inspection
CN111127122A (en) * 2018-10-30 2020-05-08 营利度富信息系统(上海)有限公司 Order splitting and merging algorithm of invoice management system
CN112270580A (en) * 2020-10-26 2021-01-26 浙江吉利控股集团有限公司 Invoice issuing method, device, equipment and storage medium
CN112270580B (en) * 2020-10-26 2024-03-29 浙江吉利控股集团有限公司 Invoice issuing method, invoice issuing device, invoice issuing equipment and storage medium
CN112613930A (en) * 2020-12-17 2021-04-06 航天信息股份有限公司 Method and system for automatically generating information to be invoiced
CN113450166A (en) * 2021-06-30 2021-09-28 山东浪潮通软信息科技有限公司 Sales invoice processing method and corresponding business management system
CN115018488A (en) * 2022-06-07 2022-09-06 广东企企通科技有限公司 Bill splitting and billing processing method and device and electronic equipment

Similar Documents

Publication Publication Date Title
CN106204175A (en) For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip
CN106204171A (en) The method and system of single tax rate VAT invoice is opened for the sales slip containing the amount of tax to be paid
CN109872220A (en) A kind of commercial product recommending list method for pushing and commercial product recommending list supplying system
CN109829001A (en) For generating the method and device of invoice data
CN102663594A (en) Electronic commerce catalog distribution system
CN108648005A (en) Data processing method and system
CN101183454A (en) Method and system for managing commodity price on electronic commerce exchange platform
CN109255703A (en) Transaction data processing method and device
CN106920136A (en) The method that the special ticket of shipping is issued
US20180053204A1 (en) Auto-population of discount information into an e-invoice
CN105809523A (en) Method and system for balancing tax for invoicing
CN106204177A (en) For opening the method and system of single tax rate VAT invoice without amount of tax to be paid sales slip
KR101687383B1 (en) Providing method for collaboration task environment using template for developing business model, Computer program for the same, and Recording medium storing computer program thereof
CN111931475A (en) Dynamic subscription book generation method, system, computer equipment and storage medium
Ingwersen et al. Using screening level environmental life cycle assessment to aid decision making: A case study of a college annual report
CN106204173A (en) For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip
CN106204179A (en) For opening the method and system of single tax rate VAT invoice without amount of tax to be paid sales slip
CN106204176A (en) The method and system of many tax rates VAT invoice is opened for the sales slip containing the amount of tax to be paid
CN106204178A (en) The method and system of many tax rates VAT invoice is opened for the sales slip containing the amount of tax to be paid
CN103294730B (en) A kind of data delivery system and method
JP2010510570A (en) System and method for creating customer-facing reports
US10990924B2 (en) System and method for variant content management
JPH10312418A (en) Business template designing method
JPWO2008078384A1 (en) Detail data aggregation device, detail data aggregation program, and detail data aggregation method
EP2116962A1 (en) Detailed data storage device, detailed data storing program, and detailed data storing method

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20161207