CN106204173A - For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip - Google Patents
For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip Download PDFInfo
- Publication number
- CN106204173A CN106204173A CN201510230661.8A CN201510230661A CN106204173A CN 106204173 A CN106204173 A CN 106204173A CN 201510230661 A CN201510230661 A CN 201510230661A CN 106204173 A CN106204173 A CN 106204173A
- Authority
- CN
- China
- Prior art keywords
- invoice
- tax
- commodity
- amount
- row
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Landscapes
- Cash Registers Or Receiving Machines (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention discloses a kind of method and system for opening many tax rates VAT invoice without amount of tax to be paid sales slip, including: obtain battalion change increasing business commodity dictionary table, the sales slip amount of money, containing tax mark, limit of making out an invoice and the sales slip detailed data collection including multiple commodity detail row, each commodity detail row includes trade name, unit price, quantity, the amount of money and the tax rate;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;Change the trade name in increasing business commodity dictionary table according to battalion to be identified as seeking and change the commodity of increasing business and in the commodity detail row at this commodity place, increase battalion change increasing mark, change the tax rate in the tax rate verification commodity detail row in increasing business commodity dictionary according to battalion the most accurate;According to containing tax mark, unit price, quantity and tax rate given price tax total, invoice amount, the invoice amount of tax to be paid and invoice unit price;Change increasing mark according to limit of making out an invoice, battalion and predetermined commodity detail line number splits sales slip detailed data collection.Which save time and human cost.
Description
Technical field
The present invention relates to electronic invoice technical field, in particular it relates to a kind of for open without amount of tax to be paid sales slip
Has the method and system of many tax rates VAT invoice.
Background technology
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 for opening the method for many tax rates VAT invoice without amount of tax to be paid sales slip and being
System, its can time-consuming and human cost, can be prepared in advance symbol for Ying Gaizengzong sub-agencies enterprise again
Close the ticket data to be developed of invoice data specification, help Ying Gaizengzong sub-agencies enterprise to issue invoice smoothly.
The present invention provides a kind of method for opening many tax rates VAT invoice without amount of tax to be paid sales slip, the party
Method includes:
Step S1, acquisition battalion change increasing business commodity dictionary table and the sales slip data set of ticket to be developed and pin
Selling single detailed data collection, described sales slip data set includes the sales slip amount of money, containing tax mark and limit of making out an invoice,
Described sales slip detailed data collection includes that multiple commodity detail row, each commodity detail row include trade name
Title, unit price, quantity, the amount of money and the tax rate, described battalion changes increasing business commodity dictionary table and includes that belonging to battalion changes
The trade name of the commodity of increasing business and the tax rate;
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, and it is detailed to verify these commodity to change the tax rate in increasing business commodity dictionary according to described battalion
The tax rate in row is the most accurate;
Step S4, according to described unit price containing tax mark, in each described commodity detail row, quantity and
The tax rate calculate and in each described commodity detail row add valency tax total, invoice amount, the invoice amount of tax to be paid and
Invoice unit price, and by valency tax total, invoice amount and the invoice amount of tax to be paid in all described commodity detail row
It is cumulative respectively that to add in described sales slip detailed data concentration, detailed total valency tax adds up to, detailed total is sent out
The ticket amount of money and the detailed total invoice amount of tax to be paid;And
Step S5, according to described in make out an invoice limit, described battalion change on increasing mark and described VAT invoice
Predetermined commodity detail line number, splits into multiple ticket data collection to be developed by described sales slip detailed data collection.
The present invention also provides for a kind of system for opening many tax rates VAT invoice without amount of tax to be paid sales slip, should
System includes:
Acquisition module, 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 includes the sales slip amount of money, containing tax mark with open
Ticket limit, described sales slip detailed data collection includes that multiple commodity detail row, each commodity detail row include
Trade name, unit price, quantity, the amount of money and the tax rate, described battalion changes increasing business commodity dictionary table and includes belonging to
Yu Yinggai increases trade name and the tax rate of the commodity of 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, and the tax rate changed in increasing business commodity dictionary according to described battalion verifies
The tax rate in this commodity detail row is the most accurate;
Invoice data computing module, for according to described containing tax mark, in each described commodity detail row
Unit price, quantity and the tax rate calculate and add in each described commodity detail row valency tax total, invoice amount,
The invoice amount of tax to be paid and invoice unit price, and by the valency tax total in all described commodity detail row, invoice amount
With the invoice amount of tax to be paid respectively cumulative 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;And
Split module, after completing described calculating at described invoice data computing module and add up, depend on
The predetermined commodity detail row increased on mark and described VAT invoice is changed according to described limit of making out an invoice, described battalion
Number, splits into multiple ticket data collection to be developed by described sales slip detailed data collection.
By technique scheme, owing to the method according to the invention and system make use of battalion to change the total extension set of increasing
Sales slip data in structure enterprise operation system, and process to obtain meeting invoice to sales slip data
The ticket data to be developed of data standard, therefore, it is possible to time-consuming and human cost, improves battalion and changes increasing total score
The invoice issuing efficiency of enterprise of mechanism, reduces the Ying Gaizengzong sub-agencies enterprise wind issued invoice lack of standardization
Danger, promotes Ying Gaizengzong sub-agencies enterprise's legacy specification operation and normal invoice issuing, strengthens further
Manage with specification VAT invoice, improve 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 be according to one embodiment of the present invention for open many tax rates value-added tax without amount of tax to be paid sales slip
The flow chart of the method for invoice;And
Fig. 2 be according to one embodiment of the present invention for open many tax rates value-added tax without amount of tax to be paid sales slip
The block diagram of the system of invoice.
Detailed description of the invention
Below in conjunction with accompanying drawing, the detailed description of the invention of the present invention is described in detail.It should be appreciated that
Detailed description of the invention described herein is merely to illustrate and explains the present invention, is not limited to this
Bright.
The commodity detail tax rate that many tax rates refer on a VAT invoice can be multiple;Without tax
Volume sales slip is the one of enterprise marketing list, and financial management uses the actual invoice amount of tax to be paid opened, enterprise
Need not just calculate in sales slip the amount of tax to be paid before invoice issuing.The feature of this sales slip data be
Sales slip master data neither identifies the tax rate, does not the most identify the amount of tax to be paid;Sales slip detailed data identifies
The different tax rates, but do not identify the amount of tax to be paid.
As it is shown in figure 1, according to one embodiment of the present invention for open many tax rates without amount of tax to be paid sales slip
The method of VAT invoice comprises the following steps:
Step S1, acquisition battalion change increasing business commodity dictionary table and the sales slip data set of ticket to be developed and pin
Selling single detailed data collection, sales slip data set includes the sales slip amount of money, containing tax mark and limit of making out an invoice, pin
Sell single detailed data collection include multiple commodity detail row, each commodity detail row include trade name, unit price,
Quantity, the amount of money and the tax rate, battalion changes increasing business commodity dictionary table and includes belonging to battalion and change the commodity of increasing business
Trade name and the tax rate.
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, and the sales slip amount of money, containing tax mark, inventory mark, the Chinese
The false proof logo of word, limit FROM of making out an invoice sales slip tables of data WHERE is made out an invoice mark=' not
Make out an invoice ' ".Above SQL statement form is only exemplary, in practical operation, and inventory mark and the Chinese
The false proof logo of word be not necessary to obtain, namely do not include in sales slip data set inventory mark and
In the case of Chinese character anti-false logo, can follow-up sales slip detailed data collection is split time,
Predetermined commodity detail line number on VAT invoice is defined to such as 7 row, and (this provides according to the tax bureau
VAT invoice and change), so that each ticket data to be developed concentrate commodity detail line number the most very much not
Exceed the restrictive condition that the tax bureau specifies.Table 1 gives exemplary sales slip data set.
Sell odd numbers | The sales slip amount of money | Containing tax mark | Inventory mark | Chinese character anti-false logo | Make out an invoice limit |
XSD0001 | 15400.00 | Y | Y | Y | 10000.00 |
Table 1
Furthermore it is possible to use SQL statement or other computer program statements to obtain sales slip detail number
According to collection, exemplary SQL statement form is: " SELECT sequence number, trade name, by discount mark,
Discount ratio, unit price, quantity, the amount of money, tax rate FROM sales slip commodity detailed data table WHERE
Sell odd numbers=' present sales odd numbers ' ".Wherein, by discount mark and discount ratio not necessarily,
When Ying Gaizengzong sub-agencies enterprise does not carries out discount sales to commodity, sales slip detailed data is concentrated permissible
Do not include by discount mark and discount ratio.Table 2 shows the example of the sales slip XSD0001 of table 1
Property sales slip detailed data collection.
Sequence number | Trade name | Unit price | Quantity | The amount of money | The tax rate | By discount mark | Discount ratio |
1 | Commodity 1 | 1000.00 | 1 | 1000.00 | 11% | ||
2 | Commodity 2 | 750.00 | 2 | 1500.00 | 6% |
3 | Discounting commodity 1 | 300.00 | 2 | 600.00 | 11% | Y | 20% |
4 | Discounting commodity 2 | 400.00 | 1 | 400.00 | 11% | Y | 20% |
5 | Commodity 3 | 700.00 | 2 | 1400.00 | 11% | ||
6 | Commodity 4 | 400.00 | 4 | 1600.00 | 6% | ||
7 | Discounting commodity 3 | 400.00 | 13 | 5200.00 | 6% | Y | 20% |
8 | Discounting commodity 4 | 600.00 | 3 | 1800.00 | 6% | Y | 20% |
9 | Commodity 5 | 500.00 | 5 | 2500.00 | 11% | ||
10 | Commodity 6 | 300.00 | 2 | 600.00 | 11% | ||
11 | Commodity 7 | 200.00 | 2 | 400.00 | 6% |
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 | The tax rate | Remarks |
SP0001 | Commodity 1 | 11% | |
SP0002 | Commodity 2 | 6% | |
… | … |
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.
Such as, 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, and change the tax rate in increasing business commodity dictionary according to battalion to verify the tax rate in this commodity detail row be
No accurately.
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 entire service title in increasing business commodity dictionary table;If it is same
Trade name in commodity detail row and battalion change the phase of the entire service title in increasing business commodity dictionary table
Like the maximum similarity value in angle value more than predetermined value, then in this does business product detail row, increase battalion change increasing mark
Know, and verify whether this tax rate in product detail row of doing business changes in increasing business commodity dictionary table equal to battalion and be somebody's turn to do
The trade name in product detail row of doing business has the tax rate corresponding to trade name of maximum similarity value.With
As a example by the sales slip detailed data collection of table 2.First calculate commodity 1 to change in increasing business commodity dictionary table with battalion
The Similarity value of entire service title, if commodity 1 change the trade name in increasing business commodity dictionary table with battalion
A is claimed to have maximum similarity value and this maximum similarity value more than predetermined value, then by the of commodity 1 place
1 battalion in product detail row that does business changes increasing mark and is set to Y, namely thinks that commodity 1 change increasing business for battalion
Commodity, whether the tax rate of verification commodity 1 is equal to the tax rate corresponding to trade name A afterwards, if unequal,
Then prompting " battalion changes the tax rate of the tax rate and sales slip detailed data concentration that increase commodity and is not inconsistent " also terminates algorithm
Flow process, if equal, continues follow-up process;By that analogy, until completing last column commodity detail row
In commodity 7 and battalion change being calculated as of Similarity value of entire service title in increasing business commodity dictionary table
Stop, thus obtain the exemplary sales list detailed data collection shown in table 4.Certainly, when performing this process,
Each maximum similarity value can also first be added to sales slip detailed data concentrate, then by selling
The Similarity value that single detailed data is concentrated and predetermined value are compared to arrange battalion and change increasing mark.
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.
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, described predetermined value can be such as 0.5
Or other are suitably worth.
Table 4
Step S4, basis calculate containing the unit price in tax mark, each commodity detail row, quantity and the tax rate
And in each commodity detail row, add valency tax total, invoice amount, the invoice amount of tax to be paid and invoice unit price, and
Valency tax total, invoice amount and the invoice amount of tax to be paid in all commodity detail row add up respectively with bright at sales slip
Count accurately according to concentrating interpolation detailed total valency tax total, detail to add up to invoice amount and detail to add up to invoice tax
Volume.
Wherein, in the case of the mark containing tax represents containing tax (such as, representing containing tax with letter Y) (also
I.e. unit price in commodity detail row is containing duty receipt valency), use below equation to calculate each commodity detail row
Valency tax total, invoice amount, the invoice amount of tax to be paid and invoice unit price:
Valency tax total=unit price * quantity;
Invoice amount=valency tax adds up to/(the 1+ tax rate);
The invoice amount of tax to be paid=valency tax total-invoice amount;
Invoice unit price=unit price/(the 1+ tax rate);
In the case of the mark containing tax represents without tax (such as, representing containing tax with letter N) (namely business
Unit price in product detail row is free from duty receipt valency), use below equation to calculate the valency of each commodity detail row
Tax total, invoice amount, the invoice amount of tax to be paid and invoice unit price:
Invoice amount=unit price * quantity;
The invoice amount of tax to be paid=invoice amount * tax rate;
Valency tax total=invoice amount+invoice amount of tax to be paid.
Calculate valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of each commodity detail row with
And detailed total valency tax add up to, detailed add up to invoice amount and detailed add up to after the invoice amount of tax to be paid exemplary
Table 6 hereinafter asked for an interview by sales slip detailed data collection.
Step S5, according to limit of making out an invoice, that battalion changes the predetermined commodity increased on mark and VAT invoice is detailed
Line number, splits into multiple ticket data collection to be developed by sales slip detailed data 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, sales organization, purchasing unit title etc.) after merging
Ticket data, the interface that the invoice data that this is complete is sent to tax-supervise system to be provided just can complete invoice
Open.
Preferably, sales slip data set can also include inventory mark and Chinese character anti-false logo, 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.So, aforesaid step S5 can include
Following steps:
Step S51, represent the VAT invoice opening band inventory at inventory mark in the case of, according to opening
Ticket limit and battalion change increasing mark and sales slip detailed data collection are split into multiple ticket data collection to be developed, wherein
It is the most identical and each to be developed that same ticket data to be developed concentrates the battalion of all commodity detail row to change increasing mark
The detailed of ticket data collection adds up to invoice amount to be respectively less than equal to making out an invoice limit.Owing to being the increasing opening band inventory
Value tax invoice, it is possible to do not consider Chinese character anti-false logo.Such as, this step can be carried out as follows:
First, change increasing mark according to battalion sales slip detailed data collection is divided into battalion to change increasing mark group and non-battalion changes increasing mark
Knowledge group, i.e. by such as SQL statement " SELECT*FROM sales slip detailed data collection WHERE
Battalion change increasing mark=" Y " " or other suitable computer program statements by sales slip detailed data concentration camp
Change to increase and be designated the commodity detail row of Y and be divided into battalion and change in increasing mark group, by such as SQL statement
" SELECT*FROM sales slip detailed data JiWHEREYing changes increasing mark!=" Y " " or its
Sales slip detailed data concentration camp is changed and increases mark not for the commodity of Y by his suitable computer program statement
Detailed row is divided into non-battalion and changes in increasing mark group, thus makes to seek and changes the commodity of increasing business and non-battalion changes increasing
The commodity of business are opened on different VAT invoices;Then increasing mark group is changed for battalion and non-battalion changes
Increase mark group, the most successively from first bar commodity detail row to end bar commodity detail row circulation, take every commodity
Invoice amount in detailed row its Amount in Total of accumulation calculating, when accumulation calculating to certain commodity detail row
Time obtained Amount in Total more than make out an invoice limit time, by bright for the entire service before this commodity detail row
Thin row is split to a ticket data to be developed and concentrates, and the rest may be inferred, battalion just changes increasing mark group and non-battalion changes
Increase the commodity detail row in mark group to be split to multiple ticket data to be developed respectively and concentrate so that each treat
The detailed total invoice amount drawn a bill in data set is not more than invoice limit, and same ticket data to be developed
It is identical that battalion in the commodity detail row concentrated changes increasing mark.
Step S52, in the case of inventory mark represents and opens without the VAT invoice of inventory, foundation
Make out an invoice limit, battalion change increasing mark and Chinese character anti-false logo sales slip detailed data collection is split into multiple
Ticket data collection to be developed, the most same ticket data to be developed concentrates the battalion of all commodity detail row to change increasing mark
The most identical, each ticket data collection to be developed detailed adds up to invoice amount to be respectively less than equal to making out an invoice limit and every
The predetermined commodity detail row that the commodity detail line number of individual ticket data collection to be developed is not more than on VAT invoice
Number.That is, according to existing tax bureau regulation, non-Chinese character anti-false enterprise at most can only open on VAT invoice
Having 8 commodity detail line numbers, Chinese character anti-false enterprise at most can only open 7 commodity on VAT invoice
Detailed line number.
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 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 according to the discount ratio in each commodity detail row
Rearrange each commodity detail row with the tax rate, calculate and there are identical discount ratio and the commodity of same tax rate
Total line number of detailed row and total discount amount thereof, and there are identical discount ratio and the commodity of same tax rate
A discount row is inserted, in the trade name of this discount row after last column commodity detail row of detailed row
Embody total line number and the discount ratio of the commodity detail row with identical discount ratio and same tax rate,
The amount of money of this discount row is total discount amount * (-1).For example, it is possible to by identical discount ratio and identical tax
The commodity detail row of rate divides at one group, and is arranged in order by group, and discount ratio is that empty one group represents this group
Commodity in commodity detail row are non-discounting commodity, this group commodity detail row can be arranged in foremost
(certainly, be arranged in sales slip detailed data collection is the most also feasible);To discount ratio it is not
Empty each group commodity detail row, needs to add up respectively total line number of each group of commodity detail row, calculates each group of business
Total discount amount of product detail row, the wherein amount of money * discount in total this group commodity detail row of discount amount=∑
Ratio, and after last column commodity detail row of each group of commodity detail row, insert a discount row, should
The trade name of discount row can be " discount line number Y (X.XXX%) ", and wherein " Y " is for calculating
Each group generated has total line number of the commodity detail row of identical discount ratio and same tax rate, and " X " is folding
Button ratio, or the trade name of this discount row can also be that other can embody this group and have identical discount
Total line number of the commodity detail row of ratio and same tax rate and other titles of discount ratio, this discount row
The amount of money is to calculate total discount amount * (-1) generated to represent that commodity are given a discount.Table 5 gives by folding
Button ratio and the tax rate rearrange commodity detail row and insert the exemplary sales list detail after discount row
Data set.
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 S52 process discount row, ticket data the most to be developed is concentrated has identical discount rate
Do not roll over after last column commodity detail row of example and a line of same tax rate or multirow commodity detail row
Button row then inserts a discount row after this last column commodity detail row and (wherein, inserts discount row
Operating identical with the operation of the insertion discount row described in step S4 before, here is omitted), if
There is after described last column commodity detail row discount row and then update this discount row (wherein, renewal discount
The operation of row is identical with the operation of the insertion discount row described in step S4 before, the most also repeats no more),
And update the detailed total valency tax that this ticket data to be developed concentrates add up to, the detailed invoice amount and bright of adding up to
The thin total invoice amount of tax to be paid.The discount data that this makes it possible to concentrate every ticket data to be developed is carried out again
Process, so that the data of every ticket data to be developed concentration are the most accurate, it is to avoid occur waiting out according to this
The data item such as the amount of money on invoice that invoice data collection is opened, the amount of tax to be paid and Ying Gaizengzong sub-agencies enterprise
The situation that the data item calculated in sales slip there are differences, improves the wealth of Ying Gaizengzong sub-agencies enterprise
Business management level.As a example by the sales slip detailed data collection of table 6, 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 that the commodity of increasing business are split has assigned to different ticket data to be developed
Concentrating, the detailed of each ticket data collection to be developed adds up to invoice amount respectively less than to make out an invoice limit (i.e. in table 1
The limit of 10000 yuan be given);Inventory mark owing to being given in table 1 is Y, namely it is clear to open band
Single VAT invoice, thus only consider when splitting battalion change increasing mark and make out an invoice limit the two factor and
Chinese character anti-false logo need not be considered.
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 S51
During discount data can not be processed.If detailed total that sales slip detailed data is concentrated is sent out
The ticket amount of money is more than making out an invoice limit, then in the split process of step S51, and can be according to above-mentioned steps S52
Split process in the processing procedure of discount data is processed the folding that will be listed on inventory when making out an invoice
The process of the insertion discount row in step S52 and renewal discount row (i.e. can be applied similarly by button data
In step S51).
According to one embodiment of the present invention, the present invention also provides for a kind of for open without amount of tax to be paid sales slip
The system of many tax rates VAT invoice, this system includes acquisition module 21, sales slip data check module
22, battalion changes increasing identification module 23, invoice data computing module 24 and splits module 25.
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, containing tax mark
With limit of making out an invoice, sales slip detailed data collection includes that multiple commodity detail row, each commodity detail row include
Trade name, unit price, quantity, the amount of money and the tax rate, battalion changes increasing business commodity dictionary table and includes belonging to battalion
Change trade name and the tax rate of the commodity of increasing business.Such as, acquisition module 21 can be according to sales slip
" mark of making out an invoice ", changes in battalion in the sales slip tables of data increasing total sub-agencies enterprise operation system and searches out
The sales slip key data of tool invoice, forms sales slip data set and sales slip detailed data collection.Such as,
Acquisition module 21 can use SQL statement or other computer program statements to obtain sales slip data
Collection, exemplary SQL statement form is: " SELECT sells odd numbers, and the sales slip amount of money, containing tax mark
Will, limit FROM of making out an invoice sales slip tables of data WHERE is made out an invoice mark=' not making out an invoice ' ", with
And the exemplary SQL statement form obtaining sales slip detailed data collection can be: " SELECT sequence number,
Trade name, unit price, quantity, the amount of money, tax rate FROM sales slip commodity detailed data table WHERE
Sell odd numbers=' present sales odd numbers ' ".Enter it addition, above battalion has been changed increasing business commodity dictionary table
Having gone description, 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.Operation performed by sales slip data check module 22 and the side according to the present invention
In method, the operation of step S2 is similar to, and here is omitted.
Battalion changes increasing identification module 23, 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, and it is detailed to verify these commodity to change the tax rate in increasing business commodity dictionary according to battalion
The tax rate in row is the most accurate.Battalion changes increasing identification module 23 and can use above in conjunction with according to the present invention's
In method, the operation described by step S3 identifies that battalion changes the commodity of increasing business, and here is omitted.
Invoice data computing module 24, for according to containing the unit price in tax mark, each commodity detail row,
Quantity and the tax rate calculate and add valency tax total, invoice amount, the invoice amount of tax to be paid in each commodity detail row
With invoice unit price, and the valency tax in all commodity detail row is added up to, invoice amount and the invoice amount of tax to be paid divide
Lei Jia be not concentrate interpolation detailed total valency tax total, detail to add up to invoice amount at sales slip detailed data
The invoice amount of tax to be paid is added up to detail.
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+ tax rate);
The invoice amount of tax to be paid=valency tax total-invoice amount;
Invoice unit price=unit price/(the 1+ tax rate);
In the case of the mark containing tax represents without tax (such as, representing containing tax with letter N) (namely business
Unit price in product detail row is free from duty receipt valency), invoice data computing module 24 uses below equation to calculate
Valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of each commodity detail row:
Invoice amount=unit price * quantity;
The invoice amount of tax to be paid=invoice amount * tax rate;
Valency tax total=invoice amount+invoice amount of tax to be paid.
Split module 25, after completing described calculating at invoice data computing module 24 and add up,
The predetermined commodity detail line number increased on mark and VAT invoice is changed, by sales slip according to limit of making out an invoice, battalion
Detailed data collection splits into multiple ticket data collection to be developed.That is, each poll to be developed finally given
Detailed according to collection adds up to invoice amount can not be more than limit of making out an invoice, and its commodity detail line number not can exceed that increment
Predetermined commodity detail line number on tax invoice, battalion changes and increases and non-battalion changes the commodity of increasing business and can not be opened in same
Open on VAT invoice.
After splitting module 25 and splitting, the ticket data collection each to be developed generated is exactly one
The key data of ticket to be developed, by drawing a bill in these key datas and sales slip, other data needed are wanted
Element can form complete invoice data after merging, and the invoice data that this is complete is sent to tax-supervise system and carries
The interface of confession just can complete opening of invoice.
Preferably, the sales slip data set acquired in acquisition module 21 can also include inventory mark and
Chinese character anti-false logo, Chinese character anti-false logo defines that the predetermined commodity on VAT invoice are detailed
Line number, splits module 25 and is additionally operable to: represent the feelings of the VAT invoice opening band inventory at inventory mark
Under condition, according to making out an invoice 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
Each 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;At inventory
In the case of mark expression is opened without the VAT invoice of inventory, change increasing mark according to limit of making out an invoice, battalion
With Chinese character anti-false logo, sales slip detailed data collection is split into multiple ticket data collection to be developed, wherein
It is the most identical that same ticket data to be developed concentrates the battalion of all commodity detail row to change increasing mark, each ticket to be developed
Data set detailed adds up to invoice amount to be respectively less than equal to make out an invoice limit and each ticket data collection to be developed
The predetermined commodity detail line number that commodity detail line number is not more than on VAT invoice.Split module 25 to be held
This operation of row can be similar to the operation described in above-mentioned steps S51 and step S52, the most no longer
Repeat.
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 described sales slip amount of money is the amount of money after discount, each
The amount of money in described commodity detail row is the amount of money before discount.In this case, sales slip data check mould
Block 22 is additionally operable to: after utilizing discount, before the amount of money=discount, amount of money * (1-discount ratio) calculates and comprises folding
After the discount of the commodity detail row of button commodity the amount of money and after verifying this discount the amount of money with do not comprise discount commodity
Other commodity detail row in amount of money sum whether equal to the sales slip amount of money.Namely the sales slip in enterprise
When having discounting commodity in detailed data table, sales slip data check module 22 needs first to calculate this commodity
After the discount of detailed row, the amount of money adds up the most again.Invoice data computing module 24 is additionally operable to calculating
Before valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of each commodity detail row, according to often
Discount ratio and the tax rate in individual commodity detail row rearrange each commodity detail row, and calculating has identical
Total line number of the commodity detail row of discount ratio and same tax rate and total discount amount thereof, and identical having
A folding is inserted after last column commodity detail row of the commodity detail row of discount ratio and same tax rate
Button row, embodies in the trade name of this discount row that to have the commodity of identical discount ratio and same tax rate bright
Total line number of thin row and discount ratio, the amount of money of this discount row is total discount amount * (-1).Invoice number
Can be similar to exist by discount mark and discount ratio the two according to the operation performed by computing module 24
Operation described in abovementioned steps S4 during data item, here is omitted.And, splitting module
After 25 complete described fractionation, represent the situation opening the VAT invoice without inventory at inventory mark
Under, invoice data computing module 24 is additionally operable to: if ticket data to be developed is concentrated has identical discount ratio
Discount is not had with after a line of same tax rate or last column commodity detail row of multirow commodity detail row
Capable then after this last column commodity detail row insert a discount row, if at described last column commodity
There is after detailed row discount row and then update this discount row, and update the bright of this ticket data to be developed concentration
Thin total valency tax adds up to, detail adds up to invoice amount and the detailed total invoice amount of tax to be paid.This makes it possible to often
The discount data opening ticket data to be developed concentration processes again, so that every ticket data collection to be developed
In data the most accurate, it is to avoid the gold on the invoice opened according to this ticket data collection to be developed occurs
It is poor that the data item calculated in the data item such as volume, the amount of tax to be paid and the sales slip of Ying Gaizengzong sub-agencies enterprise exists
Different situation, improves the Financial Control Level of Ying Gaizengzong sub-agencies enterprise.Invoice data calculates herein
Inserting performed by module 24 is retouched in the method according to the invention before with the operation updating discount row
The operation stated is similar to, and here is omitted.
It addition, from the point of view of according to existing effective sale forms data statistical result, in the increment opening band inventory
In the case of tax invoice, the detailed total invoice amount that usual sales slip detailed data is concentrated is less than making out an invoice
Limit, therefore when sales slip detailed data concentration also includes discounting commodity, enter splitting module 25
After row splits, discount data can not be reprocessed by invoice data computing module 24.If sold
The detailed total invoice amount that list detailed data is concentrated more than making out an invoice limit, is then carried out in fractionation module 25
After fractionation, invoice data computing module 24 can also carry out operation similar to the above to discount data,
I.e. insert and update discount row and update detailed total valency tax total, the detailed conjunction that ticket data to be developed is concentrated
Meter invoice amount and the detailed total invoice amount of tax to be paid.
The preferred embodiment of the present invention is described in detail above in association with accompanying drawing, but, the present invention does not limit
Detail in above-mentioned embodiment, in the technology concept of the present invention, can be to the present invention
Technical scheme carry out multiple simple variant, these simple variant belong to protection scope of the present invention.
Additionally, combination in any can also be carried out between the various different embodiment of the present invention, as long as its
Without prejudice to the thought of the present invention, it should be considered as content disclosed in this invention equally.
Claims (14)
1., for the method opening many tax rates VAT invoice without amount of tax to be paid sales slip, the method includes:
Step S1, acquisition battalion change increasing business commodity dictionary table and the sales slip data set of ticket to be developed and pin
Selling single detailed data collection, described sales slip data set includes the sales slip amount of money, containing tax mark and limit of making out an invoice,
Described sales slip detailed data collection includes that multiple commodity detail row, each commodity detail row include trade name
Title, unit price, quantity, the amount of money and the tax rate, described battalion changes increasing business commodity dictionary table and includes that belonging to battalion changes
The trade name of the commodity of increasing business and the tax rate;
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, and it is detailed to verify these commodity to change the tax rate in increasing business commodity dictionary according to described battalion
The tax rate in row is the most accurate;
Step S4, according to described unit price containing tax mark, in each described commodity detail row, quantity and
The tax rate calculate and in each described commodity detail row add valency tax total, invoice amount, the invoice amount of tax to be paid and
Invoice unit price, and by valency tax total, invoice amount and the invoice amount of tax to be paid in all described commodity detail row
It is cumulative respectively that to add in described sales slip detailed data concentration, detailed total valency tax adds up to, detailed total is sent out
The ticket amount of money and the detailed total invoice amount of tax to be paid;And
Step S5, according to described in make out an invoice limit, described battalion change on increasing mark and described VAT invoice
Predetermined commodity detail line number, splits into multiple ticket data collection to be developed by described sales slip detailed data collection.
Method the most according to claim 1, wherein, in step s 4,
In the case of the described mark containing tax represents containing tax, below equation is used to calculate each described commodity bright
Valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of thin row:
Valency tax total=unit price * quantity;
Invoice amount=valency tax adds up to/(the 1+ tax rate);
The invoice amount of tax to be paid=valency tax total-invoice amount;
Invoice unit price=unit price/(the 1+ tax rate);
In the case of the described mark containing tax represents without tax, below equation is used to calculate each described commodity
Valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of detailed row:
Invoice amount=unit price * quantity;
The invoice amount of tax to be paid=invoice amount * tax rate;
Valency tax total=invoice amount+invoice amount of tax to be paid.
Method the most according to claim 1, wherein, described sales slip data set also includes inventory
Mark and Chinese character anti-false logo, described Chinese character anti-false logo defines on described VAT invoice
Predetermined commodity detail line number, the most described step S5 comprises the following steps:
Step S51, represent the VAT invoice opening band inventory at described inventory mark in the case of, depend on
Limit is made out an invoice and described battalion changes increasing mark and described sales slip detailed data collection is split into multiple treating according to described
Drawing a bill data set, the most same ticket data to be developed concentrates the battalion of all commodity detail row to change increasing mark all
Identical and each 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;
Step S52, in the case of described inventory mark represents and opens without the VAT invoice of inventory,
Make out an invoice described in Yi Ju limit, described battalion changes increasing mark and described Chinese character anti-false logo by described sales slip
Detailed data collection splits into multiple ticket data collection to be developed, and the most same ticket data to be developed concentrates all business
It is the most identical that the battalion of product detail row changes increasing mark, and the detailed of each ticket data collection to be developed adds up to invoice amount equal
The commodity detail line number of limit of making out an invoice described in being less than or equal to and each ticket data collection to be developed is not more than described
Predetermined commodity detail line number on VAT invoice.
Method the most according to claim 3, wherein, also includes in each described commodity detail row
By discount mark and discount ratio, and the described sales slip amount of money is the amount of money after discount, and each described commodity are bright
The amount of money in thin row is the amount of money before discount, then:
In step 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, always according to the discount ratio in each described commodity detail row and the tax rate
Rearranging each described commodity detail row, the commodity that calculating has identical discount ratio and same tax rate are bright
Total line number of thin row and total discount amount thereof, and bright at the commodity with identical discount ratio and same tax rate
A discount row, body in the trade name of this discount row is inserted after last column commodity detail row of thin row
Show total line number and the discount ratio of the commodity detail row with identical discount ratio and same tax rate, should
The amount of money of discount row is described total discount amount * (-1);And
In step S52, if described ticket data to be developed is concentrated has identical discount ratio and same tax rate
A line or multirow commodity detail row last column commodity detail row after do not have discount row then at this
A discount row is inserted, if after described last column commodity detail row after rear a line commodity detail row
There is discount row and then update this discount row, and update the detailed total valency tax that this ticket data to be developed is concentrated
Add up to, detail adds up to invoice amount and the detailed total invoice amount of tax to be paid.
5. according to the method described in any claim in Claims 1-4, wherein, step S3 bag
Include:
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;
If it is complete that the trade name in same commodity detail row and described battalion change in increasing business commodity dictionary table
Maximum similarity value in the Similarity value of portion's trade name is more than predetermined value, then at this product detail row of doing business
Middle increase battalion changes increasing mark, and verifies whether this tax rate in product detail row of doing business changes increasing industry equal to described battalion
Business commodity dictionary table has the commodity of maximum similarity value with this trade name in product detail row of doing business
The tax rate corresponding to title.
Method the most according to claim 5, wherein, utilizes in ORACLE data base
Utl_match.edit_distance_similarity calculates described Similarity value.
Method the most according to claim 5, wherein, described predetermined value is 0.5.
8., for opening a system for many tax rates VAT invoice without amount of tax to be paid sales slip, 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 includes the sales slip amount of money, containing tax mark with open
Ticket limit, described sales slip detailed data collection includes that multiple commodity detail row, each commodity detail row include
Trade name, unit price, quantity, the amount of money and the tax rate, described battalion changes increasing business commodity dictionary table and includes belonging to
Yu Yinggai increases trade name and the tax rate of the commodity of 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, and the tax rate changed in increasing business commodity dictionary according to described battalion verifies
The tax rate in this commodity detail row is the most accurate;
Invoice data computing module, for according to described containing tax mark, in each described commodity detail row
Unit price, quantity and the tax rate calculate and add in each described commodity detail row valency tax total, invoice amount,
The invoice amount of tax to be paid and invoice unit price, and by the valency tax total in all described commodity detail row, invoice amount
With the invoice amount of tax to be paid respectively cumulative 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;And
Split module, after completing described calculating at described invoice data computing module and add up, depend on
The predetermined commodity detail row increased on mark and described VAT invoice is changed according to described limit of making out an invoice, described battalion
Number, splits into multiple ticket data collection to be developed by described sales slip detailed data collection.
System the most according to claim 8, wherein, described invoice data computing module is used for:
In the case of the described mark containing tax represents containing tax, below equation is used to calculate each described commodity bright
Valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of thin row:
Valency tax total=unit price * quantity;
Invoice amount=valency tax adds up to/(the 1+ tax rate);
The invoice amount of tax to be paid=valency tax total-invoice amount;
Invoice unit price=unit price/(the 1+ tax rate);
In the case of the described mark containing tax represents without tax, below equation is used to calculate each described commodity
Valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of detailed row:
Invoice amount=unit price * quantity;
The invoice amount of tax to be paid=invoice amount * tax rate;
Valency tax total=invoice amount+invoice amount of tax to be paid.
System the most according to claim 8, wherein, described sales slip data set also includes inventory
Mark and Chinese character anti-false logo, described Chinese character anti-false logo defines on described VAT invoice
Predetermined commodity detail line number, described fractionation module is used for:
Represent in the case of opening the VAT invoice of band inventory at described inventory mark, according to described in make out an invoice
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.
11. systems according to claim 10, 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:
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, according to the folding in each described commodity detail row
Button ratio and the tax rate rearrange each described commodity detail row, calculate and have identical discount ratio with identical
Total line number of the commodity detail row of the tax rate and total discount amount thereof, and there is identical discount ratio with identical
A discount row is inserted after last column commodity detail row of the commodity detail row of the tax rate, this discount row
Trade name embodies total line number of the commodity detail row with identical discount ratio and same tax rate with
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 identical discount ratio and a line of same tax rate or last column of multirow commodity detail row
Discount row is not had then to insert a discount after this last column commodity detail row after commodity detail row
OK, if there is discount row after described last column commodity detail row, this discount row, Yi Jigeng are updated
The detailed total valency tax of new this ticket data to be developed concentration adds up to, detail adds up to invoice amount and detailed total
The invoice amount of tax to be paid.
12. according to Claim 8 to the system described in any claim in 11, 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;
If it is complete that the trade name in same commodity detail row and described battalion change in increasing business commodity dictionary table
Maximum similarity value in the Similarity value of portion's trade name is more than predetermined value, then at this product detail row of doing business
Middle increase battalion changes increasing mark, and verifies whether this tax rate in product detail row of doing business changes increasing industry equal to described battalion
Business commodity dictionary table has the commodity of maximum similarity value with this trade name in product detail row of doing business
The tax rate corresponding to title.
13. systems according to claim 12, wherein, described battalion changes increasing identification module and utilizes
Utl_match.edit_distance_similarity in ORACLE data base calculates described Similarity value.
14. systems according to claim 12, wherein, described predetermined value is 0.5.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510230661.8A CN106204173A (en) | 2015-05-08 | 2015-05-08 | For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510230661.8A CN106204173A (en) | 2015-05-08 | 2015-05-08 | For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip |
Publications (1)
Publication Number | Publication Date |
---|---|
CN106204173A true CN106204173A (en) | 2016-12-07 |
Family
ID=57459711
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510230661.8A Pending CN106204173A (en) | 2015-05-08 | 2015-05-08 | For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106204173A (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109685442A (en) * | 2017-10-17 | 2019-04-26 | 航天信息股份有限公司 | Method and device for business data processing |
CN110490512A (en) * | 2019-07-18 | 2019-11-22 | 中国铁道科学研究院集团有限公司 | Liquidation method and device are carried in shipping |
-
2015
- 2015-05-08 CN CN201510230661.8A patent/CN106204173A/en active Pending
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109685442A (en) * | 2017-10-17 | 2019-04-26 | 航天信息股份有限公司 | Method and device for business data processing |
CN110490512A (en) * | 2019-07-18 | 2019-11-22 | 中国铁道科学研究院集团有限公司 | Liquidation method and device are carried in shipping |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
EP3602384B1 (en) | Layered masking of content | |
US11450129B2 (en) | Data extraction and duplicate detection | |
NL2012438B1 (en) | Resolving similar entities from a database. | |
US9892384B2 (en) | Extracting product purchase information from electronic messages | |
US11062132B2 (en) | System and method for identification of missing data elements in electronic documents | |
US9875486B2 (en) | Extracting product purchase information from electronic messages | |
US20110066662A1 (en) | System and Method for Content Extraction from Unstructured Sources | |
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 | |
CN103927615B (en) | Entity is associated with classification | |
CN106204175A (en) | For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip | |
CN103761341B (en) | Information matching method and device | |
CN104714950B (en) | For the method and system that the information in database is modified and supplemented | |
US11138372B2 (en) | System and method for reporting based on electronic documents | |
US7577653B2 (en) | Registration system and duplicate entry detection algorithm | |
CN112182207A (en) | Invoice false-proof risk assessment method based on keyword extraction and rapid text classification | |
WO2016064679A1 (en) | Extracting product purchase information from electronic messages | |
US20180053204A1 (en) | Auto-population of discount information into an e-invoice | |
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 | |
CN106204173A (en) | For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip | |
CN106204179A (en) | For opening the method and system of single tax rate VAT invoice without amount of tax to be paid sales slip | |
CN103885998A (en) | Method for unified registration applying of XBRL (extensible business reporting language) factors | |
CN106204178A (en) | The method and system of many tax rates VAT invoice is opened for the sales slip containing the amount of tax to be paid | |
CN106204177A (en) | For opening the method and system of single tax rate VAT invoice without amount of tax to be paid sales slip | |
Cherednichenko et al. | Information technology for intellectual analysis of item descriptions in e-commerce | |
CN106204176A (en) | The method and system of many tax rates VAT invoice is opened for the sales slip containing the amount of tax to be paid |
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 |
Application publication date: 20161207 |
|
RJ01 | Rejection of invention patent application after publication |