CN116561602B - Automatic sales material matching method for sales cost transfer - Google Patents

Automatic sales material matching method for sales cost transfer Download PDF

Info

Publication number
CN116561602B
CN116561602B CN202310834389.9A CN202310834389A CN116561602B CN 116561602 B CN116561602 B CN 116561602B CN 202310834389 A CN202310834389 A CN 202310834389A CN 116561602 B CN116561602 B CN 116561602B
Authority
CN
China
Prior art keywords
sales
matching
materials
data
purchased
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.)
Active
Application number
CN202310834389.9A
Other languages
Chinese (zh)
Other versions
CN116561602A (en
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.)
Three Gorges High Technology Information Technology Co ltd
Original Assignee
Three Gorges High Technology Information Technology Co ltd
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 Three Gorges High Technology Information Technology Co ltd filed Critical Three Gorges High Technology Information Technology Co ltd
Priority to CN202310834389.9A priority Critical patent/CN116561602B/en
Publication of CN116561602A publication Critical patent/CN116561602A/en
Application granted granted Critical
Publication of CN116561602B publication Critical patent/CN116561602B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F18/00—Pattern recognition
    • G06F18/20—Analysing
    • G06F18/22—Matching criteria, e.g. proximity measures
    • 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
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • 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
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02W—CLIMATE CHANGE MITIGATION TECHNOLOGIES RELATED TO WASTEWATER TREATMENT OR WASTE MANAGEMENT
    • Y02W90/00—Enabling technologies or technologies with a potential or indirect contribution to greenhouse gas [GHG] emissions mitigation

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Strategic Management (AREA)
  • General Physics & Mathematics (AREA)
  • Marketing (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Development Economics (AREA)
  • General Business, Economics & Management (AREA)
  • Economics (AREA)
  • Human Resources & Organizations (AREA)
  • Artificial Intelligence (AREA)
  • Quality & Reliability (AREA)
  • Bioinformatics & Computational Biology (AREA)
  • Evolutionary Computation (AREA)
  • Computer Vision & Pattern Recognition (AREA)
  • Life Sciences & Earth Sciences (AREA)
  • Operations Research (AREA)
  • Bioinformatics & Cheminformatics (AREA)
  • Tourism & Hospitality (AREA)
  • General Engineering & Computer Science (AREA)
  • Evolutionary Biology (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a method for automatically matching sales materials in sales cost transfer, which comprises the following steps: s1, basic data preparation: recording a purchased material list and a sales billing material list; s2, customizing a material list of purchase and a material matching field of a material list of sales invoices; s3, cleaning data of the purchased material list and the material list of the sales billing; s4, judging whether field information corresponding to the purchased materials and the sold materials after cleaning is all consistent or not based on a full-quantity matching method according to the material matching fields defined in the S2; and S5, displaying a matching result when the fact that all the field information corresponding to the purchased materials and the sold materials after cleaning are consistent is determined. The sale cost transfer time of the company is not limited by the code library, no sequence is needed, and the flexibility of the transfer time is improved; the related matching algorithm improves the work efficiency of the sales cost transfer, and can also reduce the error of artificial matching.

Description

Automatic sales material matching method for sales cost transfer
Technical Field
The invention relates to the technical field of sales and mining material matching, in particular to a sales and mining material automatic matching method for sales cost transfer.
Background
At present, commercial enterprises often have the situation that the purchasing name and the sales name of the same commodity are different, if a scattered knot transfer method is adopted to transfer the commodity sales cost, the corresponding cost and income of each sales commodity are required to be counted, and at the moment, the commodity which is sold and billed is required to be correspondingly matched with the purchased commodity.
At present, matching association is mostly carried out in the following two ways: 1. matching by tax categorization code: and inputting the invoices received during purchase into a system, inputting the invoices issued during sales into the system, and matching the same coded commodities through tax classification codes of the commodities in the two invoices. 2. Manually judging and manually matching: and manually inputting information of all commodities related to the enterprise, setting up a warehouse and a professional warehouse manager for maintenance and management, and manually judging and manually associating the commodities when the names of the same commodity are inconsistent with the names of the same commodity when the same commodity is purchased and sold.
The technical problems exist based on tax classification code matching: (1) at present, in a tax classification code database approved by the national tax administration, the condition that a plurality of tax classification codes of the same commodity exist, and companies for purchasing and billing and selling and billing are not the same, so that the matching mode effect of the purchase tax classification codes is not ideal, and the association relation of the tax classification codes is manually modified usually by human intervention. (2) For the purchase materials which have signed purchase contract but have not received invoice, there is no way to obtain tax classification code, so there is no way to match. Based on manual judgment, the manual matching mode has the following technical problems: the special personnel are required to maintain all the commodities involved in the enterprise, and more manpower and material resources are required to be input particularly when the enterprise establishes inventory management for the purpose. And when the commodity is various and the quantity is large, the manual judgment is carried out, and the manual matching mode has the error condition, so that the matching error is caused.
Disclosure of Invention
The present invention aims to solve, at least to some extent, one of the technical problems in the above-described technology. Therefore, the invention aims to provide a method for automatically matching sales materials for transferring sales cost, which is not based on a commodity coding database owned by a company and does not depend on a tax classification coding database verified by a national tax administration, so that the transfer time of the sales cost of the company is not limited by the coding database, no sequence is needed, and the flexibility of the transfer time is improved; the related matching algorithm can be automatically realized through a program, specialized warehouse management personnel are not required to be set by enterprises, data matching is not required to be carried out manually one by one, verification is only required to be carried out finally, the work efficiency of the sales cost transfer is improved, and errors of manual matching can be reduced.
In order to achieve the above objective, the embodiment of the present invention provides a method for automatically matching sales materials for transferring sales costs, including:
s1, basic data preparation: recording a purchased material list and a sales billing material list;
s2, customizing a material list of purchase and a material matching field of a material list of sales invoices;
s3, cleaning data of the purchased material list and the sold and invoiced material list to obtain cleaned purchased materials and sold materials;
s4, judging whether field information corresponding to the purchased materials and the sold materials after cleaning is all consistent or not based on a full-quantity matching method according to the material matching fields defined in the S2;
s5, displaying a matching result when the fact that all the field information corresponding to the purchased materials and the sold materials after cleaning are consistent is determined;
the purchased material list and the material list for selling and billing comprise field information; the field information comprises commodity names, specifications, models, brands and input time;
when the field information corresponding to the purchased goods and the sold goods after cleaning is not all consistent, calculating and displaying a matching result based on a character removal matching method and a weight ratio model;
based on the break-word character matching method and the weight duty ratio model, calculating a matching result comprises the following steps:
determining data to be matched, and judging a character breaking character of commodity names in the data to be matched;
comparing the commodity name length of the sales materials in the data to be matched with the commodity name length of the purchase materials in the data to be matched, and taking the value with larger length as A;
determining the type of the material with larger length as the material to be disassembled; the material type with smaller length is used as the material to be matched;
performing character-by-character disassembly on commodity names of materials to be disassembled, after disassembly is completed, circularly traversing to match the commodity names in the materials to be matched by using single disassembled characters, and if the commodity names of the materials to be matched contain the disassembled characters, successfully matching the number of single characters by +1; recording the number of successfully matched words as B, and recording the number of successfully matched words as B=0, wherein the number of successfully matched words is B=B+1 once;
after traversing, calculating the commodity name matching rate C1 of the corresponding material to be matched, wherein the calculation formula is as follows: c1 = (B/a) 100%;
according to the same method, matching calculation is sequentially carried out on other fields in the user definition to obtain corresponding matching rates C2 and C3..
The weight duty ratio model distributes respective duty ratio coefficients of the custom fields in the final comprehensive calculation, and the comprehensive matching rate is calculated according to the duty ratio coefficients and the corresponding matching rate;
and determining the materials to be matched with the highest comprehensive matching rate, establishing a matching relation with the materials to be disassembled, and determining a matching result.
According to some embodiments of the invention, the means for entering the purchased goods list and the sales invoices goods list comprises at least one of automated OCR entry, electronic document scan conversion entry, manual entry.
According to some embodiments of the present invention, when customizing the material matching fields of the purchased material list and the material list of the sales order, the commodity name and the brand are necessary options, and at least one of the specification and the model is selected.
According to some embodiments of the invention, step S3 comprises:
respectively determining a purchase material table YDC and a sales material table YDX according to the purchased material list and the sales billing material list; in the determining process, a unique primary key code is automatically created and generated for commodity materials: the coding rule of the purchase material table YDC is YDC+automatic number, and the coding rule of the sales material table YDX is YDX+automatic number;
cleaning corresponding data in the purchase material table YDC and the sales material table YDX according to the self-defined material matching field;
and (3) correspondingly taking the cleaned purchased material table YDC as a purchased material table QDC, correspondingly taking the cleaned sales material table YDX as a sales material table QDX, and keeping the unique primary key codes of the commodity materials corresponding to the purchased material table QDC and the sales material table QDX unchanged.
According to some embodiments of the present invention, cleaning corresponding data in the procurement materials table YDC includes:
adopting a replacement method for the corresponding data, and replacing the blank and the special symbol with a blank; special symbols include "-, ×, -, II, Φ, x, μ, chinese and english brackets";
after the replacement is completed, the lower case letters in the corresponding data are uniformly converted into lower case letters by adopting a conversion mode.
According to some embodiments of the invention, displaying the matching result includes:
according to the unique primary key code of the commodity materials, determining a purchasing material table YDC and a selling material table YDX which correspond to the purchasing material table QDC and the selling material table QDX respectively;
and establishing a matching relation according to the purchase material table YDC and the sales material table YDX, and displaying a sales material comparison table.
According to some embodiments of the invention, entering a list of purchased supplies includes:
determining a plurality of data types corresponding to the purchased material list; the data type comprises a text format, a picture format and a sound format;
selecting a data extraction model corresponding to the data types to extract data, and determining key data corresponding to each data type;
carrying out data integration on key data corresponding to each data type, and determining a plurality of data strips to be recorded;
determining characteristic information of the data strip to be input, and determining a target input template according to the characteristic information; the target entry template comprises fields and example contents corresponding to each field;
the data bar to be input is input to the position of the corresponding field of the target input template;
in the recording process, determining the detection content of a first field, calculating the semantic distance value of the detection content and the example content corresponding to the first field, recording the next field when the semantic distance value is smaller than the preset semantic distance value, and determining the hash value of the detection content of the first field;
when the input of the next field is executed, a hash value of the content to be input is obtained from the data bar to be input, whether the hash value of the detected content of the first field is consistent with the hash value of the detected content of the first field is judged, when the hash value of the detected content of the first field is consistent with the hash value of the detected content of the first field, the content to be input is skipped, and the target content is obtained again from the data bar to be input;
after all the data bars to be input are input into the target input template, a filling input template is obtained;
and reading the filling input template based on a preset reading model, reading out standard data according to a sequence rule, and sorting.
The invention provides a method for automatically matching sales materials for transferring sales cost, which is not based on a commodity coding library owned by a company and does not depend on a tax classification coding database verified by a national tax administration, so that the transfer time of the sales cost of the company is not limited by the coding library, no sequence is needed, and the flexibility of the transfer time is improved; the related matching algorithm can be automatically realized through a program, specialized warehouse management personnel are not required to be set by enterprises, data matching is not required to be carried out manually one by one, verification is only required to be carried out finally, the work efficiency of the sales cost transfer is improved, and errors of manual matching can be reduced.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention may be realized and attained by the structure particularly pointed out in the written description and drawings.
The technical scheme of the invention is further described in detail through the drawings and the embodiments.
Drawings
The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate the invention and together with the embodiments of the invention, serve to explain the invention. In the drawings:
FIG. 1 is a flow chart of a method for automatic matching of sales materials for a sales cost tie-down in accordance with one embodiment of the present invention;
FIG. 2 is a flow chart of a method of data cleaning of a purchased goods list and a sales listing goods list in accordance with one embodiment of the invention;
fig. 3 is a flow chart of a method of cleaning corresponding data in a procurement materials table YDC according to one embodiment of the invention.
Detailed Description
The preferred embodiments of the present invention will be described below with reference to the accompanying drawings, it being understood that the preferred embodiments described herein are for illustration and explanation of the present invention only, and are not intended to limit the present invention.
As shown in fig. 1, the embodiment of the invention provides a method for automatically matching sales materials with sales costs, which comprises the following steps of:
s1, basic data preparation: recording a purchased material list and a sales billing material list;
s2, customizing a material list of purchase and a material matching field of a material list of sales invoices;
s3, cleaning data of the purchased material list and the sold and invoiced material list to obtain cleaned purchased materials and sold materials;
s4, judging whether field information corresponding to the purchased materials and the sold materials after cleaning is all consistent or not based on a full-quantity matching method according to the material matching fields defined in the S2;
and S5, displaying a matching result when the fact that all the field information corresponding to the purchased materials and the sold materials after cleaning are consistent is determined.
The working principle of the technical scheme is as follows: in this embodiment, the purchased goods list and the goods list of sales invoices are used as the original data sets of purchased goods and sales goods.
In this embodiment, the material list includes, but is not limited to, information of fields such as commodity name, specification, model, brand, and recording time.
In this embodiment, the material matching fields are commodity name, specification, and brand.
In the embodiment, the purchased material list and the material list of the sales invoices are subjected to data cleaning, so that the consistency of the forms of the corresponding fields is realized, and the corresponding fields are conveniently compared.
In this embodiment, the full-scale matching method is an algorithm based on which the corresponding fields are aligned as a whole.
In this embodiment, when customizing the material matching fields of the purchased material list and the material list of the sales billing, the enterprise self-defines and selects the fields to be matched according to the self-situation and the requirement information, including but not limited to information such as commodity name, specification, model, brand, input time, etc.
The beneficial effects of the technical scheme are that: the method is not based on a commodity coding library owned by a company, does not depend on a tax classification coding database approved by the national tax administration, ensures that the sale cost transfer time of the company is not limited by the coding library, does not need to have a sequence, and improves the flexibility of the transfer time; the related matching algorithm can be automatically realized through a program, specialized warehouse management personnel are not required to be set by enterprises, data matching is not required to be carried out manually one by one, verification is only required to be carried out finally, the work efficiency of the sales cost transfer is improved, and errors of manual matching can be reduced.
According to some embodiments of the invention, the purchased goods list and the sales invoices list include field information; the field information comprises commodity names, specifications, models, brands and input time.
According to some embodiments of the invention, the means for entering the purchased goods list and the sales invoices goods list comprises at least one of automated OCR entry, electronic document scan conversion entry, manual entry.
According to some embodiments of the present invention, when customizing the material matching fields of the purchased material list and the material list of the sales order, the commodity name and the brand are necessary options, and at least one of the specification and the model is selected.
The beneficial effects of the technical scheme are that: the matching direction is accurately determined based on the commodity name and brand as necessary options, and the more accurate matching direction is determined based on at least one of the specification and the model, so that the accuracy of determining the matching of the purchased material list and the material list for selling and opening tickets is improved.
As shown in fig. 2, step S3, according to some embodiments of the invention, includes steps S31-S33:
s31, respectively determining a purchased material list YDC and a sales material list YDX according to the purchased material list and the sales billing material list; in the determining process, a unique primary key code is automatically created and generated for commodity materials: the coding rule of the purchase material table YDC is YDC+automatic number, and the coding rule of the sales material table YDX is YDX+automatic number;
s32, cleaning corresponding data in the purchased material table YDC and the sales material table YDX according to the self-defined material matching field;
s33, the cleaned purchased material table YDC is corresponding to the purchased material table QDC, the cleaned sales material table YDX is corresponding to the sales material table QDX, and the unique primary key codes of the commodity materials corresponding to the purchased material table QDC and the sales material table QDX are unchanged.
The working principle of the technical scheme is as follows: in this embodiment, the coding of each commodity material is determined based on the relation between the data management rate and the clear data of the purchased material list and the sales billing material list, which are coded for the purchased material list YDC and the sales material list YDX. For example, the purchase materials table YDC is coded as YDX001, and the sales materials table YDX is coded as YDX001.
In this embodiment, the procurement materials table QDC and the sales materials table QDX represent data tables including the same field, and the contents in the fields are identical in form.
Exemplary, as shown in table 1:
TABLE 1
In this embodiment, the corresponding data in the purchase material table YDC and the sales material table YDX are cleaned, so that special symbols, spaces and the like are removed conveniently, and simultaneously, the consistency of the large letter and the small letter is realized conveniently, so that the consistency of the field forms is realized conveniently.
The beneficial effects of the technical scheme are that: the method is convenient for realizing the data coding of the purchasing material table QDC and the selling material table QDX, and meanwhile, the consistency of field information forms is realized, so that the comparison is convenient, and the problem of inaccurate matching caused by form problems is avoided.
As shown in fig. 3, according to some embodiments of the present invention, the cleaning of the corresponding data in the purchased goods table YDC includes steps S321-S322:
s321, replacing corresponding data by a replacement method, and replacing blank spaces and special symbols by blank spaces; special symbols include "-, ×, -, II, Φ, x, μ, chinese and english brackets";
s322, after replacement is completed, the lower case letters in the corresponding data are uniformly converted into lower case letters by adopting a conversion mode.
The beneficial effects of the technical scheme are that: the consistency of the forms of the field information of the purchase material table QDC and the sales material table QDX is realized.
According to some embodiments of the invention, displaying the matching result includes:
according to the unique primary key code of the commodity materials, determining a purchasing material table YDC and a selling material table YDX which correspond to the purchasing material table QDC and the selling material table QDX respectively;
and establishing a matching relation according to the purchase material table YDC and the sales material table YDX, and displaying a sales material comparison table.
The working principle of the technical scheme is as follows: the unique primary key codes of the commodity materials are unchanged before and after the cleaning data, and the purchasing material table QDC and the selling material table QDX respectively corresponding to the purchasing material table YDC and the selling material table YDX are determined according to the unique primary key codes of the commodity materials; and establishing a matching relation according to the purchase material table YDC and the sales material table YDX, and displaying a sales material comparison table.
The beneficial effects of the technical scheme are that: automatic matching of the sales materials for the final transfer of the sales cost is realized.
In an embodiment, after the sales material comparison form is displayed, the sales material comparison form is sent to the detection terminal, verification can be performed manually based on the detection terminal, and manual intervention adjustment can be performed on wrong matching information.
According to some embodiments of the invention, when it is determined that the field information corresponding to the purchased goods and the sold goods after cleaning are not all consistent, a matching result is calculated and displayed based on a split character matching method and a weight ratio model.
The working principle of the technical scheme is as follows: in this embodiment, the comparison is made by partial character separation based on a split character matching method and a weight duty model representation.
The beneficial effects of the technical scheme are that: the matching of the cleaned purchased materials and the field information corresponding to the sold materials is realized when the field information is not all consistent.
According to some embodiments of the invention, calculating a matching result based on a break-word matching method and a weight-to-duty model includes:
determining data to be matched, and judging a character breaking character of commodity names in the data to be matched;
comparing the commodity name length of the sales materials in the data to be matched with the commodity name length of the purchase materials in the data to be matched, and taking the value with larger length as A; a=max (commodity name length of sales materials, commodity name length of purchase materials);
determining the type of the material with larger length as the material to be disassembled; the material type with smaller length is used as the material to be matched;
performing character-by-character disassembly on commodity names of materials to be disassembled, after disassembly is completed, circularly traversing to match the commodity names in the materials to be matched by using single disassembled characters, and if the commodity names of the materials to be matched contain the disassembled characters, successfully matching the number of single characters by +1; recording the number of successfully matched words as B, and recording the number of successfully matched words as B=0, wherein the number of successfully matched words is B=B+1 once;
after traversing, calculating the commodity name matching rate C1 of the corresponding material to be matched, wherein the calculation formula is as follows: c1 = (B/a) 100%;
according to the same method, matching calculation is sequentially carried out on other fields in the user definition to obtain corresponding matching rates C2 and C3..
The weight duty ratio model distributes respective duty ratio coefficients of the custom fields in the final comprehensive calculation, and the comprehensive matching rate is calculated according to the duty ratio coefficients and the corresponding matching rate;
and determining the materials to be matched with the highest comprehensive matching rate, establishing a matching relation with the materials to be disassembled, and determining a matching result.
The working principle of the technical scheme is as follows: in this embodiment, the data to be matched is the data that is not matched in step S4.
The materials to be disassembled are taken as sales materials, and the materials to be matched are taken as purchasing materials for illustration.
As shown in table 2, determining data to be matched;
TABLE 2
As shown in table 3, the sales material is matched with the purchase material 1 and the purchase material 2;
TABLE 3 Table 3
The matching method comprises the following steps: and determining the data to be matched, and judging the break character of the commodity name in the data to be matched.
And comparing the commodity name length of the sales materials with the commodity name length of the purchased materials, and taking a value with a larger length as A. [ namely: a=max (commodity name length of sales materials, commodity name length of purchase materials)
And (5) carrying out character-by-character disassembly on commodity names of the sales materials. After the disassembly is completed, circularly traversing the single disassembled character to match the commodity name in the purchased material, and if the commodity name of the purchased material contains the disassembled character, matching the number of the successfully matched single characters by +1. (note that the number of successfully matched words is B, original b=0, then success is b=b+1 at a time)
After traversing, calculating the commodity name matching rate (C1) of the corresponding purchased materials, wherein the calculation formula is as follows: c1 = (B/a) 100%;
according to the same method, matching calculation is sequentially carried out on other fields in the user definition, and corresponding matching rates C2 and C3..
The weight-to-duty model assigns the respective duty ratios of the custom fields in the final comprehensive calculation, assuming that the commodity name N1 duty ratio is D1, the specification N2 duty ratio is D2, the brand N3 duty ratio is D3..the field N duty ratio is DN, the final comprehensive matching rate d= (c1×d1+c2×d2+c3×d3.+ cn×dn) ×100% according to the duty model ratio. The original duty ratio model is proportionally divided into: commodity name is 50% and other matching fields average 50% in total.
D values of different purchased materials are compared, the purchased material with the highest matching rate is taken, and then a matching result is determined.
The beneficial effects of the technical scheme are that: based on the character disassembly matching method and the weight ratio model, the characters of each field are disassembled and compared, the local comparison is realized, and the comparison is more accurate.
In one embodiment, after calculating the matching result based on the break-word matching method and the weight duty ratio model, the method further comprises: and checking the matching result, and obtaining the accuracy of the model according to the checking result. The system automatically records the manually adjusted data, removes the influence factor data by normalization, and if the model accuracy is too low, carries out numerical fine adjustment on the commodity names and the weight proportion of other fields until the accuracy of the weight duty ratio model reaches the actual business standard of the enterprise, thereby realizing training and optimizing the weight duty ratio model.
According to some embodiments of the invention, entering a list of purchased supplies includes:
determining a plurality of data types corresponding to the purchased material list; the data type comprises a text format, a picture format and a sound format;
selecting a data extraction model corresponding to the data types to extract data, and determining key data corresponding to each data type;
carrying out data integration on key data corresponding to each data type, and determining a plurality of data strips to be recorded;
determining characteristic information of the data strip to be input, and determining a target input template according to the characteristic information; the target entry template comprises fields and example contents corresponding to each field;
the data bar to be input is input to the position of the corresponding field of the target input template;
in the recording process, determining the detection content of a first field, calculating the semantic distance value of the detection content and the example content corresponding to the first field, recording the next field when the semantic distance value is smaller than the preset semantic distance value, and determining the hash value of the detection content of the first field;
when the input of the next field is executed, a hash value of the content to be input is obtained from the data bar to be input, whether the hash value of the detected content of the first field is consistent with the hash value of the detected content of the first field is judged, when the hash value of the detected content of the first field is consistent with the hash value of the detected content of the first field, the content to be input is skipped, and the target content is obtained again from the data bar to be input;
after all the data bars to be input are input into the target input template, a filling input template is obtained;
and reading the filling input template based on a preset reading model, reading out standard data according to a sequence rule, and sorting.
The working principle of the technical scheme is as follows: in this embodiment, the key data is key information including purchased goods.
In the embodiment, the data integration comprises data summarization, and a plurality of data bars to be input are determined according to batch or time determination; the data strip to be input is a data packet with mixed content and non-uniform form.
In this embodiment, the characteristic information is the key information of the purchase batch and the recorded commodity corresponding to the data bar to be input.
In this embodiment, different goods correspond to different target entry templates.
In this embodiment, the fields include commodity name, specification, model number, and the like.
In this embodiment, the hash value of the detected content may be obtained based on the MD5 algorithm and the SHA-1 algorithm.
In this embodiment, the preset reading model may directly read the entire filling entry template.
In this embodiment, the order rule is the order of the individual fields.
In this embodiment, the standard data is formed data sorted in the order of the preset fields.
The beneficial effects of the technical scheme are that: carrying out data extraction on different data types based on the corresponding data extraction model, determining key data corresponding to each data type, realizing data integration, and further determining a plurality of data strips to be input; and determining a target entry template based on the characteristic information of the data strip to be entered, finishing the data in the data strip to be entered, eliminating repeated data, and filling correct data into corresponding fields of the template. In the filling process, judging whether the content of the corresponding field is correct, and recording the next field if the content of the corresponding field is correct. Meanwhile, in order to avoid repeated input, determining a hash value of the detection content of the first field; when the input of the next field is executed, a hash value of the content to be input is obtained from the data bar to be input, whether the hash value of the detected content of the first field is consistent with the hash value of the detected content of the first field is judged, when the hash value of the detected content of the first field is consistent with the hash value of the detected content of the first field, the content to be input is skipped, and the target content is obtained again from the data bar to be input; after all the data bars to be input are input into the target input template, a filling input template is obtained; and the data arrangement of the data bars to be input is realized based on the filling input template, and the efficiency and the effectiveness of data management are improved. And reading the filling input template based on a preset reading model, reading out standard data according to a sequence rule, and sorting. And furthermore, the required standard data is acquired, the standard data is recorded, the standard data is read based on the filling recording template, the time for determining the standard data is shortened, the quick recording is realized, and meanwhile, the recording accuracy is improved.
In one embodiment, the list of materials for which sales invoices are entered is consistent with the method of entering the list of purchased materials.
It will be apparent to those skilled in the art that various modifications and variations can be made to the present invention without departing from the spirit or scope of the invention. Thus, it is intended that the present invention also include such modifications and alterations insofar as they come within the scope of the appended claims or the equivalents thereof.

Claims (7)

1. A method for automatic matching of sales materials for a forward in sales costs, comprising:
s1, basic data preparation: recording a purchased material list and a sales billing material list;
s2, customizing a material list of purchase and a material matching field of a material list of sales invoices;
s3, cleaning data of the purchased material list and the sold and invoiced material list to obtain cleaned purchased materials and sold materials;
s4, judging whether field information corresponding to the purchased materials and the sold materials after cleaning is all consistent or not based on a full-quantity matching method according to the material matching fields defined in the S2;
s5, displaying a matching result when the fact that all the field information corresponding to the purchased materials and the sold materials after cleaning are consistent is determined;
the purchased material list and the material list for selling and billing comprise field information; the field information comprises commodity names, specifications, models, brands and input time;
when the field information corresponding to the purchased goods and the sold goods after cleaning is not all consistent, calculating and displaying a matching result based on a character removal matching method and a weight ratio model;
based on the break-word character matching method and the weight duty ratio model, calculating a matching result comprises the following steps:
determining data to be matched, and judging a character breaking character of commodity names in the data to be matched;
comparing the commodity name length of the sales materials in the data to be matched with the commodity name length of the purchase materials in the data to be matched, and taking the value with larger length as A;
determining the type of the material with larger length as the material to be disassembled; the material type with smaller length is used as the material to be matched;
performing character-by-character disassembly on commodity names of materials to be disassembled, after disassembly is completed, circularly traversing to match the commodity names in the materials to be matched by using single disassembled characters, and if the commodity names of the materials to be matched contain the disassembled characters, successfully matching the number of single characters by +1; recording the number of successfully matched words as B, and recording the number of successfully matched words as B=0, wherein the number of successfully matched words is B=B+1 once;
after traversing, calculating the commodity name matching rate C1 of the corresponding material to be matched, wherein the calculation formula is as follows: c1 = (B/a) 100%;
according to the same method, matching calculation is sequentially carried out on other fields in the user definition to obtain corresponding matching rates C2 and C3..
The weight duty ratio model distributes respective duty ratio coefficients of the custom fields in the final comprehensive calculation, and the comprehensive matching rate is calculated according to the duty ratio coefficients and the corresponding matching rate;
and determining the materials to be matched with the highest comprehensive matching rate, establishing a matching relation with the materials to be disassembled, and determining a matching result.
2. The method for automatic matching of sales materials for sale cost transfer of claim 1, wherein the manner of entering the purchased materials list and the sales invoices materials list includes at least one of automated OCR entry, electronic document scan conversion entry, manual entry.
3. The method for automatic matching of sales materials for balance of sales cost according to claim 1, wherein when the material matching fields of the purchased material list and the material list for sales billing are customized, the commodity name, brand are at least one of necessary options, specifications and models.
4. The method for automatic matching of sales materials with the balance of sales costs according to claim 1, wherein step S3 includes:
respectively determining a purchase material table YDC and a sales material table YDX according to the purchased material list and the sales billing material list; in the determining process, a unique primary key code is automatically created and generated for commodity materials: the coding rule of the purchase material table YDC is YDC+automatic number, and the coding rule of the sales material table YDX is YDX+automatic number;
cleaning corresponding data in the purchase material table YDC and the sales material table YDX according to the self-defined material matching field;
and (3) correspondingly taking the cleaned purchased material table YDC as a purchased material table QDC, correspondingly taking the cleaned sales material table YDX as a sales material table QDX, and keeping the unique primary key codes of the commodity materials corresponding to the purchased material table QDC and the sales material table QDX unchanged.
5. The method for automatic matching of sales materials with sales costs forwarded according to claim 4, wherein the cleaning of the corresponding data in the purchased materials table YDC includes:
adopting a replacement method for the corresponding data, and replacing the blank and the special symbol with a blank; special symbols include "-, ×, -, II, Φ, x, μ, chinese and english brackets";
after the replacement is completed, the lower case letters in the corresponding data are uniformly converted into lower case letters by adopting a conversion mode.
6. The method for automatic matching of sales materials with a return of sales costs according to claim 4, wherein displaying the matching result includes:
according to the unique primary key code of the commodity materials, determining a purchasing material table YDC and a selling material table YDX which correspond to the purchasing material table QDC and the selling material table QDX respectively;
and establishing a matching relation according to the purchase material table YDC and the sales material table YDX, and displaying a sales material comparison table.
7. The method for automatic matching of sales materials for a forward in sales cost of claim 1, wherein entering a list of purchased materials comprises:
determining a plurality of data types corresponding to the purchased material list; the data type comprises a text format, a picture format and a sound format;
selecting a data extraction model corresponding to the data types to extract data, and determining key data corresponding to each data type;
carrying out data integration on key data corresponding to each data type, and determining a plurality of data strips to be recorded;
determining characteristic information of the data strip to be input, and determining a target input template according to the characteristic information; the target entry template comprises fields and example contents corresponding to each field;
the data bar to be input is input to the position of the corresponding field of the target input template;
in the recording process, determining the detection content of a first field, calculating the semantic distance value of the detection content and the example content corresponding to the first field, recording the next field when the semantic distance value is smaller than the preset semantic distance value, and determining the hash value of the detection content of the first field;
when the input of the next field is executed, a hash value of the content to be input is obtained from the data bar to be input, whether the hash value of the detected content of the first field is consistent with the hash value of the detected content of the first field is judged, when the hash value of the detected content of the first field is consistent with the hash value of the detected content of the first field, the content to be input is skipped, and the target content is obtained again from the data bar to be input;
after all the data bars to be input are input into the target input template, a filling input template is obtained;
and reading the filling input template based on a preset reading model, reading out standard data according to a sequence rule, and sorting.
CN202310834389.9A 2023-07-10 2023-07-10 Automatic sales material matching method for sales cost transfer Active CN116561602B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310834389.9A CN116561602B (en) 2023-07-10 2023-07-10 Automatic sales material matching method for sales cost transfer

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310834389.9A CN116561602B (en) 2023-07-10 2023-07-10 Automatic sales material matching method for sales cost transfer

Publications (2)

Publication Number Publication Date
CN116561602A CN116561602A (en) 2023-08-08
CN116561602B true CN116561602B (en) 2023-09-19

Family

ID=87488315

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310834389.9A Active CN116561602B (en) 2023-07-10 2023-07-10 Automatic sales material matching method for sales cost transfer

Country Status (1)

Country Link
CN (1) CN116561602B (en)

Citations (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103093358A (en) * 2012-12-10 2013-05-08 腾讯科技（上海）有限公司 Electronic bill processing method and terminal
CN103646309A (en) * 2013-12-04 2014-03-19 广东创能科技有限公司 Ticket clearing system and method
CN106603389A (en) * 2014-11-24 2017-04-26 腾讯科技（深圳）有限公司 Virtual bill transfer method and device
CN106652159A (en) * 2016-10-20 2017-05-10 杨存岩 Intelligent digital ticket identification instrument
JP2017215710A (en) * 2016-05-31 2017-12-07 株式会社リコー Information processing device, program, and information processing method
CN107784418A (en) * 2016-11-14 2018-03-09 平安科技（深圳）有限公司 List data distribution method and device
CN107844830A (en) * 2016-12-08 2018-03-27 上海兆芯集成电路有限公司 Neutral net unit with size of data and weight size mixing computing capability
CN108520401A (en) * 2018-04-08 2018-09-11 深圳乐信软件技术有限公司 User list management method, device, platform and storage medium
CN108960223A (en) * 2018-05-18 2018-12-07 北京大账房网络科技股份有限公司 The method for automatically generating voucher based on bill intelligent recognition
CN109766778A (en) * 2018-12-19 2019-05-17 平安科技（深圳）有限公司 Invoice information input method, device, equipment and storage medium based on OCR technique
CN113627438A (en) * 2021-08-09 2021-11-09 三峡高科信息技术有限责任公司 Method and system for automatically reimbursing travel expenses based on bill recognition and configuration engine
JP2022013524A (en) * 2020-06-30 2022-01-18 Ａｒｉｔｈｍｅｒ株式会社 Form information generation apparatus, method, and program
JP2022178309A (en) * 2021-05-20 2022-12-02 富士フイルムビジネスイノベーション株式会社 Information processing device and information processing program
WO2023076754A1 (en) * 2021-10-29 2023-05-04 Oracle International Corporation Deep learning techniques for extraction of embedded data from documents

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP1346559A4 (en) * 2000-11-16 2006-02-01 Mydtv Inc System and methods for determining the desirability of video programming events
US8698896B2 (en) * 2012-08-06 2014-04-15 Cloudparc, Inc. Controlling vehicle use of parking spaces and parking violations within the parking spaces using multiple cameras

Patent Citations (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103093358A (en) * 2012-12-10 2013-05-08 腾讯科技（上海）有限公司 Electronic bill processing method and terminal
CN103646309A (en) * 2013-12-04 2014-03-19 广东创能科技有限公司 Ticket clearing system and method
CN106603389A (en) * 2014-11-24 2017-04-26 腾讯科技（深圳）有限公司 Virtual bill transfer method and device
JP2017215710A (en) * 2016-05-31 2017-12-07 株式会社リコー Information processing device, program, and information processing method
CN106652159A (en) * 2016-10-20 2017-05-10 杨存岩 Intelligent digital ticket identification instrument
CN107784418A (en) * 2016-11-14 2018-03-09 平安科技（深圳）有限公司 List data distribution method and device
CN107844830A (en) * 2016-12-08 2018-03-27 上海兆芯集成电路有限公司 Neutral net unit with size of data and weight size mixing computing capability
CN108520401A (en) * 2018-04-08 2018-09-11 深圳乐信软件技术有限公司 User list management method, device, platform and storage medium
CN108960223A (en) * 2018-05-18 2018-12-07 北京大账房网络科技股份有限公司 The method for automatically generating voucher based on bill intelligent recognition
CN109766778A (en) * 2018-12-19 2019-05-17 平安科技（深圳）有限公司 Invoice information input method, device, equipment and storage medium based on OCR technique
JP2022013524A (en) * 2020-06-30 2022-01-18 Ａｒｉｔｈｍｅｒ株式会社 Form information generation apparatus, method, and program
JP2022178309A (en) * 2021-05-20 2022-12-02 富士フイルムビジネスイノベーション株式会社 Information processing device and information processing program
CN113627438A (en) * 2021-08-09 2021-11-09 三峡高科信息技术有限责任公司 Method and system for automatically reimbursing travel expenses based on bill recognition and configuration engine
WO2023076754A1 (en) * 2021-10-29 2023-05-04 Oracle International Corporation Deep learning techniques for extraction of embedded data from documents

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
大型建筑企业票据集中管理优化研究—中铁建A局为例;张成;《中国建设会计学会第十五次（2022年度）论文集》;1-8 *

Also Published As

Publication number Publication date
CN116561602A (en) 2023-08-08

Similar Documents

Publication Publication Date Title
CN109887153B (en) Finance and tax processing method and system
US7840890B2 (en) Generation of randomly structured forms
US20200285805A1 (en) Systems and methods for user interfaces that provide enhanced verification of extracted data
US5668990A (en) Apparatus and method for generating 100% United States Postal Service bar coded lists
CN108960223A (en) The method for automatically generating voucher based on bill intelligent recognition
JP6504514B1 (en) Document classification system and method and accounting system and method.
CN112801041A (en) Financial data reimbursement method, device, equipment and storage medium
CN116433052B (en) Intelligent bidding information acquisition data analysis and evaluation system
CN117036073B (en) Invoice auditing and automatic reimbursement system based on Internet
CN111199222A (en) Bill management method and electronic equipment
CN112001173A (en) Dispatching code management method and device, terminal equipment and storage medium
CN113360768A (en) Product recommendation method, device and equipment based on user portrait and storage medium
CN108335087A (en) Value-added tax invoice for sales data statistical approach based on EXCEL and device
CN114612905A (en) Invoice processing method, device, equipment and medium based on RPA and AI
CN116561602B (en) Automatic sales material matching method for sales cost transfer
CN114723492A (en) Enterprise portrait generation method and equipment
CN114328495A (en) Enterprise material cleaning service system and data cleaning method thereof
JP6151560B2 (en) Accounting book information processing apparatus, accounting book information processing apparatus control method, accounting book processing apparatus program, and recording medium
CN111768565B (en) Method for identifying and post-processing invoice codes in value-added tax invoices
CN107563689A (en) Use bar code management system and method
CN111967246A (en) Error correction method for shopping bill recognition result
US20140236347A1 (en) Method of processing mailpieces with digital models of running mailpieces being generated on an interactive terminal
WO2022029874A1 (en) Data processing device, data processing method, and data processing program
CN113962205A (en) Method and device for pasting spreadsheet contents, electronic equipment and storage medium
US11475026B2 (en) Value discrepancy visualization apparatus and method thereof

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