CN109656953A - A kind of retail data automatic inspection system - Google Patents

A kind of retail data automatic inspection system Download PDF

Info

Publication number
CN109656953A
CN109656953A CN201811417092.8A CN201811417092A CN109656953A CN 109656953 A CN109656953 A CN 109656953A CN 201811417092 A CN201811417092 A CN 201811417092A CN 109656953 A CN109656953 A CN 109656953A
Authority
CN
China
Prior art keywords
data
automatic inspection
inspection
processing routine
check
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
CN201811417092.8A
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.)
Shanghai Amit Data System Co Ltd
Original Assignee
Shanghai Amit Data System 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 Shanghai Amit Data System Co Ltd filed Critical Shanghai Amit Data System Co Ltd
Priority to CN201811417092.8A priority Critical patent/CN109656953A/en
Publication of CN109656953A publication Critical patent/CN109656953A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G06Q10/0875Itemisation or classification of parts, supplies or services, e.g. bill of materials

Landscapes

  • Business, Economics & Management (AREA)
  • Economics (AREA)
  • Engineering & Computer Science (AREA)
  • Marketing (AREA)
  • Quality & Reliability (AREA)
  • Finance (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Accounting & Taxation (AREA)
  • Operations Research (AREA)
  • Development Economics (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a kind of retail data automatic inspection systems, including automatic inspection of data system, the upper layer of the automatic inspection of data system is provided with database, the automatic inspection of data system includes automatic inspection of data main program, data inspection processing routine, input module, logging modle, data application platform and log recording center, the lower layer of the automatic inspection of data main program is connected with data and checks processing routine, the data check that processing routine is connected with data application platform, and the lower layer of the data application platform is connected with log recording center.The retail data automatic inspection system, can setting general-purpose check item and rule, and each retailer's special examined item and rule, automatically inspection judgement is carried out to merchant data, the prompt that reports an error is had when noting abnormalities, part checks after can safeguarding or correct by artificial supplementation, can check again for, and is conducive to avoid mistake to look into and appearance the case where under-enumeration.

Description

A kind of retail data automatic inspection system
Technical field
The present invention relates to a kind of automatic inspection of data systems, more particularly to carry out check item and rule to each merchant data Then it is arranged, and executes the system automaticly inspected;Moreover, it relates to automaticly inspect the implementation method of data system.
Background technique
Currently, zero is all by all kinds of document operations, such as order, receiving note, returning note zero for the business contact of both sides It sells quotient and is opened in the document content that website is checked to supplier, especially merchandise news part, although marching into the arena it in the commodity It is preceding to purchase the data provided from supplier business personnel to retailer, but may malfunction in maintenance process, also or the later period passes through Adjustment, modifies wrong, and daily contact document (especially order) is caused to occur mistake, supplier in order to ensure document information just Really, it needs manually to check document information, the scope of examination includes but is not limited to commodity, unit, specification, unit price, the amount of money, folding Button, the tax rate, order validity period etc., there are also the inspection of some particular service rules, such as minimum inducement, all check items by Artificial treatment, project is more, and each retailer's check item disunity, is easy under-enumeration or misjudgement;
Due to more than retailer and document amount is larger, and check item is more, by the work of artificial judgment inspection, needs personnel Be perfectly clear each retailer's document content and business need, and treatment effeciency is very low, by person works' experience or is familiar with journey The influence of degree, easy under-enumeration or error can bring puzzlement to subsequent delivery, reconciliation operation once slipping, may if serious It causes damages to enterprise, therefore, it is proposed that a kind of retail data automatic inspection system, in order to which solve to propose among the above asks Topic.
Summary of the invention
The purpose of the present invention is to provide a kind of retail data automatic inspection systems, to solve above-mentioned background technique proposition At present due to more than retailer and document amount is larger, and check item is more, by the work of artificial judgment inspection, needs personnel very Clear each retailer's document content and business need, treatment effeciency is very low, by person works' experience or familiarity It influences, easy under-enumeration or error, once slipping, puzzlement can be brought to subsequent delivery, reconciliation operation, it may be to enterprise if serious The problem of industry causes damages.
To achieve the above object, the invention provides the following technical scheme: a kind of retail data automatic inspection system, including number According to automatic inspection system, the upper layer of the automatic inspection of data system is provided with database, the automatic inspection of data system packet Include automatic inspection of data main program, data check that processing routine, input module, logging modle, data application platform and log are remembered Record center, the lower layer of the automatic inspection of data main program are connected with data and check processing routine, and the data inspection handles journey Sequence is connected with data application platform, and the lower layer of the data application platform is connected with log recording center.
Preferably, it is in parallel with automatic inspection of data main program defeated to check that the upper layer of processing routine is also connected with for the data Enter module, and data check that the lower layer of processing routine also passes through logging modle and is connected with data application platform.
Preferably, successful data are converted in the data store internal storage, and will have converted data conveying by database The preparation of automatic inspection of data is carried out into automatic inspection of data system.
Preferably, the preparation of the automatic inspection of data comprises the steps of:
Step 1: the data that have converted of the data store internal storage are transmitted into the automatic inspection of data main program having been turned on, It is ready for automaticly inspecting for data;
Step 2: data are delivered to the inside that data check processing routine by the automatic inspection of data main program, are counted According to automaticly inspect.
Preferably, automaticly inspecting for the data comprises the steps of:
Step 1: by input module in advance by the Index for examination safeguarded, rule (comprising quantitative criteria, price standard, Amount of money standard, stock level, tax rate standard, discount rate standard) convey into data check processing routine in carry out data inspection make With;
Step 2: the data check that processing routine carries out automaticly inspecting for data using Index for examination, regular data, and Processing is automaticly inspected to various documents progress quantity, price, the amount of money, inventory, the tax rate, discount rate etc., while judging that data are It is no to meet;
Step 3: data check that processing routine judge the processing of data.
Preferably, the processing of the judgement data comprises the steps of:
Step 1: if the data check processing routine and judges the inspection result of processing data for " meeting ", by data and As a result it is directly presented to data application platform automatically;
Step 2: if the data check that processing routine judges the inspection result for handling data for " not meeting ", data are examined The reason of processing routine is not automatically inconsistent inspection is looked into be recorded in this data, after record, the data that " will not meet " with Reason is presented to data application platform together.
Preferably, after successfully data are presented in the data application platform, data content and abnormal cause will be presented as holding Row result record is input to log recording center, and is written in log sheet and carries out log recording, while single automatic inspection of data Task terminates.
It compared with prior art, can setting general-purpose inspection the beneficial effects of the present invention are: the retail data automatic inspection system Item and rule and each retailer's special examined item and rule are looked into, inspection judgement is carried out to merchant data automatically, is noted abnormalities Shi Huiyou reports an error prompt, and part checks after can safeguarding or correct by artificial supplementation, can check again for;
1. by database by switched data transmission into the inside of automatic inspection of data system, convenient for quickly direct Automaticly inspecting for data is carried out, and convenient for being convenient for the inspection of data by the timing of data input;
2. by input module, convenient for (including quantitative criteria, price standard, the amount of money by the Index for examination safeguarded, rule Standard, stock level, tax rate standard, discount rate standard) it conveys into progress data inspection use in data inspection processing routine, just In setting general-purpose check item and rule, conveniently adapts to all kinds of work and use, increase the practicability of the system, advantageously reduce under-enumeration Or the phenomenon that error, occurs;
3. checking that processing routine is not only convenient for carrying out quantity, price, the amount of money, inventory, the tax rate, folding to kind of document by data Button rate etc. automaticly inspects processing, and is able to use each retailer's special examined item and rule, carries out automatically to merchant data It checks judgement, convenient for presenting between the reason that reports an error by data, convenient for artificial supplementation maintenance amendment, advantageously ensures that data inspection Correctness advantageously reduces staff's operating pressure.
Detailed description of the invention
Fig. 1 is workflow schematic diagram of the present invention.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other Embodiment shall fall within the protection scope of the present invention.
Referring to Fig. 1, the present invention provides a kind of technical solution: a kind of retail data automatic inspection system, including data are certainly Dynamic inspection system, the upper layer of automatic inspection of data system are provided with database, and automatic inspection of data system includes that data are examined automatically Main program, data inspection processing routine, input module, logging modle, data application platform and log recording center are looked into, data are certainly The dynamic lower layer for checking main program is connected with data and checks that processing routine, data check that processing routine is connected with data application platform, The lower layer of data application platform is connected with log recording center.
Data check that the upper layer of processing routine is also connected with the input module in parallel with automatic inspection of data main program, and number Also pass through logging modle according to the lower layer for checking processing routine to be connected with data application platform, convenient for examining data by input module The input that processing routine check rule etc. is looked into, is convenient for checking use, and convenient for passing through logging modle to data inspection Inspection result in processing routine is recorded.
Successful data are converted in data store internal storage, and by database will be had converted data and be conveyed into data and examine automatically The preparation that system carries out automatic inspection of data is looked into, convenient for the transmission of data, and data can be saved, avoid accident In the case of occur data loss.
The preparation of automatic inspection of data comprises the steps of: step 1: data store internal storage has converted data biography It is input into the automatic inspection of data main program having been turned on, is ready for automaticly inspecting for data;Step 2: the main journey of automatic inspection of data Sequence by data be delivered to data check processing routine inside, carry out automaticly inspecting for data, be convenient for preparation into Row, consequently facilitating progress data automaticly inspect processing.
Automaticly inspecting for data comprises the steps of: step 1: by input module in advance by the Index for examination safeguarded, Rule (including quantitative criteria, price standard, amount of money standard, stock level, tax rate standard, discount rate standard) is conveyed and is examined into data It looks into and carries out data inspection use in processing routine;Step 2: data check that processing routine is carried out using Index for examination, regular data Data automaticly inspect, and automaticly inspect place to various documents progress quantity, price, the amount of money, inventory, the tax rate, discount rate etc. Reason, while judging whether data meet;Step 3: data check that processing routine judge the processing of data, convenient for in data Various indicator rules checked, and convenient for judging the situation that meets of Various types of data, convenient for guaranteeing data inspection department The accuracy of reason.
Judge that the processing of data comprises the steps of: step 1: if data check the inspection of processing routine judgement processing data As a result it is " not meeting ", then data and result is directly presented to data application platform automatically;Step 2: data inspection handles journey If sequence judges the inspection result for handling data for " meeting ", data check the reason of processing routine is not automatically inconsistent inspection record Into this data, after record, the data of " not meeting " and reason is presented to data application platform together, are not only convenient for The inspection of data is carried out, and the reason that do not meet of data can be judged, supplementary maintenance is carried out convenient for artificial, is conducive to subtract Low operating pressure is conducive to the quick inspection of data, and the under-enumeration or mistake that can be avoided data are looked into.
After successfully data are presented in data application platform, will present data content recorded as implementing result with abnormal cause it is defeated Enter to log recording center, and is written in log sheet and carries out log recording, and single automatic inspection of data task terminates, and is convenient for The inspection processing result of Various types of data collection is recorded, is inquired convenient for the later period, is convenient for the management of data.
Working principle: when using the retail data automatic inspection system, it is defeated data will to be had converted first with database It is sent into the preparation that automatic inspection of data system carries out automatic inspection of data, is passing through automatic inspection of data main program for data It is delivered to the inside that data check processing routine, carries out automaticly inspecting for data, and before automatic inspection of data processing, is passed through Input module in advance by the Index for examination safeguarded, rule (comprising quantitative criteria, price standard, amount of money standard, stock level, Tax rate standard, discount rate standard) it conveys into progress data inspection use in data inspection processing routine, consequently facilitating to all kinds of zero Sell data to be checked, avoid under-enumeration, at the same be conducive to save manpower, then data check processing routine using Index for examination, Regular data carries out automaticly inspecting for data, and carries out quantity, price, the amount of money, inventory, the tax rate, discount rate etc. to various documents Automaticly inspect processing, while judging whether data meet and handle data, if data check at processing routine judgement The inspection result for managing data is " meeting ", then data and result is directly presented to data application platform automatically, if data inspection Processing routine judges the inspection result for handling data for " not meeting ", then data check the original that processing routine is not automatically inconsistent inspection Because being recorded in this data, after record, the data of " not meeting " and reason are presented to data application platform together, from And it is convenient for the prompt that reports an error, in order to be safeguarded or corrected by artificial supplementation, in order to guarantee that the accuracy of data, data are answered After data successfully are presented with platform, data content and abnormal cause will be presented and be input in log recording as implementing result record The heart, and be written in log sheet and carry out log recording, while single automatic inspection of data task terminates, here it is the retail datas certainly The whole work process of inspection system is moved, the content being not described in detail in this specification belongs to professional and technical personnel in the field's public affairs The prior art known.
Although the present invention is described in detail referring to the foregoing embodiments, for those skilled in the art, It is still possible to modify the technical solutions described in the foregoing embodiments, or part of technical characteristic is carried out etc. With replacement, all within the spirits and principles of the present invention, any modification, equivalent replacement, improvement and so on should be included in this Within the protection scope of invention.

Claims (7)

1. a kind of retail data automatic inspection system, including automatic inspection of data system, it is characterised in that: the data are examined automatically The upper layer for looking into system is provided with database, and the automatic inspection of data system includes automatic inspection of data main program, data inspection Processing routine, input module, logging modle, data application platform and log recording center, the automatic inspection of data main program Lower layer be connected with data and check that processing routine, the data check that processing routine is connected with data application platform, the data The lower layer of application platform is connected with log recording center.
2. a kind of retail data automatic inspection system according to claim 1, it is characterised in that: the data inspection processing The upper layer of program is also connected with the input module in parallel with automatic inspection of data main program, and data check the lower layer of processing routine Also it is connected by logging modle with data application platform.
3. a kind of retail data automatic inspection system according to claim 1, it is characterised in that: the data store internal storage It deposits the successful data of conversion, and data will be had converted by database convey and carry out data into automatic inspection of data system and examine automatically The preparation looked into.
4. a kind of retail data automatic inspection system according to claim 3, it is characterised in that: the automatic inspection of data Preparation comprise the steps of:
Step 1: the data that have converted of the data store internal storage are transmitted into the automatic inspection of data main program having been turned on, and are prepared Carry out automaticly inspecting for data;
Step 2: data are delivered to the inside that data check processing routine by the automatic inspection of data main program, carry out data It automaticly inspects.
5. a kind of retail data automatic inspection system according to claim 4, it is characterised in that: the automatic inspection of the data It looks into and comprises the steps of:
Step 1: (including in advance quantitative criteria, price standard, the amount of money by the Index for examination safeguarded, rule by input module Standard, stock level, tax rate standard, discount rate standard) it conveys into progress data inspection use in data inspection processing routine;
Step 2: the data check that processing routine carries out automaticly inspecting for data using Index for examination, regular data, and to each Kind document progress quantity, price, the amount of money, inventory, the tax rate, discount rate etc. automaticly inspect processing, while judging whether data accord with It closes;
Step 3: data check that processing routine judge the processing of data.
6. a kind of retail data automatic inspection system according to claim 5, it is characterised in that: the place of the judgement data Reason comprises the steps of:
Step 1: if the data check that processing routine judges the inspection result for handling data for " meeting ", by data and result It is directly presented to data application platform automatically;
Step 2: if the data check processing routine judge processing data inspection result for " not meeting ", data inspection department The reason of reason program is not automatically inconsistent inspection is recorded in this data, after record, the data and reason that " will not meet " It is presented to data application platform together.
7. a kind of retail data automatic inspection system according to claim 6, it is characterised in that: the data application platform After data are presented in success, data content and abnormal cause will be presented as implementing result record and be input to log recording center, and Log recording is carried out in write-in log sheet, and single automatic inspection of data task terminates.
CN201811417092.8A 2018-11-26 2018-11-26 A kind of retail data automatic inspection system Pending CN109656953A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811417092.8A CN109656953A (en) 2018-11-26 2018-11-26 A kind of retail data automatic inspection system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811417092.8A CN109656953A (en) 2018-11-26 2018-11-26 A kind of retail data automatic inspection system

Publications (1)

Publication Number Publication Date
CN109656953A true CN109656953A (en) 2019-04-19

Family

ID=66111084

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811417092.8A Pending CN109656953A (en) 2018-11-26 2018-11-26 A kind of retail data automatic inspection system

Country Status (1)

Country Link
CN (1) CN109656953A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111338731A (en) * 2020-02-24 2020-06-26 腾讯科技(深圳)有限公司 Page display method and device, computer readable storage medium and computer equipment
CN112711584A (en) * 2021-01-08 2021-04-27 安徽希施玛数据科技有限公司 Data checking method, checking device, terminal equipment and readable storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101453359A (en) * 2007-12-06 2009-06-10 北京启明星辰信息技术股份有限公司 Database error information extracting method and system
US20130014106A1 (en) * 2011-07-05 2013-01-10 Fujitsu Limited Information processing apparatus, computer-readable medium storing information processing program, and management method
CN104217276A (en) * 2013-06-05 2014-12-17 上海宝信软件股份有限公司 Rule-based automatic auditing method and system
CN105808655A (en) * 2016-02-26 2016-07-27 广州品唯软件有限公司 Processing method, device and system for mass data anomaly checking

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101453359A (en) * 2007-12-06 2009-06-10 北京启明星辰信息技术股份有限公司 Database error information extracting method and system
US20130014106A1 (en) * 2011-07-05 2013-01-10 Fujitsu Limited Information processing apparatus, computer-readable medium storing information processing program, and management method
CN104217276A (en) * 2013-06-05 2014-12-17 上海宝信软件股份有限公司 Rule-based automatic auditing method and system
CN105808655A (en) * 2016-02-26 2016-07-27 广州品唯软件有限公司 Processing method, device and system for mass data anomaly checking

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111338731A (en) * 2020-02-24 2020-06-26 腾讯科技(深圳)有限公司 Page display method and device, computer readable storage medium and computer equipment
CN112711584A (en) * 2021-01-08 2021-04-27 安徽希施玛数据科技有限公司 Data checking method, checking device, terminal equipment and readable storage medium

Similar Documents

Publication Publication Date Title
US8165933B2 (en) Systems, methods, and computer program products for performing item level transaction processing
US7996312B1 (en) System and method for image based electronic check presentment
US20140310170A1 (en) System and Method for Back Office Processing of Banking Transactions Using Electronic Files
CN102542402B (en) Financial data processing method and system
CN109656953A (en) A kind of retail data automatic inspection system
KR101084440B1 (en) Automatic entry generation appartus and method thereof
CN108228736A (en) Data processing method, data processing system and computer readable storage medium
CN111340584A (en) Method, device, equipment and storage medium for determining fund side
CN111553137A (en) Report generation method and device, storage medium and computer equipment
CN111179104A (en) OCR image recognition-based automatic insurance claim settlement initial review method and system
CN110910232B (en) Financial reconciliation system and method
CN112417917A (en) Value-added tax invoice checking and deducting method and system
US20040098356A1 (en) Expert decision making system for the release and handling of supervised commercial imports
Ciprian-Costel Arguments on using computer-assisted audit techniques (Caat) and business intelligence to improve the work of the financial auditor
CN112257644A (en) Intelligent management system for commodity inventory of electronic commerce platform stores based on cloud computing
Itang Do small and medium enterprises optimally utilize computerized accounting systems internal controls? An empirical study
CN107657528A (en) A kind of business factoring management system of combination risk management
CN109584009B (en) Automatic matching system for website data
CN111640030B (en) Processing device, equipment and storage medium for insurance claim failure data
JP4045835B2 (en) Decision support method
CN114742563A (en) Automatic transaction wind control system
Immawan et al. Escalation proposal of supply chain management performance of oil and gas upstream industry in PT. XYZ by using SCOR model approach
CN113947465A (en) Cross-border electricity quotient declaration result checking and early warning method and device
JPS63282838A (en) Name collation processing system
US8108224B2 (en) Method and system of identifying potential under reporters to monitor compliance in reporting unclaimed property

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

Application publication date: 20190419

RJ01 Rejection of invention patent application after publication