CN109948130A - A method of intelligence filling VAT invoice commodity detail - Google Patents
A method of intelligence filling VAT invoice commodity detail Download PDFInfo
- Publication number
- CN109948130A CN109948130A CN201910193671.7A CN201910193671A CN109948130A CN 109948130 A CN109948130 A CN 109948130A CN 201910193671 A CN201910193671 A CN 201910193671A CN 109948130 A CN109948130 A CN 109948130A
- Authority
- CN
- China
- Prior art keywords
- invoice
- commodity
- record
- detail
- making out
- 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.)
- Granted
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of methods of intelligence filling VAT invoice commodity detail, this method is after the completion of making out an invoice every time, the detail xml formatted file of current invoice is recorded, and is inserted into the record including information such as invoice codes, number, product names in the history invoice information database locallyd create；Before making out an invoice every time, several invoices record issued recently is searched from history invoice information tables of data, product name in all records found out is counted, find out the record for occurring that commodity number is most and invoicing time is nearest, invoice codes, invoice number are inquired from the record of selection, this is found out again and records the file of corresponding description invoice detail, and it is filled into automatically in current environment of making out an invoice.Method of the invention is compared with existing filled by hand commodity detail, greatly improves the invoicing speed of drawer and accuracy rate of making out an invoice, convenient and efficient, has good promotional value.
Description
Technical field
The invention belongs to VAT invoice administrative skill field, it is related to a kind of intelligence filling VAT invoice commodity detail
Method realizes the method for intelligent autofill commodity detail during opening VAT invoice.
Background technique
In traditional mode of making out an invoice, purchaser provides new line information to pin side by oral or hand-written mode, general to wrap
Include purchaser's title, Taxpayer Identification Number, address phone and Bank Account Number etc..Drawer (pin side) needs this new line information solicitation
In making out an invoice on software for the end PC, and the information such as upper sold goods classification, product name and specification are supplemented manually, can just issue out one
Open complete invoice.
Universal with Internet technology and smart phone, the mode that mobile terminal barcode scanning is made out an invoice is by more and more enterprises
Receive and use with individual.Currently, the most common mobile terminal barcode scanning mode of making out an invoice is: drawer (pin side) provides one two
Code is tieed up, purchaser is swept with the App that mobile terminal is specified and swept, and is then come back in the designated position filling invoice for jumping out the page bright
Carefully and submit.Drawer can pull the new line information of submission by corresponding pc client from server, be filled into automatically
It makes out an invoice software.However still need to supplement commodity detail manually again, it can just issue out a complete invoice.
Both the above is made out an invoice mode, is required drawer's filled by hand commodity detail, is not only expended a large amount of human time,
The accuracy of invoice information is not can guarantee also.
Summary of the invention
In view of the above-mentioned deficiencies in the prior art, it is an object of the present invention to provide a kind of intelligence filling VAT invoice commodity detail
Method, intellectual analysis of this method based on the history invoice data to the side of making out an invoice, realization filled out in page in ticket to be developed, automatically
Fill the function of commodity detail.
The method of intelligence filling VAT invoice commodity detail of the invention, the method is as follows:
After the completion of making out an invoice every time, connect according to affiliated in " VAT invoice tax control counting software data interface specification V3.0 "
The detail xml formatted file of the mouth current invoice of canonical record, and one is inserted into the history invoice information database locallyd create
Item record, which includes the information of invoice codes, invoice number, invoicing time and product name；
Before making out an invoice every time, the 5 invoices record issued recently is searched from history invoice information tables of data, works as record
Whole is then searched when less than 5, the product name in all records found out is counted, finds out and commodity number occurs most
More and nearest invoicing time records, inquires invoice codes and invoice number from the record of selection, finds out this further according to this
Item records the file of corresponding description invoice detail, and it is filled into automatically in current environment of making out an invoice.
Product name can be a kind of commodity in every record in the history invoice information database, be also possible to
The combination of a variety of commodity, depending on there is several merchandise newss in invoice, by the title of commodity all on invoice according to unified rule
It then carries out arrangement and obtains product name combination.
When for a variety of commodity, can be arranged according to following rule in record: the titles of several commodity according to
First letter of pinyin ascending sort carries out product name combination, can avoid leading to product name not because of sequence difference listed by commodity in this way
Together, the statistics of commodity frequency of occurrence is influenced.
The invention has the advantages that:
The intelligent autofill that the present invention realizes commodity detail is compared with existing filled by hand commodity detail, greatly
The invoicing speed for improving drawer and make out an invoice accuracy rate.It especially makes out an invoice the single industry of type, answers in food and drink, hotel etc.
Use it is even more convenient and efficient, have good promotional value.
Detailed description of the invention
Fig. 1 is the flow diagram of the method for the present invention；
Fig. 2 is that process contrast schematic diagram is embodied in the method for the present invention and existing method；
Specific embodiment
Explanation is further elaborated to mode of the invention below.
As shown in Figure 1, the present invention is according to " VAT invoice tax control counting software data interface after the completion of drawer makes out an invoice
Specification V3.0 " in affiliated interface specification record the detail xml formatted file of current invoice, and in the history invoice letter locallyd create
It ceases in database, is inserted into a record, including invoice codes, invoice number, invoicing time and product name etc..
Before drawer makes out an invoice next time, the present invention is searched from the database of log history invoice information and is issued recently
5 invoices record (record less than 5 when, search all), the product name in all records is counted, appearance is found out
The record that commodity number is most and invoicing time is nearest.Invoice codes and invoice number, then root are inquired from the record of selection
This is found out accordingly and records the file of corresponding description invoice detail, and it is filled into automatically in current environment of making out an invoice.
Using practical case of the invention as shown in Fig. 2, bold portion is the detailed process of existing method, dotted portion is
Apply the case study on implementation of method of the invention.It is the currently used mobile terminal barcode scanning side of making out an invoice from the first step to third step
The function that formula has been carried out.Purchaser sweeps the two dimensional code for sweeping drawer's offer with the App that mobile terminal is specified, and is then jumping out
The designated position filling invoice new line detail of the page come is simultaneously submitted.Drawer is pulled up by corresponding pc client from server
The information that comes back of making out an invoice for taking purchaser to submit, the invoice which is filled into software of making out an invoice automatically fill out the page.4th step and the 5th
Step is the process that drawer is manually entered commodity detail and printed invoice, and the 6th step is then that pc client is monitored and made out an invoice successfully simultaneously
Invoice information is passed back to the process of the mobile terminal of purchaser.
Wherein the 4th step is the part that the present invention can substitute.In original technology, four steps, that is, drawer's filled by hand
Commodity detail process is operation most time-consuming during currently entirely making out an invoice, and is easier the part of error.And it is of the invention
Based on the intellectual analysis to history invoice commodity detail, the automatic filling of commodity detail is realized, after filling, drawer is only
Lower quantity and the amount of money need to simply be modified.
7th step is the newly-increased part of the present invention, and after the completion of making out an invoice, the present invention needs to record current invoice information, as
The reference of commodity detail of making out an invoice in the future filling, and this step is unaware for drawer.
This method industry relatively simple for type of making out an invoice is especially useful, and effect is obvious.
The present invention will be further described by taking a specific practical application as an example below.
Certain shop drawer has issued three invoices.First commodity detail is keyboard, mouse and notebook, issues completion
Afterwards, using method of the invention by the invoice detail record at xml formatted file, and in the local database increase newly one note
It records, corresponding invoice codes, invoice number and product name on record, wherein product name is that " keyboard of notebook computer mouse " (is pressed
Initial ascending sort)；Likewise, second commodity detail is keyboard and notebook, product name is recorded as " pen in database
Remember this keyboard "；Third commodity detail is mouse, keyboard and notebook (with first order difference), trade name in database
Claim still to be recorded as " keyboard of notebook computer mouse " according to initial ascending order permutation and combination.When drawer issues the 4th invoice,
It is counted using the product name that method of the invention opens invoice to history three, " keyboard of notebook computer mouse " occurs two
Secondary, " keyboard of notebook computer " occurs once.After algorithm comparison of the present invention, take out third invoice invoice codes and
Invoice number, and the xml formatted file for recording corresponding invoice is found out, its commodity detail is filled into environment of currently making out an invoice, is made
For the Recommendations detail of the 4th invoice.Drawer needs verification commodity detail before making out an invoice, according to the actual situation to listed commodity
It carries out additions and deletions or modifies the operation of the amount of money.
It can be significantly reduced the work that drawer is manually entered commodity detail by this method, cumbersome input is simplified
For verification, modification can be very big especially for the more single industry of type of making out an invoice, such as restaurant, hotel, hotel industry
Invoicing speed and accuracy rate are improved, this method is simple and easy, convenient and efficient.
Claims (4)
1. a kind of method of intelligence filling VAT invoice commodity detail, which is characterized in that method is as follows:
After the completion of making out an invoice every time, advised according to interface affiliated in " VAT invoice tax control counting software data interface specification V3.0 "
Model records the detail xml formatted file of current invoice, and a note is inserted into the history invoice information database locallyd create
Record, which includes the information of invoice codes, invoice number, invoicing time and product name；
Before making out an invoice every time, several invoices record issued recently is searched from history invoice information tables of data, works as record
Whole is then searched when less than 5, the product name in all records found out is counted, finds out and commodity number occurs most
More and nearest invoicing time records, inquires invoice codes and invoice number from the record of selection, finds out this further according to this
Item records the file of corresponding description invoice detail, and it is filled into automatically in current environment of making out an invoice.
2. the method for intelligence filling VAT invoice commodity detail according to claim 1, which is characterized in that the quotient
The name of an article claims to be all product names are ranked up according to uniform rules on current invoice combination.
3. the method for intelligence filling VAT invoice commodity detail according to claim 2, which is characterized in that the system
One rule are as follows: the title of commodity all on invoice is ranked up according to lead-in first letter of pinyin ascending order the group for obtaining product name
It closes.
4. the method for intelligence filling VAT invoice commodity detail according to claim 1, which is characterized in that if described
A dry invoice is recorded as 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910193671.7A CN109948130B (en) | 2019-03-14 | 2019-03-14 | Method for intelligently filling value-added tax invoice commodity details |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910193671.7A CN109948130B (en) | 2019-03-14 | 2019-03-14 | Method for intelligently filling value-added tax invoice commodity details |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109948130A true CN109948130A (en) | 2019-06-28 |
| CN109948130B CN109948130B (en) | 2023-03-24 |
Family
ID=67009962
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910193671.7A Active CN109948130B (en) | 2019-03-14 | 2019-03-14 | Method for intelligently filling value-added tax invoice commodity details |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109948130B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111260453A (en) * | 2020-01-02 | 2020-06-09 | 航天信息软件技术有限公司 | Method and device for generating purchase-sale account based on purchase-sale item invoice data |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050165681A1 (en) * | 2000-08-07 | 2005-07-28 | Tymetrix, Inc. | Method for automatic processing of invoices |
| CN103116953A (en) * | 2013-02-21 | 2013-05-22 | 广州宝钢南方贸易有限公司 | Device and method for invoicing in self-service manner |
| CN106779890A (en) * | 2016-12-08 | 2017-05-31 | 用友网络科技股份有限公司 | The generation method and system of electronic invoice |
| CN106920133A (en) * | 2015-12-28 | 2017-07-04 | 航天信息股份有限公司 | A kind of invoice issuing method and system based on bankcard consumption |
-
2019
- 2019-03-14 CN CN201910193671.7A patent/CN109948130B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050165681A1 (en) * | 2000-08-07 | 2005-07-28 | Tymetrix, Inc. | Method for automatic processing of invoices |
| CN103116953A (en) * | 2013-02-21 | 2013-05-22 | 广州宝钢南方贸易有限公司 | Device and method for invoicing in self-service manner |
| CN106920133A (en) * | 2015-12-28 | 2017-07-04 | 航天信息股份有限公司 | A kind of invoice issuing method and system based on bankcard consumption |
| CN106779890A (en) * | 2016-12-08 | 2017-05-31 | 用友网络科技股份有限公司 | The generation method and system of electronic invoice |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111260453A (en) * | 2020-01-02 | 2020-06-09 | 航天信息软件技术有限公司 | Method and device for generating purchase-sale account based on purchase-sale item invoice data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109948130B (en) | 2023-03-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111428599B (en) | Bill identification method, device and equipment | |
| CN112668968B (en) | Warehouse management modeling method and system based on field drive design | |
| US20080086409A1 (en) | Fraud detection, risk analysis and compliance assessment | |
| US7720842B2 (en) | Value-chained queries in analytic applications | |
| CN106504042A (en) | Electronic invoice new line information processing method, client of making out an invoice and relevant device | |
| CN1971566A (en) | Tracking usage of data elements in electronic business communications | |
| US11501549B2 (en) | Document processing using hybrid rule-based artificial intelligence (AI) mechanisms | |
| CN108334568A (en) | Source of houses method for pushing, device, equipment and computer readable storage medium | |
| CN110377801A (en) | A kind of product name bearing calibration, device and computer readable storage medium | |
| CN106327321A (en) | Method for automatically generating financial data | |
| CN101236550A (en) | Method and system for processing tree -type structure data | |
| CN105843793A (en) | Detection and creation of appropriate row concept during automated model generation | |
| CN111179068A (en) | Method, device and storage medium for determining enterprise performance credit level | |
| CN111680506A (en) | External key mapping method and device of database table, electronic equipment and storage medium | |
| CN103294845A (en) | Business analysis design support device, business analysis design support method and business analysis design support program | |
| CN109636303B (en) | Storage method and system for semi-automatically extracting and structuring document information | |
| CN109948130A (en) | A method of intelligence filling VAT invoice commodity detail | |
| CN109241167B (en) | Table data importing method based on BS framework | |
| CN113592512A (en) | Online commodity identity uniqueness identification and confirmation system | |
| CN108897763A (en) | A kind of block chain data conversion system | |
| CN105913071A (en) | Information processing device, information processing system and information processing method | |
| CN108257007A (en) | Intelligent Matching system based on Internet of Things finance investment and financing platform | |
| US20180121978A1 (en) | User-Assisted Processing of Receipts and Invoices | |
| JP6948470B1 (en) | Repair support system and repair support method | |
| CN110413659B (en) | General shopping ticket data accurate extraction method |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |