CN106204172A - The method and system of single tax rate VAT invoice is opened for the sales slip containing the amount of tax to be paid - Google Patents
The method and system of single tax rate VAT invoice is opened for the sales slip containing the amount of tax to be paid Download PDFInfo
- Publication number
- CN106204172A CN106204172A CN201510230649.7A CN201510230649A CN106204172A CN 106204172 A CN106204172 A CN 106204172A CN 201510230649 A CN201510230649 A CN 201510230649A CN 106204172 A CN106204172 A CN 106204172A
- Authority
- CN
- China
- Prior art keywords
- tax
- amount
- invoice
- commodity
- paid
- 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
Landscapes
- Cash Registers Or Receiving Machines (AREA)
Abstract
The present invention discloses a kind of method and system opening single tax rate VAT invoice for the sales slip containing the amount of tax to be paid, including: obtain battalion change increasing business commodity dictionary table, the sales slip amount of money, the sales slip amount of tax to be paid, the sales slip tax rate, containing tax mark, limit of making out an invoice and the multiple commodity detail row including trade name, unit price, quantity and the amount of money；Whether whether verification unit price be equal to the sales slip amount of money equal to the amount of money, amount of money sum with the long-pending of quantity；According to battalion change in increasing business commodity dictionary table trade name identification battalion change increasing business commodity and in corresponding commodity detail row increase battalion change increasing mark；According to the sales slip tax rate, containing tax mark, unit price sum amount given price tax total, invoice amount, the invoice amount of tax to be paid and invoice unit price；Whether verification detail adds up to the invoice amount of tax to be paid-sales slip amount of tax to be paid less than predetermined value；Change increasing mark according to limit of making out an invoice, battalion and predetermined commodity detail line number splits sales slip detailed data collection and the plurality of ticket data collection to be developed is carried out amount of tax to be paid balance.Which save time and human cost.
Description
Technical field
The present invention relates to electronic invoice technical field, open for the sales slip containing the amount of tax to be paid in particular it relates to a kind of
The method and system of single tax rate VAT invoice.
Background technology
Levying the popularization of value-added tax along with Sales Tax changes, the branch of some conglomerates is except receiving in possession
Beyond tax is declared, in addition it is also necessary to battalion is changed the data such as the sales volume of increasing business, tax amount of offset item and is reported to head office,
Carried out collecting declaring by head office.For the needs of financial management, this part battalion changes increasing business datum and opens
The invoice that should open with other business datum of invoice open respectively.
In enterprise business, the sales slip data generated in operation system are at same sales slip
Upper existing battalion changes increasing business datum, also has non-battalion and changes increasing business datum；Simultaneously because enterprise is in Administration of State Bureau
Registration type, productive and business scope different, the sales slip data of different enterprises also have whether comprise tax
Volume, is that single tax rate is made out an invoice or many tax rates such as are made out an invoice at many attribute, if above-mentioned attribute does not do correct place
Reason is imparted to anti-false tax-controlled system and issues invoice, and will not be inconsistent because of various data check relations, it is impossible to normal
Make out an invoice；Even if or opened invoice, it is also possible to due to the data item such as the amount of money of invoice data, the amount of tax to be paid with
The data item calculated in enterprise marketing list there are differences, and brings problem to the financial management of enterprise.
Summary of the invention
The present invention provides a kind of method and system opening single tax rate VAT invoice for the sales slip containing the amount of tax to be paid,
It can time-consuming and human cost, can be prepared in advance to meet for Ying Gaizengzong sub-agencies enterprise again and send out
The ticket data to be developed of ticket data specification, helps Ying Gaizengzong sub-agencies enterprise to issue invoice smoothly.
The present invention provides a kind of method opening single tax rate VAT invoice for the sales slip containing the amount of tax to be paid, the method
Including:
Step S1, obtain battalion change increasing business commodity dictionary table and the sales slip data set of ticket to be developed and
Sales slip detailed data collection, described battalion changes increasing business commodity dictionary table and includes that belonging to battalion changes increasing business
The trade name of commodity, described sales slip data set includes the sales slip amount of money, the sales slip amount of tax to be paid, sales slip
The tax rate, containing tax mark and limit of making out an invoice, described sales slip detailed data collection includes multiple commodity detail row,
Each commodity detail row includes trade name, unit price, quantity and the amount of money；
Step S2, whether verify in each described commodity detail row the product of unit price and quantity equal to this business
The amount of money in product detail row, and whether verify the amount of money sum in all described commodity detail row equal to described
The sales slip amount of money；
Step S3, the trade name changed according to described battalion in increasing business commodity dictionary table are to identify described pin
Sell single detailed data to be grouped as seeking commodity the increasing in the commodity detail row at this commodity place changing increasing business
Add battalion and change increasing mark；
Step S4, according to the described sales slip tax rate, described detailed containing tax mark and each described commodity
Unit price sum amount in row calculates and adds in each described commodity detail row valency tax total, invoice gold
Volume, the invoice amount of tax to be paid and invoice unit price, and the valency tax in all described commodity detail row that adds up respectively adds up to,
Invoice amount and the invoice amount of tax to be paid with described sales slip detailed data concentrate add detailed total valency tax add up to,
Detailed total invoice amount and the detailed total invoice amount of tax to be paid；
Whether step S5, verification (the detailed total invoice amount of tax to be paid-sales slip amount of tax to be paid) be less than predetermined value；With
And
Step S6, according to described in make out an invoice limit, described battalion change on increasing mark and described VAT invoice
Described sales slip detailed data collection is split into multiple ticket data collection to be developed by predetermined commodity detail line number, and
The plurality of ticket data collection to be developed is carried out amount of tax to be paid balance.
The present invention also provides for a kind of system opening single tax rate VAT invoice for the sales slip containing the amount of tax to be paid, and this is
System includes:
Acquisition module, changes increasing business commodity dictionary table and the sales slip data of ticket to be developed for obtaining battalion
Collection and sales slip detailed data collection, described sales slip data set include the sales slip amount of money, the sales slip tax rate,
Containing tax mark and limit of making out an invoice, described sales slip detailed data collection includes multiple commodity detail row, Mei Geshang
Product detail row includes that trade name, unit price, quantity and the amount of money, described battalion change in increasing business commodity dictionary table
Including belonging to the trade name that battalion changes the commodity of increasing business；
Sales slip data check module, for verifying taking advantage of of unit price and quantity in each described commodity detail row
Long-pending whether equal to the amount of money in this commodity detail row, and verify the amount of money in all described commodity detail row it
Whether equal to the described sales slip amount of money；
Battalion changes increasing identification module, for changing the trade name in increasing business commodity dictionary table according to described battalion
Identify that described sales slip detailed data is grouped as seeking the commodity changing increasing business the commodity at this commodity place
Detailed row increases battalion and changes increasing mark；
Invoice data computing module, for according to the described sales slip tax rate, described containing tax mark and each
Unit price sum amount in described commodity detail row calculates and adds valency tax in each described commodity detail row
Total, invoice amount, the invoice amount of tax to be paid and invoice unit price, and add up respectively in all described commodity detail row
Valency tax add up to, invoice amount and the invoice amount of tax to be paid add detail close to concentrate at described sales slip detailed data
Valuation tax adds up to, detail adds up to invoice amount and detail adds up to the invoice amount of tax to be paid；
Sales slip amount of tax to be paid correction verification module, being used for verifying (detailed add up to the invoice amount of tax to be paid-sales slip amount of tax to be paid) is
No less than predetermined value；And
Split module, for after described sales slip amount of tax to be paid correction verification module completes described verification, according to institute
State limit of making out an invoice, described battalion changes the predetermined commodity detail line number increased on mark and described VAT invoice by institute
State sales slip detailed data collection and split into multiple ticket data collection to be developed, and to the plurality of poll to be developed
Amount of tax to be paid balance is carried out according to collection.
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 of Ying Gaizengzong sub-agencies enterprise
Open efficiency, reduce the Ying Gaizengzong sub-agencies enterprise risk issued invoice lack of standardization, promote that battalion changes increasing total
Sub-agencies enterprise legacy specification is managed and normal invoice issuing, strengthens further and specification VAT invoice
Management, improves the Financial Control Level of Ying Gaizengzong sub-agencies 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 is opening single tax rate value-added tax for the sales slip containing the amount of tax to be paid and send out according to one embodiment of the present invention
The flow chart of the method for ticket；And
Fig. 2 is opening single tax rate value-added tax for the sales slip containing the amount of tax to be paid and send out according to one embodiment of the present invention
The block diagram of the system of ticket.
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.
It can only be a kind of that single tax rate refers to the commodity detail tax rate on a VAT invoice；Containing the amount of tax to be paid
Sales slip is the one of enterprise marketing list, according to the needs of financial management, enterprise before invoice issuing the most
Through having calculated the amount of tax to be paid of this sales slip in sales slip.The feature of this sales slip data is to sell
Single master data identifies a kind of tax rate, identifies the amount of tax to be paid simultaneously；But do not mark in sales slip detailed data
Know the tax rate and the most do not identify the amount of tax to be paid.
As it is shown in figure 1, opening single tax rate for the sales slip containing the amount of tax to be paid and increase according to one embodiment of the present invention
The method of value tax invoice comprises the following steps:
Step S1, obtain battalion change increasing business commodity dictionary table and the sales slip data set of ticket to be developed and
Sales slip detailed data collection, battalion changes increasing business commodity dictionary table and includes belonging to battalion and change the commodity of increasing business
Trade name, sales slip data set include the sales slip amount of money, the sales slip amount of tax to be paid, the sales slip tax rate, containing tax
Mark and limit of making out an invoice, sales slip detailed data collection includes multiple commodity detail row, each commodity detail row
Including trade name, unit price, quantity and the amount of money.
Generally, in the operation system of Ying Gaizengzong sub-agencies enterprise, the pin in sales slip tables of data can be given
Sell list and add mark of making out an invoice, in order to clearly search and process the sales slip not issued invoice.Therefore,
The sales slip increasing total sub-agencies enterprise operation system can be changed in battalion according to " mark of making out an invoice " of sales slip
Tables of data is searched the sales slip key data not issued invoice, forms sales slip data set.Such as, may be used
To use SQL statement or other computer program statements to obtain sales slip data set, exemplary SQL
Sentence format is: " SELECT sells odd numbers, the sales slip amount of money, the sales slip amount of tax to be paid, the sales slip tax rate,
Containing tax mark, inventory mark, Chinese character anti-false logo, limit FROM of making out an invoice sales slip tables of data
WHERE makes out an invoice mark=' not making out an invoice ' ".Above SQL statement form is only exemplary, in reality
In the operation of border, inventory mark and Chinese character anti-false logo are not necessary to acquisition, namely are selling odd number
In the case of not including inventory mark and Chinese character anti-false logo according to concentration, can be follow-up to sales slip
When detailed data collection splits, the predetermined commodity detail line number on VAT invoice is defined to such as 7
Row (this changes according to the VAT invoice of tax bureau's offer), so that each ticket data collection to be developed
In the restrictive condition that specifies less than the tax bureau of commodity detail line number maximum.Table 1 gives exemplary
Sales slip data set.
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, amount of money FROM sales slip commodity detailed data table WHERE sells
Sell odd numbers=' present sales odd numbers ' ".Wherein, by discount mark and discount ratio not necessarily, when
When Ying Gaizengzong sub-agencies enterprise does not carries out discount sales to commodity, sales slip detailed data is concentrated can not
Including by discount mark and discount ratio.Table 2 shows that the sales slip XSD0001's of table 1 is exemplary
Sales slip detailed data collection.
| Sequence number | Trade name | By discount mark | Discount ratio | Unit price | Quantity | The amount of money |
| 1 | Commodity 1 | 1000.00 | 1 | 1000.00 | ||
| 2 | Commodity 2 | 750.00 | 2 | 1500.00 | ||
| 3 | Discounting commodity 1 | Y | 20% | 300.00 | 2 | 600.00 |
| 4 | Discounting commodity 2 | Y | 20% | 400.00 | 1 | 400.00 |
| 5 | Commodity 3 | 700.00 | 2 | 1400.00 | ||
| 6 | Commodity 4 | 400.00 | 4 | 1600.00 | ||
| 7 | Discounting commodity 3 | Y | 20% | 400.00 | 13 | 5200.00 |
| 8 | Discounting commodity 4 | Y | 20% | 600.00 | 3 | 1800.00 |
| 9 | Commodity 5 | 500.00 | 5 | 2500.00 | ||
| 10 | Commodity 6 | 300.00 | 2 | 600.00 | ||
| 11 | Commodity 7 | 200.00 | 2 | 400.00 |
Table 2
It addition, battalion changes increasing business commodity dictionary table and can pre-build, and along with battalion changes the total sub-agencies of increasing
The development of business event and belong to battalion change the increase of type of merchandize of increasing business and be constantly updated and
Safeguard.Table 3 gives a kind of exemplary battalion and changes increasing business commodity dictionary table.
| Commodity code | Trade name | Remarks |
| SP0001 | Commodity 1 | |
| SP0002 | Commodity 2 | |
| … | … |
Table 3
Step S2, to verify unit price and the product of quantity in each commodity detail row the brightest equal to these commodity
The amount of money in thin row, and whether verify the amount of money sum in all commodity detail row equal to the sales slip amount of money.
Wherein, in verifying each commodity detail row, unit price is the most detailed equal to these commodity with the product of quantity
During the amount of money in row, can concentrate at sales slip detailed data, from first bar to end data circulation, one by one
Obtain these data item of line number, the amount of money, quantity and unit price of every commodity detail row, and calculate " single
Valency * 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 point out such as " line number be ' current line number ' sales slip detailed data concentrate, unit price * quantity with gold
Volume is unequal ", and terminate algorithm flow；If equal, then continue subsequent step.
When whether the amount of money sum in verifying all commodity detail row is equal to the sales slip amount of money, can be at pin
Sell single detailed data to concentrate, from first bar to end data circulation, obtain the gold of every commodity detail row one by one
Volume data item, accumulative addition calculation generates detailed Amount in Total, and judges this detail Amount in Total and sale
Single amount of money is the most equal, if unequal, then points out such as " the ∑ sales slip detail amount of money and sales slip gold
Volume is unequal " after, terminate algorithm flow；If equal, then continue subsequent step.
Step S3, foundation battalion change the trade name in increasing business commodity dictionary table to identify that sales slip is detailed
Data are grouped as seeking and change the commodity of increasing business and increase battalion in the commodity detail row at this commodity place and change increasing
Mark.
Preferably, this step can be realized by procedure below: calculates successively in each commodity detail row
Trade name and battalion change the Similarity value of trade name in increasing business commodity dictionary table；If being calculated
The Similarity value of the trade name in same commodity detail row is more than the first predetermined value, then stop calculating this business
The name of an article claims and the Similarity value seeking the surplus commodities title changed in increasing business commodity dictionary table；And accordingly
Commodity detail row in increase battalion change increasing mark.As a example by the sales slip detailed data collection shown in table 2, first
The Similarity value first calculating commodity 1 and seek the trade name changed in increasing business commodity dictionary table, if commodity 1
The Similarity value changing certain trade name in increasing business commodity dictionary table with battalion is more than the first predetermined value, then stop
The Similarity value only calculating commodity 1 and seek the surplus commodities title changed in increasing business commodity dictionary table, and
The first row commodity detail row of table 2 adds battalion and changes increasing mark Y to represent that commodity 1 are that battalion changes increasing commodity；
The rest may be inferred, till the calculating of the Similarity value of the commodity 7 completed in last column commodity detail row,
Thus obtain the exemplary sales list detailed data collection shown in table 4.Thus need not calculate same commodity bright
Trade name in thin row and battalion change the Similarity value of the entire service title in increasing business commodity dictionary table,
Thus save the calculating time, improve the data-handling efficiency of the method according to the invention.
Preferably, this step can also be realized by procedure below: calculates each commodity detail row successively
In trade name and battalion change the Similarity value of entire service title in increasing business commodity dictionary table；Will be with
Trade name in one commodity detail row and battalion change the entire service title in increasing business commodity dictionary table
Maximum similarity value in Similarity value is added in corresponding commodity detail row, if this maximum similarity value
More than the first predetermined value, then in this corresponding commodity detail row, increase battalion change increasing mark.Or with table 2
Sales slip detailed data collection as a example by.First calculate commodity 1 and seek change in increasing business commodity dictionary table complete
The Similarity value of portion's trade name, adds the 1st article of commodity detail to by the maximum similarity value 1 calculated
In row, and the battalion in this commodity detail row is changed increasing mark it is set to Y, namely think that these commodity are
Battalion changes the commodity of increasing business；Then calculate commodity 2 and change the entire service in increasing business commodity dictionary table with battalion
The Similarity value of title, adds in the 2nd article of commodity detail row by the maximum similarity value 1 calculated,
And the battalion in this commodity detail row changed increasing mark be set to Y；By that analogy, until completing last
The commodity 7 done business in product detail row change the similar of the entire service title in increasing business commodity dictionary table to battalion
Till the calculating of angle value, thus obtain the exemplary sales list detailed data collection shown in table 4.Certainly, exist
When performing this process, battalion changes the setting of increasing mark can also be in the trade name in completing all commodity detail row
The Similarity value claimed performs after calculating.Or as a example by the sales slip detailed data collection of table 2: first count
Calculate commodity 1 and seek the Similarity value of the entire service title changed in increasing business commodity dictionary table and will be calculated
Maximum similarity value 1 add in the 1st article of commodity detail row, then calculate commodity 2 and change increasing industry with battalion
The maximum similarity value 1 calculated also is added by the Similarity value of entire service title in business commodity dictionary table
Being added in the 2nd article of commodity detail row, the rest may be inferred, until the business completed in last column commodity detail row
Till the calculating of the Similarity value that product 7 and battalion change the entire service title in increasing business commodity dictionary table, from
And obtain the exemplary sales list detailed data collection shown in table 4；Then every commodity in table 4 it are successively read
It is also compared, if this Similarity value is more than first by Similarity value in detailed row with the first predetermined value
Predetermined value, just changes the battalion in this commodity detail row increasing mark and is set to Y.
Wherein, similarity refers to the similarity degree of two titles, is to use fuzzy synthesis judgment principle, will
Two contents to be evaluated carry out the numerical value that computing draws.Two duplicate contents, Similarity value is 1,
As: " notebook computer " is 1 with the end value of the Similarity Measure of " notebook computer ", illustrates two
Content relatively is identical.Two complete different contents, Similarity value is 0, such as: " notebook
Computer " it is 0 with the Similarity value of " hard disk ", illustrate that two contents compared are entirely without in identical
Hold.The Similarity value of part identical content is between (0,1), such as: " yellow big metal goods and materials withdrawer is high
Meishan City " with " Emeishan City the biggest metal goods and materials withdrawer " Similarity Measure result be 0.35, explanation
In two contents compared, some is identical content.
The calculating of Similarity value can use fuzzy synthesis judgment principle to complete, such as can be bright by commodity
Trade name and battalion in thin row change the trade name the two data item generation in increasing business commodity dictionary table
Enter in method utl_match.edit_distance_similarity provided in ORACLE data base and calculate
The Similarity value of trade name.
Table 4
After completing to seek and changing the setting increasing mark, (such as, hand inspection) can be examined in whether
Have battalion to change increase the situation of mark mistake and correct.Preferably, the first predetermined value can be such as 0.5
Or other are suitably worth.
Step S4, according to the sales slip tax rate, containing the unit price in tax mark and each commodity detail row and
Quantity calculates and adds valency tax total, invoice amount, the invoice amount of tax to be paid and invoice in each commodity detail row
Unit price, and the valency tax in all commodity detail row of adding up respectively adds up to, invoice amount and the invoice amount of tax to be paid with
Sales slip detailed data concentrates interpolation detailed total valency tax total, detail to add up to invoice amount and detail to add up to
The 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+ sales slip tax rate)；
The invoice amount of tax to be paid=valency tax total-invoice amount；
Invoice unit price=unit price/(the 1+ sales slip 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 * sales slip 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 6 hereinafter asked for an interview by sales slip detailed data collection.
Whether step S5, verification (the detailed total invoice amount of tax to be paid-sales slip amount of tax to be paid) be less than predetermined value.
Generally, the amount of tax to be paid that the amount of tax to be paid that enterprise practical is made out an invoice calculates if less than enterprise in sales slip oneself, also
I.e. enterprise has underpay tax, then enterprise allows to make out an invoice.But, if the amount of tax to be paid that enterprise practical is made out an invoice
The amount of tax to be paid calculated more than enterprise in sales slip oneself, but its difference is again in the range of error allows, then need
Amount of tax to be paid error to be balanced, it is therefore an objective to will make out an invoice according to the sales slip amount of tax to be paid, it is impossible to pay taxes more.This step is just
Carry out based on such actual scene.Therefore, if amount of tax to be paid error=(detail adds up to invoice tax
Volume-sales slip amount of tax to be paid) more than predetermined value, the then scope that this amount of tax to be paid error allows beyond error, prompting
After " the ∑ invoice amount of tax to be paid exceeds error allowed band with the difference of the sales slip amount of tax to be paid, it is impossible to make out an invoice ", terminate
Algorithm flow, if this amount of tax to be paid error is less than predetermined value, then continues subsequent step.
Preferably, described predetermined value is 1.27, and it is the allowed amount of tax to be paid error according to revenue department's regulation
Arrange.Certainly, selecting the value less than 1.27 is also feasible as predetermined value.
Step S6, according to limit of making out an invoice, that battalion changes the predetermined commodity increased on mark and VAT invoice is detailed
Sales slip detailed data collection is split into multiple ticket data collection to be developed by line number, and to multiple polls to be developed
Amount of tax to be paid balance is carried out according to collection.
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 Ying Gaizengzong sub-agencies enterprise
The maximum commodity detail line number can listed on VAT invoice.That is, each finally given is waited out
The detailed of invoice data collection adds up to invoice amount can not be more than limit of making out an invoice, and its commodity detail line number can not surpass
Crossing the predetermined commodity detail line number that Ying Gaizengzong sub-agencies enterprise can open on VAT invoice, battalion changes
Increasing and non-battalion change the commodity of increasing business and can not be opened on same VAT invoice.It is exemplary that fractionation obtains
Table 7 to table 9 hereinafter asked for an interview by ticket data collection to be developed.
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, purchasing unit title, sales organization 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, the Chinese
The false proof logo of word defines the predetermined commodity detail line number on VAT invoice.Wherein, inventory mark
For representing whether the VAT invoice opening band inventory, such as, can represent open with inventory mark Y
The VAT invoice of tool band inventory, represents with inventory mark N and opens the VAT invoice without inventory.The Chinese
The false proof logo of word illustrates enterprise's registration type in Administration of State Bureau, such as, can use Chinese character anti-false enterprise
Mark Y represents that this enterprise is Chinese character anti-false enterprise, represents that this enterprise is with Chinese character anti-false logo N
Non-Chinese character anti-false enterprise.Regulation, non-Chinese character anti-false enterprise is opened according to current tax bureau's VAT invoice
The commodity detail line number opened on VAT invoice not can exceed that 8, and Chinese character anti-false enterprise is at value-added tax
The commodity detail line number opened on invoice not can exceed that 7.Then:
(1) in the case of inventory mark represents and opens the VAT invoice of band inventory, abovementioned steps S6
Including: according to making out an invoice limit and battalion changes increasing mark and sales slip detailed data collection is split into multiple ticket to be developed
Data set, the most same ticket data to be developed concentrate all commodity detail row battalion change increasing mark the most identical and
The detailed of each ticket data collection to be developed adds up to invoice amount to be respectively less than equal to making out an invoice limit.Owing to being to open
VAT invoice with inventory, it is possible to do not consider Chinese character anti-false logo.Such as, this step can
To be carried out as follows: first, change increasing mark according to battalion and sales slip detailed data collection is divided into battalion changes increasing mark group
Changing increasing mark group with non-battalion, i.e. by such as SQL statement, " SELECT*FROM sales slip is detailed
Data set WHERE battalion changes and increases mark=" Y " " or other suitable computer program statements will sell
Single detailed data concentration camp changes to increase and is designated the commodity detail row of Y and is divided into battalion and changes in increasing mark group, passes through
Such as " SELECT*FROM sales slip detailed data JiWHEREYing changes increasing mark to SQL statement
Know！=" Y " " or other suitable computer program statements sales slip detailed data concentration camp is changed increasing mark
Know and be not divided into non-battalion for the commodity detail row of Y and change in increasing mark group, thus make to seek and change increasing business
Commodity and non-battalion change the commodity of increasing business and are opened on different VAT invoices；Then increasing is changed for battalion
Mark group and non-battalion change increasing mark group, follow to end bar commodity detail row from first bar commodity detail row the most successively
Ring, takes the invoice amount in every commodity detail row its Amount in Total of accumulation calculating, when accumulation calculating arrives
Amount in Total obtained during certain commodity detail row more than make out an invoice limit time, by this commodity detail row it
Front entire service detail row is split to a ticket data to be developed and concentrates, and the rest may be inferred, just battalion is changed increasing
Mark group and non-battalion change the commodity detail row increased in mark group and have been split to multiple ticket data to be developed respectively
Concentrate so that the detailed total invoice amount that each ticket data to be developed is concentrated is not more than invoice limit, and
It is identical that battalion in the commodity detail row that same ticket data to be developed is concentrated changes increasing mark.
(2) in the case of inventory mark represents and opens without the VAT invoice of inventory, abovementioned steps
S6 includes: change increasing mark and Chinese character anti-false logo by sales slip detail number according to limit of making out an invoice, battalion
Splitting into multiple ticket data collection to be developed according to collection, the most same ticket data to be developed concentrates all commodity detailed
It is the most identical that the battalion of row changes increasing mark, and the detailed of each ticket data collection to be developed adds up to invoice amount to be respectively less than
Commodity detail line number in make out an invoice limit and each ticket data collection to be developed is not more than on VAT invoice
Predetermined commodity detail line number.That is, according to existing tax bureau regulation, non-Chinese character anti-false enterprise is sent out at value-added tax
At most can only open 8 commodity detail line numbers on ticket, Chinese character anti-false enterprise on VAT invoice at most only
7 commodity detail line numbers can be opened.
It addition, when Ying Gaizengzong sub-agencies enterprise is to its commodity discount sales, increasing total score will be changed in battalion
The sales slip detailed data table of enterprise of mechanism have by discount mark and discount ratio the two data item, with
Showing which commodity is discounting commodity, discount percentage is how many, consequently facilitating Ying Gaizengzong sub-agencies enterprise
Financial management.It is therefore preferred that each commodity detail row also includes by discount mark and discount rate
Example, and the sales slip amount of money is the amount of money after discount, the sales slip amount of tax to be paid also for consider the amount of tax to be paid after discount,
The amount of money in each commodity detail row is the amount of money before discount, so:
In aforesaid step S2, it is necessary to utilize after discount amount of money * (1-discount rate before the amount of money=discount
Example) calculate the discount of the commodity detail row comprising discount commodity after the amount of money and after verifying this discount the amount of money with
Whether do not comprise the amount of money sum in other commodity detail row of discount commodity equal to the sales slip amount of money.Namely
When having discounting commodity in the sales slip detailed data table of Ying Gaizengzong sub-agencies enterprise, need first to calculate
After the discount of this commodity detail row, the amount of money adds up the most again.
And, in aforesaid step S4, calculating the valency tax total of each commodity detail row, invoice
Before the amount of money, the invoice amount of tax to be paid and invoice unit price, in addition it is also necessary to rearrange each institute according to described discount ratio
State commodity detail row, calculate total line number of the commodity detail row with identical discount ratio and total discount gold thereof
Volume, and after there is last column commodity detail row of commodity detail row of identical discount ratio, insert one
Bar discount row, embodies the commodity detail row with identical discount ratio in the trade name of this discount row
Total line number and discount ratio, the amount of money of this discount row is described total discount amount * (-1).Such as, may be used
To divide the commodity detail row of identical discount ratio at one group, and being arranged in order by group, discount ratio is empty
One group of commodity represented in this group commodity detail row be non-discounting commodity, can be by this group commodity detail row
It is arranged in foremost (certainly, be arranged in sales slip detailed data collection is the most also feasible)；Right
Discount ratio is not empty each group commodity detail row, needs to add up respectively the head office of each group of commodity detail row
Number, calculates total discount amount of each group of commodity detail row, and wherein total these group commodity of discount amount=∑ are detailed
Amount of money * discount ratio in row, and insert after last column commodity detail row of each group of commodity detail row
Entering a discount row, the trade name of this discount row can be " discount line number Y (X.XXX%) ",
Wherein " Y " is the total line number calculating the commodity detail row that each group generated has identical discount ratio, " X "
For discount ratio, or the trade name of this discount row can also be that other can embody this group and have identical
Total line number of the commodity detail row of discount ratio and other titles of discount ratio, the amount of money of this discount row is
Calculate total discount amount * (-1) generated to represent that commodity are given a discount.Table 5 gives in discount ratio
Rearrange commodity detail row and insert the exemplary sales list detailed data collection after discount row.
Table 5
Table 6
Table 6 gives and calculates the valency tax total of each commodity detail row, invoice gold on the basis of table 5
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.
And, when sales slip detailed data concentration includes by discount mark and discount ratio, in step
Also needing in S6 process discount row, ticket data the most to be developed is concentrated has identical discount rate
Discount row is not had then at this after a line of example or last column commodity detail row of multirow commodity detail row
Insert a discount row after last column commodity detail row and (wherein, insert the operation of discount row with before
The operation of described insertion discount row is identical, and here is omitted), if bright at described last column commodity
There is after thin row discount row then update this discount row and (wherein, update the operation of discount row with described before
The operation of insertion discount row identical, the most also repeat no more), and update this ticket data collection to be developed
In detailed total valency tax add up to, detailed add up to invoice amount and detailed add up to the invoice amount of tax to be paid.Thus can
Enough discount datas concentrating every ticket data to be developed process again, so that every ticket to be developed
Data in data set are the most accurate, it is to avoid occur according on the invoice that this ticket data collection to be developed is opened
The amount of money, the data item that calculated in the data item such as the amount of tax to be paid and the sales slip of Ying Gaizengzong sub-agencies enterprise deposits
In the situation of difference, improve the Financial Control Level of Ying Gaizengzong sub-agencies enterprise.Sale with table 6
As a example by single detailed data collection, after utilizing this step to split, obtain three ticket data collection to be developed,
Ask for an interview shown in table 7 to table 9.From table 7 to table 9 it can be seen that battalion changes the commodity of increasing business and non-battalion changes
The commodity of increasing business are split has assigned to different ticket data to be developed concentrations, each ticket data collection to be developed
Detailed invoice amount is added up to respectively less than to make out an invoice limit (limits of 10000 yuan be i.e. given in table 1)；By
The inventory mark be given in table 1 is N, and Chinese character anti-false logo is N, so split is each
The maximum 8 that the commodity detail line number of ticket data collection to be developed all can be opened less than non-Chinese character anti-false enterprise
Bar commodity detail line number；And, after the split, owing to after the discounting commodity 2 in table 6 being originally
There is no discount row, so needing to insert a line discount row in table 8 after discount commodity 2, so that
The invoice amount sum obtained in table 8 in all commodity detail row adds up to invoice amount equal to detail；It addition,
Owing to originally having discount row after the discounting commodity 4 in table 6, thus also need to after the split right
Discount row in table 9 is updated.
Table 7
Table 8
Table 9
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 S6
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 S6, can according to above-mentioned open without
In split process in the case of the VAT invoice of inventory, process will be for processing procedure to discount data
The discount data on inventory it is listed in when making out an invoice.
Preferably, the amount of tax to be paid balance that carries out multiple ticket data collection to be developed in step S6 includes following step
Rapid:
Step S61, calculating ready to balance total error, wherein, ready to balance total error=all polls to be developed
Detailed according to collection adds up to invoice amount of tax to be paid sum-sales slip amount of tax to be paid；
Step S62, the balanced invoice amount of tax to be paid error of calculating i-th ticket data to be developed collection, wherein,
(the detailed total invoice amount * sales slip tax rate-detail adds up to invoice can to balance invoice amount of tax to be paid error=1.27-
The amount of tax to be paid)；
If the balanced invoice amount of tax to be paid error of step S63 i-th ticket data to be developed collection > ready to balance always misses
Difference, then add up to the invoice amount of tax to be paid to be revised as i-th ticket to be developed the detailed of ticket data collection to be developed for i-th
The detailed invoice amount of tax to be paid+ready to balance total error that adds up to of data set, and terminate amount of tax to be paid balance；
If < ready to balance always misses the balanced invoice amount of tax to be paid error of step S64 i-th ticket data to be developed collection
Difference, then add up to the invoice amount of tax to be paid to be revised as i-th ticket to be developed the detailed of ticket data collection to be developed for i-th
Detailed the balanced invoice amount of tax to be paid error adding up to the invoice amount of tax to be paid+i-th ticket data to be developed collection of data set,
And return step S61 to continue the amount of tax to be paid balance of i+1 ticket data collection to be developed, wherein,
I=1,2 ... N, N are positive integer.Wherein, i+1 ticket data collection to be developed is being carried out amount of tax to be paid balance
Time, can use ready to balance total error=ready to balance total error i-th ticket data to be developed collection can
Balance invoice amount of tax to be paid error recalculates ready to balance total error, it would however also be possible to employ the calculating in step S61
Formula recalculates ready to balance total error.
So, after carrying out amount of tax to be paid balance by step S61 to S64, it becomes possible to make whole ticket to be developed
Detailed total invoice amount of tax to be paid sum in data set is equal with the sales slip amount of tax to be paid.
It will be apparent to a skilled person that the algorithm carrying out amount of tax to be paid balance is not limited to step
Algorithm shown in S61-S64, other amount of tax to be paid balanced algorithm is also feasible.For example, it is possible to will wait to put down
Weighing apparatus total error is evenly distributed to the detailed of each ticket data collection to be developed and adds up in the invoice amount of tax to be paid.
According to one embodiment of the present invention, the present invention also provides for one and opens list for the sales slip containing the amount of tax to be paid
The system of tax rate VAT invoice, this system include acquisition module 21, sales slip data check module 22,
Battalion changes increasing identification module 23, invoice data computing module 24, sales slip amount of tax to be paid correction verification module 25 and splits
Module 26.
Wherein, acquisition module 21, change increasing business commodity dictionary table and the pin of ticket to be developed for obtaining battalion
Selling forms data collection and sales slip detailed data collection, sales slip data set includes the sales slip amount of money, sales slip tax
Volume, the sales slip tax rate, containing tax mark and limit of making out an invoice, sales slip detailed data collection includes that multiple commodity are bright
Thin row, each commodity detail row includes that trade name, unit price, quantity and the amount of money, battalion change increasing business commodity
Dictionary table includes the trade name belonging to the commodity that battalion changes increasing business.Such as, acquisition module 21 is permissible
According to " mark of making out an invoice " of sales slip, change the sales slip data increasing total sub-agencies enterprise operation system in battalion
Table is searched the sales slip key data not issued invoice, forms sales slip data set and sales slip detail number
According to collection.Such as, acquisition module 21 can use SQL statement or other computer program statements to obtain
Sales slip data set, exemplary SQL statement form is: " SELECT sells odd numbers, sales slip gold
Volume, the sales slip amount of tax to be paid, the sales slip tax rate, containing tax mark, limit FROM of making out an invoice sales slip tables of data
WHERE makes out an invoice mark=' not making out an invoice ' ", and obtain the exemplary SQL of sales slip detailed data collection
Sentence format can be: " SELECT sequence number, trade name, unit price, quantity, amount of money FROM sells
Sell single commodity detailed data table WHERE and sell odd numbers=' present sales odd numbers ' ".It addition, above
Battalion having changed increasing business commodity dictionary table be described, here is omitted.
Sales slip data check module 22, for verifying unit price and the product of quantity in each commodity detail row
Whether equal to the amount of money in this commodity detail row, and whether verify the amount of money sum in all commodity detail row
Equal to the sales slip amount of money.The operation of sales slip data check module 22 is similar to above-mentioned according to the present invention's
The operation of step S2 in method, here is omitted.
Battalion changes increasing identification module 23 and knows for the trade name changed in increasing business commodity dictionary table according to battalion
Other sales slip detailed data is grouped as seeking the commodity changing increasing business the commodity detail row at this commodity place
Middle increase battalion changes increasing mark.Battalion changes increasing identification module 23 and can use above in conjunction with the side according to the present invention
The operation that method describes identifies that battalion changes the commodity of increasing business, and here is omitted.
Invoice data computing module 24, for according to the sales slip tax rate, bright containing tax mark and each commodity
Unit price sum amount in thin row calculate and add in each commodity detail row valency tax total, invoice amount,
The invoice amount of tax to be paid and invoice unit price, and by all commodity detail row valency tax add up to, invoice amount and send out
The ticket amount of tax to be paid is cumulative to add detailed total valency tax total, detailed total in sales slip detailed data concentration respectively
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), invoice data computing module 24 uses below equation meter
Calculate valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of each commodity detail row:
Valency tax total=unit price * quantity；
Invoice amount=valency tax adds up to/(the 1+ sales slip tax rate)；
The invoice amount of tax to be paid=valency tax total-invoice amount；
Invoice unit price=unit price/(the 1+ sales slip 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 * sales slip tax rate；
Valency tax total=invoice amount+invoice amount of tax to be paid.
Sales slip amount of tax to be paid correction verification module 25 is used for verifying (the detailed total invoice amount of tax to be paid-sales slip amount of tax to be paid)
No less than predetermined value.In the operation of sales slip amount of tax to be paid correction verification module 25 and above-mentioned the method according to the invention
The operation of step S5 is similar, and here is omitted.
Split module 26, be used for after sales slip amount of tax to be paid correction verification module 25 completes described verification, foundation
Make out an invoice limit, battalion change increase mark and VAT invoice on predetermined commodity detail line number by sales slip detail number
Split into multiple ticket data collection to be developed according to collection, and multiple ticket data collection to be developed are carried out amount of tax to be paid balance.
That is, the detailed of each ticket data collection to be developed finally given adds up to invoice amount can not be more than limit of making out an invoice
Volume, its commodity detail line number not can exceed that the predetermined commodity detail line number on VAT invoice, battalion change increasing and
Non-battalion changes the commodity of increasing business and can not be opened on same VAT invoice.
After splitting module 26 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 26 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 limit and battalion changes increasing mark and sales slip detailed data collection is split into multiple ticket to be developed
Data set, the most same ticket data to be developed concentrate all commodity detail row battalion change increasing mark the most identical and
The detailed of each ticket data collection to be developed adds up to invoice amount to be respectively less than equal to making out an invoice limit；At inventory mark
Represent in the case of opening without the VAT invoice of inventory, change increasing mark and the Chinese according to limit of making out an invoice, battalion
Sales slip detailed data collection is split into multiple ticket data collection to be developed by the false proof logo of word, the most same
It is the most identical that ticket data to be developed concentrates the battalion of all commodity detail row to change increasing mark, each ticket data to be developed
The detailed of collection adds up to invoice amount to be respectively less than 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 26
This operation can be similar to the operation in above-mentioned the method according to the invention described in step S6, herein
Repeat no more.
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, sales slip tax
Volume is also for consider the amount of tax to be paid after discount, and the amount of money in each commodity detail row is the amount of money before discount.?
In this case, sales slip data check module 22 is additionally operable to: utilize after discount the amount of money before the amount of money=discount
* the amount of money verify should after (1-discount ratio) calculates the discount of the commodity detail row comprising discount commodity
After discount, whether the amount of money and the amount of money sum in other commodity detail row not comprising discount commodity be equal to pin
Sell single amount of money.Namely when having discounting commodity in the sales slip detailed data table of enterprise, sales slip data school
Test the amount of money after module 22 needs first to calculate the discount of this commodity detail row to add up the most again.Invoice
Data computation module 24 is additionally operable to calculating the valency tax total of each commodity detail row, invoice amount, sending out
Before the ticket amount of tax to be paid and invoice unit price, rearrange each described commodity detail row according to discount ratio, calculate
There is total line number of the commodity detail row of identical discount ratio and total discount amount thereof, and there is identical folding
A discount row, this discount row is inserted after last column commodity detail row of the commodity detail row of button ratio
Trade name in embody total line number and the discount rate of the commodity detail row with identical discount ratio
Example, the amount of money of this discount row is described total discount amount * (-1).Invoice data computing module 24 is held
The operation of row can be similar to exist by abovementioned steps when discount mark and discount ratio the two data item
Operation described in S4, here is omitted.And, split module 26 complete described fractionation it
After, in the case of inventory mark represents and opens without the VAT invoice of inventory, invoice data calculates mould
Block 24 is additionally operable to: if ticket data to be developed is concentrated and had a line of identical discount ratio or multirow commodity are bright
Do not have after last column commodity detail row of thin row discount row then this last column commodity detail row it
One discount row of rear insertion, if having discount row after described last column commodity detail row, updates this
Discount row, and update detailed total valency tax total, the detailed total invoice that this ticket data to be developed is concentrated
The amount of money and the detailed total invoice amount of tax to be paid.This makes it possible to the discount data that every ticket data to be developed is concentrated
Again process, so that the data of every ticket data to be developed concentration are the most accurate, it is to avoid occur depending on
The total extension set of increasing is changed with battalion according to data item such as the amount of money on the invoice that this ticket data collection to be developed is opened, the amounts of tax to be paid
The situation that the data item calculated in the sales slip of structure enterprise there are differences, improves battalion and changes the total sub-agencies of increasing
The Financial Control Level of enterprise.Insertion performed by invoice data computing module 24 herein and renewal discount
Row operation with the method according to the invention before described in operation similar, 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 26
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 26
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.
Preferably, split module 26 multiple ticket data collection to be developed are carried out the amount of tax to be paid balance include: calculate
Ready to balance total error, wherein, the detailed of ready to balance total error=all ticket data collection to be developed adds up to invoice
Amount of tax to be paid sum-sales slip amount of tax to be paid；Calculate the balanced invoice amount of tax to be paid error of i-th ticket data to be developed collection,
Wherein, (the detailed total invoice amount * sales slip tax rate-detail is closed can to balance invoice amount of tax to be paid error=1.27-
The meter invoice amount of tax to be paid)；If the balanced invoice amount of tax to be paid error of i-th ticket data to be developed collection > ready to balance always misses
Difference, then add up to the invoice amount of tax to be paid to be revised as i-th ticket to be developed the detailed of ticket data collection to be developed for i-th
The detailed invoice amount of tax to be paid+ready to balance total error that adds up to of data set, and terminate amount of tax to be paid balance；If i-th is treated
< ready to balance total error, then by ticket to be developed for i-th for the balanced invoice amount of tax to be paid error of data set of drawing a bill
The detailed detailed total invoice tax adding up to the invoice amount of tax to be paid to be revised as i-th ticket data to be developed collection of data set
The balanced invoice amount of tax to be paid error of volume+i-th ticket data to be developed collection, then updates ready to balance total error
And the ready to balance total error after updating is to i+1 ticket data collection to be developed balance, wherein,
I=1,2 ... N, N are positive integer.So, it becomes possible to make the detailed total that whole ticket data to be developed is concentrated
Invoice amount of tax to be paid sum is equal with the sales slip amount of tax to be paid.
Wherein, when i+1 ticket data collection to be developed is carried out amount of tax to be paid balance, splitting module 26 can
To use balancing of ready to balance total error=ready to balance total error i-th ticket data to be developed collection to send out
Ticket amount of tax to be paid error recalculates ready to balance total error, it would however also be possible to employ " ready to balance total error=needed
The detailed of data set of drawing a bill adds up to invoice amount of tax to be paid sum-sales slip amount of tax to be paid " to recalculate ready to balance total
Error.
It will be apparent to a skilled person that the algorithm carrying out amount of tax to be paid balance is not limited to institute above
The algorithm shown, other amount of tax to be paid balanced algorithm is also feasible.Such as, split module 26 can will treat
Balance total error is evenly distributed to the detailed of each ticket data collection to be developed and adds up in the 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.And
And, the sequence of steps in the method flow of the present invention can change, and such as battalion changes increasing identification step and invoice
The order of data calculation procedure can be exchanged, and i.e. can first calculate invoice data and identify that battalion changes increasing business the most again
Product.
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 (18)
1. the method opening single tax rate VAT invoice for the sales slip containing the amount of tax to be paid, the method includes:
Step S1, obtain battalion change increasing business commodity dictionary table and the sales slip data set of ticket to be developed and
Sales slip detailed data collection, described battalion changes increasing business commodity dictionary table and includes that belonging to battalion changes the business of increasing business
The trade name of product, described sales slip data set includes the sales slip amount of money, the sales slip amount of tax to be paid, sales slip tax
Rate, containing tax mark and limit of making out an invoice, described sales slip detailed data collection includes multiple commodity detail row, often
Individual commodity detail row includes trade name, unit price, quantity and the amount of money；
Step S2, whether verify in each described commodity detail row the product of unit price and quantity equal to this business
The amount of money in product detail row, and whether verify the amount of money sum in all described commodity detail row equal to described
The sales slip amount of money；
Step S3, the trade name changed according to described battalion in increasing business commodity dictionary table are to identify described pin
Sell single detailed data to be grouped as seeking commodity the increasing in the commodity detail row at this commodity place changing increasing business
Add battalion and change increasing mark；
Step S4, according to the described sales slip tax rate, described detailed containing tax mark and each described commodity
Unit price sum amount in row calculates and adds in each described commodity detail row valency tax total, invoice gold
Volume, the invoice amount of tax to be paid and invoice unit price, and the valency tax in all described commodity detail row that adds up respectively adds up to,
Invoice amount and the invoice amount of tax to be paid with described sales slip detailed data concentrate add detailed total valency tax add up to,
Detailed total invoice amount and the detailed total invoice amount of tax to be paid；
Whether step S5, verification (the detailed total invoice amount of tax to be paid-sales slip amount of tax to be paid) be less than predetermined value；With
And
Step S6, according to described in make out an invoice limit, described battalion change on increasing mark and described VAT invoice
Described sales slip detailed data collection is split into multiple ticket data collection to be developed by predetermined commodity detail line number, and
The plurality of ticket data collection to be developed is carried out amount of tax to be paid balance.
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+ sales slip tax rate)；
The invoice amount of tax to be paid=valency tax total-invoice amount；
Invoice unit price=unit price/(the 1+ sales slip 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 * sales slip 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, then in described step S6:
Represent in the case of opening the VAT invoice of band inventory at described inventory mark, according to described in make out an invoice
Limit and described battalion change increasing mark and described sales slip detailed data collection are split into multiple ticket data to be developed
Collection, it is the most identical and each that the most same ticket data to be developed concentrates the battalion of all commodity detail row to change increasing mark
Ticket data collection to be developed detailed add up to invoice amount be respectively less than 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
Ticket limit, described battalion change increasing mark and described Chinese character anti-false logo by described sales slip detailed data collection
Splitting into multiple ticket data collection to be developed, the most same ticket data to be developed concentrates all commodity detail row
It is the most identical that battalion changes increasing mark, and the detailed of each ticket data collection to be developed adds up to invoice amount to be respectively less than equal to institute
The commodity detail line number stating make out an invoice limit and each ticket data collection to be developed is not more than described VAT invoice
On predetermined commodity detail line number.
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 s 2, after utilizing discount, before the amount of money=discount, amount of money * (1-discount ratio) calculates bag
After the discount of the commodity detail row containing discount commodity the amount of money and after verifying this discount the amount of money with do not comprise discount
Whether the amount of money sum in other commodity detail row of commodity is equal to the described sales slip amount of money；
In step s 4, the valency tax total calculated in each described commodity detail row, invoice amount,
Before the invoice amount of tax to be paid and invoice unit price, rearrange each described commodity always according to described discount ratio detailed
OK, calculate total line number of the commodity detail row with identical discount ratio and total discount amount thereof, and at tool
Have identical discount ratio commodity detail row last column commodity detail row after insert a discount row,
The trade name of this discount row embodies total line number of the commodity detail row with identical discount ratio with
And discount ratio, the amount of money of this discount row is described total discount amount * (-1)；And
In step s 6, represent, at described inventory mark, the situation of the VAT invoice without inventory opened
Under, if described ticket data to be developed is concentrated has a line of identical discount ratio or multirow commodity detail row
Discount row is not had then to insert after this last column commodity detail row after last column commodity detail row
Article one, discount row, if having discount row after described last column commodity detail row, updates this discount
OK, and update the detailed total valency tax that this ticket data to be developed concentrates and add up to, detailed add up to invoice amount
The invoice amount of tax to be paid is added up to detail.
Method the most according to claim 1, wherein, step S3 includes:
The trade name calculated successively in each described commodity detail row changes increasing business commodity word with described battalion
The Similarity value of the trade name in allusion quotation table；
If the Similarity value of the trade name in the same commodity detail row calculated is more than the first predetermined value,
Then this trade name of stopping calculating and described battalion change the surplus commodities title in increasing business commodity dictionary table
Similarity value；And
In corresponding commodity detail row, increase battalion change increasing mark.
Method the most according to claim 1, wherein, step S3 includes:
The trade name calculated successively in each described commodity detail row changes increasing business commodity word with described battalion
The Similarity value of the entire service title in allusion quotation table；
Trade name in same commodity detail row and described battalion changed in increasing business commodity dictionary table is complete
Maximum similarity value in the Similarity value of portion's trade name is added in corresponding commodity detail row, if should
Maximum similarity value is more than the first predetermined value, then increase battalion in this corresponding commodity detail row and change increasing mark
Know.
7. according to the method described in claim 5 or 6, wherein, utilize in ORACLE data base
Utl_match.edit_distance_similarity calculates described Similarity value.
8. according to the method described in claim 5 or 6, wherein, described first predetermined value is 0.5.
9. according to the method described in any claim in claim 1 to 6, wherein, in step S6
The plurality of ticket data collection to be developed is carried out the amount of tax to be paid balance include:
Step S61, calculating ready to balance total error, wherein, ready to balance total error=all polls to be developed
Detailed according to collection adds up to invoice amount of tax to be paid sum-sales slip amount of tax to be paid；
Step S62, the balanced invoice amount of tax to be paid error of calculating i-th ticket data to be developed collection, wherein,
(the detailed total invoice amount * sales slip tax rate-detail adds up to invoice can to balance invoice amount of tax to be paid error=1.27-
The amount of tax to be paid)；
If the balanced invoice amount of tax to be paid error of step S63 i-th ticket data to be developed collection > ready to balance always misses
Difference, then add up to the invoice amount of tax to be paid to be revised as i-th ticket to be developed the detailed of ticket data collection to be developed for i-th
The detailed invoice amount of tax to be paid+ready to balance total error that adds up to of data set, and terminate amount of tax to be paid balance；
If < ready to balance always misses the balanced invoice amount of tax to be paid error of step S64 i-th ticket data to be developed collection
Difference, then add up to the invoice amount of tax to be paid to be revised as i-th ticket to be developed the detailed of ticket data collection to be developed for i-th
Detailed the balanced invoice amount of tax to be paid error adding up to the invoice amount of tax to be paid+i-th ticket data to be developed collection of data set,
And return step S61 to continue the amount of tax to be paid balance of i+1 ticket data collection to be developed, wherein,
I=1,2 ... N, N are positive integer.
10. open a system for single tax rate VAT invoice for the sales slip containing the amount of tax to be paid, this system includes:
Acquisition module, changes increasing business commodity dictionary table and the sales slip data of ticket to be developed for obtaining battalion
Collection and sales slip detailed data collection, described sales slip data set include the sales slip amount of money, the sales slip amount of tax to be paid,
The sales slip tax rate, containing tax mark and limit of making out an invoice, described sales slip detailed data collection includes that multiple commodity are bright
Thin row, each commodity detail row includes that trade name, unit price, quantity and the amount of money, described battalion change increasing business
Commodity dictionary table includes the trade name belonging to the commodity that battalion changes increasing business；
Sales slip data check module, for verifying taking advantage of of unit price and quantity in each described commodity detail row
Long-pending whether equal to the amount of money in this commodity detail row, and verify the amount of money in all described commodity detail row it
Whether equal to the described sales slip amount of money；
Battalion changes increasing identification module, for changing the trade name in increasing business commodity dictionary table according to described battalion
Identify that described sales slip detailed data is grouped as seeking the commodity changing increasing business the commodity at this commodity place
Detailed row increases battalion and changes increasing mark；
Invoice data computing module, for according to the described sales slip tax rate, described containing tax mark and each
Unit price sum amount in described commodity detail row calculates and adds valency tax in each described commodity detail row
Total, invoice amount, the invoice amount of tax to be paid and invoice unit price, and add up respectively in all described commodity detail row
Valency tax add up to, invoice amount and the invoice amount of tax to be paid add detail close to concentrate at described sales slip detailed data
Valuation tax adds up to, detail adds up to invoice amount and detail adds up to the invoice amount of tax to be paid；
Sales slip amount of tax to be paid correction verification module, being used for verifying (detailed add up to the invoice amount of tax to be paid-sales slip amount of tax to be paid) is
No less than predetermined value；And
Split module, for after described sales slip amount of tax to be paid correction verification module completes described verification, according to institute
State limit of making out an invoice, described battalion changes the predetermined commodity detail line number increased on mark and described VAT invoice by institute
State sales slip detailed data collection and split into multiple ticket data collection to be developed, and to the plurality of poll to be developed
Amount of tax to be paid balance is carried out according to collection.
11. systems according to claim 10, 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 adds up to=containing duty receipt valency * quantity；
Invoice amount=valency tax adds up to/(the 1+ sales slip tax rate)；
The invoice amount of tax to be paid=valency tax total-invoice amount；
Invoice unit price=containing duty receipt valency/(the 1+ sales slip 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=without duty receipt valency * quantity；
The invoice amount of tax to be paid=invoice amount * sales slip tax rate；
Valency tax total=invoice amount+invoice amount of tax to be paid.
12. systems according to claim 10, wherein, described sales slip data set also includes clearly
Single mark and Chinese character anti-false logo, described Chinese character anti-false logo defines described VAT invoice
On 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
Limit and described battalion change increasing mark and described sales slip detailed data collection are split into multiple ticket data to be developed
Collection, it is the most identical and each that the most same ticket data to be developed concentrates the battalion of all commodity detail row to change increasing mark
Ticket data collection to be developed detailed add up to invoice amount be respectively less than 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
Ticket limit, described battalion change increasing mark and described Chinese character anti-false logo by described sales slip detailed data collection
Splitting into multiple ticket data collection to be developed, the most same ticket data to be developed concentrates all commodity detail row
It is the most identical that battalion changes increasing mark, and the detailed of each ticket data collection to be developed adds up to invoice amount to be respectively less than equal to institute
The commodity detail line number stating make out an invoice limit and each ticket data collection to be developed is not more than described VAT invoice
On predetermined commodity detail line number.
13. systems according to claim 12, wherein, also wrap in each described commodity detail row
Include by discount mark and discount ratio, and the described sales slip amount of money is the amount of money after discount, each described commodity
The amount of money in detailed row is the amount of money before discount, then:
Described sales slip data check 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 discount of the commodity detail row comprising discount commodity after the amount of money gold after verifying this discount
Whether volume and the amount of money sum not comprised in other commodity detail row of discount commodity be equal to described sales slip
The amount of money；
Described invoice data computing module is additionally operable to the valency tax in calculating each described commodity detail row and closes
Before meter, invoice amount, the invoice amount of tax to be paid and invoice unit price, rearrange each according to described discount ratio
Described commodity detail row, calculates total line number of the commodity detail row with identical discount ratio and total discount thereof
The amount of money, and insert after there is last column commodity detail row of commodity detail row of identical discount ratio
Article one, discount row, embodies the commodity detail row with identical discount ratio in the trade name of this discount row
Total line number and discount ratio, the amount of money of this discount row is 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 a line of identical discount ratio or last column commodity detail row of multirow commodity detail row
Discount row is not had then to insert a discount row after this last column commodity detail row, if described afterwards
There is after last column commodity detail row discount row and then update this discount row, and update this ticket to be developed
Detailed total valency tax in data set adds up to, detail adds up to invoice amount and the detailed total invoice amount of tax to be paid.
14. systems according to claim 10, wherein, described battalion change increasing identification module for:
The trade name calculated successively in each described commodity detail row changes increasing business commodity word with described battalion
The Similarity value of the trade name in allusion quotation table；
If the Similarity value of the trade name in the same commodity detail row calculated is more than the first predetermined value,
Then this trade name of stopping calculating and described battalion change the surplus commodities title in increasing business commodity dictionary table
Similarity value；And
In corresponding commodity detail row, increase battalion change increasing mark.
15. systems according to claim 10, wherein, described battalion change increasing identification module for:
The trade name calculated successively in each described commodity detail row changes increasing business commodity word with described battalion
The Similarity value of the entire service title in allusion quotation table；
Trade name in same commodity detail row and described battalion changed in increasing business commodity dictionary table is complete
Maximum similarity value in the Similarity value of portion's trade name is added in corresponding commodity detail row, if should
Maximum similarity value is more than the first predetermined value, then increase battalion in this corresponding commodity detail row and change increasing mark
Know.
16. according to the system described in claims 14 or 15, and wherein, described battalion changes increasing identification module profit
Described similarity is calculated with the utl_match.edit_distance_similarity in ORACLE data base
Value.
17. according to the system described in claims 14 or 15, and wherein, described first predetermined value is 0.5.
18. according to the system described in any claim in claim 10 to 15, wherein, described in tear open
Sub-module carries out amount of tax to be paid balance and includes the plurality of ticket data collection to be developed:
Calculate ready to balance total error, wherein, the detail of ready to balance total error=all ticket data collection to be developed
Add up to invoice amount of tax to be paid sum-sales slip amount of tax to be paid；
Calculate the balanced invoice amount of tax to be paid error of i-th ticket data to be developed collection, wherein, invoice can be balanced
Amount of tax to be paid error=1.27-(the detailed total invoice amount * sales slip tax rate-detail adds up to the invoice amount of tax to be paid)；
If the balanced invoice amount of tax to be paid error of i-th ticket data to be developed collection > ready to balance total error, then will
The detailed of i-th ticket data to be developed collection adds up to the invoice amount of tax to be paid to be revised as i-th ticket data to be developed collection
The detailed invoice amount of tax to be paid+ready to balance total error that adds up to, and terminate amount of tax to be paid balance；
If the balanced invoice amount of tax to be paid error of i-th ticket data to be developed collection < then will by ready to balance total error
The detailed of i-th ticket data to be developed collection adds up to the invoice amount of tax to be paid to be revised as i-th ticket data to be developed collection
Detailed the balanced invoice amount of tax to be paid error adding up to the invoice amount of tax to be paid+i-th ticket data to be developed collection, the most more
New ready to balance total error the ready to balance total error after updating are put down to i+1 ticket data collection to be developed
Weighing apparatus, wherein, i=1,2 ... N, N are positive integer.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510230649.7A CN106204172A (en) | 2015-05-08 | 2015-05-08 | The method and system of single tax rate VAT invoice is opened for the sales slip containing the amount of tax to be paid |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510230649.7A CN106204172A (en) | 2015-05-08 | 2015-05-08 | The method and system of single tax rate VAT invoice is opened for the sales slip containing the amount of tax to be paid |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106204172A true CN106204172A (en) | 2016-12-07 |
Family
ID=57459802
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510230649.7A Pending CN106204172A (en) | 2015-05-08 | 2015-05-08 | The method and system of single tax rate VAT invoice is opened for the sales slip containing the amount of tax to be paid |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106204172A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112016982A (en) * | 2020-08-19 | 2020-12-01 | 云账户技术(天津)有限公司 | Billing amount calculation method and device |
| CN112102059A (en) * | 2020-09-27 | 2020-12-18 | 中国建设银行股份有限公司 | Service data processing method and device |
| CN113065935A (en) * | 2019-12-27 | 2021-07-02 | 航天信息股份有限公司 | Data processing method, device, equipment and storage medium |
-
2015
- 2015-05-08 CN CN201510230649.7A patent/CN106204172A/en active Pending
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113065935A (en) * | 2019-12-27 | 2021-07-02 | 航天信息股份有限公司 | Data processing method, device, equipment and storage medium |
| CN112016982A (en) * | 2020-08-19 | 2020-12-01 | 云账户技术(天津)有限公司 | Billing amount calculation method and device |
| CN112102059A (en) * | 2020-09-27 | 2020-12-18 | 中国建设银行股份有限公司 | Service data processing method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7580848B2 (en) | Method of and system for analyzing, modeling and valuing elements of a business enterprise | |
| CN107798515A (en) | A kind of method that database automatically generates accounting voucher | |
| US9875486B2 (en) | Extracting product purchase information from electronic messages | |
| 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 | |
| US10242377B2 (en) | Systems and methods for analyzing businesses based on gratuities | |
| CN106204175A (en) | For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip | |
| Bhalekar et al. | the Study of E-Commerce | |
| CN112182207A (en) | Invoice false-proof risk assessment method based on keyword extraction and rapid text classification | |
| US7711615B2 (en) | Methods, apparatus, systems, computer program products and mediums for use in association with accounting and/or financial analysis | |
| CN106204172A (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 | |
| US20130006820A1 (en) | System and Method of Determining the Quality of Enhanced Transaction Data | |
| KR20190128441A (en) | Welfare type discount mall system and operating method thereof | |
| KR102366405B1 (en) | Commodity trading system and method thereof | |
| CN110415064A (en) | A kind of benefit community system of integration retail supply chain and distribution chain | |
| EP2232749A1 (en) | Merchant rate lookup | |
| CN102722808A (en) | Payment system | |
| CN106204179A (en) | For opening the method and system of single tax rate VAT invoice without amount of tax to be paid sales slip | |
| US20040122758A1 (en) | Budget and financial analysis system and method | |
| CN106204173A (en) | For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip | |
| CN107590707A (en) | A SaaS architecture modes realize more distribution substation systems | |
| KR102464993B1 (en) | Method for credit evaluation based on order data generated between online seller and customer on OMS(order management system) | |
| TWM529227U (en) | Sales system with multi-level consumption cashback | |
| CN106204177A (en) | For opening the method and system of single tax rate VAT invoice without amount of tax to be paid sales slip | |
| US20220405859A1 (en) | Recommendation system for recording a transaction | |
| Hastuti et al. | Middle economic growth towards to development of e-commerce in Southeast Asia |
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 |