CN109872198A - The generation method and device of credit note - Google Patents

The generation method and device of credit note Download PDF

Info

Publication number
CN109872198A
CN109872198A CN201711268421.2A CN201711268421A CN109872198A CN 109872198 A CN109872198 A CN 109872198A CN 201711268421 A CN201711268421 A CN 201711268421A CN 109872198 A CN109872198 A CN 109872198A
Authority
CN
China
Prior art keywords
data set
return
goods
note
forms data
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
Application number
CN201711268421.2A
Other languages
Chinese (zh)
Inventor
耿立家
杨威
尹春天
张玉魁
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Aisino Corp
Original Assignee
Aisino Corp
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Aisino Corp filed Critical Aisino Corp
Priority to CN201711268421.2A priority Critical patent/CN109872198A/en
Publication of CN109872198A publication Critical patent/CN109872198A/en
Pending legal-status Critical Current

Links

Landscapes

  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

The embodiment of the present invention provides the generation method and device of a kind of credit note, and to overcome the efficiency for issuing credit note in the prior art lower, and the quantity of credit note is also more, does not meet the defect that the management of enterprise needs.Wherein method includes: to obtain the original data set not issued invoice and the returning note data set not issued invoice in sales slip;The original data set and the returning note data set are subjected to counteracting processing;The return of goods forms data of ticket to be developed is determined according to processing result is offset, and credit note is generated to the return of goods forms data of the ticket to be developed.The embodiment of the present invention reduces the quantity of credit note, improves the formation efficiency of credit note, and reduces the error rate in credit note generating process, to strengthen supervision of the enterprise to value-added tax credit note, the financial management of specification enterprise.

Description

The generation method and device of credit note
Technical field
The present embodiments relate to technical field of data processing more particularly to the generation methods and dress of a kind of credit note It sets.
Background technique
Currently, according to the relevant regulations of Administration of State Bureau: for general taxpayer after obtaining VAT invoice, selling Goods retracts, the situations such as wrong of making out an invoice but does not meet calcellation condition, or because selling concession is retracted or occurred in sales part, answers Issue credit note.
In enterprise business, VAT invoice just usually is issued to purchaser after completing sales process.If Subsequent purchaser has return of goods behavior, then the VAT invoice first issued is possible to need to issue credit note.In the prior art, red Word invoice issues what process was usually handled by hand, i.e., first takes the corresponding value-added tax indigo plant word invoice of returning note, then by opening The relevant information that ticket software craft typing credit note is issued, that triggers credit note issues process.
But this credit note of the prior art issues method, the efficiency for issuing credit note is lower, and The Scarlet Letter is sent out The quantity of ticket is also more, does not meet the management needs of enterprise.
Summary of the invention
In view of this, one of the technical issues of embodiment of the present invention is solved is to provide a kind of generation side of credit note Method and device, to overcome the efficiency for issuing credit note in the prior art lower, and the quantity of credit note is also more, no Meet the defect that the management of enterprise needs.
The embodiment of the present invention provides a kind of generation method of credit note, which comprises
Obtain the original data set not issued invoice and the returning note data set not issued invoice in sales slip;
The original data set and the returning note data set are subjected to counteracting processing;
The return of goods forms data of ticket to be developed is determined according to counteracting processing result, and to the return of goods forms data of the ticket to be developed Generate credit note.
It is optionally, described that the original data set and the returning note data set are subjected to the step of offsetting processing, comprising:
Positive forms data in the original data set is merged;
Return of goods forms data in the returning note data set is split;
Returning note data set according to the original data set after merging and after splitting carries out counteracting processing.
Optionally, the step of positive forms data by the original data set merges, comprising: by the original Positive forms data in data set, comprising identical commodity merges into a positive forms data.
Optionally, the step of return of goods forms data by the returning note data set is split, comprising: will be described Return of goods forms data in returning note data set, comprising a variety of commodity is split as a plurality of return of goods forms data comprising a kind of commodity.
Optionally, the returning note data set after the original data set and fractionation according to after merging carries out offsetting processing Step, comprising: the returning note data set after the fractionation is compared with the original data set after described merge, determines and offsets Processing result.
Optionally, the returning note data set by after the fractionation is compared with the original data set after described merge The step of, comprising:
Search from the original data set after the merging and the returning note data set after the fractionation includes identical commodity Positive forms data and return of goods forms data;
The positive forms data comprising identical commodity is added with the goods amount in return of goods forms data;
It is to have offset by the status indication of issuing of the return of goods forms data, by institute if addition result is greater than or equal to zero It states the goods amount in positive forms data and is revised as the addition result.
Optionally, described the step of determining the return of goods forms data of ticket to be developed according to counteracting processing result, comprising:
It obtains to offset and offsets treated returning note data set in processing result;
To offset in treated returning note data set, issue state be that the return of goods forms data that do not open is determined as wait open by described The return of goods forms data of invoice.
The embodiment of the present invention also provides a kind of generating means of credit note, and described device includes:
Module is obtained, for obtaining the original data set not issued invoice in sales slip and the return of goods not issued invoice odd number According to collection;
Cancellation module, for the original data set and the returning note data set to be carried out counteracting processing;
Generation module, for determining the return of goods forms data of ticket to be developed according to counteracting processing result, and to described to be developed The return of goods forms data of ticket generates credit note.
Optionally, the cancellation module includes:
Combining unit, for merging the positive forms data in the original data set;
Split cells, for splitting the return of goods forms data in the returning note data set;
Processing unit carries out at counteracting for the returning note data set according to the original data set after merging and after splitting Reason.
Optionally, the combining unit is further used for the positive odd number in the original data set, comprising identical commodity According to merging into a positive forms data.
The embodiment of the present invention obtains the original data set not issued invoice in sales slip and the return of goods not issued invoice first Then the original data set and the returning note data set are carried out counteracting processing by forms data collection, last to handle according to counteracting As a result it determines the return of goods forms data of ticket to be developed, and credit note is generated to the return of goods forms data of the ticket to be developed.By above Technical solution as it can be seen that by counteracting processing the returning note data offset not issued invoice partly or entirely can be fallen, it is then right The remaining return of goods forms data not being cancelled generates credit note, therefore reduces the quantity of credit note, improves credit note Formation efficiency, and reduce the error rate in credit note generating process, value-added tax The Scarlet Letter sent out to strengthen enterprise The supervision of ticket, the financial management of specification enterprise.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this The some embodiments recorded in inventive embodiments can also obtain according to these attached drawings for those of ordinary skill in the art Obtain other attached drawings.
Fig. 1 is a kind of step flow chart of the generation method of credit note of the embodiment of the present invention one;
Fig. 2 is a kind of step flow chart of the generation method of credit note of the embodiment of the present invention two;
Fig. 3 is a kind of structural block diagram of the generating means of credit note of the embodiment of the present invention three.
Specific embodiment
Certainly, any technical solution for implementing the embodiment of the present invention must be not necessarily required to reach simultaneously above all excellent Point.
In order to make those skilled in the art more fully understand the technical solution in the embodiment of the present invention, below in conjunction with the present invention Attached drawing in embodiment, technical scheme in the embodiment of the invention is clearly and completely described, it is clear that described reality Applying example only is a part of the embodiment of the embodiment of the present invention, instead of all the embodiments.Based on the implementation in the embodiment of the present invention The range of protection of the embodiment of the present invention all should belong in example, those of ordinary skill in the art's every other embodiment obtained.
Below with reference to attached drawing of the embodiment of the present invention the embodiment of the present invention will be further explained specific implementation.
Embodiment one
Referring to Fig.1, a kind of step flow chart of the generation method of credit note of the embodiment of the present invention one is shown.
The generation method of the credit note of the present embodiment the following steps are included:
Step 101, the original data set not issued invoice and the returning note data set not issued invoice in sales slip are obtained.
The sales slip tables of data of enterprise can be preserved in the operation system of enterprise, include positive odd number in sales slip tables of data According to, return of goods forms data etc., had recorded in sales slip tables of data the sale odd numbers of positive forms data and return of goods forms data, product name, Unit price, the amount of money, issues the parameters such as state at quantity, wherein issuing state such as is to have opened, do not opened.It can be true according to the state of issuing The positive forms data of fixed untapped ticket and the return of goods forms data of untapped ticket, and then the original data set that is not issued invoice and not The returning note data set to issue invoice.
Step 102, the original data set and the returning note data set are subjected to counteracting processing.
Counteracting processing is such as that the positive forms data comprising identical commodity and return of goods forms data are carried out counteracting processing, to support Disappear part or all of return of goods forms data, and the return of goods forms data being canceled out no longer needs to issue credit note.For specifically supporting Disappear treatment process, will be discussed in detail in following embodiment two.
Step 103, the return of goods forms data of ticket to be developed is determined according to counteracting processing result, and the ticket to be developed is moved back Manifest data generates credit note.
After counteracting processing, part or all of return of goods forms data is canceled out, and can determine according to counteracting processing result to be developed The return of goods forms data of ticket, for example be to determine that the return of goods forms data not being cancelled is the return of goods forms data of ticket to be developed, when enterprise needs When issuing credit note, the return of goods forms data drawn a bill can be treated and generate credit note, for example moved back to what is be not cancelled Manifest data generates credit note.
The embodiment of the present invention obtains the original data set not issued invoice in sales slip and the return of goods not issued invoice first Then the original data set and the returning note data set are carried out counteracting processing by forms data collection, last to handle according to counteracting As a result it determines the return of goods forms data of ticket to be developed, and credit note is generated to the return of goods forms data of the ticket to be developed.By above Technical solution as it can be seen that by counteracting processing the returning note data offset not issued invoice partly or entirely can be fallen, it is then right The remaining return of goods forms data not being cancelled generates credit note, therefore reduces the quantity of credit note, improves credit note Formation efficiency, and reduce the error rate in credit note generating process, value-added tax The Scarlet Letter sent out to strengthen enterprise The supervision of ticket, the financial management of specification enterprise.
Embodiment two
Referring to Fig. 2, a kind of step flow chart of the generation method of credit note of the embodiment of the present invention two is shown.
The generation method of the credit note of the present embodiment the following steps are included:
Step 201, the original data set and returning note data set in sales slip are obtained.
Step 201 and step 202 are Data Preparation Process.
1.1, sales slip original data preparation
According to " mark of making out an invoice ", the positive forms data of sales slip is searched in the sales slip tables of data of operation system, forms sale Single original data set.SQL (Structured Query Language, structured query language) Sentence format of calculating can be with Are as follows: " SELECT sells odd numbers, and product name, quantity, the amount of money, issues state FROM sales slip tables of data WHERE sale at unit price Single attribute=' original ' ' ".
For example, original data set is as shown in Table 1:
Serial number Sell odd numbers Product name Unit price Quantity The amount of money Issue state
1 XSD001 Commodity 1 1000.00 3 3000.00 It has opened
2 XSD001 Commodity 2 400.00 3 1200.00 It has opened
3 XSD001 Commodity 3 200.00 2 400.00 It has opened
4 XSD002 Commodity 1 1000.00 2 2000.00 It does not open
5 XSD003 Commodity 2 400.00 1 400.00 It does not open
6 XSD004 Commodity 1 1000.00 2 2000.00 It does not open
7 XSD004 Commodity 3 200.00 1 200.00 It does not open
Table one
In the original data set shown in above-mentioned table one, the original that sale odd numbers is XSD001 has issued invoice, Remaining original does not issue invoice.
1.2, sales slip returning note data preparation
According to " mark of making out an invoice ", sales slip return of goods forms data is searched in the sales slip tables of data of operation system, forms pin Sell single returning note data set.The SQL statement format of calculating can be with are as follows: " SELECT sells odd numbers, product name, unit price, quantity, The amount of money, issue state FROM sales slip tables of data WHERE sales slip attribute=' negative single ' ' ".
For example, returning note data set is as shown in Table 2:
Table two
In the returning note data set shown in above-mentioned table two, the sales slip of corresponding sale odd numbers XSD001 produces the return of goods, Wherein commodity 1 are all to return goods, and commodity 2 are that part is returned goods.
Step 202, the original data set not issued invoice and the returning note data set not issued invoice in sales slip are obtained.
According to issuing state and can search in sales slip not in the original data set and returning note data set of above-mentioned acquisition The original data set to issue invoice and the returning note data set not issued invoice.
For example, according to original data set shown in table one, due to not opening including the positive forms data to have issued invoice and Have the positive forms data of invoice, thus may determine that the original data set not issued invoice is as shown in Table 3:
Serial number Sell odd numbers Product name Unit price Quantity The amount of money Issue state
1 XSD002 Commodity 1 1000.00 2 2000.00 It does not open
2 XSD003 Commodity 2 400.00 1 400.00 It does not open
3 XSD004 Commodity 1 1000.00 2 2000.00 It does not open
4 XSD004 Commodity 3 200.00 1 200.00 It does not open
Table three
For example, according to returning note data set shown in table two, due to including be the returning note not issued invoice Data, thus may determine that the returning note data set not issued invoice is identical as table two.
Step 203, the original data set not issued invoice and the returning note data set not issued invoice are carried out at counteracting Reason.
In a kind of preferred embodiment, which may include following sub-step:
Sub-step a1 merges the positive forms data in the original data set not issued invoice.
Preferably, sub-step a1 further comprises: by the original data set not issued invoice, comprising identical commodity Positive forms data merges into a positive forms data.In the original data set not issued invoice, the positive unirecord of identical commodity is closed And be a positive unirecord, quantity and the amount of money are accumulative.
For example, the positive forms data in the original data set not issued invoice shown in table three is merged, merged Original data set afterwards, as shown in Table 4:
Table four
The original data set not issued invoice shown in contrast table three can be satisfied and not open if do not merged The positive forms data that the return of goods forms data of tool invoice offset processing will be fewer.The positive forms data of identical commodity merges it Afterwards, it can both meet and forms data of returning goods is offset, the needs for opening positive forms data invoice less can also be met.
Sub-step a2 splits the return of goods forms data in the returning note data set not issued invoice.
Preferably, sub-step a2 further comprises: by the returning note data set not issued invoice, include a variety of commodity Return of goods forms data be split as a plurality of return of goods forms data comprising a kind of commodity.
For example, the return of goods forms data in the returning note data set not issued invoice shown in table two is split, obtain Returning note data set after fractionation, as shown in Table 5:
Table five
Sub-step a3, the returning note data set according to the original data set after merging and after splitting carry out counteracting processing.
Preferably, sub-step a3 further comprises: by after the fractionation returning note data set with after described merge Original data set compares, and determines and offsets processing result.
Wherein, the step returning note data set after the fractionation compared with the original data set after described merge Suddenly, may include:
A31 is searched from the original data set after the merging and the returning note data set after the fractionation comprising identical The positive forms data and return of goods forms data of commodity.
The positive forms data comprising identical commodity is added by a32 with the goods amount in return of goods forms data.
The status indication of issuing of the return of goods forms data is to have offset if addition result is greater than or equal to zero by a33, Goods amount in the positive forms data is revised as the addition result.
From the returning note data set after fractionation, successively take out each return of goods forms data, by its with merge after positive odd number Counteracting operation, process are done according to the positive forms data of concentration are as follows: a return of goods forms data are taken out, by its original data set after merging In compare, compare product name first, inconsistent then skips, then more next;After product name is consistent, compares and move back The goods amount of the goods amount of manifest data and positive forms data, i.e. two goods amounts are added;If result is less than zero, no It can offset, skip current record, more next;If result is not less than zero, success is offset, by issuing for forms data of returning goods State stamps the mark offset, and the goods amount of positive forms data is revised as above-mentioned goods amount addition result, will positive odd number According to commodity amount be revised as the difference of the commodity amount of positive forms data and the commodity amount of return of goods forms data.
By above-mentioned counteracting treatment process, obtains offsetting treated original data set and offset that treated and return goods odd number According to collection, the two data sets are to offset processing result.
For example, the original data set after merging shown in table four is supported with the returning note data set after splitting shown in table five Disappear after processing, obtain offsetting that treated that original data set is as shown in Table 6:
Table six
Obtain offsetting that treated that returning note data set is as shown in Table 7:
Table seven
After offsetting operation, original data set have it is new as a result, returning note data set be then only left it is a kind of untapped The commodity of ticket.
Step 204, the return of goods forms data of ticket to be developed is determined according to counteracting processing result, and the ticket to be developed is moved back Manifest data generates credit note.
Preferably, if do not issued invoice temporarily, the original data set after aforementioned counteracting operation and odd number of returning goods It can retain them temporarily according to collection, carry out counteracting operation again after having new a batch sale forms data.
It (for example can determine the need for issuing invoice according to predetermined period, or when can be with when needing to issue invoice It is determined when the sale forms data (positive forms data, return of goods forms data) to issue invoice reaches certain amount and needs to issue invoice, etc. Deng), the data set of the counteracting processing result obtained after the processing of above-mentioned process is the data set that can be issued invoice, It is middle to offset that treated original data set issue blue word invoice, returning note data set of offsetting that treated, if be no longer participate in Operation is offset, then can issue credit note.
In a kind of preferred embodiment, it can wrap according to the step of processing result determines the return of goods forms data of ticket to be developed is offset It includes: obtaining to offset and offset treated returning note data set in processing result;Treated returning note data set is offset by described In, to issue state be the return of goods forms data that the return of goods forms data that do not open is determined as ticket to be developed.
For example, the return of goods forms data according to treated returning note data set the determines ticket to be developed of counteracting shown in table seven It is as shown in Table 8:
Table eight
When needing to issue credit note, credit note is generated to the return of goods forms data of the ticket to be developed.
For example, table nine and table ten show the tables of data of two kinds of credit notes:
Table nine
Table ten
The embodiment of the present invention carries out a series of fortune by the sale forms data generated to enterprise production and management operation system After calculation processing, the data finally to issue invoice become to be more suitable for, and reduce the invoiced amount issued, and improve invoice issuing efficiency, and And reduce enterprise's risk lack of standardization to issue invoice, promote the operation of enterprise's legacy specification and normal invoice issuing, further Reinforcement and specification VAT invoice management, improve the Financial Control Level of enterprise.
Embodiment three
Referring to Fig. 3, a kind of structural block diagram of the generating means of credit note of the embodiment of the present invention three is shown.
The generating means of the credit note of the embodiment of the present invention comprise the following modules:
Module 301 is obtained, for obtaining the original data set not issued invoice in sales slip and the return of goods not issued invoice Forms data collection;
Cancellation module 302, for the original data set and the returning note data set to be carried out counteracting processing;
Generation module 303, for determining the return of goods forms data of ticket to be developed according to counteracting processing result, and to described wait open The return of goods forms data of invoice generates credit note.
Preferably, the cancellation module includes: combining unit, for carrying out the positive forms data in the original data set Merge;Split cells, for splitting the return of goods forms data in the returning note data set;Processing unit is used for foundation The returning note data set after original data set and fractionation after merging carries out counteracting processing.
Preferably, the combining unit is further used for the positive odd number in the original data set, comprising identical commodity According to merging into a positive forms data.
Preferably, the split cells, be further used for by the returning note data set, the return of goods comprising a variety of commodity Forms data is split as a plurality of return of goods forms data comprising a kind of commodity.
Preferably, the processing unit, be further used for by after the fractionation returning note data set with after described merge Original data set compare, determine offset processing result.
Preferably, the processing unit includes: lookup subelement, for from original data set after the merging and described Positive forms data and return of goods forms data comprising identical commodity are searched in returning note data set after fractionation;Computation subunit is used for The positive forms data comprising identical commodity is added with the goods amount in return of goods forms data;Subelement is marked, if being used for phase Add result to be greater than or equal to zero, is then to have offset by the status indication of issuing of the return of goods forms data, by the positive forms data In goods amount be revised as the addition result.
Preferably, the generation module, be further used for obtain offset processing result in offset treated return goods odd number According to collection;By it is described offset in treated returning note data set, issuing state, to be that the return of goods forms data that do not open is determined as to be developed The return of goods forms data of ticket.
The embodiment of the present invention can be fallen the returning note data offset not issued invoice partly or entirely by counteracting processing, Then credit note is generated to the remaining return of goods forms data not being cancelled, therefore reduces the quantity of credit note, improved red The formation efficiency of word invoice, and reduce the error rate in credit note generating process, to strengthen enterprise to value-added tax The supervision of credit note, the financial management of specification enterprise.
It may be noted that all parts/step described in the embodiment of the present invention can be split as more according to the needs of implementation The part operation of two or more components/steps or components/steps can also be combined into new component/step by multi-part/step Suddenly, to realize the purpose of the embodiment of the present invention.
It is above-mentioned to be realized in hardware, firmware according to the method for the embodiment of the present invention, or be implemented as being storable in note Software or computer code in recording medium (such as CD ROM, RAM, floppy disk, hard disk or magneto-optic disk), or it is implemented through net The original storage of network downloading in long-range recording medium or nonvolatile machine readable media and will be stored in local recording medium In computer code, so that method described herein can be stored in using general purpose computer, application specific processor or can compile Such software processing in journey or the recording medium of specialized hardware (such as ASIC or FPGA).It is appreciated that computer, processing Device, microprocessor controller or programmable hardware include can store or receive software or computer code storage assembly (for example, RAM, ROM, flash memory etc.), when the software or computer code are by computer, processor or hardware access and execute, realize The generation method of credit note described herein.In addition, when general purpose computer accesses for realizing the credit note being shown here Generation method code when, the execution of code, which is converted to general purpose computer, to be used to execute the life of credit note being shown here At the special purpose computer of method.
Those of ordinary skill in the art may be aware that list described in conjunction with the examples disclosed in the embodiments of the present disclosure Member and method and step can be realized with the combination of electronic hardware or computer software and electronic hardware.These functions are actually It is implemented in hardware or software, the specific application and design constraint depending on technical solution.Professional technician Each specific application can be used different methods to achieve the described function, but this realization is it is not considered that exceed The range of the embodiment of the present invention.
Embodiment that the above embodiments are only used to illustrate the present invention, and the limitation not to the embodiment of the present invention, related skill The those of ordinary skill in art field can also make various in the case where not departing from the spirit and scope of the embodiment of the present invention Variation and modification, therefore all equivalent technical solutions also belong to the scope of the embodiment of the present invention, the patent of the embodiment of the present invention Protection scope should be defined by the claims.

Claims (10)

1. a kind of generation method of credit note, which is characterized in that the described method includes:
Obtain the original data set not issued invoice and the returning note data set not issued invoice in sales slip;
The original data set and the returning note data set are subjected to counteracting processing;
The return of goods forms data of ticket to be developed is determined according to processing result is offset, and the return of goods forms data of the ticket to be developed is generated Credit note.
2. the method according to claim 1, wherein described by the original data set and the return of goods forms data Collection carries out the step of offsetting processing, comprising:
Positive forms data in the original data set is merged;
Return of goods forms data in the returning note data set is split;
Returning note data set according to the original data set after merging and after splitting carries out counteracting processing.
3. according to the method described in claim 2, it is characterized in that, the positive forms data by the original data set carries out The step of merging, comprising:
Positive forms data in the original data set, comprising identical commodity is merged into a positive forms data.
4. according to the method described in claim 2, it is characterized in that, the return of goods forms data by the returning note data set The step of being split, comprising:
Return of goods forms data in the returning note data set, comprising a variety of commodity is split as a plurality of return of goods comprising a kind of commodity Forms data.
5. according to the method described in claim 2, it is characterized in that, after the original data set and fractionation according to after merging Returning note data set carries out the step of offsetting processing, comprising:
Returning note data set after the fractionation is compared with the original data set after described merge, determines and offsets processing knot Fruit.
6. according to the method described in claim 5, it is characterized in that, the returning note data set by after the fractionation with it is described The step of original data set after merging compares, comprising:
It is searched comprising identical commodity just from the original data set after the merging and the returning note data set after the fractionation Forms data and return of goods forms data;
The positive forms data comprising identical commodity is added with the goods amount in return of goods forms data;
If addition result be greater than or equal to zero, by the return of goods forms data issue status indication be offset, by it is described just Goods amount in forms data is revised as the addition result.
7. the method according to claim 1, wherein described determine moving back for ticket to be developed according to counteracting processing result The step of manifest data, comprising:
It obtains to offset and offsets treated returning note data set in processing result;
To offset in treated returning note data set, issue state be that the return of goods forms data that do not open is determined as ticket to be developed by described Return of goods forms data.
8. a kind of generating means of credit note, which is characterized in that described device includes:
Obtain module, the return of goods forms data for obtaining the original data set not issued invoice in sales slip and not issuing invoice Collection;
Cancellation module, for the original data set and the returning note data set to be carried out counteracting processing;
Generation module, for determining the return of goods forms data of ticket to be developed according to counteracting processing result, and to the ticket to be developed Return of goods forms data generates credit note.
9. device according to claim 8, which is characterized in that the cancellation module includes:
Combining unit, for merging the positive forms data in the original data set;
Split cells, for splitting the return of goods forms data in the returning note data set;
Processing unit carries out counteracting processing for the returning note data set according to the original data set after merging and after splitting.
10. device according to claim 9, which is characterized in that the combining unit is further used for the positive odd number A positive forms data is merged into according to concentration, the positive forms data comprising identical commodity.
CN201711268421.2A 2017-12-05 2017-12-05 The generation method and device of credit note Pending CN109872198A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201711268421.2A CN109872198A (en) 2017-12-05 2017-12-05 The generation method and device of credit note

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201711268421.2A CN109872198A (en) 2017-12-05 2017-12-05 The generation method and device of credit note

Publications (1)

Publication Number Publication Date
CN109872198A true CN109872198A (en) 2019-06-11

Family

ID=66916478

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201711268421.2A Pending CN109872198A (en) 2017-12-05 2017-12-05 The generation method and device of credit note

Country Status (1)

Country Link
CN (1) CN109872198A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110473034A (en) * 2019-08-22 2019-11-19 携程旅游网络技术(上海)有限公司 Red punching method, system, electronic equipment and the medium of electronic invoice

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2006042703A2 (en) * 2004-10-20 2006-04-27 T-Mobile Deutschland Gmbh Method for a billing and shipping service
CN103093337A (en) * 2012-12-25 2013-05-08 远光软件股份有限公司 Data processing system capable of combining and separating payment records
CN103985205A (en) * 2014-05-30 2014-08-13 税友软件集团股份有限公司 Generation method, device and system of red-letter electronic invoices
CN106920136A (en) * 2015-12-28 2017-07-04 航天信息股份有限公司 The method that the special ticket of shipping is issued

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2006042703A2 (en) * 2004-10-20 2006-04-27 T-Mobile Deutschland Gmbh Method for a billing and shipping service
CN103093337A (en) * 2012-12-25 2013-05-08 远光软件股份有限公司 Data processing system capable of combining and separating payment records
CN103985205A (en) * 2014-05-30 2014-08-13 税友软件集团股份有限公司 Generation method, device and system of red-letter electronic invoices
CN106920136A (en) * 2015-12-28 2017-07-04 航天信息股份有限公司 The method that the special ticket of shipping is issued

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
谢振华: ""ERP 系统中的销售退货流程"", 《信息化运用》 *
谢振华: ""ERP系统中的销售退货流程"", 《信息化运用》 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110473034A (en) * 2019-08-22 2019-11-19 携程旅游网络技术(上海)有限公司 Red punching method, system, electronic equipment and the medium of electronic invoice

Similar Documents

Publication Publication Date Title
EP3353672B1 (en) Method and apparatus for transferring data between databases
US7940899B2 (en) Fraud detection, risk analysis and compliance assessment
US11062132B2 (en) System and method for identification of missing data elements in electronic documents
CN102567345A (en) Method and device for generating bookkeeping voucher
US20070156583A1 (en) Clearing receivables with improved search
CN104050543A (en) Event processing method in stream processing system and stream processing system
CN107274291A (en) Cross-platform valuation table analytic method, storage medium and application server
CN109829001A (en) For generating the method and device of invoice data
CN116561389A (en) Text matching method, device, equipment and storage medium
CN109872198A (en) The generation method and device of credit note
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
US20220318903A1 (en) Machine learning based prediction for multiple currency goals
CN115934515A (en) Internet financial business full-process testing method
US20230031111A1 (en) Scoring potential actions for machine learning based recommendations
CN107203506A (en) A kind of report form generation method and device
CN110765100B (en) Label generation method and device, computer readable storage medium and server
CN106204179A (en) For opening the method and system of single tax rate VAT invoice without amount of tax to be paid sales slip
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
CN106204173A (en) For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip
CN108268456A (en) A kind of method for establishing invoice database and the method for invoice in inquiry database
JP2021168087A (en) Information processing device and program
US10417488B2 (en) Re-application of filters for processing receipts and invoices
CN111563760A (en) Prediction method, medium, device and computing equipment of total volume of trades
CN109636275A (en) A kind of intelligent transport charging method and device
US20230137553A1 (en) Gradient based anomaly detection system for time series features

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: 20190611