WO2018000622A1 - Wms系统与erp系统的同步方法及系统 - Google Patents

Wms系统与erp系统的同步方法及系统 Download PDF

Info

Publication number
WO2018000622A1
WO2018000622A1 PCT/CN2016/100160 CN2016100160W WO2018000622A1 WO 2018000622 A1 WO2018000622 A1 WO 2018000622A1 CN 2016100160 W CN2016100160 W CN 2016100160W WO 2018000622 A1 WO2018000622 A1 WO 2018000622A1
Authority
WO
WIPO (PCT)
Prior art keywords
data information
reference table
wms
newly added
synchronization
Prior art date
Application number
PCT/CN2016/100160
Other languages
English (en)
French (fr)
Inventor
阮常铭
何永成
Original Assignee
乐视控股（北京）有限公司
乐视电子商务（北京）有限公司
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 乐视控股（北京）有限公司, 乐视电子商务（北京）有限公司 filed Critical 乐视控股（北京）有限公司
Publication of WO2018000622A1 publication Critical patent/WO2018000622A1/zh

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/903—Querying
    • 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
    • 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

Definitions

  • Embodiments of the present invention relate to the field of computer software systems, and in particular, to a method and system for synchronizing a WMS system and an ERP system.
  • ERP Enterprise Resource Planning
  • ERP is the order record
  • WMS is the outbound record
  • WMS will transfer data to ERP, but not all data is passed to ERP.
  • ERP is a special staff to first count the return quantity, and then upload the data to the ERP.
  • the data that ERP can obtain directly from WMS is only the simplest data, such as inter-warehouse transfer and delivery.
  • FIG. 1 is a flow chart of a synchronization method of a WMS system and an ERP system in the prior art.
  • the WMS system synchronizes part of the product information to the ERP system, and the remaining part of the product information needs to be uploaded to the ERP system by a dedicated staff member at a predetermined time.
  • the WMS system and the ERP system cannot be synchronized in time, which may lead to confusion of warehouse management and inconvenience to warehouse management.
  • the embodiment of the present invention provides a method for synchronizing a WMS system and an ERP system, including: at least one time in the i-th cycle, in a first aspect, the first embodiment of the present invention provides a method for synchronizing data between the WMS system and the ERP system.
  • the newly added data information of the WMS system and the newly added data information of the ERP system are used to generate at least one comparison information table; the at least one comparison information table is sequentially subjected to data statistics according to the comparison time until the new data information of the WMS system There is no difference between the newly added data information of the ERP system, and the ith reference table is generated by using the data information that is not statistically different; wherein, when i is equal to 1, the i-th reference table is used as the i-th synchronization reference table; When i is greater than 1, the i-th reference table is added to the i-th synchronization reference table to generate an i-th synchronization reference table; the i-th synchronization reference table is provided for querying synchronization between the WMS system and the ERP system data.
  • an embodiment of the present invention provides a synchronization system between a WMS system and an ERP system, including: an acquiring unit, configured to acquire and compare new data information of the WMS system and a new ERP system at least once in the i-th cycle.
  • the data information is generated to generate at least one comparison information table;
  • the statistical unit is configured to perform statistics on the at least one comparison information table according to the comparison time, until the newly added data information of the WMS system and the newly added data information of the ERP system.
  • a generating unit configured to generate an i-th reference table by using the data information that is not statistically different, wherein when i is equal to 1, the i-th reference table is used as the i-th synchronization reference table; when i is greater than 1st, the i-th reference table is added to the i-th synchronization reference table to generate an i-th synchronization reference table; and the i-th synchronization reference table is provided for querying synchronization data between the WMS system and the ERP system.
  • an embodiment of the present invention further provides a non-volatile computer storage medium storing computer executable instructions for performing synchronization of any one of the foregoing WMS systems and an ERP system of the present invention. method.
  • an embodiment of the present invention further provides an electronic device, including: at least one processor; and a memory; wherein the memory stores a program executable by the at least one processor, where the instruction is Executing at least one processor to enable the at least one processor to A method of synchronizing the WMS system and the ERP system of any of the above aspects of the present invention is performed.
  • an embodiment of the present invention further provides a computer program product, including at least one non-volatile computer storage medium having computer executable program code instructions stored therein,
  • the computer executable program code instructions are for performing the synchronization method of any of the above-described WMS systems and ERP systems of the present invention.
  • the synchronization method and the electronic device of the WMS warehouse management system and the ERP enterprise resource planning system use the daily comparison method to timely synchronize the data of the WMS warehouse management system and the ERP enterprise resource planning system, and can be organized.
  • the record management data avoids confusion and thus facilitates warehouse management.
  • FIG. 1 is a flow chart of a synchronization method of a WMS system and an ERP system in the prior art
  • FIG. 2 is a flow chart of an embodiment of a method for synchronizing a WMS system and an ERP system according to the present invention
  • FIG. 3 is a schematic structural diagram of an embodiment of a synchronization system of a WMS system and an ERP system according to the present invention
  • FIG. 4 is a schematic structural diagram of hardware of an electronic device for performing a method for synchronizing a WMS system and an ERP system according to an embodiment of the present invention.
  • obtaining new data information of the WMS system and adding new data information of the ERP system can be implemented by conventional means. This is not repeated in this embodiment.
  • the synchronization method between the WMS system and the ERP system includes:
  • the newly added data information generally includes: order number, warehouse number, code, quantity and other data information.
  • the new data information of the WMS system and the newly added data information of the ERP system are acquired and compared at least once in each cycle to generate at least one comparison information table;
  • Table 1 First alignment information table
  • the comparison information tables are sequentially counted according to the comparison time, until there is no difference between the newly added data information of the WMS system and the newly added data information of the ERP system.
  • the statistics are accumulated for the new data information of the WMS system and the new data information of the ERP system, respectively. For example, during the current period (first period), where the period is at most one day, the newly added data information of the WMS system acquired for the first time is compared with the newly added data information of the ERP system to determine whether there is a difference. As shown in the comparison information table in Table 1, the number of new ERP systems is 3, and the number of new WMS systems is 4, so the second time to continue to obtain new data information of the WMS system and the new ERP system. Data information.
  • the comparison information table in Table 2 As shown in the comparison information table in Table 2, the number of new ERP systems is 2, the number of new additions to the WMS system is 1 difference, and the difference data in the comparison information table acquired for the second time is the first time.
  • the statistics of the difference data in the comparison information table are statistically accumulated (accumulated), and the comparison information table in which the number of new ERP systems shown in FIG. 3 is 5 and the number of new additions to the WMS system is 5 is obtained.
  • there is no difference between the newly added data information of the WMS system in Table 3 after statistics and the newly added data information of the ERP system indicating that the difference between the WMS system and the ERP system is smoothed, and this period does not Then obtain new data information of the WMS system and new data information of the ERP system.
  • Table 2 Second comparison information table
  • Table 3 Table 1 difference and table 2 difference accumulation
  • the comparison information table (Table 3) having no difference after the statistics is used as the first synchronization reference table, and the first synchronization reference table will be used as the next cycle (second cycle). Synchronize the benchmark table.
  • a first synchronization reference table is provided for querying synchronization data between the WMS system and the ERP system.
  • next cycle the WMS system and the ERP system newly added data information after the statistics are used as the second reference table, and the second reference table is added to the first synchronization reference table to generate the second reference table. Synchronize the benchmark table.
  • a second synchronization reference table is provided for querying synchronization data between the WMS system and the ERP system.
  • the same expression is: generating the i-th reference table by using the data information that is not statistically different; wherein, when i is equal to 1, the i-th reference table is used as the i-th synchronization reference table; when i is greater than 1 And sending the i-th reference table to the i-th synchronization reference table to generate an i-th synchronization reference table; and providing the i-th synchronization reference table for querying synchronization data between the WMS system and the ERP system.
  • the WMS warehouse management system and the ERP warehouse management system adopt a daily comparison principle in data synchronization, which illustrates a daily comparison principle.
  • the WMS warehouse management system lists all product information on the list.
  • the ERP warehouse management system generates the shipper and warehouse receipt information on a daily basis. Since the goods are shipped and stored in the warehouse, there will be a product order number, so the daily comparison can be compared according to the product order number.
  • a benchmark is generated.
  • comparing the data of the two sides for the first time and judging the difference when comparing the data of the two sides for the second time, it will first judge whether there is any difference between the value and the value in the benchmark. If there is no difference, then the second time The data is used as a new benchmark; if there are still differences, the new values are brought into the benchmark to determine if the difference can be smoothed.
  • the WMS warehouse management system transmits data to the ERP enterprise resource planning system, and the ERP enterprise resource planning system synchronizes the data.
  • the data of the WMS warehouse management system and the ERP enterprise resource planning system can be synchronized in time, and the organized record management data is realized, which avoids confusion and is beneficial to warehouse management.
  • a synchronization system of a WMS system and an ERP system includes:
  • the obtaining unit 101 is configured to acquire and compare the newly added data information of the WMS system with the newly added data information of the ERP system to generate at least one comparison information at least once in each period (the period is at most one day).
  • Table, new data information generally includes: order number, warehouse number, code, quantity and other data information.
  • the statistic unit 102 is configured to perform data statistics according to the comparison time table generated by each at least one acquiring unit 101, until there is no difference between the newly added data information of the WMS system and the newly added data information of the ERP system;
  • the statistics are accumulated for the new data information of the WMS system and the new data information of the ERP system, respectively.
  • the generating unit 103 is configured to generate, in the current period (first period), the generating unit 103 generates a first synchronization reference table by using the comparison information table (Table 3) having no difference after the statistical unit 102 counts, and the generating unit 103 generates the first 1
  • the synchronization reference table will be used as the synchronization reference table for the next cycle (second cycle).
  • a first synchronization reference table is provided for querying synchronization data between the WMS system and the ERP system.
  • next cycle the new data information of the WMS system and the ERP system with no difference after the statistical unit 102 is counted is used as the second reference table, and the second reference table is accumulated to the first synchronization.
  • the reference table a second synchronization reference table is generated.
  • a second synchronization reference table is provided for querying synchronization data between the WMS system and the ERP system, and so on.
  • the system or device described above may be a server or a server cluster, and the corresponding units may also be related processing units in one server or one or more servers in the server cluster.
  • the related unit is one or more servers in the server cluster
  • the interaction between the corresponding units is represented as an interaction between the servers, and the present invention is not limited in this respect.
  • the embodiment of the present invention further provides a non-volatile computer storage medium, where the computer storage medium stores computer executable instructions, and the computer executable instructions can execute the synchronization method of the WMS system and the ERP system in any of the foregoing method embodiments. .
  • the non-volatile computer storage medium of the present invention stores computer-executable instructions that are set to:
  • the at least one comparison information table is sequentially subjected to data statistics according to the comparison time until there is no difference between the newly added data information of the WMS system and the newly added data information of the ERP system, and the ith reference is generated by using the data information of the statistics without difference. table;
  • the i-th reference table is taken as the i-th synchronization reference table
  • the i-th reference table is added to the i-th synchronization reference table to generate an i-th synchronization reference table;
  • the ith synchronization reference table is provided for querying synchronization data between the WMS system and the ERP system.
  • non-volatile computer readable storage medium it can be used to store non-volatile software programs, non-volatile computer-executable programs, and modules, such as the WMS system in the embodiment of the present invention and the synchronization method of the ERP system.
  • Program instructions/modules for example, acquisition unit 101, statistics unit 102, and generation unit 103 shown in FIG. 3).
  • the one or more modules are stored in the non-transitory computer readable storage medium, and when executed by the processor, perform a synchronization method of the WMS system and the ERP system in any of the above method embodiments.
  • the non-transitory computer readable storage medium may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application required for at least one function; and a storage data area Data and the like created according to the use of the storage optimization device of the memory can be stored.
  • the non-transitory computer readable storage medium may include a high speed random access memory, and may also include a nonvolatile memory such as at least one magnetic disk storage device, flash memory device, or other nonvolatile solid state storage device.
  • the non-transitory computer readable storage medium can optionally include memory remotely disposed relative to the processor, the remote memory being connectable to a memory optimization device of the memory over a network.
  • Embodiments of the present invention also provide a computer program product comprising at least one non-volatile computer storage medium having computer executable program code instructions stored therein, the computer executable program The code instructions are capable of performing the synchronization method of the WMS system and the ERP system according to any of the above embodiments of the present invention.
  • FIG. 4 is a schematic structural diagram of hardware of an electronic device for performing a method for synchronizing a WMS system and an ERP system according to an embodiment of the present invention.
  • the device includes: one or more processors 410 and a memory 420, and one processor 410 is taken as an example in FIG.
  • the apparatus for performing the synchronization method of the WMS system and the ERP system may further include: an input device 430 and an output device 440.
  • the processor 410, the memory 420, the input device 430, and the output device 440 may be connected by a bus or other means, as exemplified by a bus connection in FIG.
  • the memory 420 is the above-described nonvolatile computer readable storage medium.
  • the processor 410 performs various functional applications and data processing of the server by running non-volatile software programs, instructions, and modules stored in the memory 420, that is, the synchronization method between the WMS system and the ERP system in the foregoing method embodiments. .
  • Input device 430 can receive input numeric or character information and generate key signal inputs related to user settings and function control of the memory optimization device of the memory.
  • Output device 440 can include a display device such as a display screen.
  • the above product can perform the method provided by the embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.
  • the above product can perform the method provided by the embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.
  • the electronic device includes: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory is stored to be One less processor-executed instruction executed by the at least one processor to enable the at least one processor to:
  • the at least one comparison information table is sequentially subjected to data statistics according to the comparison time until there is no difference between the newly added data information of the WMS system and the newly added data information of the ERP system, and the ith reference is generated by using the data information of the statistics without difference. table;
  • the i-th reference table is taken as the i-th synchronization reference table
  • the i-th reference table is added to the i-th synchronization reference table to generate an i-th synchronization reference table;
  • the ith synchronization reference table is provided for querying synchronization data between the WMS system and the ERP system.
  • the electronic device of the embodiment of the invention exists in various forms, including but not limited to:
  • Mobile communication devices These devices are characterized by mobile communication functions and are mainly aimed at providing voice and data communication.
  • Such terminals include: smart phones (such as iPhone), multimedia phones, functional phones, and low-end phones.
  • Ultra-mobile personal computer equipment This type of equipment belongs to the category of personal computers, has computing and processing functions, and generally has mobile Internet access.
  • Such terminals include: PDAs, MIDs, and UMPC devices, such as the iPad.
  • Portable entertainment devices These devices can display and play multimedia content. Such devices include: audio, video players (such as iPod), handheld game consoles, e-books, and smart toys and portable car navigation devices.
  • the server consists of a processor, a hard disk, a memory, a system bus, etc.
  • the server is similar to a general-purpose computer architecture, but because of the need to provide highly reliable services, processing power and stability High reliability in terms of reliability, security, scalability, and manageability.
  • the device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separate, and the components displayed as units may It may or may not be a physical unit, that is, it may be located in one place, or it may be distributed to multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the embodiment. Those of ordinary skill in the art can understand and implement without deliberate labor.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • Economics (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Tourism & Hospitality (AREA)
  • Accounting & Taxation (AREA)
  • Strategic Management (AREA)
  • Operations Research (AREA)
  • Marketing (AREA)
  • General Business, Economics & Management (AREA)
  • Finance (AREA)
  • Quality & Reliability (AREA)
  • Human Resources & Organizations (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Development Economics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Information Transfer Between Computers (AREA)

Abstract

一种WMS系统与ERP系统的同步方法和同步系统，方法包括：在第i周期内至少一次比对WMS系统的新增数据信息与ERP系统的新增数据信息以生成至少一个比对信息表（S1），将各至少一个比对信息表按照比对时间依次进行数据统计，直到WMS系统的新增数据信息与ERP系统的新增数据信息之间无差异（S2），利用无差异时统计的数据信息生成第i基准表。通过采用逐日比对的方式，对WMS系统和ERP系统的数据进行及时同步，能条理地记录管理数据，避免混乱，从而有利于仓库管理。

Description

WMS系统与ERP系统的同步方法及系统
本发明要求在2016年06月28日提交中国专利局、申请号为201610490617.5、发明名称为“WMS系统与ERP系统的同步方法”的中国专利申请的优先权，其全部内容通过引用结合在本发明中。
技术领域
本发明实施例涉及计算机软件系统领域，尤其涉及WMS系统与ERP系统的同步方法及系统。
背景技术
大多数公司都会有企业资源计划ERP(Enterprise Resource Planning)系统。现有技术下，仓库管理系统WMS(Warehouse Management System)每天都会发货/入货等，ERP企业资源计划系统会定时同步这部分数据。但是，可能无法做到完全同步。因为对于仓库管理来说，各个仓库调拨、发货、退货、换货、免费赠送等因素都会导致仓库库存量发生变化，导致WMS仓库管理系统与ERP企业资源计划系统存在信息差异，ERP系统可能需要到预定时间才由专门的工作人员汇总。若WMS仓库管理系统和ERP企业资源计划系统不能及时同步，会导致仓库管理混乱，给仓库管理带来不便。
ERP是下单记录，WMS是出库记录，WMS会给ERP传输数据，但并不是将所有数据都传给ERP。当出现退换货、免费赠送等情况时，WMS会立即录入信息，但是ERP却是由专门的工作人员先统计退换货数量，再将数据上传到ERP。ERP能直接从WMS获得的数据只有最简单的数据，比如：仓库间调拨、发货等。
图1为现有技术中WMS系统与ERP系统的同步方法流程图。其中，WMS系统将一部分商品信息同步给ERP系统，余下的另一部分商品信息需要到预定时间才由专门的工作人员汇总上传到ERP系统。
在实现本发明的过程中，发明人发现相关技术中至少存在如下问题：WMS系统和ERP系统不能及时同步，会导致仓库管理混乱，给仓库管理带来不便。
发明内容
针对现有技术存在的WMS系统和ERP系统之间数据同步不及时的问题，第一方面，本发明实施例提供一种WMS系统与ERP系统的同步方法，包括：在第i周期内至少一次比对WMS系统的新增数据信息与ERP系统的新增数据信息以生成至少一个比对信息表；将各至少一个比对信息表按照比对时间依次进行数据统计，直到WMS系统的新增数据信息与ERP系统的新增数据信息之间无差异，利用无差异时统计的数据信息生成第i基准表；其中，当i等于1时，则将所述第i基准表作为第i同步基准表；当i大于1时，则将该第i基准表添加至第i-1同步基准表以生成第i同步基准表；提供所述第i同步基准表以供查询WMS系统与ERP系统之间的同步数据。
第二方面，本发明实施例提供一种WMS系统与ERP系统的同步系统，包括：获取单元，用于在第i周期内至少一次获取并比对WMS系统的新增数据信息与ERP系统的新增数据信息以生成至少一个比对信息表；统计单元，用于将各至少一个比对信息表按照比对时间依次进行数据统计，直到WMS系统的新增数据信息与ERP系统的新增数据信息之间无差异；生成单元，用于利用无差异时统计的数据信息生成第i基准表，其中，当i等于1时，则将所述第i基准表作为第i同步基准表；当i大于1时，则将该第i基准表添加至第i-1同步基准表以生成第i同步基准表；提供所述第i同步基准表以供查询WMS系统与ERP系统之间的同步数据。
第三方面，本发明实施例还提供了一种非易失性计算机存储介质，存储有计算机可执行指令，所述计算机可执行指令用于执行本发明上述任一项WMS系统与ERP系统的同步方法。
第四方面，本发明实施例还提供了一种电子设备，包括：至少一个处理器；以及存储器；其中，所述存储器存储有可被所述至少一个处理器执行的程序，所述指令被所述至少一个处理器执行，以使所述至少一个处理器能够 执行本发明上述任一项WMS系统与ERP系统的同步方法。
第五方面，本发明实施例还提供了一种计算机程序产品，包括至少一个非易失性计算机存储介质，所述非易失性计算机存储介质具有存储在其中的计算机可执行程序代码指令，所述计算机可执行程序代码指令以执行本发明上述任一项WMS系统与ERP系统的同步方法。
本发明实施例提供的WMS仓库管理系统与ERP企业资源计划系统的同步方法及电子设备，采用逐日比对的方式，对WMS仓库管理系统和ERP企业资源计划系统的数据进行及时同步，能够有条理的记录管理数据，避免混乱，从而有利于仓库管理。
附图说明
为了更清楚地说明本发明实施例或现有技术中的技术方案，下面将对实施例或现有技术描述中所需要使用的附图作一简单地介绍，显而易见地，下面描述中的附图是本发明的一些实施例，对于本领域普通技术人员来讲，在不付出创造性劳动的前提下，还可以根据这些附图获得其他的附图。
图1为现有技术中WMS系统与ERP系统的同步方法流程图；
图2为本发明WMS系统与ERP系统的同步方法实施例流程图；
图3为本发明WMS系统与ERP系统的同步系统实施例结构示意图；
图4为本发明实施例提供用于执行WMS系统与ERP系统同步方法的电子设备的硬件结构示意图。
具体实施方式
为使本发明实施例的目的、技术方案和优点更加清楚，下面将结合本发明实施例中的附图，对本发明实施例中的技术方案进行清楚、完整地描述，显然，所描述的实施例是本发明一部分实施例，而不是全部的实施例。基于本发明中的实施例，本领域普通技术人员在没有作出创造性劳动前提下所获得的所有其他实施例，都属于本发明保护的范围。
在本例中，获取WMS系统的新增数据信息与ERP系统的新增数据信息可以采用常规的手段实现。在本实施例中不再赘述。
如图2所示，WMS系统与ERP系统的同步方法，包括：
S1、获取WMS系统的新增数据信息与ERP系统的新增数据信息，新增数据信息一般包括：订单号、仓库号、编码、数量等数据信息。将WMS系统的新增数据信息与ERP系统的新增数据信息进行对比，生成比对信息表，如表1所示。通常在每个周期内都至少一次获取并比对WMS系统的新增数据信息与ERP系统的新增数据信息以生成至少一个比对信息表；
表1：第一个比对信息表
Figure PCTCN2016100160-appb-000001
S2、将各比对信息表按照比对时间依次进行数据统计，直到WMS系统的新增数据信息与ERP系统的新增数据信息之间无差异。
在一个实施例中，数据统计为分别对WMS系统的新增数据信息和ERP系统的新增数据信息进行累加。例如，在本周期内(第一周期)，其中该周期至多为一日，将第一次获取的WMS系统的新增数据信息与ERP系统的新增数据信息进行比对以判断是否存在差异。如表1中比对信息表所示，其中ERP系统新增数量为3比对WMS系统新增数量为4存在差异，则第二次继续获取WMS系统的新增数据信息与ERP系统的新增数据信息。如表2中比对信息表所示，其中ERP系统新增数量为2比对WMS系统新增数量为1存在差异，将第二次获取的比对信息表中的差异数据与第一次获取的比对信息表中的差异数据对应进行统计(累加)，得到如图3所示的ERP系统新增数量为5比对WMS系统新增数量为5的比对信息表。此时经统计之后的表3中的WMS系统的新增数据信息与ERP系统的新增数据信息之间无差异，则说明WMS系统与ERP系统之间的差异抹平了，则本周期内不再获取WMS系统的新增数据信息与ERP系统的新增数据信息。
如果统计后的表3中WMS系统的新增数据信息与ERP系统的新增数据信息之间还有差异，则说明WMS系统与ERP系统之间的没有抹平差异，则本周期内还需要继续第三次获取WMS系统的新增数据信息与ERP系统的新增数据信息，并将第三次获取的该比对信息表与上次统计后的表3进行累加。
表2：第二个比对信息表
Figure PCTCN2016100160-appb-000002
表3：表1差值与表2差值累加之后
Figure PCTCN2016100160-appb-000003
S3、在本周期内(第一周期)，将统计之后无差异的比对信息表(表3)作为第1同步基准表，该第1同步基准表将作为下一周期(第二周期)的同步基准表。提供第1同步基准表以供查询WMS系统与ERP系统之间的同步数据。
在下一周期内(第二周期)，将统计后无差异的WMS系统与ERP系统新增数据信息作为第2基准表，并将该第2基准表添加至第1同步基准表中，生成第2同步基准表。提供第2同步基准表以供查询WMS系统与ERP系统之间的同步数据。以此类推，同样的表述即：利用无差异时统计的数据信息生成第i基准表；其中，当i等于1时，则将所述第i基准表作为第i同步基准表；当i大于1时，则将该第i基准表添加至第i-1同步基准表以生成第i同步基准表；提供所述第i同步基准表以供查询WMS系统与ERP系统之间的同步数据。
在本发明的一个实施例中，WMS仓库管理系统与ERP仓库管理系统在数据同步时采用逐日对比原则，举例说明逐日对比原则，例如，WMS仓库管理系统会在列表上，列出所有商品信息的出货单和入库单信息，ERP仓库管理系统自行每天生成出货单和入库单信息，由于商品出库和入库时都会有商品订单号，所以逐日对比可以根据商品订单号进行对比。
这里说明一下逐日对比的重要性，假定WMS仓库管理系统今天已经出货，如果出货数据信息第二天再传输给ERP仓库管理系统，意味着WMS仓库管理系统有数据变化，ERP仓库管理系统却未同步，会导致WMS仓库管理系统与ERP仓库管理系统双方数据出现差异，会产生一些问题，比如说，对账时，WMS仓库管理系统存在某个数据，ERP仓库管理系统 却没有该数据，第二天对账时，ERP仓库管理系统有该数据了，而WMS仓库管理系统又没有该数据了。
采用逐日对比的优点：首先会产生一种基准。在第一次对比双方数据，判断出存在差异时，第二次再对比双方数据时，会首先判断这次数值与基准里的值是否还有差异，若已经没有差异，就把该第二次的数据作为新的基准；若还是有差异，就把新增的数值带入基准中，判断是否能抹平差异。
因此，需要同步、比对WMS仓库管理系统和ERP企业资源计划系统的数据。在匹配时，WMS仓库管理系统传输数据到ERP企业资源计划系统，ERP企业资源计划系统同步数据。
通过采用逐日比对的方式，能够对WMS仓库管理系统和ERP企业资源计划系统数据的进行及时同步，实现了有条理的记录管理数据，避免了混乱，从而有利于仓库管理。
如图3所示，根据本发明实施例的WMS系统与ERP系统的同步系统包括：
获取单元101，用于在每个周期内(周期至多为一日)，获取单元101至少一次获取并比对WMS系统的新增数据信息与ERP系统的新增数据信息以生成至少一个比对信息表，新增数据信息一般包括：订单号、仓库号、编码、数量等数据信息。
统计单元102，用于将各至少一个获取单元101生成的比对信息表按照比对时间依次进行数据统计，直到WMS系统的新增数据信息与ERP系统的新增数据信息之间无差异；
在一个实施例中，数据统计为分别对WMS系统的新增数据信息和ERP系统的新增数据信息进行累加。
生成单元103，用于在本周期内(第一周期)，生成单元103将统计单元102统计之后无差异的比对信息表(表3)生成第1同步基准表，该生成单元103生成的第1同步基准表将作为下一周期(第二周期)的同步基准表。提供第1同步基准表以供查询WMS系统与ERP系统之间的同步数据。
在下一周期内(第二周期)，将统计单元102统计后无差异的WMS系统与ERP系统新增数据信息作为第2基准表，并将该第2基准表累加至第1同步 基准表中，生成第2同步基准表。提供第2同步基准表以供查询WMS系统与ERP系统之间的同步数据，并以此类推。
以上所述的系统或装置可以是一个服务器或者服务器集群，相应的各个单元也可以为一个服务器中的相关处理单元或者为服务器集群中的一个或多个服务器。当相关的单元为服务器集群中的一个或多个服务器时，相应的单元之间的交互则表现为服务器之间的交互，本发明在此方面没有限制。
本发明实施例还提供一种非易失性计算机存储介质，所述计算机存储介质存储有计算机可执行指令，该计算机可执行指令可执行上述任意方法实施例中的WMS系统与ERP系统的同步方法。
作为一种实施方式，本发明的非易失性计算机存储介质存储有计算机可执行指令，所述计算机可执行指令设置为:
在第i周期内至少一次获取并比对WMS系统的新增数据信息与ERP系统的新增数据信息以生成至少一个比对信息表；
将各至少一个比对信息表按照比对时间依次进行数据统计，直到WMS系统的新增数据信息与ERP系统的新增数据信息之间无差异，利用无差异时统计的数据信息生成第i基准表；
其中，当i等于1时，则将所述第i基准表作为第i同步基准表；
当i大于1时，则将该第i基准表添加至第i-1同步基准表以生成第i同步基准表；
提供所述第i同步基准表以供查询WMS系统与ERP系统之间的同步数据。
作为一种非易失性计算机可读存储介质，可用于存储非易失性软件程序、非易失性计算机可执行程序以及模块，如本发明实施例中的WMS系统与ERP系统的同步方法对应的程序指令/模块(例如，附图3所示的获取单元101、统计单元102和生成单元103)。所述一个或者多个模块存储在所述非易失性计算机可读存储介质中，当被处理器执行时，执行上述任意方法实施例中的WMS系统与ERP系统的同步方法。
非易失性计算机可读存储介质可以包括存储程序区和存储数据区，其中，存储程序区可存储操作系统、至少一个功能所需要的应用程序；存储数据区 可存储根据存储器的存储优化装置的使用所创建的数据等。此外，非易失性计算机可读存储介质可以包括高速随机存取存储器，还可以包括非易失性存储器，例如至少一个磁盘存储器件、闪存器件、或其他非易失性固态存储器件。在一些实施例中，非易失性计算机可读存储介质可选包括相对于处理器远程设置的存储器，这些远程存储器可以通过网络连接至存储器的存储优化装置。上述网络的实例包括但不限于互联网、企业内部网、局域网、移动通信网及其组合。本发明实施例还提供一种计算机程序产品，包括至少一个非易失性计算机存储介质，所述非易失性计算机存储介质具有存储在其中的计算机可执行程序代码指令，所述计算机可执行程序代码指令能够执行本发明上述任一实施例所述的WMS系统与ERP系统的同步方法。
图4为本发明实施例提供的用于执行WMS系统与ERP系统同步方法的电子设备的硬件结构示意图。如图4所示，该设备包括：一个或多个处理器410以及存储器420，图4中以一个处理器410为例。
执行WMS系统与ERP系统的同步方法的设备还可以包括：输入装置430和输出装置440。
处理器410、存储器420、输入装置430和输出装置440可以通过总线或者其他方式连接，图4中以通过总线连接为例。
存储器420为上述的非易失性计算机可读存储介质。处理器410通过运行存储在存储器420中的非易失性软件程序、指令以及模块，从而执行服务器的各种功能应用以及数据处理，即实现上述方法实施例中的WMS系统与ERP系统的同步方法。
输入装置430可接收输入的数字或字符信息，以及产生与存储器的存储优化装置的用户设置以及功能控制有关的键信号输入。输出装置440可包括显示屏等显示设备。
上述产品可执行本发明实施例所提供的方法，具备执行方法相应的功能模块和有益效果。未在本实施例中详尽描述的技术细节，可参见本发明实施例所提供的方法。
作为一种实施方式，上述电子设备包括：至少一个处理器；以及，与所述至少一个处理器通信连接的存储器；其中，所述存储器存储有可被所述至 少一个处理器执行的指令，所述指令被所述至少一个处理器执行，以使所述至少一个处理器能够：
在第i周期内至少一次获取并比对WMS系统的新增数据信息与ERP系统的新增数据信息以生成至少一个比对信息表；
将各至少一个比对信息表按照比对时间依次进行数据统计，直到WMS系统的新增数据信息与ERP系统的新增数据信息之间无差异，利用无差异时统计的数据信息生成第i基准表；
其中，当i等于1时，则将所述第i基准表作为第i同步基准表；
当i大于1时，则将该第i基准表添加至第i-1同步基准表以生成第i同步基准表；
提供所述第i同步基准表以供查询WMS系统与ERP系统之间的同步数据。
本发明实施例的电子设备以多种形式存在，包括但不限于:
(1)移动通信设备:这类设备的特点是具备移动通信功能，并且以提供话音、数据通信为主要目标。这类终端包括:智能手机(例如iPhone)、多媒体手机、功能性手机，以及低端手机等。
(2)超移动个人计算机设备:这类设备属于个人计算机的范畴，有计算和处理功能，一般也具备移动上网特性。这类终端包括:PDA、MID和UMPC设备等，例如iPad。
(3)便携式娱乐设备:这类设备可以显示和播放多媒体内容。该类设备包括:音频、视频播放器(例如iPod)，掌上游戏机，电子书，以及智能玩具和便携式车载导航设备。
(4)服务器:提供计算服务的设备，服务器的构成包括处理器、硬盘、内存、系统总线等，服务器和通用的计算机架构类似，但是由于需要提供高可靠的服务，因此在处理能力、稳定性、可靠性、安全性、可扩展性、可管理性等方面要求较高。
(5)其他具有数据交互功能的电子装置。
以上所描述的装置实施例仅仅是示意性的，其中所述作为分离部件说明的单元可以是或者也可以不是物理上分开的，作为单元显示的部件可以 是或者也可以不是物理单元，即可以位于一个地方，或者也可以分布到多个网络单元上。可以根据实际的需要选择其中的部分或者全部模块来实现本实施例方案的目的。本领域普通技术人员在不付出创造性的劳动的情况下，即可以理解并实施。
通过以上的实施方式的描述，本领域的技术人员可以清楚地了解到各实施方式可借助软件加必需的通用硬件平台的方式来实现，当然也可以通过硬件。基于这样的理解，上述技术方案本质上或者说对现有技术做出贡献的部分可以以软件产品的形式体现出来，该计算机软件产品可以存储在计算机可读存储介质中，如ROM/RAM、磁碟、光盘等，包括若干指令用以使得一台计算机设备(可以是个人计算机，服务器，或者网络设备等)执行各个实施例或者实施例的某些部分所述的方法。
最后应说明的是：以上实施例仅用以说明本发明的技术方案，而非对其限制；尽管参照前述实施例对本发明进行了详细的说明，本领域的普通技术人员应当理解：其依然可以对前述各实施例所记载的技术方案进行修改，或者对其中部分技术特征进行等同替换；而这些修改或者替换，并不使相应技术方案的本质脱离本发明各实施例技术方案的精神和范围。

Claims (9)

  1. WMS系统与ERP系统的同步方法，应用于电子设备，包括：
    在第i周期内至少一次获取并比对WMS系统的新增数据信息与ERP系统的新增数据信息以生成至少一个比对信息表；
    将各至少一个比对信息表按照比对时间依次进行数据统计，直到WMS系统的新增数据信息与ERP系统的新增数据信息之间无差异，利用无差异时统计的数据信息生成第i基准表；
    其中，当i等于1时，则将所述第i基准表作为第i同步基准表；
    当i大于1时，则将该第i基准表添加至第i-1同步基准表以生成第i同步基准表；
    提供所述第i同步基准表以供查询WMS系统与ERP系统之间的同步数据。
  2. 根据权利要求1所述的方法，其中，所述周期至多为一日。
  3. 根据权利要求1或2所述的方法，所述数据统计为分别对所述WMS系统的新增数据信息和所述ERP系统的新增数据信息进行累加。
  4. WMS系统与ERP系统的同步系统，包括：
    获取单元，用于在第i周期内至少一次获取并比对WMS系统的新增数据信息与ERP系统的新增数据信息以生成至少一个比对信息表；
    统计单元，用于将各至少一个比对信息表按照比对时间依次进行数据统计，直到WMS系统的新增数据信息与ERP系统的新增数据信息之间无差异；
    生成单元，用于利用无差异时统计的数据信息生成第i基准表，其中，当i等于1时，则将所述第i基准表作为第i同步基准表；当i大于1时，则将该第i基准表添加至第i-1同步基准表以生成第i同步基准表；
    提供所述第i同步基准表以供查询WMS系统与ERP系统之间的同步数据。
  5. 根据权利要求4所述的系统，其中，所述周期至多为一日。
  6. 根据权利要求4或5所述的系统，所述数据统计为分别对所述WMS系统的新增数据信息和所述ERP系统的新增数据信息进行累加。
  7. 一种非易失性计算机存储介质，存储有计算机可执行指令，所述计算机可执行指令能够执行：
    在第i周期内至少一次获取并比对WMS系统的新增数据信息与ERP系统的新增数据信息以生成至少一个比对信息表；
    将各至少一个比对信息表按照比对时间依次进行数据统计，直到WMS系统的新增数据信息与ERP系统的新增数据信息之间无差异，利用无差异时统计的数据信息生成第i基准表；
    其中，当i等于1时，则将所述第i基准表作为第i同步基准表；
    当i大于1时，则将该第i基准表添加至第i-1同步基准表以生成第i同步基准表；
    提供所述第i同步基准表以供查询WMS系统与ERP系统之间的同步数据。
  8. 一种电子设备，包括：
    至少一个处理器；以及，
    与所述至少一个处理器通信连接的存储器；其中，
    所述存储器存储有可被所述至少一个处理器执行的指令，所述指令被所述至少一个处理器执行，以使所述至少一个处理器能够：
    在第i周期内至少一次获取并比对WMS系统的新增数据信息与ERP系统的新增数据信息以生成至少一个比对信息表；
    将各至少一个比对信息表按照比对时间依次进行数据统计，直到WMS系统的新增数据信息与ERP系统的新增数据信息之间无差异，利用无差异时统计的数据信息生成第i基准表；
    其中，当i等于1时，则将所述第i基准表作为第i同步基准表；
    当i大于1时，则将该第i基准表添加至第i-1同步基准表以生成第i同步基准表；
    提供所述第i同步基准表以供查询WMS系统与ERP系统之间的同步数据。
  9. 一种计算机程序产品，包括至少一个非易失性计算机存储介质，所述非易失性计算机存储介质具有存储在其中的计算机可执行程序代码指令，所述计算机可执行程序代码指令能够执行权利要求1-3任一项所述的WMS系统与ERP系统的同步方法。
PCT/CN2016/100160 2016-06-28 2016-09-26 Wms系统与erp系统的同步方法及系统 WO2018000622A1 (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201610490617.5A CN107247715A (zh) 2016-06-28 2016-06-28 Wms系统与erp系统的同步方法
CN201610490617.5 2016-06-28

Publications (1)

Publication Number Publication Date
WO2018000622A1 true WO2018000622A1 (zh) 2018-01-04

Family

ID=60016134

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2016/100160 WO2018000622A1 (zh) 2016-06-28 2016-09-26 Wms系统与erp系统的同步方法及系统

Country Status (2)

Country Link
CN (1) CN107247715A (zh)
WO (1) WO2018000622A1 (zh)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110502565A (zh) * 2019-08-29 2019-11-26 山东浪潮通软信息科技有限公司 一种满足计算机化验证的接口配置方法
CN111383088A (zh) * 2020-03-04 2020-07-07 海南金盘智能科技股份有限公司 仓储账务的核对方法及相关装置

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108629542B (zh) * 2018-05-11 2022-06-28 青山信息技术开发(深圳)有限公司 基于物流配送的退换货信息同步方法、装置及设备

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030050936A1 (en) * 2001-04-13 2003-03-13 Wainwright Rob M. Three-layer architecture for retail and warehouse stock audit system and method
CN101634944A (zh) * 2009-08-17 2010-01-27 浪潮集团山东通用软件有限公司 Erp参照wms入库的接口方法
CA2776073A1 (en) * 2012-05-02 2013-11-02 Nulogy Corporation Method, system and apparatus for integrating order management and warehouse management
CN104809553A (zh) * 2015-04-20 2015-07-29 广东工业大学 面向异构数据的多源电商数据处理平台及方法
CN105096083A (zh) * 2015-07-30 2015-11-25 中国石油化工股份有限公司 一种用于仓库的信息系统

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103632241A (zh) * 2012-08-28 2014-03-12 纽海信息技术（上海）有限公司 仓库盘点方法及仓库盘点系统
CN103297329B (zh) * 2013-06-26 2016-09-07 北京金和软件股份有限公司 一种异构系统间消息的准实时双向同步方法
CN103399888B (zh) * 2013-07-19 2016-08-10 广东电网有限责任公司电力科学研究院 电网模型数据的差分同步方法及系统
CN105608210A (zh) * 2015-12-29 2016-05-25 北京京东尚科信息技术有限公司 一种数据存储方法和装置

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030050936A1 (en) * 2001-04-13 2003-03-13 Wainwright Rob M. Three-layer architecture for retail and warehouse stock audit system and method
CN101634944A (zh) * 2009-08-17 2010-01-27 浪潮集团山东通用软件有限公司 Erp参照wms入库的接口方法
CA2776073A1 (en) * 2012-05-02 2013-11-02 Nulogy Corporation Method, system and apparatus for integrating order management and warehouse management
CN104809553A (zh) * 2015-04-20 2015-07-29 广东工业大学 面向异构数据的多源电商数据处理平台及方法
CN105096083A (zh) * 2015-07-30 2015-11-25 中国石油化工股份有限公司 一种用于仓库的信息系统

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110502565A (zh) * 2019-08-29 2019-11-26 山东浪潮通软信息科技有限公司 一种满足计算机化验证的接口配置方法
CN111383088A (zh) * 2020-03-04 2020-07-07 海南金盘智能科技股份有限公司 仓储账务的核对方法及相关装置
CN111383088B (zh) * 2020-03-04 2023-05-05 海南金盘智能科技股份有限公司 仓储账务的核对方法及相关装置

Also Published As

Publication number Publication date
CN107247715A (zh) 2017-10-13

Similar Documents

Publication Publication Date Title
US10949447B2 (en) Blockchain-based data synchronizing and data block parsing method and device
US9712645B2 (en) Embedded event processing
US11469891B2 (en) Expendable cryptographic key access
US20210083856A1 (en) Improved hardware security module management
CN107590277B (zh) 数据同步方法、装置、电子设备及存储介质
US10127294B2 (en) Idempotency of application state data
US9117191B2 (en) Automatic device inventory management for different types of devices
US20180227329A1 (en) Method and apparatus for detecting security using an industry internet operating system
SG11201809909RA (en) User permission data query method and apparatus, electronic device and medium
US10025878B1 (en) Data lineage analysis
GB2499351A (en) System and method for computer-implemented accounting services provided using cloud resources
US20170185454A1 (en) Method and Electronic Device for Determining Resource Consumption of Task
WO2018000622A1 (zh) Wms系统与erp系统的同步方法及系统
US20150113070A1 (en) Optimization of posting in social networks
AU2020408143B2 (en) Watermark-based techniques for change-data-capture
US20220300928A1 (en) Cloud Computing Metering and Charging Method and Apparatus, and Electronic Device and Storage Medium
WO2021068113A1 (zh) 时长统计方法、装置、电子设备和计算机可读介质
WO2017096884A1 (zh) 设备识别的方法和装置
US10832348B2 (en) Topic recommendation in a social network environment
US11294704B2 (en) Monitoring and reporting performance of online services using a monitoring service native to the online service
CN109766386A (zh) 一种同步服务端离线数据的方法及系统
CN115660591A (zh) 用于业务审批的流程配置方法、系统、电子设备及介质
CN106211353A (zh) 数据获取方法、装置和系统
MX2018007857A (es) Metodos, sistemas y medios legibles en computadora para infraestructura electronica para asociacion de ahorros y credito rotatorio.
CN109063201B (zh) 一种基于混合存储方案的impala在线交互式查询方法

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 16907018

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 16907018

Country of ref document: EP

Kind code of ref document: A1