CN108133352A - A kind of practical method made an inventory with account inventory variance in quick processing warehouse - Google Patents
A kind of practical method made an inventory with account inventory variance in quick processing warehouse Download PDFInfo
- Publication number
- CN108133352A CN108133352A CN201810134289.4A CN201810134289A CN108133352A CN 108133352 A CN108133352 A CN 108133352A CN 201810134289 A CN201810134289 A CN 201810134289A CN 108133352 A CN108133352 A CN 108133352A
- Authority
- CN
- China
- Prior art keywords
- inventory
- data
- product information
- adjustment
- account
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
Abstract
The invention discloses a kind of quick practical methods made an inventory with account inventory variance in processing warehouse, this method first imports the data of inventory list and cash statement, generate product information table, then data are extracted, the data of both inventory list and cash statement are compared, judge whether the two is consistent, if the two data are inconsistent, adjustment table is then generated, it is consistent according to both adjustment table adjustment.The present invention is in time adjusted account, the direct difference of the two is eliminated, so as to improve the accuracy and reliability of stock control by verifying physical holding of stock and the direct difference of book inventory.
Description
Technical field
The present invention relates to a kind of sides of warehouse stock counting in the technical field of production management more particularly to production management process
Method.
Background technology
Warehouse stock counting refers to check inventory etc., and common method has book method of making an inventory to make an inventory method with stock, frequently with
Machine make an inventory as tool, effect is integration to warehouse, concludes and inventory is checked, and is showed so that inventory is well understood
Shape.
Make an inventory be also classified into book make an inventory and stock make an inventory.Book is made an inventory also known as forever to continue and make an inventory, be exactly daily storage and
The quantity and unit price of outbound kinds of goods, are recorded on computer or account book, then constantly add up to add up the quantity in stock calculated on book
And inventory's amount of money.Stock is made an inventory also known as physical inventory or firm offer, is exactly actually to go to check the inventory in investigation warehouse, then according to
The method that kinds of goods unit price calculates the physical holding of stock amount of money.Domestic majority home-delivery center is used in both computer to handle inventory's account,
When difference occurs for book number and real storage number, it is sometimes difficult to conclude that book number is wrong or firm offer number is wrong.So it can adopt
The method for taking " book is made an inventory " parallel with " making an inventory from stock ", to investigate thoroughly the actual cause of error appearance.
With the development of technology, people gradually realize generation management using computer, simultaneously for the stock-taking in warehouse
Also it is carried out using intelligentized method, as patent application 201210311161.3 discloses a kind of warehouse stock counting method and warehouse disk
Dot system, the warehouse stock counting method include step：One data collector terminal is obtained from a server includes current library of making an inventory
Position and the one of the commodity plans of making an inventory of currently making an inventory；The data collector terminal is based on the plan of making an inventory, in current library of making an inventory
The stockpile number for commodity of currently making an inventory is acquired in position, and will be on the stockpile number and current time data of the current commodity of making an inventory
Reach the server.The warehouse stock counting system includes a server and a data collector terminal, and using as described above
Warehouse stock counting method.The present invention realizes that warehouse inventory is made an inventory parallel with warehouse homework, makes an inventory and is not interfere with each other with business, and makes an inventory
Data are more accurate.
Patent application 201310706608.1 discloses a kind of material depot check system.Wherein, which includes：It is mobile
Mechanism, for being moved in material depot, the mobile route of mobile mechanism is corresponding with predetermined deposit position collection, predetermined deposit position
Collection includes the predetermined deposit position of each in multiple goods and materials to be made an inventory in material depot；First sensor is arranged on shifting
On motivation structure, for mobile mechanism to be followed to sense each practical goods and materials stored of predetermined deposit position, and export with actually depositing
The corresponding identification signal of goods and materials put；Processor connects first sensor, for judging predetermined deposit position according to identification signal
Whether each predetermined deposit position concentrated has stored goods and materials to be made an inventory corresponding with each predetermined deposit position.The present invention solves
Problem caused by the existing mode manually made an inventory.
Patent application 201410457885.8 then discloses a kind of intelligent warehouse management system, it is characterised in that：Including number
According to center processor, terminating machine station and WEB server, the terminating machine station is connected with access control system, RFID read-write equipment, takes the photograph phase
Head, the DCP date central processor are communicated by network and WEB service and hand-held PDA.The present invention compared with prior art excellent
Putting is：Warehouse stock counting is accurate, efficient；Inventory information is grasped in real time for stock clerk to provide a convenient；It is adopted for warehouse item
Purchase provides foundation；Greatly improve working efficiency.
In above-mentioned patent application, accurately and rapidly made an inventory the inventory in warehouse using existing smart machine,
Then it has been found that in practical inventory procedure, due to a variety of causes such as losses, book inventory and physical holding of stock are often not
Symbol, it needs to be adjusted thus, to eliminate the direct difference of account.
Invention content
For shortcoming present in above-mentioned technology, the present invention provides that a kind of quick processing warehouse is practical to be made an inventory and account
The method of inventory variance, this method are in time adjusted account by verifying physical holding of stock and the direct difference of book inventory,
The direct difference of the two is eliminated, so as to improve the accuracy and reliability of stock control.
To achieve the above object, the invention is realized in this way.
A kind of practical method made an inventory with account inventory variance in quick processing warehouse, it is characterised in that this method is first by disk
The data of point table and cash statement are imported, and are generated product information table, data are then extracted, to both inventory list and cash statement
Data are compared, and judge whether the two is consistent, if the two data are inconsistent, generate adjustment table, according to adjustment table adjustment
The two is consistent.
Specifically, this method comprises the following steps：
101st, data are enumerated；By inventory list, cash statement, all products are set out according to the two；
102nd, data merge；Product in inventory list, cash statement is merged, forms new table, i.e. product information table；
103rd, product information is read；First product information, Article 2 product letter are read from product information table successively
The N articles product information of breath ...；
104th, comparison judges；According to the N articles first article of product information, Article 2 product information ... product information, difference
The data in inventory list, cash statement are read, inventory count, inventory are compared, judge whether the two is consistent,
105th, it adjusts；If inventory count is more than or less than inventory, illustrate that the two is inconsistent, tune is generated to this product
Integer (inventory count-inventory)；If it is 0, illustrate that the two is consistent, do not generate adjustment number, without adjustment.
Further, all adjustment number forms are single into adjustment, are adjusted according to the data in adjustment single pair inventory list.Due to
Data in cash statement are typically physical presence, correct, so, data in cash statement are not adjusted, just in inventory list
Data be adjusted.
The quick processing practical method made an inventory with account inventory variance in warehouse that the present invention is realized, by verifying actual library
Deposit with the direct difference of book inventory, account is adjusted in time, direct difference both is eliminated, so as to improve stock control
Accuracy and reliability.
Description of the drawings
Fig. 1, which is that the processing warehouse of the invention realized is practical, to be made an inventory and account inventory variance flow chart.
Specific embodiment
In order to more clearly state the present invention, the present invention is further described below in conjunction with the accompanying drawings.
Refering to Figure 1, the quick processing practical side to make an inventory with account inventory variance in warehouse realized for the present invention
Method, shown in figure, this method first imports the data of inventory list and cash statement, generates product information table, then extracts
Data compare the data of both inventory list and cash statement, judge whether the two is consistent, if the two data are inconsistent,
Adjustment table is then generated, it is consistent according to both adjustment table adjustment.
Specifically, this method comprises the following steps：
S1, product information is obtained；Obtain the product data in inventory list, cash statement；
S2, progress data are enumerated；By inventory list, cash statement, all products are set out according to the two；
S3, data merge；Product in inventory list, cash statement is merged, forms new table, i.e. product information table；Production
All corresponding quantity of product and product is included in product data sheet.
S4, product information is read；First product information, Article 2 product letter are read from product information table successively
The N articles product information of breath ...；
S5, comparison judge；According to the N articles first article of product information, Article 2 product information ... product information, read respectively
The data in inventory list, cash statement are taken, inventory count, inventory are compared, judge whether the two is consistent,
S6, it forms adjustment list and is adjusted；If inventory count is more than or less than inventory, illustrate that the two is inconsistent,
Adjustment number (inventory count-inventory) is generated to this product；If it is 0, both illustrate consistent, do not generate adjustment number, not into
Row adjustment.
By the product formation of adjustment in need adjust single, be adjusted according to the data in adjustment single pair inventory list.By
Data in cash statement are typically physical presence, correct, so, data in cash statement are not adjusted, just for inventory list
In data be adjusted.
The quick processing practical method made an inventory with account inventory variance in warehouse that the present invention is realized as a result, will pass through core
Real physical holding of stock and the direct difference of book inventory, are in time adjusted account, the direct difference of the two are eliminated, so as to improve
The accuracy and reliability of stock control.
Disclosed above is only several specific embodiments of the present invention, but the present invention is not limited to this, any ability
What the technical staff in domain can think variation should all fall into protection scope of the present invention.
Claims (4)
- A kind of 1. practical method made an inventory with account inventory variance in quick processing warehouse, it is characterised in that quick processing warehouse is practical The method made an inventory with account inventory variance, it is characterised in that this method first imports the data of inventory list and cash statement, Generate product information table, then extract data, the data of both inventory list and cash statement are compared, both judge whether one It causes, if the two data are inconsistent, generates adjustment table, it is consistent according to both adjustment table adjustment.
- 2. the practical method made an inventory with account inventory variance in quick processing warehouse according to claim 1, it is characterised in that Specifically, this method comprises the following steps：101st, data are enumerated；By inventory list, cash statement, all products are set out according to the two；102nd, data merge；Product in inventory list, cash statement is merged, forms new table, i.e. product information table；103rd, product information is read；First product information, Article 2 product information ... are read from product information table successively The N articles product information；104th, comparison judges；According to the N articles first article of product information, Article 2 product information ... product information, read respectively Data in inventory list, cash statement compare inventory count, inventory, judge whether the two is consistent,105th, it adjusts；If inventory count is more than or less than inventory, illustrate that the two is inconsistent, tune is generated to this product information Integer is adjusted.
- 3. the practical method made an inventory with account inventory variance in quick processing warehouse according to claim 2, it is characterised in that In 105 step, the adjustment number=inventory count-inventory.
- 4. the practical method made an inventory with account inventory variance in quick processing warehouse according to claim 3, it is characterised in that All adjustment number forms are single into adjustment, are adjusted according to the data in adjustment single pair inventory list.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810134289.4A CN108133352A (en) | 2018-02-09 | 2018-02-09 | A kind of practical method made an inventory with account inventory variance in quick processing warehouse |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810134289.4A CN108133352A (en) | 2018-02-09 | 2018-02-09 | A kind of practical method made an inventory with account inventory variance in quick processing warehouse |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108133352A true CN108133352A (en) | 2018-06-08 |
Family
ID=62430837
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810134289.4A Pending CN108133352A (en) | 2018-02-09 | 2018-02-09 | A kind of practical method made an inventory with account inventory variance in quick processing warehouse |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108133352A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110322192A (en) * | 2019-05-30 | 2019-10-11 | 苏宁云计算有限公司 | Account checking method and system for the physical holding of stock of electric business platform and logic inventory |
| CN112397181A (en) * | 2020-11-16 | 2021-02-23 | 深圳医智联科技有限公司 | Medical consumable management method and system |
| CN113496374A (en) * | 2020-04-08 | 2021-10-12 | 北京京东振世信息技术有限公司 | Data processing method and device |
| CN113592377A (en) * | 2021-06-17 | 2021-11-02 | 中核凯利(深圳)餐饮管理有限公司 | Efficient food material checking method, device and equipment for smart catering |
| CN113762827A (en) * | 2020-07-30 | 2021-12-07 | 北京京东振世信息技术有限公司 | Inventory difference hedging processing method and device |
| CN117236861A (en) * | 2023-11-16 | 2023-12-15 | 锦浪科技股份有限公司 | Inventory standing book monitoring method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1510603A (en) * | 2002-12-21 | 2004-07-07 | 鸿富锦精密工业（深圳）有限公司 | Inventory checking system and method |
| CN1598827A (en) * | 2003-09-20 | 2005-03-23 | 鸿富锦精密工业（深圳）有限公司 | Checking system and method of delivery man |
| CN105550846A (en) * | 2015-12-31 | 2016-05-04 | 中国外运广东有限公司 | Barcoded WMS based counting method |
| CN107341529A (en) * | 2017-07-05 | 2017-11-10 | 成都电科智联科技有限公司 | Intelligent warehouse management system and management method based on RFID |
-
2018
- 2018-02-09 CN CN201810134289.4A patent/CN108133352A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1510603A (en) * | 2002-12-21 | 2004-07-07 | 鸿富锦精密工业（深圳）有限公司 | Inventory checking system and method |
| CN1598827A (en) * | 2003-09-20 | 2005-03-23 | 鸿富锦精密工业（深圳）有限公司 | Checking system and method of delivery man |
| CN105550846A (en) * | 2015-12-31 | 2016-05-04 | 中国外运广东有限公司 | Barcoded WMS based counting method |
| CN107341529A (en) * | 2017-07-05 | 2017-11-10 | 成都电科智联科技有限公司 | Intelligent warehouse management system and management method based on RFID |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110322192A (en) * | 2019-05-30 | 2019-10-11 | 苏宁云计算有限公司 | Account checking method and system for the physical holding of stock of electric business platform and logic inventory |
| CN113496374A (en) * | 2020-04-08 | 2021-10-12 | 北京京东振世信息技术有限公司 | Data processing method and device |
| CN113762827A (en) * | 2020-07-30 | 2021-12-07 | 北京京东振世信息技术有限公司 | Inventory difference hedging processing method and device |
| CN113762827B (en) * | 2020-07-30 | 2023-11-07 | 北京京东振世信息技术有限公司 | Inventory difference hedging processing method and device |
| CN112397181A (en) * | 2020-11-16 | 2021-02-23 | 深圳医智联科技有限公司 | Medical consumable management method and system |
| CN113592377A (en) * | 2021-06-17 | 2021-11-02 | 中核凯利(深圳)餐饮管理有限公司 | Efficient food material checking method, device and equipment for smart catering |
| CN117236861A (en) * | 2023-11-16 | 2023-12-15 | 锦浪科技股份有限公司 | Inventory standing book monitoring method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108133352A (en) | A kind of practical method made an inventory with account inventory variance in quick processing warehouse | |
| CN102930420B (en) | Cigar mill RFID tobacco leaf management system and tobacco leaf management method | |
| CN101582121A (en) | Logistic information management system using RFID labels | |
| CN106056335A (en) | Intelligent asset management method | |
| CN103186842A (en) | Shop purchase-sell-stock management system and shop purchase-sell-stock management method | |
| CN101515352A (en) | Article anti-counterfeiting system combining radio frequency identification and two-dimension code | |
| CN103679473A (en) | Smart supermarket control method based on radio frequency identification system | |
| CN106126587A (en) | Multinode data based on flow process display recording mechanism | |
| CN110163705A (en) | Method and apparatus for pushed information | |
| CN108922025A (en) | Settle accounts method of payment, device, Intelligent cargo cabinet and server | |
| CN105589911A (en) | Customer value assessment method and system | |
| CN207020696U (en) | It is a kind of can display of commodity information data commodity shelf system | |
| CN105956810A (en) | Weighing manager | |
| CN109302214A (en) | With the price display system and its control method of function of making an inventory, equipment, medium | |
| CN104636805A (en) | Report data management server, report data management program, and report data management device | |
| CN104751234A (en) | User asset predicting method and device | |
| CN111325540A (en) | POS system based on block chain | |
| CN115344584A (en) | Logistics express delivery information real-time updating system based on big data | |
| CN107784753A (en) | A kind of voice playing device based on scanning machine | |
| CN202404617U (en) | Tracking anti-counterfeit system for brand clothing based on mobile RFID | |
| CN106204403A (en) | A kind of high efficiency logistic information management system based on Internet of Things | |
| CN109377143A (en) | Operation trace acquisition system, acquisition method, management system and management method | |
| CN207458248U (en) | Voice system on scanner | |
| CN107688974A (en) | A kind of method and system for being used to count goods browse amount under line | |
| CN106951452A (en) | The data query method and device reviewed for account |
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 | ||
| REG | Reference to a national code |
Ref country code: HK Ref legal event code: DE Ref document number: 1255364 Country of ref document: HK |
|
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180608 |
|
| RJ01 | Rejection of invention patent application after publication |