CN106204176A - The method and system of many tax rates VAT invoice is opened for the sales slip containing the amount of tax to be paid - Google Patents
The method and system of many tax rates VAT invoice is opened for the sales slip containing the amount of tax to be paid Download PDFInfo
- Publication number
- CN106204176A CN106204176A CN201510232312.XA CN201510232312A CN106204176A CN 106204176 A CN106204176 A CN 106204176A CN 201510232312 A CN201510232312 A CN 201510232312A CN 106204176 A CN106204176 A CN 106204176A
- Authority
- CN
- China
- Prior art keywords
- tax
- amount
- invoice
- paid
- discount
- 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 invention discloses a kind of method and system opening many tax rates VAT invoice for the sales slip containing the amount of tax to be paid, including: obtaining and include the sales slip amount of money, the sales slip amount of tax to be paid, sales slip data set containing tax mark and limit of making out an invoice and include the sales slip detailed data collection of multiple commodity detail row, each commodity detail row includes trade name, unit price, quantity, the amount of money, the amount of tax to be paid and the tax rate;Whether whether whether verification unit price be equal to the sales slip amount of money, amount of tax to be paid sum equal to the sales slip amount of tax to be paid equal to the amount of money, amount of money sum with the long-pending of quantity;According to containing tax mark, unit price, quantity and tax rate given price tax total, invoice amount, the invoice amount of tax to be paid and invoice unit price, the valency tax that adds up respectively total, invoice amount and the invoice amount of tax to be paid obtain detailed total valency tax total, detailed total invoice amount and detail and add up to the invoice amount of tax to be paid;Whether the verification amount of tax to be paid is less than the first predetermined value with the absolute value of the difference of the invoice amount of tax to be paid;Split sales slip detailed data collection.It can be prepared in advance and meet the ticket data to be developed of invoice data specification.
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 many tax rates VAT invoice.
Background technology
The forgery prevention for value-added tax taxation control system of Administration of State Bureau is that ordinary enterprises provides and opens VAT invoice
Function, user can the most item by item typing invoice data to complete invoice issuing, it is also possible to will
Ticket data to be developed imports this system interface to complete invoice issuing.But opened by typing invoice data
Ticket, had both added time and human cost, may make mistakes again logging data when.Lead if used
Enter data to make out an invoice, then need first to be ready to meet the ticket data to be developed of invoice data specification, but at present
Also do not have a kind of reasonable method to be prepared in advance and meet the ticket data to be developed of invoice data specification.
Summary of the invention
In enterprise business, in the operation system of enterprise, the most first generate sales slip data,
So can consider sales slip data to be passed to forgery prevention for value-added tax taxation control system interface to complete invoice issuing.
But owing to enterprise is different in registration type, the productive and business scope of Administration of State Bureau, the sale odd number of different enterprises
According to having many different attributes, it is imparted to anti-false tax-controlled system and carries out invoice if not doing correct process and open
Tool, can cause normally making out an invoice because various data check relations are not inconsistent;Even if or opened invoice,
Possibly also owing to the data item such as the amount of money of invoice data, the amount of tax to be paid are deposited with the data item of calculating in enterprise marketing list
In difference, bring problem to the financial management of enterprise.
The present invention is in the case of taking into full account above-mentioned present situation, it is provided that one is opened for the sales slip containing the amount of tax to be paid
The method and system of many tax rates VAT invoice, its can time-consuming and human cost, again can be accurate in advance
Get the ticket data to be developed meeting invoice data specification ready.
The present invention provides a kind of method opening many tax rates VAT invoice for the sales slip containing the amount of tax to be paid, the method
Including:
Step S1, the sales slip data set obtaining ticket to be developed and sales slip detailed data collection, described pin
Sell forms data collection include the sales slip amount of money, the sales slip amount of tax to be paid, containing tax mark and limit of making out an invoice, described sale
Single detailed data collection include multiple commodity detail row, each commodity detail row include trade name, unit price,
Quantity, the amount of money, the amount of tax to be paid and the tax rate;
Step S2, whether verify in each described commodity detail row unit price and the product of quantity equal to same
Whether the amount of money in commodity detail row, verify the amount of money sum in all described commodity detail row equal to described
The sales slip amount of money, and whether the amount of tax to be paid sum verified in all described commodity detail row is equal to described sales slip
The amount of tax to be paid;
Step S3, according to described unit price containing tax mark, in each described commodity detail row, quantity and
The tax rate calculate and in each described commodity detail row add valency tax total, invoice amount, the invoice amount of tax to be paid and
Invoice unit price, and valency tax total, invoice amount and the invoice tax of all described commodity detail row that adds up respectively
Volume is cumulative to add detailed total valency tax total, detailed total in described sales slip detailed data concentration respectively
Invoice amount and the detailed total invoice amount of tax to be paid;
Step S4, the described amount of tax to be paid verified in each described commodity detail row and the difference of the described invoice amount of tax to be paid
Absolute value whether less than the first predetermined value;And
Step S5, according to described in make out an invoice the predetermined commodity detail line number on limit and described VAT invoice,
Described sales slip detailed data collection is split into multiple ticket data collection to be developed.
The present invention also provides for a kind of system opening many tax rates VAT invoice for the sales slip containing the amount of tax to be paid, and this is
System includes:
Acquisition module, for obtaining sales slip data set and sales slip detailed data collection, the institute of ticket to be developed
State sales slip data set include the sales slip amount of money, the sales slip amount of tax to be paid, 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, list
Valency, quantity, the amount of money, the amount of tax to be paid and the tax rate;
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 same commodity detail row, verify the amount of money in all described commodity detail row it
Whether whether it is equal to the amount of tax to be paid sum in the described sales slip amount of money and all described commodity detail row of verification
Equal to the described sales slip amount of tax to be paid;
Invoice data computing module, for according to described containing tax mark, in each described commodity detail row
Unit price, quantity and the tax rate calculate and add in each described commodity detail row valency tax total, invoice amount,
The invoice amount of tax to be paid and invoice unit price, and the valency tax of all described commodity detail row that adds up respectively adds up to, invoice gold
Volume and the invoice amount of tax to be paid are cumulative respectively adds detailed total valency tax conjunction to concentrate at described sales slip detailed data
Meter, detailed total invoice amount and the detailed total invoice amount of tax to be paid;
Amount of tax to be paid error estimator module, for verifying the described amount of tax to be paid in each described commodity detail row with described
Whether the absolute value of the difference of the invoice amount of tax to be paid is less than the first predetermined value;And
Split module, for after described amount of tax to be paid error estimator module completes described verification, according to described
Predetermined commodity detail line number in limit of making out an invoice and described VAT invoice, by described sales slip detailed data
Collection splits into multiple ticket data collection to be developed.
By technique scheme, owing to the method according to the invention and system make use of enterprise operation system
In sales slip data, and sales slip data processed obtains meeting invoice data specification wait out
Invoice data, therefore, it is possible to time-consuming and human cost, improves the invoice issuing efficiency of enterprise, reduces
Enterprise's risk issued invoice lack of standardization, promotes that enterprise's legacy specification is managed and normal invoice issuing, enters
One step is strengthened and specification VAT invoice manages, and improves the Financial Control Level of enterprise.
Other features and advantages of the present invention will be described in detail in detailed description of the invention part subsequently.
Accompanying drawing explanation
Accompanying drawing is used to provide a further understanding of the present invention, and constitutes the part of description, with
Detailed description below is used for explaining the present invention together, but is not intended that limitation of the present invention.?
In accompanying drawing:
Fig. 1 is opening many tax rates value-added tax send out for the sales slip containing the amount of tax to be paid according to one embodiment of the present invention
The flow chart of the method for ticket;And
Fig. 2 is opening many tax rates value-added tax send out for the sales slip containing the amount of tax to be paid 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.
The commodity detail tax rate that many tax rates refer on a VAT invoice can be multiple;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 does not identify the tax rate, but identifies the amount of tax to be paid;Sales slip detailed data both identified multiple
The tax rate, also identifies the amount of tax to be paid.
As it is shown in figure 1, according to one embodiment of the present invention for the sales slip containing the amount of tax to be paid open many tax rates increase
The method of value tax invoice comprises the following steps:
Step S1, the sales slip data set obtaining ticket to be developed and sales slip detailed data collection, sales slip
Data set include the sales slip amount of money, the sales slip amount of tax to be paid, containing tax mark and limit of making out an invoice, sales slip detail number
Include that multiple commodity detail row, each commodity detail row include trade name, unit price, quantity, gold according to collection
Volume, the amount of tax to be paid and the tax rate.
Generally, in the operation system of enterprise, add mark of making out an invoice can to the sales slip in sales slip tables of data
Will, in order to clearly search and process the sales slip not issued invoice.Therefore, it can according to sales slip
" mark of making out an invoice ", the sales slip tables of data of enterprise operation system is searched the sale not issued invoice
Single key data, forms sales slip data set.It is for instance possible to use SQL statement or other computers
Program statement obtains sales slip data set, and exemplary SQL statement form is: " SELECT sells
Odd numbers, the sales slip amount of money, the sales slip amount of tax to be paid, containing tax mark, inventory mark, Chinese character anti-false logo,
Limit FROM of making out an invoice sales slip tables of data WHERE is made out an invoice mark=' not making out an invoice ' ".Above SQL
Sentence format is only exemplary, and in practical operation, inventory mark and Chinese character anti-false logo are not
Must obtain, namely in sales slip data set, not include inventory mark and Chinese character anti-false logo
In the case of, can follow-up sales slip detailed data collection is split time, pre-by VAT invoice
Determine commodity detail line number and be defined to such as 7 row (this changes according to the VAT invoice of tax bureau's offer),
So that the limit that the commodity detail line number maximum that each ticket data to be developed is concentrated specifies less than the tax bureau
Condition processed.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, the amount of money, the tax rate, amount of tax to be paid FROM sales slip commodity detailed data table
WHERE sells odd numbers=' present sales odd numbers ' ".Wherein, by discount mark and discount ratio it is not
Necessary, when enterprise does not carries out discount sales to commodity, sales slip detailed data is concentrated and can not be included
By discount mark and discount ratio.Table 2 shows the exemplary sales of the sales slip XSD0001 of table 1
Single detailed data collection.It addition, when there being discounting commodity, before the amount of tax to be paid in table 2 is based on the discount of commodity
The amount of tax to be paid that the amount of money calculates.
Sequence number | Trade name | Unit price | Quantity | The amount of money | The tax rate | The amount of tax to be paid | By discount mark | Discount ratio |
1 | Commodity 1 | 1000.00 | 1 | 1000.00 | 11% | 99.10 | ||
2 | Commodity 2 | 750.00 | 2 | 1500.00 | 6% | 84.91 | ||
3 | Discounting commodity 1 | 300.00 | 2 | 600.00 | 11% | 59.46 | Y | 20% |
4 | Discounting commodity 2 | 400.00 | 1 | 400.00 | 11% | 39.64 | Y | 20% |
5 | Commodity 3 | 700.00 | 2 | 1400.00 | 11% | 138.74 | ||
6 | Commodity 4 | 400.00 | 4 | 1600.00 | 6% | 90.57 | ||
7 | Discounting commodity 3 | 400.00 | 13 | 5200.00 | 6% | 294.34 | Y | 20% |
8 | Discounting commodity 4 | 600.00 | 3 | 1800.00 | 6% | 101.89 | Y | 20% |
9 | Commodity 5 | 500.00 | 5 | 2500.00 | 11% | 247.75 |
Table 2
Step S2, whether verify in each commodity detail row the product of unit price and quantity equal to same commodity
The amount of money in detailed row, verifies whether the amount of money sum in all commodity detail row is equal to the sales slip amount of money,
With the amount of tax to be paid sum verified in all commodity detail row whether equal to the sales slip amount of tax to be paid.
Such as, in verifying each commodity detail row, unit price is the brightest equal to same commodity with the product of quantity
Carefully during the amount of money in row, can concentrate at sales slip detailed data, circulate to end data from first bar, by
Bar obtains these data item of line number, the amount of money, quantity and unit price of every commodity detail row, and calculates " 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.
When whether the amount of tax to be paid sum in verifying all commodity detail row is equal to the sales slip amount of tax to be paid, can be at pin
Sell single detailed data to concentrate, from first bar to end data circulation, obtain one by one in each commodity detail row
Amount of tax to be paid data item, accumulative addition calculation generates detail and adds up to the amount of tax to be paid, finally judge this detail add up to the amount of tax to be paid and
The sales slip amount of tax to be paid is the most equal, if unequal, then prompting " the ∑ sales slip detail amount of tax to be paid and sales slip tax
Volume is unequal " after, terminate algorithm flow;If equal, then continue subsequent step.
Step S3, basis calculate containing the unit price in tax mark, each commodity detail row, quantity and the tax rate
And in each commodity detail row, add valency tax total, invoice amount, the invoice amount of tax to be paid and invoice unit price, and
The valency tax of all commodity detail row of adding up respectively adds up to, invoice amount and the invoice amount of tax to be paid be with detailed at sales slip
Data set adds detail total valency tax total, detailed total invoice amount and the detailed total invoice amount of tax to be paid.
Wherein, in the case of the mark containing tax represents containing tax (such as, representing containing tax with letter Y) (also
I.e. unit price in commodity detail row is containing duty receipt valency), use below equation to calculate each commodity detail row
Valency tax total, invoice amount, the invoice amount of tax to be paid and invoice unit price:
Valency tax total=unit price * quantity;
Invoice amount=valency tax adds up to/(the 1+ tax rate);
The invoice amount of tax to be paid=valency tax total-invoice amount;
Invoice unit price=unit price/(the 1+ tax rate);
In the case of the mark containing tax represents without tax (such as, representing containing tax with letter N) (namely business
Unit price in product detail row is free from duty receipt valency), use below equation to calculate the valency of each commodity detail row
Tax total, invoice amount, the invoice amount of tax to be paid and invoice unit price:
Invoice amount=unit price * quantity;
The invoice amount of tax to be paid=invoice amount * tax rate;
Valency tax total=invoice amount+invoice amount of tax to be paid.
Calculate valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of each commodity detail row with
And detailed total valency tax add up to, detailed add up to invoice amount and detailed add up to after the invoice amount of tax to be paid exemplary
Table 4 hereinafter asked for an interview by sales slip detailed data collection.
Whether the absolute value of the difference of step S4, the amount of tax to be paid verified in each commodity detail row and the invoice amount of tax to be paid
Less than the first predetermined value.
Such as, in this step, each commodity detail row data that sales slip detailed data is concentrated, from
First bar calculates the amount of tax to be paid error of each commodity detail row one by one to end bar circulation, and formula is: amount of tax to be paid error=
The amount of tax to be paid-invoice amount of tax to be paid, if | amount of tax to be paid error | > the first predetermined value, then the range of error beyond regulation can not
Make out an invoice, after prompting " line number is that the commodity detail amount of tax to be paid of ' current line number ' surpasses error, it is impossible to make out an invoice ",
Terminate algorithm flow, if < the first predetermined value then continues subsequent step to | amount of tax to be paid error |.Preferably,
One predetermined value is the 0.06 of revenue department's regulation, certainly selects the value less than 0.06 as the first predetermined value also
It is feasible.
Step S5, according to making out an invoice the predetermined commodity detail line number on limit and VAT invoice, will sell
Single detailed data collection splits into multiple ticket data collection to be developed.
Limit of making out an invoice is the restriction to the amount of money of making out an invoice, the VAT invoice of such as 10,000 yuan, the highest opens
The ticket amount of money is 10,000 yuan.Predetermined commodity detail line number on VAT invoice is that enterprise can send out at value-added tax
The maximum commodity detail line number listed on ticket.That is, each ticket data collection to be developed finally given is bright
Thin total invoice amount can not be more than making out an invoice limit, and its commodity detail line number not can exceed that on VAT invoice
Predetermined commodity detail line number.Split the ticket data collection exemplary to be developed obtained and ask for an interview table 5 hereinafter
With table 6.
So far, just completing the process of sales slip data, the ticket data collection each to be developed generated is exactly
The key data of one ticket to be developed, other number needed drawing a bill in these key datas and sales slip
Complete sending out can be formed according to key element (such as, sales organization, purchasing unit title etc.) after merging
Ticket data, the interface that the invoice data that this is complete is sent to tax-supervise system to be provided just can complete invoice
Open.
Preferably, sales slip data set can also include inventory mark and Chinese character anti-false logo, should
Chinese character anti-false logo defines the predetermined commodity detail line number on VAT invoice.Wherein, inventory mark
Will for representing whether the VAT invoice opening band inventory, such as, can represent with inventory mark Y
Open the VAT invoice of band inventory, represent with inventory mark N and open the VAT invoice without inventory.
Chinese character anti-false logo illustrates enterprise's registration type in Administration of State Bureau, such as, can look forward to Chinese character anti-false
Industry mark Y represents that this enterprise is Chinese character anti-false enterprise, represents this enterprise with Chinese character anti-false logo N
Shi Fei Chinese character anti-false enterprise.Opening regulation according to existing Administration of State Bureau VAT invoice, non-Chinese character anti-false is looked forward to
The commodity detail line number that industry is opened on VAT invoice not can exceed that 8, and Chinese character anti-false enterprise is in increment
The commodity detail line number opened on tax invoice not can exceed that 7.Then:
(1) in the case of inventory mark represents and opens the VAT invoice of band inventory, abovementioned steps S4
Also include that the amount of tax to be paid sum verifying in all commodity detail row and detail add up to the exhausted of the difference of the invoice amount of tax to be paid
To value whether less than the second predetermined value, namely verification | detailed total invoice amount of tax to be paid detail adds up to the amount of tax to be paid |
Whether less than the second predetermined value, if less than, continue subsequent step, if being more than, then point out such as and " sell
Single amount of tax to be paid surpasses error, it is impossible to make out an invoice " after, terminate algorithm flow.Preferably, the second predetermined value is the tax
The 1.27 of agencies dictate, certainly, selecting the value less than 1.27 is also feasible as the second predetermined value.With
And, step S5 includes, according to limit of making out an invoice, sales slip detailed data collection is split into multiple poll to be developed
According to collection, the most each ticket data collection to be developed detailed add up to invoice amount be less than or equal to described in make out an invoice limit
Volume.Owing to being the VAT invoice opening band inventory, it is possible to do not consider Chinese character anti-false logo.
Such as, this step can be carried out as follows: first, it is determined that send out detailed total that sales slip detailed data is concentrated
The ticket amount of money, whether less than or equal to making out an invoice limit, if being less than or equal to, does not the most split sales slip detailed data collection;
If being more than, then need sales slip detailed data collection to be split, i.e. from sales slip detailed data to be split
Concentrate, successively from first bar commodity detail row to end bar commodity detail row circulation, take in every commodity detail row
Invoice amount and its Amount in Total of accumulation calculating, obtained when accumulation calculating to certain commodity detail row
Amount in Total more than make out an invoice limit time, by before this commodity detail row entire service detail row split
Concentrating to a ticket data to be developed, the rest may be inferred, sales slip detailed data collection is split into multiple and waits out
Invoice data collection so that the detailed total invoice amount that each ticket data to be developed is concentrated is not more than invoice limit
Volume.
(2) in the case of inventory mark represents and opens without the VAT invoice of inventory, abovementioned steps
S5 includes: according to making out an invoice limit and sales slip detailed data collection is split into many by Chinese character anti-false logo
Individual ticket data collection to be developed, the detailed of the most each ticket data collection to be developed adds up to invoice amount to be less than or equal to
It is pre-that the commodity detail line number of limit of making out an invoice and each ticket data collection to be developed is not more than on VAT invoice
Determine commodity detail line number.That is, non-Chinese character anti-false enterprise at most can only open 8 on VAT invoice
Commodity detail line number, Chinese character anti-false enterprise at most can only open 7 commodity detail row on VAT invoice
Number.
It addition, when enterprise is to its commodity discount sales, will be in the sales slip detailed data table of enterprise
Have by discount mark and discount ratio the two data item, to show which commodity is discounting commodity, give a discount
Ratio is how many, consequently facilitating the financial management of enterprise.It is therefore preferred that sales slip detailed data collection
Each commodity detail row in also include by discount mark and discount ratio, and after the sales slip amount of money is discount
The amount of money, the sales slip amount of tax to be paid 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, the amount of tax to be paid in each commodity detail row is the amount of tax to be paid calculated according to 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 enterprise, need first to calculate this commodity detail row
After discount, the amount of money adds up the most again.And, in step s 2, the most correspondingly need first to calculate bag
After the discount of the commodity detail row containing discount commodity the amount of tax to be paid and after verifying this discount the amount of tax to be paid with do not comprise discount
Whether the amount of tax to be paid sum in other commodity detail row of commodity is equal to the sales slip amount of tax to be paid.After discount, the amount of tax to be paid is permissible
Calculate according to the amount of money after discount and the mark Han tax.
And, in aforesaid step S3, concentrate each commodity detailed calculating sales slip detailed data
Before valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of row, in addition it is also necessary to according to discount ratio
Rearrange each commodity detail row with the tax rate, calculate and there are identical discount ratio and the commodity of same tax rate
Detailed total line number of row, total discount amount and total discount amount of tax to be paid, 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 total discount amount * (-1), and the amount of tax to be paid of this discount row is described
Total discount amount of tax to be paid * (-1).For example, it is possible to the commodity detail row of identical discount ratio and same tax rate is divided
At one group, and being arranged in order by group, discount ratio is one group of empty business represented in this group commodity detail row
Product are non-discounting commodity, this group commodity detail row can be arranged in foremost and (certainly, come sales slip
Detailed data collection is the most also feasible);It is not empty each group commodity detail row to discount ratio,
Need to add up respectively total line number of each group of commodity detail row, calculate total discount amount of each group of commodity detail row
With total discount amount of tax to be paid, the wherein amount of money * discount ratio in total this group commodity detail row of discount amount=∑, always
The discount amount of tax to be paid can be according to containing tax mark, calculate by aforesaid invoice computation of tax amount formula, and respectively
A discount row, the commodity of this discount row are inserted after last column commodity detail row of group commodity detail row
Title can be " discount line number Y (X.XXX%) ", and wherein " Y " respectively organizes tool for what calculating generated
Having total line number of the commodity detail row of identical discount ratio and same tax rate, " X " is discount ratio, or
The trade name of this discount row can also be that other can embody this group and have identical discount ratio with identical
Total line number of the commodity detail row of the tax rate and other titles of discount ratio, the amount of money of this discount row is for calculating
Total discount amount * (-1) generated is to represent that commodity are given a discount.Table 3 gives in discount ratio and tax
Rate rearranges the commodity detail row in table 2 and inserts the exemplary sales list detailed data after discount row
Collection.
Table 3
Table 4 gives and calculates the valency tax total of each commodity detail row, invoice gold on the basis of table 3
Volume, the invoice amount of tax to be paid and invoice unit price and detailed total valency tax add up to, detail adds up to invoice amount and detail
Add up to the exemplary sales list detailed data collection after the invoice amount of tax to be paid.
Table 4
And, when sales slip detailed data concentration includes by discount mark and discount ratio, at inventory mark
In the case of will represents and opens without the VAT invoice of inventory, also need in step s 5 discount row
Process, ticket data the most to be developed concentrate have identical discount ratio and a line of same tax rate or
Discount row is not had then to do business this last after last column commodity detail row of multirow commodity detail row
Insert a discount row after product detail row and (wherein, insert the operation of discount row and insertion described before
The operation of discount row is identical, and here is omitted), if having after described last column commodity detail row
There is discount row then to update this discount row and (wherein, update the operation of discount row and insertion discount described before
The operation of row is identical, the most also repeats no more), and update the detailed conjunction that this ticket data to be developed is concentrated
Valuation tax adds up to, detail adds up to invoice amount and detail adds up to the invoice amount of tax to be paid.This makes it possible to treat every
The discount data drawn a bill in data set processes again, so that every ticket data to be developed concentration
Data are the most accurate, it is to avoid occur according to the amount of money on the invoice that this ticket data collection to be developed is opened, tax
The situation that the data item calculated in the sales slip of the data item such as volume and enterprise there are differences, improves enterprise
Financial Control Level.As a example by the sales slip detailed data collection of table 4, split utilizing this step
Obtain two ticket data collection to be developed afterwards, ask for an interview shown in table 5 and table 6.Clear due to what table 1 was given
Single mark is Y, namely opens the VAT invoice of band inventory, so only considering, when splitting, limit of making out an invoice
This factor is without considering Chinese character anti-false logo.
Table 5
Table 6
It addition, from the point of view of according to existing effective sale forms data statistical result, in the increment opening band inventory
In the case of tax invoice, the detailed total invoice amount that usual sales slip detailed data is concentrated is less than making out an invoice
Limit, therefore when sales slip detailed data concentration also includes discounting commodity, in the fractionation of step S5
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 S5, 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.
According to one embodiment of the present invention, the present invention also provides for one and opens many 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,
Invoice data computing module 23, amount of tax to be paid error estimator module 24 and fractionation module 25.
Wherein, acquisition module 21, for obtaining sales slip data set and the sales slip detail number of ticket to be developed
According to collection, sales slip data set include the sales slip amount of money, the sales slip amount of tax to be paid, containing tax mark and limit of making out an invoice,
Sales slip detailed data collection includes that multiple commodity detail row, each commodity detail row include trade name, list
Valency, quantity, the amount of money, the amount of tax to be paid and the tax rate.Such as, acquisition module 21 can " opening according to sales slip
Ticket mark ", the sales slip tables of data of enterprise operation system is searched the sales slip not issued invoice main
Data, form sales slip data set and sales slip detailed data collection, and such as, acquisition module 21 can be adopted
Sales slip data set, exemplary SQL language is obtained with SQL statement or other computer program statements
Sentence form is: " SELECT sells odd numbers, the sales slip amount of money, the sales slip amount of tax to be paid, containing tax mark, opens
Ticket limit FROM sales slip tables of data WHERE is made out an invoice mark=' not making out an invoice ' ", and obtain
Sales slip detailed data collection, exemplary SQL statement form is: " SELECT sequence number, trade name,
Unit price, quantity, the amount of money, the tax rate, amount of tax to be paid FROM sales slip commodity detailed data table WHERE sells
Sell odd numbers=' present sales odd numbers ' ".
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 same commodity detail row, whether verify the amount of money sum in all commodity detail row
Equal to the sales slip amount of money, and whether the amount of tax to be paid sum verified in all commodity detail row is equal to sales slip tax
Volume.The operation of sales slip data check module 22 is similar to step S2 in above-mentioned the method according to the invention
Operation, here is omitted.
Invoice data computing module 23, for according to containing the unit price in tax mark, each commodity detail row,
Quantity and the tax rate calculate and add valency tax total, invoice amount, the invoice amount of tax to be paid in each commodity detail row
With invoice unit price, and the valency tax of all commodity detail row that adds up respectively adds up to, invoice amount and the invoice amount of tax to be paid
To concentrate at sales slip detailed data, the detailed total valency tax of interpolation adds up to, detail adds up to invoice amount and detail
Add up to the invoice amount of tax to be paid.Wherein, represent containing tax (such as, representing containing tax with letter Y) at the mark containing tax
In the case of (namely the unit price in commodity detail row is containing duty receipt valency), invoice data computing module 23 uses
Valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of the below equation each commodity detail row of calculating:
Valency tax total=unit price * quantity;
Invoice amount=valency tax adds up to/(the 1+ tax rate);
The invoice amount of tax to be paid=valency tax total-invoice amount;
Invoice unit price=unit price/(the 1+ tax rate);
In the case of the mark containing tax represents without tax (such as, representing containing tax with letter N) (namely business
Unit price in product detail row is free from duty receipt valency), invoice data computing module 23 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.
Amount of tax to be paid error estimator module 24 for verify the amount of tax to be paid and the invoice amount of tax to be paid in each commodity detail row it
Whether the absolute value of difference is less than the first predetermined value.Such as, amount of tax to be paid error estimator module 24 can be from sale
The first bar commodity detail that single detailed data is concentrated walks to end bar commodity detail row circulation and calculates each one by one
The amount of tax to be paid error of commodity detail row, formula is: the amount of tax to be paid error=amount of tax to be paid-invoice amount of tax to be paid, if | the amount of tax to be paid
Error | > the first predetermined value, then the range of error beyond regulation can not be made out an invoice, and " line number is ' current in prompting
Line number ' the commodity detail amount of tax to be paid surpass error, it is impossible to make out an invoice " after, terminate algorithm flow, if | the amount of tax to be paid is by mistake
Difference | < the first predetermined value, then sales slip detailed data is split by prompting fractionation module 25.Preferably,
First predetermined value is the 0.06 of revenue department's regulation, certainly selects the value less than 0.06 as the first predetermined value
Also it is feasible.
Split module 25, for after amount of tax to be paid error estimator module 24 completes described verification, according to opening
Predetermined commodity detail line number in ticket limit and VAT invoice, splits into many by sales slip detailed data collection
Individual ticket data collection to be developed.That is, the detailed of each ticket data collection to be developed finally given adds up to invoice
The amount of money can not be more than making out an invoice limit, and its commodity detail line number not can exceed that the predetermined commodity on VAT invoice
Detailed line number.
After splitting module 25 and splitting, the ticket data collection each to be developed generated is exactly one
The key data of ticket to be developed, by drawing a bill in these key datas and sales slip, other data needed are wanted
Element can form complete invoice data after merging, and the invoice data that this is complete is sent to tax-supervise system and carries
The interface of confession just can complete opening of invoice.
Preferably, the sales slip data set acquired in acquisition module 21 can also include inventory mark and
Chinese character anti-false logo, Chinese character anti-false logo defines that the predetermined commodity on VAT invoice are detailed
Line number.Then: in the case of (1) represents the VAT invoice opening band inventory at inventory mark, the amount of tax to be paid is by mistake
The amount of tax to be paid sum that difference correction verification module 24 is additionally operable to verify in all commodity detail row adds up to invoice tax with detailed
Whether the absolute value of the difference of volume is less than the second predetermined value, namely verification | and the detailed total invoice amount of tax to be paid is bright
Carefully add up to the amount of tax to be paid | whether less than the second predetermined value, if less than, prompting splits module 25 and splits, if
It is more than, then, after pointing out such as " the sales slip amount of tax to be paid surpasses error, it is impossible to make out an invoice ", terminates algorithm flow.Excellent
Selection of land, the second predetermined value is the 1.27 of revenue department's regulation, certainly, selects the value less than 1.27 as the
Two predetermined values are also feasible.And, split module 25 and be additionally operable to according to limit of making out an invoice sales slip is bright
Thin data set splits into multiple ticket data collection to be developed, the detailed total of the most each ticket data collection to be developed
Invoice amount is less than or equal to making out an invoice limit.(2) represent that opening the value-added tax without inventory sends out at inventory mark
In the case of ticket, amount of tax to be paid error estimator module 24 need not verify | and detailed total invoice amount of tax to be paid detail adds up to
The amount of tax to be paid | whether less than the second predetermined value, split module 25 then for according to limit and the Chinese character anti-false enterprise of making out an invoice
Sales slip detailed data collection is split into multiple ticket data collection to be developed, the most each ticket to be developed by industry mark
The detailed of data set adds up to invoice amount less than or equal to making out an invoice limit and the business of each ticket data collection to be developed
The predetermined commodity detail line number that product detail line number is not more than on VAT invoice.Here, module 25 is split
This performed operation can be similar to the splitting step institute described in above-mentioned the method according to the invention
The operation performed, here is omitted.
Preferably, in each commodity detail row of the sales slip detailed data collection acquired in acquisition module 21
Can also include by discount mark and discount ratio, and the sales slip amount of money is the amount of money after discount, 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, often
The amount of tax to be paid in individual commodity detail row is the amount of tax to be paid calculated according to the amount of money before discount.In this case, sell
Forms data correction verification module 22 is additionally operable to: utilize after discount amount of money * (1-discount ratio) before the amount of money=discount
After calculating the discount of the commodity detail row comprising discount commodity the amount of money and after verifying this discount the amount of money with not
Whether 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 enterprise, sales slip data check module 22 needs elder generation
After calculating the discount of this commodity detail row, the amount of money adds up the most again.Sales slip data check module 22
The amount of tax to be paid verify the amount of tax to be paid after this discount after being additionally operable to calculate the discount of the commodity detail row comprising discount commodity
With the amount of tax to be paid sum in other commodity detail row not comprising discount commodity whether equal to the sales slip amount of tax to be paid.Folding
After button, the amount of tax to be paid can calculate according to the amount of money after discount and the mark Han tax.Namely sales slip data check module
22 are also required to when verifying the amount of tax to be paid consider discounting situation.Invoice data computing module 23 is additionally operable to
Before calculating valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of each commodity detail row,
Rearrange each commodity detail row according to discount ratio and the tax rate, calculate and there is identical discount ratio and phase
With total line number of commodity detail row of the tax rate, total discount amount and total discount amount of tax to be paid, and there is identical folding
A discount is inserted after last column commodity detail row of the commodity detail row of button ratio and same tax rate
OK, the trade name of this discount row embodies to have the commodity of identical discount ratio and same tax rate detailed
Total line number of row and discount ratio, the amount of money of this discount row is total discount amount * (-1), this discount row
The amount of tax to be paid be total discount amount of tax to be paid * (-1), wherein total discount amount of tax to be paid can be according to containing tax mark, by aforementioned
Invoice computation of tax amount formula calculate.Operation performed by invoice data computing module 23 can be similar to
In exist by discount mark and discount ratio the two data item time abovementioned steps S3 described in behaviour
Making, here is omitted.And, after splitting module 25 and completing described fractionation, at inventory mark
Represent that in the case of opening without the VAT invoice of inventory, invoice data computing module 23 is additionally operable to:
If ticket data to be developed is concentrated has identical discount ratio and a line of same tax rate or multirow commodity detail
Do not have discount row then after this last column commodity detail row after last column commodity detail row of row
Inserting a discount row, if there is discount row after this last column commodity detail row, updating 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.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 according to being somebody's turn to do
The data item such as the amount of money on invoice that ticket data collection to be developed is opened, the amount of tax to be paid and institute in the sales slip of enterprise
The situation that the data item calculated there are differences, improves the Financial Control Level of enterprise.Insert and update folding
Button 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 25
After row splits, discount data can not be reprocessed by invoice data computing module 23.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 23 can also carry out operation similar to the above to discount data,
I.e. insert and update discount row and update detailed total valency tax total, the detailed conjunction that ticket data to be developed is concentrated
Meter invoice amount and the detailed total invoice amount of tax to be paid.
The preferred embodiment of the present invention is described in detail above in association with accompanying drawing, but, the present invention does not limit
Detail in above-mentioned embodiment, in the technology concept of the present invention, can be to the present invention
Technical scheme carry out multiple simple variant, these simple variant belong to protection scope of the present invention.
Additionally, combination in any can also be carried out between the various different embodiment of the present invention, as long as its
Without prejudice to the thought of the present invention, it should be considered as content disclosed in this invention equally.
Claims (8)
1. the method opening many tax rates VAT invoice for the sales slip containing the amount of tax to be paid, the method includes:
Step S1, the sales slip data set obtaining ticket to be developed and sales slip detailed data collection, described pin
Sell forms data collection include the sales slip amount of money, the sales slip amount of tax to be paid, containing tax mark and limit of making out an invoice, described sale
Single detailed data collection include multiple commodity detail row, each commodity detail row include trade name, unit price,
Quantity, the amount of money, the amount of tax to be paid and the tax rate;
Step S2, whether verify in each described commodity detail row unit price and the product of quantity equal to same
Whether the amount of money in commodity detail row, verify the amount of money sum in all described commodity detail row equal to described
The sales slip amount of money, and whether the amount of tax to be paid sum verified in all described commodity detail row is equal to described sales slip
The amount of tax to be paid;
Step S3, according to described unit price containing tax mark, in each described commodity detail row, quantity and
The tax rate calculate and in each described commodity detail row add valency tax total, invoice amount, the invoice amount of tax to be paid and
Invoice unit price, and valency tax total, invoice amount and the invoice tax of all described commodity detail row that adds up respectively
To concentrate at described sales slip detailed data, the detailed total valency tax of interpolation adds up to volume, detail adds up to invoice amount
The invoice amount of tax to be paid is added up to detail;
Step S4, the described amount of tax to be paid verified in each described commodity detail row and the difference of the described invoice amount of tax to be paid
Absolute value whether less than the first predetermined value;And
Step S5, according to described in make out an invoice the predetermined commodity detail line number on limit and described VAT invoice,
Described sales slip detailed data collection is split into multiple ticket data collection to be developed.
Method the most according to claim 1, wherein, in step s3,
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, then:
Represent that at described inventory mark in the case of opening the VAT invoice of band inventory, step S4 is also wrapped
Include the amount of tax to be paid sum and the described detailed difference adding up to the invoice amount of tax to be paid verified in all described commodity detail row
Absolute value whether less than the second predetermined value, and step S5 include according to described in make out an invoice limit by described
Sales slip detailed data collection splits into multiple ticket data collection to be developed, the most each described ticket data to be developed
Collection detailed add up to invoice amount be less than or equal to described in make out an invoice limit;
In the case of described inventory mark represents and opens without the VAT invoice of inventory, step S5 bag
Include: described sales slip detailed data collection is torn open by limit of making out an invoice described in Yi Ju and described Chinese character anti-false logo
Being divided into multiple ticket data collection to be developed, the detailed of the most each described ticket data collection to be developed adds up to invoice gold
Volume be less than or equal to described in the make out an invoice commodity detail line number of limit and each described ticket data collection to be developed little
Predetermined commodity detail line number on described VAT invoice.
Method the most according to claim 3, wherein, also includes in each described commodity detail row
By discount mark and discount ratio, and the described sales slip amount of money is the amount of money after discount, and each described commodity are bright
The amount of money in thin row is the amount of money before discount, then:
In step 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, and calculates bag
After the discount of the commodity detail row containing discount commodity the amount of tax to be paid and after verifying this discount the amount of tax to be paid with do not comprise discount
Whether the amount of tax to be paid sum in other commodity detail row of commodity is equal to the described sales slip amount of tax to be paid;
In step s3, calculating the valency tax total of each described commodity detail row, invoice amount, sending out
Before the ticket amount of tax to be paid and invoice unit price, rearrange described in each always according to described discount ratio and the described tax rate
Commodity detail row, calculates total line number of the commodity detail row with identical discount ratio and same tax rate, total
Discount amount and total discount amount of tax to be paid, and there is the commodity detail row of identical discount ratio and same tax rate
Insert a discount row after last column commodity detail row, the trade name of this discount row embodies tool
There are total line number and the discount ratio of the commodity detail row of identical discount ratio and same tax rate, this discount row
The amount of money be described total discount amount * (-1), the amount of tax to be paid of this discount row is described total discount amount of tax to be paid * (-1);
And
In step s 5, represent, at described inventory mark, the situation of the VAT invoice without inventory opened
Under, there is identical discount ratio and a line of same tax rate if described ticket data to be developed is concentrated or do business more
Do not have discount row then detailed at these last column commodity after last column commodity detail row of product detail row
A discount row is inserted, if there is discount row, more after described last column commodity detail row after row
This discount row new, and update detailed total valency tax total, the detailed total that this ticket data to be developed is concentrated
Invoice amount and the detailed total invoice amount of tax to be paid.
5. open a system for many tax rates VAT invoice for the sales slip containing the amount of tax to be paid, this system includes:
Acquisition module, for obtaining sales slip data set and sales slip detailed data collection, the institute of ticket to be developed
State sales slip data set include the sales slip amount of money, the sales slip amount of tax to be paid, 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, list
Valency, quantity, the amount of money, the amount of tax to be paid and the tax rate;
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 same commodity detail row, verify the amount of money in all described commodity detail row it
Whether equal to the described sales slip amount of money, and whether the amount of tax to be paid sum verified in all described commodity detail row
Equal to the described sales slip amount of tax to be paid;
Invoice data computing module, for according to described containing tax mark, in each described commodity detail row
Unit price, quantity and the tax rate calculate and add in each described commodity detail row valency tax total, invoice amount,
The invoice amount of tax to be paid and invoice unit price, and the valency tax of all described commodity detail row that adds up respectively adds up to, invoice gold
The detailed total valency tax of interpolation adds up to, detail is closed to concentrate at described sales slip detailed data for volume and the invoice amount of tax to be paid
Meter invoice amount and the detailed total invoice amount of tax to be paid;
Amount of tax to be paid error estimator module, for verifying the described amount of tax to be paid in each described commodity detail row with described
Whether the absolute value of the difference of the invoice amount of tax to be paid is less than the first predetermined value;And
Split module, for after described amount of tax to be paid error estimator module completes described verification, according to described
Predetermined commodity detail line number in limit of making out an invoice and described VAT invoice, by described sales slip detailed data
Collection splits into multiple ticket data collection to be developed.
System the most according to claim 5, wherein, described invoice data computing module is used for:
In the case of the described mark containing tax represents containing tax, below equation is used to calculate each described commodity bright
Valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of thin row:
Valency tax total=unit price * quantity;
Invoice amount=valency tax adds up to/(the 1+ tax rate);
The invoice amount of tax to be paid=valency tax total-invoice amount;
Invoice unit price=unit price/(the 1+ tax rate);
In the case of the described mark containing tax represents without tax, below equation is used to calculate each described commodity
Valency tax total, invoice amount, the invoice amount of tax to be paid and the invoice unit price of detailed row:
Invoice amount=unit price * quantity;
The invoice amount of tax to be paid=invoice amount * tax rate;
Valency tax total=invoice amount+invoice amount of tax to be paid.
System the most according to claim 5, wherein, described sales slip data set also includes inventory
Mark and Chinese character anti-false logo, described Chinese character anti-false logo defines on described VAT invoice
Predetermined commodity detail line number, then:
Represent in the case of opening the VAT invoice of band inventory at described inventory mark, described amount of tax to be paid error
The amount of tax to be paid sum that correction verification module is additionally operable to verify in all described commodity detail row was sent out with described detailed total
Whether the absolute value of the difference of the ticket amount of tax to be paid is less than the second predetermined value, and described fractionation module is for according to institute
State limit of making out an invoice and described sales slip detailed data collection is split into multiple ticket data collection to be developed, the most each
Described ticket data collection to be developed detailed add up to invoice amount be less than or equal to described in make out an invoice limit;
In the case of described inventory mark represents and opens without the VAT invoice of inventory, described fractionation mould
Block for according to described in make out an invoice limit and described Chinese character anti-false logo by described sales slip detailed data
Collection splits into multiple ticket data collection to be developed, and detailed total of the most each described ticket data collection to be developed is sent out
The ticket amount of money is made out an invoice limit and the commodity detail line number of each described ticket data collection to be developed described in being less than or equal to
It is not more than the predetermined commodity detail line number on described VAT invoice.
System the most according to claim 7, wherein, also includes in each described commodity detail row
By discount mark and discount ratio, and the described sales slip amount of money is the amount of money after discount, and each described commodity are bright
The amount of money in thin row is the amount of money before discount, 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, and calculate the amount of tax to be paid verify tax after this discount after the discount of the commodity detail row comprising discount commodity
Whether volume and the amount of tax to be paid sum not comprised in other commodity detail row of discount commodity be equal to described sales slip
The amount of tax to be paid,
Described invoice data computing module be additionally operable to calculate each described commodity detail row valency tax add up to,
Before invoice amount, the invoice amount of tax to be paid and invoice unit price, again arrange according to described discount ratio and the described tax rate
Arranging each described commodity detail row, calculating has the commodity detail row of identical discount ratio and same tax rate
Total line number, total discount amount and total discount amount of tax to be paid, and there is identical discount ratio and the business of same tax rate
A discount row, the trade name of this discount row is inserted after last column commodity detail row of product detail row
In embody total line number and the discount rate of the commodity detail row with identical discount ratio and same tax rate
Example, the amount of money of this discount row is described total discount amount * (-1), and the amount of tax to be paid of this discount row is described total folding
Button amount of tax to be paid * (-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.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510232312.XA CN106204176A (en) | 2015-05-08 | 2015-05-08 | The method and system of many tax rates 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 |
---|---|---|---|
CN201510232312.XA CN106204176A (en) | 2015-05-08 | 2015-05-08 | The method and system of many tax rates VAT invoice is opened for the sales slip containing the amount of tax to be paid |
Publications (1)
Publication Number | Publication Date |
---|---|
CN106204176A true CN106204176A (en) | 2016-12-07 |
Family
ID=57459132
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510232312.XA Pending CN106204176A (en) | 2015-05-08 | 2015-05-08 | The method and system of many tax rates VAT invoice is opened for the sales slip containing the amount of tax to be paid |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106204176A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111144958A (en) * | 2018-11-06 | 2020-05-12 | 航天信息股份有限公司 | Block chain-based electronic invoice issuing method, device and system |
-
2015
- 2015-05-08 CN CN201510232312.XA patent/CN106204176A/en active Pending
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111144958A (en) * | 2018-11-06 | 2020-05-12 | 航天信息股份有限公司 | Block chain-based electronic invoice issuing method, device and system |
CN111144958B (en) * | 2018-11-06 | 2023-07-14 | 航天信息股份有限公司 | Electronic invoice issuing method, device and system based on block chain |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106204175A (en) | For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip | |
CN106204171A (en) | The method and system of single tax rate VAT invoice is opened for the sales slip containing the amount of tax to be paid | |
US20140244416A1 (en) | Method and system to facilitate the addition of items to an electronic item catalog | |
CN104574157A (en) | Method for achieving intelligent matching of medical instrument B2B website orders | |
CN105184600A (en) | Rule and operation-based electronic business platform price engine implementing method | |
CN102663594A (en) | Electronic commerce catalog distribution system | |
CN110990403A (en) | Business data storage method, system, computer equipment and storage medium | |
CN101183454A (en) | Method and system for managing commodity price on electronic commerce exchange platform | |
Marconi et al. | AutomatedWeb Service Composition at Work: the Amazon/MPS Case Study. | |
CN105894179B (en) | Service state transfer method and system based on dynamic programming | |
CN110225076A (en) | File interaction method, apparatus, electronic equipment and storage medium | |
CN117709326A (en) | E-commerce commodity customs reporting method and system | |
CN106204177A (en) | For opening the method and system of single tax rate VAT invoice without amount of tax to be paid sales slip | |
CN106204176A (en) | The method and system of many tax rates VAT invoice is opened for the sales slip containing the amount of tax to be paid | |
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 | |
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 | |
CN111931475A (en) | Dynamic subscription book generation method, system, computer equipment and storage medium | |
CN102456029A (en) | Data processing method and computer | |
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 | |
CN116090888A (en) | Decision engine configuration management method, device, electronic equipment and program product | |
JP2019102034A (en) | Determination program, determination apparatus and determination method | |
CN112734543A (en) | Accounting processing method and device, computer equipment and storage medium | |
US20080021758A1 (en) | Responsibility determination | |
WO2020173148A1 (en) | Method and system for automatically generating order, and storage medium |
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 |