CN106875236A - Tax control counting system and the method using the tax control counting system statistics commodity data - Google Patents
Tax control counting system and the method using the tax control counting system statistics commodity data Download PDFInfo
- Publication number
- CN106875236A CN106875236A CN201510919019.0A CN201510919019A CN106875236A CN 106875236 A CN106875236 A CN 106875236A CN 201510919019 A CN201510919019 A CN 201510919019A CN 106875236 A CN106875236 A CN 106875236A
- Authority
- CN
- China
- Prior art keywords
- invoice
- tax
- amount
- discount
- row
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/04—Billing or invoicing
Landscapes
- Business, Economics & Management (AREA)
- Development Economics (AREA)
- Accounting & Taxation (AREA)
- Economics (AREA)
- Finance (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Cash Registers Or Receiving Machines (AREA)
Abstract
The present invention relates to electronic invoice technical field, a kind of tax control counting system and the method using its statistics commodity data are disclosed.The tax control counting system includes：Acquisition module, it obtains invoice body data from sales invoice table, and correspondingly invoice commodity detailed data is obtained from sales invoice detail list or pin item inventory detail list according to the inventory mark in invoice body data；Discount processing module, it is when acquired invoice commodity detailed data includes discount row and is designated without tax containing tax, according to the trade name of discount row determine the line number N of discount commodity, the N before the amount of money and the amount of tax to be paid in discount row are divided into discount row respectively do business product detail row the amount of money and the amount of tax to be paid in；And statistical module, for counting commodity data according to the invoice commodity detailed data after discount treatment.It disclosure satisfy that the demand that diversified query statistic is carried out to the split ticket broker's product of an enterprise of making out an invoice more of the typing in tax control counting system without tax invoice data.
Description
Technical field
The present invention relates to electronic invoice technical field, in particular it relates to a kind of tax control counting system and be opened using the tax control
The method that bill system counts commodity data.
Background technology
At present, the VAT invoice tax control counting system that the State Tax Administration supervises is provided for national general taxpayer enterprise
The management function of VAT invoice, including invoice data typing, invoice issuing, invoice inquiry, sends a duplicate to the functions such as tax.Although tax
Control billing system provides complete invoice workflow management, and function is succinct and meets the regulatory requirement of the tax, but the tax
Controlling the invoice query function of billing system cannot meet the diversified query statistic demand of enterprise.
The content of the invention
It is an object of the invention to provide a kind of tax control counting system and using the tax control counting system statistics commodity data
Method, it disclosure satisfy that is carried out to the split ticket broker's product of an enterprise of making out an invoice more of the typing in tax control counting system without tax invoice data
The demand of diversified query statistic.
To achieve these goals, the present invention provides a kind of tax control counting system, and the tax control counting system includes pin hair
Ticket table, sales invoice detail list and pin item inventory detail list, it is characterised in that the tax control counting system includes：Acquisition module, uses
At least include the invoice master of invoice codes, invoice number, inventory mark and billing machine number in being obtained from the sales invoice table
Volume data, and correspondingly obtain bag from the sales invoice detail list or pin item inventory detail list according to inventory mark
The invoice commodity detailed data of at least one commodity detail row is included, each described commodity detail row at least includes trade name, number
Amount, unit price, the amount of money, the amount of tax to be paid, the tax rate and containing tax mark；Discount processing module, in acquired invoice commodity detailed data
Including discount row and it is described be designated without tax containing tax in the case of, determine discount business according to the trade name of the discount row
The line number N of product, and N before the amount of money and the amount of tax to be paid in the discount row are divided into the discount row respectively does business the gold of product detail row
In volume and the amount of tax to be paid；And statistical module, for counting commodity data according to the invoice commodity detailed data after discount treatment.
The present invention also provides a kind of method of utilization tax control counting system statistics commodity data, and the tax control counting system includes
Sales invoice table, sales invoice detail list and pin item inventory detail list, it is characterised in that the method includes：Sent out from the pin
Being obtained in ticket table at least includes the invoice body data of invoice codes, invoice number, inventory mark and billing machine number；According to described
Inventory mark is correspondingly obtained from the sales invoice detail list or pin item inventory detail list includes that at least one commodity are detailed
Capable invoice commodity detailed data, each described commodity detail row at least include trade name, quantity, unit price, the amount of money, the amount of tax to be paid,
The tax rate and containing tax mark；Include discount row in acquired invoice commodity detailed data and described be designated the feelings without tax containing tax
Under condition, the line number N of discount commodity is determined according to the trade name of the discount row, and by the amount of money and the amount of tax to be paid in the discount row
N before dividing the discount row respectively do business product detail row the amount of money and the amount of tax to be paid in；And according to the invoice after discount treatment
Commodity detailed datas counts commodity data
By above-mentioned technical proposal, because tax control counting system and method for the invention can be from sales invoice table
Obtain invoice body data, correspondingly obtain invoice from sales invoice detail list or pin item inventory detail list according to inventory mark
Commodity detailed data, and discount treatment is carried out to invoice commodity detailed data, therefore it can be provided by force for tax control counting system
The data analysis function in large and complete face, realizes flexible, the accurate query statistic of commodity, for Enterprises ' Financial Workers provide tax information
Change solution, improve the accuracy rate of operating efficiency and the commodity data statistics of financial staff, reduce the workload of artificial nucleus couple,
Enterprise finance tax administration efficiency and do tax efficiency.
Other features and advantages of the present invention will be described in detail in subsequent specific embodiment part.
Brief description of the drawings
Accompanying drawing is, for providing a further understanding of the present invention, and to constitute the part of specification, with following tool
Body implementation method is used to explain the present invention together, but is not construed as limiting the invention.In the accompanying drawings：
Fig. 1 is the block diagram of the tax control counting system according to one embodiment of the present invention；And
Fig. 2 is the flow of the method for the utilization tax control counting system statistics commodity data according to one embodiment of the present invention
Figure.
Specific embodiment
Specific embodiment of the invention is described in detail below in conjunction with accompanying drawing.It should be appreciated that this place is retouched
The specific embodiment stated is merely to illustrate and explain the present invention, and is not intended to limit the invention.
Generally, the quantity made out an invoice a little that can be set up according to enterprise and enterprise is divided into and singly make out an invoice an enterprise and make out an invoice more
Point enterprise, so, in tax control counting system, the difference of " billing machine number " field in meeting basis " sales invoice table ", and incite somebody to action
The invoice data storage that each billing machine number is issued is different database physical file.The operation further, since enterprise makes out an invoice
The difference of custom, physical aspect, the mode containing tax of invoice data stored in tax control counting system etc. would also vary from, example
Such as, if enterprise is got used to typing volume containing tax in tax control counting system, the invoice amount stored in tax control counting system is
Containing tax, if enterprise is got used to typing in tax control counting system without tax volume, the invoice stored in tax control counting system
The amount of money is free from tax, and this is indicated by mark containing tax.Tax control counting system and method for the invention are applied to be opened more
Piao Dian enterprises are to situation of the typing in tax control counting system without tax volume.
The present invention provides a kind of tax control counting system, and the tax control counting system includes that sales invoice table, sales invoice are detailed
Table and pin inventory detail list, as shown in figure 1, the tax control counting system also includes acquisition module 1, discount processing module 2 and system
Meter module 3, describes in detail to this below.
Acquisition module 1 is used to be obtained from the sales invoice table at least includes invoice codes, invoice number, inventory mark
With the invoice body data of billing machine number, and according to the inventory mark correspondingly from the sales invoice detail list or pin item
Being obtained in inventory detail list includes the invoice commodity detailed data of at least one commodity detail row, and each described commodity detail row is extremely
Include trade name, quantity, unit price, the amount of money, the amount of tax to be paid, the tax rate less and identified containing tax.
Preferably, the invoice body data can also include it is following at least one：(1) in purchaser's title and purchaser's duty paragraph
One of or both；(2) invoice type；(3) invoice amount；And (4) invoice amount of tax to be paid.
Preferably, the invoice commodity detailed data can also include at least one of specifications and models, measurement unit.
In addition, acquisition module 1 can obtain invoice body data using SQL statement or other sentences.Exemplary SQL
Sentence can be：" SELECT invoice types, invoice codes, invoice number, purchaser's title, purchaser's duty paragraph, inventory mark, invoice
The amount of money, invoice amount of tax to be paid FROM sales invoice table WHERE inventory mark=' false ' AND billing machines number=' billing machine X ' ".This
Invoice body data for obtaining non-inventory invoice.A kind of exemplary such invoice body data is shown in table 1.
Table 1
Obtaining the another exemplary SQL statement form of invoice body data can be：" SELECT invoice types, invoice generation
Code, invoice number, purchaser's title, purchaser's duty paragraph, inventory mark, invoice amount, WHERE is clear for invoice amount of tax to be paid FROM sales invoice tables
Single mark=' true ' AND billing machines number=' billing machine X ' ".This is used to obtain the invoice body data of inventory invoice.Table 2
In show a kind of exemplary such invoice body data.
Table 2
Further, acquisition module 1 can obtain invoice commodity detailed data using SQL statement or other sentences.Show
Example property SQL statement can be：" SELECT trade names, specifications and models, measurement unit, quantity, unit price, the amount of money, the amount of tax to be paid, tax
Rate FROM sales invoice detail list WHERE invoice codes=* * * * * * and invoice numbers=* * * * * * and containing tax mark=
‘false’”.In tax control counting system, according to the difference of " inventory mark ", can be by without the invoice commodity detailed data of inventory
It is stored in " sales invoice detail list " and is stored in " pin item inventory detail list " the invoice commodity detailed data with inventory
In.SQL statement above is exactly to obtain invoice commodity in the case that invoice data is without inventory from sales invoice detail list
The example of detailed data.Table 3 shows the example of the invoice commodity detailed data obtained from sales invoice detail list.
Table 3
Obtaining the another exemplary SQL statement form of invoice commodity detailed data can be：" SELECT trade names, rule
Lattice number, measurement unit, quantity, unit price, the amount of money, the amount of tax to be paid, tax rate FROM pin item inventory detail list WHERE invoice codes
=* * * * * * and invoice numbers=* * * * * * and are containing tax mark=' false ' ".The SQL statement is in invoice data band inventory
In the case of the example of invoice commodity detailed data is obtained from pin inventory detail list.Table 4 shows detailed from pin inventory
The example of the invoice commodity detailed data obtained in table.
| Sequence number | Trade name | Specifications and models | Measurement unit | Quantity | Unit price | The amount of money | The amount of tax to be paid | The tax rate | Containing tax mark |
| 1 | Printer | 1 | 1000.00 | 1000.00 | 170 | 17% | false | ||
| 2 | Washing machine | 2 | 750.00 | 1500.00 | 255 | 17% | false | ||
| 3 | Computer | Y | 2 | 300.00 | 600.00 | 102 | 17% | false | |
| 4 | Notebook | Y | 1 | 400.00 | 400.00 | 68 | 17% | false | |
| 5 | Band accessory | 2 | 700.00 | 1400.00 | 238 | 17% | false | ||
| 6 | CPU | 4 | 400.00 | 1600.00 | 272 | 17% | false | ||
| 7 | Fan | Y | 13 | 400.00 | 5200.00 | 884 | 17% | false | |
| 8 | The type of printer 500 | Y | 3 | 600.00 | 1800.00 | 306 | 17% | false | |
| 9 | Discount line number 2 (10%) | -700.00 | -119 | 17% | false |
Table 4
The field in SQL statement example is given above, for example, obtains invoice type, the invoice generation during invoice body data
The fields such as code, invoice number, purchaser's title, purchaser's duty paragraph, inventory mark, invoice amount, the invoice amount of tax to be paid and acquisition invoice business
The fields such as trade name, specifications and models, measurement unit, quantity, unit price, the amount of money, the amount of tax to be paid, the tax rate during product detailed data, be not
Must all be chosen, in fact, these fields can be according to needing the commodity data of statistics to be selected, such as if desired
Statistics commodity amount, then only need to selection trade name and quantity the two fields i.e. when invoice commodity detailed data is obtained
Can.
After acquisition module 1 obtains invoice body data and invoice commodity detailed data, discount processing module 2 can
For including discount row in acquired invoice commodity detailed data and described being designated without tax (for example, mark containing tax containing tax
It is false to know) in the case of, determine the line number N of discount commodity according to the trade name of the discount row, and by the discount row
In the amount of money and the amount of tax to be paid divide the discount row respectively before N do business product detail row the amount of money and the amount of tax to be paid in.It is mentioned here
Discount row is independently of the specialty goods detail row beyond real goods detail row.It is directed in due to being counted in commodity data true
Real commodity are counted, namely statistics when be directed to real goods detail row carry out query statistic, discount row is not united
Meter, so in order to obtain really and accurately commodity statistics data, it is necessary to the data of discount row are divided into corresponding real goods
On detailed row.
Generally, in tax control counting system, if only including a line discount row, discount row in invoice commodity detailed data
Trade name field form be " discount (XX.XXX%) "；If including multirow discount row in invoice commodity detailed data,
Then the form of the trade name field of discount row is " discount line number N (XX.XXX%) ".Discount processing module 2 is namely based on this
Determine the line number of the discount commodity in invoice commodity detailed data.
After the line number that discount processing module 2 determines discount commodity, discount processing module 2 can be carried out following folding
Buckle is managed：
(1) in the case where acquired invoice commodity detailed data includes a line discount row, the discount processing module 2
Divided using below equation：
Divide the rear amount of money=divide the preceding amount of money+discount row amount of money
Divide the rear amount of tax to be paid=divide the preceding amount of tax to be paid+discount row amount of tax to be paid
It is univalent after dividing=to divide the rear amount of money/quantity
Table 5 and table 6 sets forth the invoice commodity detailed data after discount before processing in such cases and discount treatment
Example.
| Sequence number | Trade name | Specifications and models | Measurement unit | Quantity | Unit price | The amount of money | The amount of tax to be paid | The tax rate | Containing tax mark |
| 1 | Printer | 1 | 1000.00 | 1000.00 | 170 | 17% | false | ||
| 2 | Discount (10%) | -100.00 | -17 | 17% | false |
Table 5
| Sequence number | Trade name | Specifications and models | Measurement unit | Quantity | Unit price | The amount of money | The amount of tax to be paid | The tax rate | Containing tax mark |
| 1 | Printer | 1 | 900.00 | 900.00 | 153 | 17% | false |
Table 6
(2) include multirow discount row in acquired invoice commodity detailed data (such as N rows, N is the integer more than 1)
In the case of, the discount processing module 2 is divided using below equation：
The do business discounts of product detail row of 1 to N-1 before discount row divide computing formula and are：
Divide the rear amount of money=divide preceding amount of money * (1- discount rates)
Divide the rear amount of tax to be paid=divide preceding amount of tax to be paid * (1- discount rates)
It is univalent after dividing=to divide the rear amount of money/quantity
The discount of the Nth row commodity detail row before discount row divides computing formula and is：
It is univalent after dividing=to divide the rear amount of money/quantity
Table 7 and table 8 sets forth the invoice commodity detailed data after discount before processing in such cases and discount treatment
Example.
| Sequence number | Trade name | Specifications and models | Measurement unit | Quantity | Unit price | The amount of money | The amount of tax to be paid | The tax rate | Containing tax mark |
| 1 | Printer | 1 | 1000.00 | 1000.00 | 170 | 17% | false | ||
| 2 | Computer | 1 | 1000.00 | 1000.00 | 170 | 17% | false | ||
| 3 | Notebook | 1 | 1000.00 | 1000.00 | 170 | 17% | false | ||
| 4 | Discount line number 3 (10%) | -300.00 | -51 | 17% | false |
Table 7
| Sequence number | Trade name | Specifications and models | Measurement unit | Quantity | Unit price | The amount of money | The amount of tax to be paid | The tax rate | Containing tax mark |
| 1 | Printer | 1 | 900.00 | 900.00 | 153 | 17% | false | ||
| 2 | Computer | 1 | 900.00 | 900.00 | 153 | 17% | false | ||
| 3 | Notebook | 1 | 900.00 | 900.00 | 153 | 17% | false |
Table 8
After discount processing module 2 carries out discount treatment, statistical module 3 just can be according to the invoice business after discount treatment
Product detailed datas counts commodity data.Common invoice commodity data statistics has goods amount, the amount of tax to be paid, valency tax to add up to, commodity
Quantity etc..For example, statistical module 3 can count consumption sum using SQL statement or other sentences by trade name, it is exemplary
SQL statement be：" SELECT trade name AS trade names, 1.0*SUM (amount of money) AS Amounts in Total, 1.0*SUM (amount of tax to be paid) AS
Total amount of tax to be paid, the total FROM sales invoice detail lists of 1.0*SUM (amount of money+amount of tax to be paid) AS valencys tax, pin item inventory detail list WHERE is opened
Ticket date BETWEEN'YYYY-MM-DD'AND'YYYY-MM-DD'AND invoice numbers BETWEEN'00000000'AND'
99999999'AND billing machines number=" billing machine X " GROUP BY trade names ".It is detailed this makes it possible to count sales invoice
The information such as consumption sum, the amount of tax to be paid of certain commodity being related in table and pin inventory detail list.Need it is clear that, system
Data in the sales invoice detail list and pin inventory detail list that are used during the meter statistics commodity data of module 3 are processed through discount
Data after the treatment of the discount of module 2.Table 9 gives the exemplary merchandise sales amount of money, the amount of tax to be paid and valency tax aggregate statistics result.
| Sequence number | Trade name | Amount in Total | Total amount of tax to be paid | Valency tax adds up to |
| 1 | Commodity 1 | 854.70 | 145.30 | 1000.00 |
| 2 | Commodity 2 | 1282.05 | 217.95 | 1500.00 |
| 3 | Commodity 3 | 1196.58 | 203.42 | 1400.00 |
Table 9
The present invention also provides a kind of method of utilization tax control counting system statistics commodity data, and the tax control counting system includes
Sales invoice table, sales invoice detail list and pin item inventory detail list.As shown in Fig. 2 the method may comprise steps of：
Step S1, to obtain from sales invoice table and at least include invoice codes, invoice number, inventory mark and billing machine number
Invoice body data.
Preferably, the invoice body data can also include it is following at least one：(1) in purchaser's title and purchaser's duty paragraph
One of or both；(2) invoice type；(3) invoice amount；And (4) invoice amount of tax to be paid.
For example, the method for statistics commodity data of the invention can obtain hair using SQL statement or other sentences
Ticket body data.Exemplary SQL statement can be：" SELECT invoice types, invoice codes, invoice number, purchaser's title,
Purchaser's duty paragraph, inventory mark, invoice amount, invoice amount of tax to be paid FROM sales invoice table WHERE inventories mark=' false ' AND is opened
Ticket machine number=' billing machine X ' ".This is used to obtain the invoice body data of non-inventory invoice.Exemplary such invoice main body
Data refer to table 1 above.
Obtaining the another exemplary SQL statement form of invoice body data can be：" SELECT invoice types, invoice generation
Code, invoice number, purchaser's title, purchaser's duty paragraph, inventory mark, invoice amount, WHERE is clear for invoice amount of tax to be paid FROM sales invoice tables
Single mark=' true ' AND billing machines number=' billing machine X ' ".This is used to obtain the invoice body data of inventory invoice.Example
Such invoice body data of property refers to table 2 above.
Step S2, according to the inventory mark correspondingly from the sales invoice detail list or pin item inventory detail list in obtain
The invoice commodity detailed data including at least one commodity detail row is taken, each described commodity detail row at least includes trade name
Title, quantity, unit price, the amount of money, the amount of tax to be paid, the tax rate and containing tax mark.
Preferably, the invoice commodity detailed data can also include at least one of specifications and models, measurement unit.
The method of statistics commodity data of the invention can obtain invoice commodity using SQL statement or other sentences
Detailed data.Exemplary SQL statement can be：" SELECT trade names, specifications and models, measurement unit, quantity, unit price, gold
Volume, the amount of tax to be paid, tax rate FROM sales invoice detail list WHERE invoice codes=* * * * * * and invoice numbers=* * * * * * and contain tax
Mark=' false ' ".In tax control counting system, according to the difference of " inventory mark ", can will be bright without the invoice commodity of inventory
Count evidence accurately and be stored in " sales invoice detail list " and be stored in the invoice commodity detailed data with inventory and " sell item inventory bright
In thin table ".SQL statement above is exactly to obtain invoice from sales invoice detail list in the case that invoice data is without inventory
The example of commodity detailed data.The example of the invoice commodity detailed data obtained from sales invoice detail list is referred to above
Table 3.
Obtaining the another exemplary SQL statement form of invoice commodity detailed data can be：" SELECT trade names, rule
Lattice number, measurement unit, quantity, unit price, the amount of money, the amount of tax to be paid, tax rate FROM pin item inventory detail list WHERE invoice codes
=* * * * * * and invoice numbers=* * * * * * and are containing tax mark=' false ' ".The SQL statement is in invoice data band inventory
In the case of the example of invoice commodity detailed data is obtained from pin inventory detail list.Obtained from pin inventory detail list
The example of invoice commodity detailed data refers to table 4 above.
In addition, the field in the SQL statement example be given in superincumbent step S1 and S2, such as obtain invoice main body number
According to when invoice type, invoice codes, invoice number, purchaser's title, purchaser's duty paragraph, inventory mark, invoice amount, the invoice amount of tax to be paid
Etc. field and obtain invoice commodity detailed data when trade name, specifications and models, measurement unit, quantity, unit price, the amount of money,
The fields such as the amount of tax to be paid, the tax rate, it is not necessary to be all chosen, in fact, these fields can be according to the commodity data for needing statistics
Selected, such as if necessary to statistics commodity amount, then only need to select trade name when invoice commodity detailed data is obtained
Claim and the two fields of quantity.
Step S3, include discount row in acquired invoice commodity detailed data and described be designated without tax (example containing tax
Such as, it is designated false containing tax) in the case of, the line number N of discount commodity is determined according to the trade name of the discount row, and
N before the amount of money and the amount of tax to be paid in the discount row is divided into the discount row respectively do business product detail row the amount of money and the amount of tax to be paid in.
Discount row mentioned here is independently of the specialty goods detail row beyond real goods detail row.Due in commodity
Being directed to real goods in data statistics to be counted, namely be directed to real goods detail row in statistics carries out inquiry system
Meter, does not count, so in order to obtain really and accurately commodity statistics data, it is necessary to the data of discount row are put down to discount row
Spread out on corresponding real goods detail row.
Generally, in tax control counting system, if only including a line discount row, discount row in invoice commodity detailed data
Trade name field form be " discount (XX.XXX%) "；If including multirow discount row in invoice commodity detailed data,
Then the form of the trade name field of discount row is " discount line number N (XX.XXX%) ".This is namely based in step s3 comes true
Determine the line number of the discount commodity in invoice commodity detailed data.
After the line number that discount commodity are determined, the method according to the invention can carry out following discount treatment：
(1) in the case where acquired invoice commodity detailed data includes a line discount row, carried out using below equation
Divide：
Divide the rear amount of money=divide the preceding amount of money+discount row amount of money
Divide the rear amount of tax to be paid=divide the preceding amount of tax to be paid+discount row amount of tax to be paid
It is univalent after dividing=to divide the rear amount of money/quantity
The example of the invoice commodity detailed data after discount before processing and discount are processed in such cases is referred to above
Table 5 and table 6.
(2) include multirow discount row in acquired invoice commodity detailed data (such as N rows, N is the integer more than 1)
In the case of, divided using below equation：
The do business discounts of product detail row of 1 to N-1 before discount row divide computing formula and are：
Divide the rear amount of money=divide preceding amount of money * (1- discount rates)
Divide the rear amount of tax to be paid=divide preceding amount of tax to be paid * (1- discount rates)
It is univalent after dividing=to divide the rear amount of money/quantity
The discount of the Nth row commodity detail row before discount row divides computing formula and is：
It is univalent after dividing=to divide the rear amount of money/quantity
The example of the invoice commodity detailed data after discount before processing and discount are processed in such cases is please respectively referring to upper
The table 7 and table 8 in face.
Step S4, count commodity data according to the invoice commodity detailed data after discount treatment.
Common invoice commodity data statistics has total, commodity amount of goods amount, the amount of tax to be paid, valency tax etc..For example, can adopt
Consumption sum is counted by trade name with SQL statement or other sentences, exemplary SQL statement is：" SELECT trade names
AS trade names, 1.0*SUM (amount of money) AS Amounts in Total, 1.0*SUM (amount of tax to be paid) AS adds up to the amount of tax to be paid, 1.0*SUM (amount of money+amount of tax to be paid)
The total FROM sales invoice detail lists of AS valencys tax, pin item inventory detail list WHERE makes out an invoice date BETWEEN'YYYY-MM-DD'
AND'YYYY-MM-DD'AND invoice number BETWEEN'00000000'AND'99999999'AND billing machines number=" billing machine
Number X " GROUP BY trade names ".This makes it possible to what is be related in counting sales invoice detail list and pin inventory detail list
The information such as consumption sum, the amount of tax to be paid of certain commodity.Need it is clear that, the sales invoice that uses is bright during statistics commodity data
Data in thin table and pin inventory detail list are the data after being processed through discount.The exemplary merchandise sales amount of money, the amount of tax to be paid and
Valency tax aggregate statistics result refers to table 9 above.
The preferred embodiment of the present invention is described in detail above in association with accompanying drawing, but, the present invention is not limited to above-mentioned reality
The detail in mode is applied, in range of the technology design of the invention, various letters can be carried out to technical scheme
Monotropic type, these simple variants belong to protection scope of the present invention.
It is further to note that each particular technique feature described in above-mentioned specific embodiment, in not lance
In the case of shield, can be combined by any suitable means.In order to avoid unnecessary repetition, the present invention to it is various can
The combination of energy is no longer separately illustrated.
Additionally, can also be combined between a variety of implementation methods of the invention, as long as it is without prejudice to originally
The thought of invention, it should equally be considered as content disclosed in this invention.
Claims (8)
1. a kind of tax control counting system, the tax control counting system includes sales invoice table, sales invoice detail list and pin item inventory
Detail list, it is characterised in that the tax control counting system also includes：
Acquisition module, for being obtained from the sales invoice table at least including invoice codes, invoice number, inventory mark and being opened
The invoice body data of ticket machine number, and according to inventory mark correspondingly from the sales invoice detail list or pin item inventory
Being obtained in detail list includes the invoice commodity detailed data of at least one commodity detail row, and each described commodity detail row is at least wrapped
Include trade name, quantity, unit price, the amount of money, the amount of tax to be paid, the tax rate and identified containing tax；
Discount processing module, for including that discount row and described being designated containing tax are free of in acquired invoice commodity detailed data
In the case of tax, the line number N of discount commodity is determined according to the trade name of the discount row, and by the amount of money in the discount row
N before dividing the discount row respectively with the amount of tax to be paid do business product detail row the amount of money and the amount of tax to be paid in；And
Statistical module, for counting commodity data according to the invoice commodity detailed data after discount treatment.
2. tax control counting system according to claim 1, it is characterised in that the invoice body data also include it is following extremely
Few one：(1) one of purchaser's title and purchaser's duty paragraph or both；(2) invoice type；(3) invoice amount；And (4) hair
The ticket amount of tax to be paid.
3. tax control counting system according to claim 1, it is characterised in that the invoice commodity detailed data also includes rule
At least one of lattice number, measurement unit.
4. tax control counting system according to claim 1, it is characterised in that
(1) in the case where acquired invoice commodity detailed data includes a line discount row, the discount processing module is used
Below equation is divided：
Divide the rear amount of money=divide the preceding amount of money+discount row amount of money
Divide the rear amount of tax to be paid=divide the preceding amount of tax to be paid+discount row amount of tax to be paid
It is univalent after dividing=to divide the rear amount of money/quantity
(2) in the case where acquired invoice commodity detailed data includes multirow discount row, the discount processing module is used
Below equation is divided：
The do business discounts of product detail row of 1 to N-1 before discount row divide computing formula and are：
Divide the rear amount of money=divide preceding amount of money * (1- discount rates)
Divide the rear amount of tax to be paid=divide preceding amount of tax to be paid * (1- discount rates)
It is univalent after dividing=to divide the rear amount of money/quantity
The discount of the Nth row commodity detail row before discount row divides computing formula and is：
It is univalent after dividing=to divide the rear amount of money/quantity.
5. a kind of method of utilization tax control counting system statistics commodity data, the tax control counting system includes sales invoice table, pin
Item invoice specification and pin inventory detail list, it is characterised in that the method includes：
Being obtained from the sales invoice table at least includes the invoice of invoice codes, invoice number, inventory mark and billing machine number
Body data；
Correspondingly being obtained from the sales invoice detail list or pin item inventory detail list according to inventory mark is included at least
One invoice commodity detailed data of commodity detail row, each described commodity detail row at least includes trade name, quantity, list
Valency, the amount of money, the amount of tax to be paid, the tax rate and containing tax mark；
Acquired invoice commodity detailed data include discount row and it is described be designated without tax containing tax in the case of, according to institute
State the trade name of discount row to determine the line number N of discount commodity, and the amount of money and the amount of tax to be paid in the discount row are divided respectively
N before the discount row do business product detail row the amount of money and the amount of tax to be paid in；And
Commodity data is counted according to the invoice commodity detailed data after discount treatment.
6. method according to claim 5, it is characterised in that the invoice body data also include it is following at least one：
(1) one of purchaser's title and purchaser's duty paragraph or both；(2) invoice type；(3) invoice amount；And (4) invoice amount of tax to be paid.
7. method according to claim 5, it is characterised in that the invoice commodity detailed data also include specifications and models,
At least one of measurement unit.
8. method according to claim 5, it is characterised in that
(1) in the case where acquired invoice commodity detailed data includes a line discount row, the discount processing module is used
Below equation is divided：
Divide the rear amount of money=divide the preceding amount of money+discount row amount of money
Divide the rear amount of tax to be paid=divide the preceding amount of tax to be paid+discount row amount of tax to be paid
It is univalent after dividing=to divide the rear amount of money/quantity
(2) in the case where acquired invoice commodity detailed data includes multirow discount row, the discount processing module is used
Below equation is divided：
The do business discounts of product detail row of 1 to N-1 before discount row divide computing formula and are：
Divide the rear amount of money=divide preceding amount of money * (1- discount rates)
Divide the rear amount of tax to be paid=divide preceding amount of tax to be paid * (1- discount rates)
It is univalent after dividing=to divide the rear amount of money/quantity
The discount of the Nth row commodity detail row before discount row divides computing formula and is：
It is univalent after dividing=to divide the rear amount of money/quantity.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510919019.0A CN106875236A (en) | 2015-12-11 | 2015-12-11 | Tax control counting system and the method using the tax control counting system statistics commodity data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510919019.0A CN106875236A (en) | 2015-12-11 | 2015-12-11 | Tax control counting system and the method using the tax control counting system statistics commodity data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106875236A true CN106875236A (en) | 2017-06-20 |
Family
ID=59177994
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510919019.0A Pending CN106875236A (en) | 2015-12-11 | 2015-12-11 | Tax control counting system and the method using the tax control counting system statistics commodity data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106875236A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113450165A (en) * | 2021-06-28 | 2021-09-28 | 首约科技(北京)有限公司 | Method for issuing invoices with different main bodies and tax rates according to configuration |
-
2015
- 2015-12-11 CN CN201510919019.0A patent/CN106875236A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113450165A (en) * | 2021-06-28 | 2021-09-28 | 首约科技(北京)有限公司 | Method for issuing invoices with different main bodies and tax rates according to configuration |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Scherer | The link between gross profitability and pharmaceutical R&D spending | |
| US8027860B2 (en) | Systems and methods for planning demand for configurable products | |
| CN109389431A (en) | Distribution method, device, electronic equipment and the readable storage medium storing program for executing of discount coupon | |
| US20130073518A1 (en) | Integrated transactional and data warehouse business intelligence analysis solution | |
| CN110633331B (en) | Method, system and related equipment for extracting data in relational database | |
| CN106056418A (en) | Invoice submission method, device and system | |
| CN109840622A (en) | A kind of wash sale method for early warning and system based on invoice judgement | |
| US8050957B2 (en) | Systems and methods for planning demand for configurable products | |
| CN102222285A (en) | Multi-dimensional data linkage computing device and multi-dimensional data linkage computing method | |
| CN108304591A (en) | A kind of method for customizing of label, system and terminal device | |
| CN105809523A (en) | Method and system for balancing tax for invoicing | |
| US20130167114A1 (en) | Code scoring | |
| CN103885998A (en) | Method for unified registration applying of XBRL (extensible business reporting language) factors | |
| CN106875236A (en) | Tax control counting system and the method using the tax control counting system statistics commodity data | |
| CN108960672A (en) | The air control method, apparatus and computer readable storage medium of limit limit time | |
| CN102629362A (en) | Method for realizing flexible account structure in enterprise annuity account management system | |
| US10325276B2 (en) | Financial reporting system integrating market segment attributes and accounting data | |
| 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 | |
| CN106874283A (en) | Tax control counting system and the method using the tax control counting system statistics commodity data | |
| US8473375B2 (en) | Utilizing supporting dimensions to further define transaction entities in a computerized financial/accounting system | |
| US20150302429A1 (en) | Report generation system and method | |
| CN107203506A (en) | A kind of report form generation method and device | |
| CN107203935B (en) | XBRL technology-based proxy accounting system and method | |
| US10157419B1 (en) | Multi-factor risk modeling platform | |
| US20210182963A1 (en) | System and Process for Option Trading |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170620 |