200834456 九、發明說明： 【發明所屬之技術領域】 /本發明#及_種純處H统及方法，尤其涉及— 系統及方法。 【先前技術】 著越流與商流的快速準確流通在現代企㈣理中佔據 夠進行有的地位’特別是企業間的商品與資金往來如果能 易—方在胁對^則可提高企業效率。傳統的對帳方式是交 細表，六h日可賴帳明細表’或者在指定地點存放對帳明 又易另一方核對無誤後寄回回執。 在傳統的對帳方式下，對帳人 找出差供 、而要手工對比及分析，以 叮平又長，且容易出錯。 【發明内容】 有鑑於此，需要提供一種對帳 料鱼一妆糸、、先，可自動實現一付款資 ^ 收款貧料之間的對帳。 另’遏需要提供一種對帳方法， 一收私次ϋ 可自動声、現一付款資料與 從斥人貝料之間的對帳。 :種對帳系統’包括-收款資料產生系統及一對帳資料處 /糸、、先。收款資料產生祕祕產生—收款資料。對帳資料處理 =包括-資料導人模組及-資料對比模組。資料導入模組用 入收款資料及-付款貧料。:f料對比模組用於對比收款資 200834456 料與付款資料，將收款資料與付款資料中關鍵訊息不符之項目 饈存於一缺失表，益將收款資料與付款資料中關鍵訊息相符但 銷售訊息不符之項目儲存於一異常表。 一種對帳方法包括以下步驟：藉由一收款資料產生系統產 生一收款資料；藉由一對帳資料處理系統導入收款資料；藉由 對帳資料處理系統導入一付款資料；藉由對帳資料處理系統對 比收款資料與付款資料；將收款資料與付款資料中關鍵訊息不 _符之項目儲存於一缺失表；及將收款資料與付款資料中關鍵訊 息相符但銷售訊息不符之項目儲存於一異常表。 藉由以下對具體實施方式詳細的描述結合附圖，將可輕易 的瞭解上述内容及此項發明之諸多優點。 【實施方式】 參閱圖1，為本發明對帳系統一實施方式之環境圖。在本 籲實施方式中，一資料處理系統包括一對帳系統1000、一現場流 程管控（Shop Floor Control，SFC)系統 2〇〇〇 及一客戶系統 3000。 SFC系統2000甩於傳送一交易資料至對帳系統1〇〇〇。在 本實施方式中，交易資料可為出貨資料或退貨資料。交易資料 包括箱號、產品數量、機種、工單號、出貨廠別、出貨曰期及 肖。類型4訊息。生產工廠之銷售產品係以箱為單位出貨給客 戶或被客戶退貨。箱號指明裝载銷售產品之包裝箱之編號，產 叩數量指明包裝箱中所包含的產品的數量，機種指明銷售產品 之類型，工單號指明銷售產品對應的生產工單的編號，出貨廠 200834456 別指明銷售產品之生產工廠名稱，出貨日期指明銷售產品被出 資給客戶的日期，銷售類型指明銷售產品係被出貨給客戶或被 客戶退貨，故包括出貨類型與退貨類型。 在其他實施方式中，交易資料可以根據不同的需求而包括 不同的訊息。 客戶系統3000為客戶之自動付款系統，其包括客戶之付 款貧料。在本實施方式中，付款資料為客戶物料用量付款記 錄，其包括付款之箱號、出貨廠別、銷售類型、物料料號、物 料數量及銷售單價等訊息。 在其他實施方式中，付款資料亦可根據不同的需求而包括 不同的訊息。 對帳系統1000包括一收款資料產生系統1100及一對帳資料 處理系統1200。在本實施方式中，收款資料產生系統11〇〇為 生產工腐:之企業資源規劃（Enterprise Res〇urce pianning，erp ) 系統之構成部件，對帳資料處理系統1200為生產工廠之資料 倉儲系統之構成部件。 在本實施方式中，對帳系統1000先藉由收款資料產生系 統1100產生一收款資料，再藉由對帳資料處理系統1200從收 放資料產生系統1100導入收款資料及從客戶系統3〇〇〇導入付 款貧料。然後’對帳資料處理系統1200再對比收款資料與付 款資料’將收款資料與付款資料中關鍵訊息不符的項目儲存於 一缺失表’並將收款資料與付款資料中關鍵訊息相符但銷售訊 200834456 息不符的項目儲存於—異常表。在本實施例中，該關鍵訊息包 詰箱號、出貨廠別、物料料號及銷售類型。銷售訊息包括銷售 單價與物料數量。從而，對㈣統1_藉由收款資料產生系 統1100與對帳#料處㈣統12QG相結合自動實現收款資料與 付款資料之間的對帳。 ^收认貝料產生系統u⑻用於產生收款資料，其包括一儲 存miiG π單產生模組112Q及_收料傳送模組 籲 1130 。 儲存模組mo包括複數表單，如—交易資料表 丄丄丄丄 工早表1112、一庫存表1113、一 1114C ^ 物枓β早表1114、一料號對 π表1115及一銷售單價表1116。200834456 IX. Description of the invention: [Technical field to which the invention pertains] / The present invention and the method and method, in particular, the system and method. [Prior Art] The rapid and accurate circulation of the flow and the flow of business in the modern enterprise (4) has a sufficient position to carry out the position. In particular, if the goods and funds exchange between enterprises are easy, the party can improve the efficiency of the enterprise. . The traditional method of reconciliation is a balance sheet, which can be used to record the reconciliation statement at the designated location or to reconcile the receipt at the designated location. In the traditional reconciliation mode, the reconciler finds the difference, but needs manual comparison and analysis to be flat and long, and error-prone. SUMMARY OF THE INVENTION In view of the above, it is necessary to provide a reconciliation between a payment and a depletion of materials. Another need to provide a method of reconciliation, a collection of private orders, automatic reconciliation, current payment data and reconciliation between reprimands. : Kind of reconciliation system' includes - collection data generation system and one-on-one data office / 糸, first. The collection information is generated secretly - collection information. Reconciliation data processing = including - data guide module and - data comparison module. The data import module uses the payment information and the payment of the poor material. The :f material comparison module is used to compare the receipts and payment materials of 200834456 and the payment information, and the items that do not match the key information in the payment information and the payment data are stored in a missing form, which will match the key information of the payment information and the payment information. However, items that do not match the sales message are stored in an exception table. A reconciliation method includes the steps of: generating a receipt data by a receipt data generation system; importing payment data by a pair of account data processing system; and importing a payment data by a reconciliation data processing system; The account data processing system compares the payment data with the payment data; stores the items in the payment data and the payment information that are not in the payment data in a missing form; and matches the payment information with the key information in the payment data but the sales information does not match The project is stored in an exception table. The above and many of the advantages of the invention will be readily apparent from the Detailed Description of the Detailed Description. [Embodiment] Referring to Figure 1, an environmental diagram of an embodiment of a reconciliation system of the present invention is shown. In the present embodiment, a data processing system includes a pair of account system 1000, a site flow control (SFC) system 2A, and a client system 3000. The SFC system 2000 transmits a transaction data to the reconciliation system. In this embodiment, the transaction data may be shipping materials or return materials. Transaction data includes box number, product quantity, model, work order number, shipping site, shipping schedule and XI. Type 4 message. The sales products of the production plant are shipped to the customer in boxes or returned by the customer. The box number indicates the number of the package in which the product is to be sold. The number of calories indicates the quantity of the product contained in the package. The model indicates the type of product to be sold. The work order number indicates the number of the production work order corresponding to the sales product. Plant 200834456 does not specify the name of the manufacturing plant in which the product is sold. The date of shipment indicates the date on which the product was sold to the customer. The type of sales indicates that the product being sold is either shipped to or returned by the customer, and therefore includes the type of shipment and the type of return. In other embodiments, the transaction data may include different messages depending on different needs. The customer system 3000 is the customer's automatic payment system, which includes the customer's payment of poor materials. In the present embodiment, the payment data is a customer material usage payment record, which includes a payment box number, a shipping site, a sales type, a material item number, a quantity of materials, and a sales unit price. In other embodiments, the payment profile may also include different messages depending on different needs. The reconciliation system 1000 includes a receipt data generation system 1100 and a pair of account data processing system 1200. In the present embodiment, the receipt data generating system 11 is a component of an enterprise resource planning (Enterprise Res〇urce pianning, erp) system, and the reconciliation data processing system 1200 is a data storage system of a production plant. The components. In the present embodiment, the reconciliation system 1000 first generates a receipt data by the receipt data generation system 1100, and then imports the receipt data and the slave customer system 3 from the reconciliation data generation system 1100 by the reconciliation data processing system 1200. 〇〇〇 Import payment poor. Then, the 'reconciliation data processing system 1200 compares the payment data and the payment data' to store the item that does not match the key information in the payment data in a missing form' and matches the payment information with the key information in the payment data but sells News 200834456 items that do not match are stored in the - exception table. In this embodiment, the key message box number, shipping site, material item number, and sales type. Sales information includes sales unit price and material quantity. Therefore, the reconciliation between the payment data and the payment data is automatically realized by the combination of the payment data generation system 1100 and the reconciliation data processing unit (4) unified 12QG. The acknowledged bedding production system u(8) is used to generate payment information, which includes a storage miiG π single generation module 112Q and a _ receipt delivery module call 1130. The storage module mo includes a plurality of forms, such as a transaction data table completion table 1112, an inventory table 1113, a 1114C^ object 早β early table 1114, a material number pair π table 1115, and a sales unit price table 1116. .
^ έά οηππ ^ 4存杈組1110用於從SFC 糸、、、充2000接收交易資料，並將 1111。工單# — 易貝科儲存於交易資料表 早表1112包括母個產品所需的物 庫存表如包括生產工薇之物料訊 4號及物枓數罝。 儲存物料帳目"物料清單表1114用於 丁“丁寸恨目/月早。在本實施方式中 倒扣帳清單與物料倒入帳清單。料號對听又目清單包括物料 叙物料料號與客戶之物料料號之對照^111”括生產工 用於儲存每個物料之銷售單價。 ”'、鐵售單價表1116 清單產生模組1120用於根據交易 理’並產生物料帳目清單。在本實施方式中主订物料帳目處 先從交易資料表仙中讀取交㈣料，產生模組1120 單號在工單表1112 t查詢每一產品所x父易資料中的工 而的物科料號及物料數 200834456 量，然後再根據交易資料中的銷售類型、產品數 物料料號與物料數量在 里斤一珣之 產生物料帳目、青單中進行物料帳目處理，並 扣帳清單與物料倒入帳清單。 月早包括物料倒 當銷售類型為出#類型時’清單產生模組⑽根 =、產品數量騎麵之物_ 中進行轉倒純，㈣生物_扣帳料。2庫4表如 1產生模組⑽先根據產品數旦早㈣吕之’清單 量計算-整箱產口所中 s —δ旬之物料料號與物料數 *產°°所4的物騎號舆物料數量 型在庫存表⑽中進行物料倒扣 再^出貨類 —整箱所需的物料料號與物料數量=存表仙令減去 清單。 並產生相應的物料倒扣帳 當銷售類型為退貨類型時，清 類型、產品數量及所查， 、及U20根據退貨 灸中推/u —勺物科枓號與物料數量在庫存矣”” 中進仃物_續，並產生簡倒 在庫存表如 產生模組mo先根據產品數量早坪而言之，清單 量計算一整箱產品所+ 一°3之物料料號與物料數 型在庫存表m3中^于物 號與物料數量，再根據退貨類 —整箱__==^卩=存表肋中加上 清單。 產生相應的物料倒入帳 然後，清單產生槿組1l9n u 單表1114。 、、、將物料帳目清單儲存於物料清 11 200834456 -收款資料傳送餘謂用於從財模組⑽岐易資料 表m及物料清單表1114中讀取收款資料，並將收款^值 送至對帳資料處理系統腫。在本實施方式中，收款資料 產工廠之物料用量收款記錄，其包括收款之箱號、出貨 銷售類型、物料料號、物料數量及鎖售單價等訊息。 :送模組⑽先從交易資料表⑽中讀取箱號、㈣= 物且LI戶t 料單價。最後，收款資料傳 棋、、且1130將所讀取之箱號、出貨廠別、销隹轉荆 號、物料數量及銷售單m里、物料料 處理系統湖。 4卩__至對帳資料 在本實施方式中，生產n分 物料料號不符。收款資料產生系統咖採用部分 方式，即先藉由清單產生模組112〇產生物二貝料處理 表1114,再藉由收款資料傳送二二並储存 早表1114中讀取物料 、、、130攸物料清 夠根據料號對照表lm將口a此’收放貧料傳送模組1130能 物料料號，進而有利於41付之物料料號自動轉換為客戶之 舉例而言， 之鉍W 相由设數卡板與一外箱紐杰^ 之物料料號 工=’客戶記載 為卡板之物料料號與外箱之 己载之物料料號 物㈣5虎。此時’收款資料傳送模 12 200834456 組ωο可根據料號對照表1115將卡板之物料料號與外箱之物 料料號自動轉換為包裝箱之物料料號。 *對帳資料處理系統1200包括一資料導入模組121〇、一資 料儲存她122〇-#料對比餘删、_資料緩衝模組124〇 及一查詢分析模組1250。 資料儲存模組1220包括一收款表1221及一付款表1222。 資料‘入模組1210用於從收款資料產生系統1100導入收 款資料及從客戶系統3000導入付款資料。在本實施方式中， 資料導入模組1210從收款資料傳送模組1130導入收款資料， Ρ收执之釦唬、出貨廠別、銷售類型、物料料號、物料數量及 銷售早價等訊息，並將收款資料儲存於收款表1221。資料導入 模組1210藉由企業對企業（Business to Business , Β2Β)的方式從 客戶系統3000導入付款資料’即付款之箱號、出貨廠別、鎖 售類型、物料料號、物料數量及銷售單價等訊息，並將付款資 料儲存於付款表1222。 貝料緩衝模組1240包括一缺失表1241及一異常表1242。 貝料對比模組1230用於對比收款資料與付款資料，將收 款資料與付款資料巾關鍵訊息不符之項目儲存於缺失表 1241 ’並將收款f料與付款f料中關鍵訊息相符但鎖售訊息不 符^項目儲存於異常表1242。在本實施方式中，該關鍵訊息包 括，號、出貨礙別、物料料號及銷售類型。該鎖售訊息包括銷 售單價與物料數量。 13 200834456 .在其他實施方式中，關鍵訊息亦可根據不同㈣求而“ 不同的訊息。 資料對比模組1230先判斷收款資料與付款資料中每一項 =號、出貨廠別、物料料號及銷售類型是否相符。當收款 付*欠次料1目之箱#u、出貨薇別、物料料號及銷售類型分別與 _貝=1—項目/箱號、出貨廠別、物料料號及銷售類型相 目。以對比杻組1230判斷此兩項目為關鍵訊息相符之項 類型rt資料卜項目、物料料號及鎖售 ⑵〇= 料中找到相應的項目時，則資料對比模組 料^欠貢料中此項目為關鍵訊息不符之項目。此時，資 、喰組U30將收款資料中此項目儲存於缺失表1241。、 及鎖當付Μ料中—項目之箱號、出貨薇別、物料料號 時，資料璧·/斷付款貢料中此項目為關鍵訊息不符之項目。此 吻對比模組㈣將付款資料中此項目儲存於缺失表 _訊·“目符之項目:銷斷收款資料與付款資料中 資料中關鍵 、’’ 1:15心疋否相符。當收款資料與付款 時，則資料對Γ相符之項目之銷售單價及物料數量同時相等 時貝枓對比模組1230分別在收款表 14 200834456 1221與付款表1222中此兩項目標記為正常。否則，資料對比 樸組1230判斷此兩項目為關鍵訊息相符但銷售訊息不符之項 _。此時，資料對比模組1230分別在收款表12 21與付款表i 2 2 2 中將關鍵訊息相符但銷售訊息不符之項目標記為異常，並將此 等項目儲存於異常表1242。 在其他實施方式中，資料對比模組1230可能僅在收款表 1221與付款表1222中將關鍵訊息相符且銷售訊息相符之項目 •標記為正常，或者僅在收款表1221與付款表1222中將關鍵訊 息相符但銷售訊息不符之項目標記為異常。 資料緩衝模組1240還用於將缺失表1241及異常表1242 中的差異資料反饋至收款資料產生系統，作為收款資料產 生系統1100修正資料之參考依據。 查詢分析模組1250給用戶提供資料查詢功能，包括查詢^ ο οηππ ^ 4 The 11 杈 group 1110 is used to receive transaction data from SFC 糸, ,, 充 2000, and will be 1111. Work Order # — E-Beco is stored in the transaction data sheet. Table 1112 includes the items required for the parent product. The inventory form includes the material information No. 4 and the number of materials. The storage material account "bill of materials list 1114 is used for Ding Xiaoying hate/month early. In this embodiment, the reverse debit account list and the material reversal account list. The material number is also included in the material list. The comparison with the customer's material number number ^111" includes the sales unit price used by the manufacturer to store each material. ", the iron and steel sales unit price table 1116 list generation module 1120 is used to generate a material account list according to the transaction theory. In the present embodiment, the main material account first reads the (four) material from the transaction data table fairy, The module 1120 generates the number of the material item number and the number of materials 200834456 in the work order table 1112 t in the x father data of each product, and then according to the sales type and the product number in the transaction data. The material account processing is performed with the material quantity in the production material account and the green sheet, and the debiting list and the material reversal list are included. The month includes the material when the sales type is ## Module (10) root =, the number of products riding the surface _ in the middle of the turn down pure, (four) biological _ deduction of materials. 2 library 4 table such as 1 production module (10) according to the number of products early (four) Lu Zhi 'list amount calculation - In the case of the whole box, the material number and material number of the s-δ-years are produced. The production quantity of the material is typed in the inventory table (10) and then shipped. Material item number and material quantity = save table immortal order minus the list. Corresponding material debits when the sales type is the return type, the type of cleaning, the number of products and the investigation, and U20 according to the return moxibustion / u - spoon material nickname and material quantity in the inventory 矣 "" _ Continuation, and generate a simple dump in the inventory table, such as the production module mo first according to the number of products in the early ping, the amount of inventory calculation of a full box of products + 1 ° 3 material number and material type in the inventory table m3 In the item number and the quantity of the material, according to the return type - the whole box __==^ 卩 = add the list to the table rib. Generate the corresponding material into the account and then the list generates the 1 group 1l9n u single table 1114. , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , The value is sent to the reconciliation data processing system. In the present embodiment, the receipt data record of the receipt data production factory includes the box number of the collection, the type of shipment and sales, the material number, the quantity of the material, and the lock sale. Unit price and other information. : Send module (10) first read from the transaction data sheet (10) Take the box number, (4) = and the price of the LI household t. Finally, the receipt information will be transferred to the game, and the 1130 will read the box number, the shipping plant, the sales volume, the quantity of the material and the sales order m In the case of the material handling system lake. 4卩__to the reconciliation data In the present embodiment, the production of the n-point material number does not match. The receipt data generation system coffee adopts part of the method, that is, by the list generation module 112〇 Produce two bunker processing table 1114, and then transfer the second and second by the receipt data and store the material in the early table 1114, and the 130 攸 material is clear. According to the material number comparison table lm, the port a will be retracted. The transfer module 1130 can materialize the material number, thereby facilitating the automatic conversion of the material number of the 41 material to the customer, and then the W phase is set by the number of cards and an outer box of the new material. The customer records the material number of the card board and the material number of the material contained in the outer box (4) 5 tiger. At this time, the collection data transfer module 12 200834456 group ωο can automatically convert the material number of the card and the material number of the outer box into the material number of the package according to the item number comparison table 1115. * Reconciliation data processing system 1200 includes a data import module 121, a data storage server 122, a data comparison module, a data buffer module 124, and a query analysis module 1250. The data storage module 1220 includes a payment form 1221 and a payment form 1222. The data entry module 1210 is used to import payment information from the payment data generation system 1100 and to import payment data from the customer system 3000. In this embodiment, the data importing module 1210 imports the payment data from the payment data transmission module 1130, and the information such as the deduction of the deduction, the shipment, the sales type, the material number, the quantity of the material, and the pre-sale price. And the receipt information is stored in the payment form 1221. The data import module 1210 imports the payment data from the customer system 3000 by means of a business-to-business ("business"), ie, the payment box number, the shipping company, the lock type, the material number, the quantity of the item, and the sales. The unit price and other information, and the payment information is stored in the payment form 1222. The shell buffer module 1240 includes a missing table 1241 and an abnormal table 1242. The beaker comparison module 1230 is used to compare the payment data with the payment data, and store the items that do not match the key information of the payment data and the payment data in the missing table 1241' and match the receipt information with the key information in the payment material. The lock sale information does not match the ^ item stored in the exception table 1242. In this embodiment, the key messages include, number, shipment block, material item number, and sales type. The lock sale message includes the sales unit price and the quantity of the material. 13 200834456 . In other embodiments, the key message may also be "different messages" according to different (four) requests. The data comparison module 1230 first determines each item in the payment data and payment data = number, shipment site, material material Whether the number and the sales type match. When the payment is paid * the quantity of the item #u, the shipment of Wei, the material number and the sales type are respectively _bei = 1 - project / box number, shipping plant, The material item number and the sales type are the same. When comparing the two groups to determine the item type rt data item, material item number and lock sale (2) 〇 = material in the corresponding item, the data comparison In the module material ^ tribute, this item is a project whose key message does not match. At this time, the U30 and the group U30 will store the item in the receipt data in the missing table 1241. When the number, shipment, and material number are shipped, the item is the item that does not match the key message in the payment tribute. This kiss comparison module (4) stores the item in the payment data in the missing form_讯·" Project of the target: sales receipt information and payment information The key in the material, ’’ 1:15 is not consistent. When the payment data and payment are made, the sales unit price and material quantity of the matching items are equal. The comparison module 1230 marks the two items in the payment form 14 200834456 1221 and the payment form 1222 as normal. Otherwise, the data comparison Park Group 1230 judges that the two items are the key messages but the sales information does not match the item _. At this time, the data comparison module 1230 marks the items in the payment table 12 21 and the payment form i 2 2 2 that match the key messages but the sales information does not match, and stores the items in the exception table 1242. In other embodiments, the data comparison module 1230 may only mark items that match the key message and the sales message in the payment form 1221 and the payment form 1222 as normal, or only in the payment form 1221 and the payment form 1222. Marks items whose key messages match but the sales message does not match is marked as an exception. The data buffer module 1240 is further configured to feed back the difference data in the missing table 1241 and the abnormal table 1242 to the receipt data generating system as a reference for the revised data generation system 1100 to modify the data. The query analysis module 1250 provides the user with a data query function, including a query.
貝料儲存杈組1220中的元資料及資料緩衝模組124〇中的差異 貝料。且，用戶可藉由查詢分析模組125〇對比差異數據，並 將差異數據反饋錢款資料產生系統11GG，作為收款資料產生 系統1100修正資料之參考依據。 在步驟識，收款資料產生系統11〇〇產生-收款資料。 在步驟S202，對帳資料處理系統麗從收款資料 統1100導入收款資料。 ’、 參閱圖2，為本發明對帳方法—實施方式之流程圖。 在步驟S204，對帳資料声 了帳貝枓處理糸統12〇〇從客戶系統_ 15 200834456 筹入一付款資料。 在本實施方式中，步驟S202與步驟S2〇4之執行順序不 限，可以同時執行，亦可一先一後的執行。 在步驟S206，對帳資料處理系統12⑽對比收款資料與付 款資料。 ~ 在步驟S208，董十帳資料處理系统12〇〇將收款資料與付款 貢料中關鍵訊息不符的項目儲存於缺失表1241。 〃在步驟S210，龍資料處理系統12〇〇將收款資料與付款 貧料中關鍵訊息相符但銷售訊息不符之項目儲存於異常表 1242。 一從而，對帳系統_藉由收款資料產生系統n〇〇與對帳 貧料處理系統12GG之結合自動實現收款資料與付款資料之間 的對帳。 參閱圖3’為圖2中對帳方法之具體流程圖。 …在步驟纖’收款資料產生系統_之儲存模組1110 系統2_接收交易資料，並將交易資料儲存於交易資 料表1111。 、 ㈣易資料表而中讀 取父易貢料。 在㈣S304，清單產生模組⑽根據交易㈣中的工單 二:表m2中查詢每—產品所需的物料 量。 在步驟，清單產生模組·根據交易資料中的銷售 16 200834456 顏型、產减射轉额轉 中進行物料帳目處理，並__ 庫=^ 物料=單包括物料倒扣帳清單與心^ 當銷售類型為出貨類型時，清單產生模組^早根據出貨 類型、產及所查詢之物料料就與 加 中進行物料倒扣帳，双里在犀存表m3 貨類型時，扣帳清單。#_類型為退 負類孓犄/月早產生模組1120根櫨#眢雜拥^ 查詢之物料料號與物料數存了、中品數夏及所 帳，並產生物料甸入帳清單。庫存表1113令進行物料倒入 總述之’步驟S3〇2至纖係描 據交易資料進行帳目處理，並產生物料帳目清單根 在步驟S308，、、主蓥方4 1 單儲存於物料清單表1114。果、、且120將所產生之物料帳目清 中4 了=收款資料傳送模組1130從交易 中5貝取相號、出貨廠別及銷售類型。 在乂驟S3U，收款資料傳送模組1130從物料清單表1114 中讀取物料料號及物料數量。 ^早表⑽ 在步驟S3U，收款資料傳送模組u 1115更新物料料號。在 冢斜说對…、表 节i 貝 式中，生產工廠之部分物料料 戶之部分物料料號不符。收款資料傳送模組 根據料號對照表U15將饵铷 將不付之物抖料號自動轉換為客戶之物 ’進而有利於實現收款資料與付款資料的自動對帳。 17 200834456 ••在步驟S316,收款資料傳送模組謂根據出貨日期與物 科料號從銷售單價表1116中讀取銷售單價。 在步驟S318，收款資料傳送模組113〇將所讀取之箱號、 出狨廠別、銷售類型、物料料號、物料數量及銷售單價等訊息， 即收款育料傳送至對帳資料處理系統12〇〇。 總述之，步驟S310至S318係描述收款資料傳送模組n3〇 财特触mo巾讀取收款資料，並將收款資料傳送至對帳 •資料處理系統1200。 參閱圖4 ’為圖3中節點A之後的流程圖。 在步驟S400 ,對帳資料處理系统謂之資料導入模組 10 k收秋資料產生系統u⑻導入收款資料，並將收款資料 儲存於收款表ml。在本實财式巾，資料導人馳1210從 收款資料傳送模組1130導入收款資料，即收款之箱號、出貨 廠別、銷售類型、物料料號、物料數量及銷售單價等訊息，並 將收款資料儲存於收款表1221。 在y驟S402，資料導入模組121〇從客戶系統3〇〇〇導入 付款資料，並將付款資料儲存於付款表1222。在本實施方式 中’資料導入模組121〇藉由企業對企業的方式從客戶系統3〇〇〇 導入付款資料，即付款之箱號、出貨廠別、銷售類型、物料料 破、物料數量及鎖售單價等訊息，並將付款資料儲存於付款表 1222。 在步驟S404，資料對比模組123〇對比收款表1221中收 18 200834456 款資料與付款表1222中付款資料。 在步驟S406，資料對比模組123〇判斷收款資料與付款表 乏關鍵訊息是否相符。在本實施方式中，關鍵訊息包括箱號、 出貨廠別、物料料號及銷售類型。資料對比模組123Θ對比收 款資料與付款資料中每一項目之箱號、出貨廠別、物料料號及 銷口^型。當收款資料中一項目之箱號、出貨廠別、物料料號 及銷售類型分別與付款資料中一項目之箱號、出貨廠別、物料 鲁料號及銷售類型相同時，資料對比模組123〇判斷此兩項目為 關鍵訊息相符之項目。 當收款資料中一項目之箱號、出貨廠別、物料料號及銷售 類型無法在付款資料中找到相應的項目時，則資料對比模組 1230判斷收款資料中此項目為關鍵訊息不符之項目。 同樣’當付款資料中一項目之箱號、出貨廠別、物料料號 及銷售類型無法在收款資料中找到相應的項目時，則資料對比 模組1230判斷付款資料中此項目為關鍵訊息不符之項目。 如果資料對比模組1230判斷收款資料或付款資料中一項 目為關鍵訊息不符之項目，則在步驟S408,資料對比模組1230 將此項目儲存於缺失表1241。 如果資料對比模組1230判斷收款資料與付款資料中雨項 目為關鍵訊息相符之項目，則在步釅S410,資料對比模組123〇 判斷此兩項目之銷售訊息是否相符。在本實施方式中，當收款 資料與付款資料中關鍵訊息相符之項0之銷售單價及物料數 19 200834456 .里同％相專k ’則寅料對比模組1230判斷此兩項目為關鍵訊 惠相符且銷售訊息相符之項目。否則，資料對比模組123〇判 斷此兩項目為關鍵訊息相符但銷售訊息不符之項目。 如果資料對比模組1230判斷收款資料與付款資料中的兩 項目為關鍵訊息相符且銷售訊息相符之項目，則在步驟S4i6， 資料對比模組1230分別在收款表1221與付款表ι222中將關 鍵訊息相符且銷售訊息相符之項目標記為正常。 如果資料對比模組1230判斷收款資料與付款資料中的兩 項目為關鍵訊息相符但銷售訊息不符之項目，則在步驟以U， 貧料對比模組1230分別在收款表1221與付款表1222中將關 鍵訊息相符但銷售訊息不符之項目標記為異常。 在步驟S414，資料對比模組1230將關鍵訊息相符但銷隹 訊息不符之項目儲存於異常表1242。 "The material in the hopper storage group 1220 and the difference in the data buffer module 124 贝 are the same. Moreover, the user can compare the difference data by the query analysis module 125, and feed the difference data back to the money data generation system 11GG as a reference basis for the correction data generation system 1100 to correct the data. In the step, the receipt data generating system 11 generates a receipt data. In step S202, the reconciliation data processing system MN imports the payment information from the payment data system 1100. Referring to Figure 2, there is shown a flow chart of an embodiment of the present invention. In step S204, the reconciliation information is sounded, and the payment information is raised from the customer system _ 15 200834456. In the present embodiment, the execution order of step S202 and step S2〇4 is not limited, and may be performed at the same time, or may be performed one after the other. In step S206, the reconciliation data processing system 12 (10) compares the payment information with the payment information. ~ In step S208, the Dongke account data processing system 12 stores the items in which the payment information does not match the key information in the payment tribute in the missing table 1241. In step S210, the dragon data processing system 12 stores the items in which the payment information matches the key information in the payment poorness but the sales information does not match in the exception table 1242. Thus, the reconciliation system - by means of the combination of the receipt data generation system n and the reconciliation processing system 12GG, automatically reconciles the payment data with the payment data. Referring to Figure 3', a detailed flow chart of the reconciliation method of Figure 2 is shown. ...in the storage module 1110 of the step-receipt data generation system_system 2_ receives the transaction data, and stores the transaction data in the transaction data table 1111. (4) Easy to read the information sheet and read the father's tribute. In (4) S304, the list generation module (10) queries the quantity of material required for each product according to the work order 2 in the transaction (4): table m2. In the step, the list generation module is processed according to the sales in the transaction data 16 200834456, the production and reduction of the transfer amount, and the __ library = ^ material = single including the material reverse debit list and heart ^ When the sales type is the shipping type, the list generation module ^ deducts the material according to the shipping type, the production and the materials inquired, and the material is deducted from the billing table. List. #_型为退负类孓犄/月早早模块1120栌#眢杂拥^ The material number and material number of the inquiry are stored, the number of products is summer and the account is counted, and the list of materials is generated. The inventory table 1113 causes the material to be poured into the general description of the step S3〇2 to the volume description transaction data for account processing, and the material account list is generated in step S308, and the main party 4 1 is stored in the material. List 1114. Fruit, and 120 will clear the generated material account. 4 = The payment data transmission module 1130 takes the phase number, the shipping site and the sales type from the transaction. At step S3U, the receipt data transfer module 1130 reads the material item number and the material quantity from the bill of materials table 1114. ^早表(10) In step S3U, the receipt data transfer module u 1115 updates the material item number. In the skewed statement, the table i, the part number of the material part of the production plant does not match. The payment data transmission module automatically converts the unsatisfied material to the customer's object according to the item number comparison table U15, which is convenient for automatic reconciliation of the payment data and the payment data. 17 200834456 • In step S316, the payment data transmission module reads the sales unit price from the sales unit price table 1116 based on the shipment date and the material number. In step S318, the receipt data transmission module 113 transmits the information such as the read box number, the shipment type, the sales type, the material item number, the quantity of the item, and the unit price of the sale, that is, the collection and delivery materials to the reconciliation data. Processing system 12〇〇. In summary, steps S310 to S318 describe the receipt data transfer module n3, and the receipt data is transmitted to the reconciliation data processing system 1200. Refer to Figure 4' for the flow chart after node A in Figure 3. In step S400, the reconciliation data processing system refers to the data importing module 10 k, and the receipt data is imported into the collection form ml. In the real money towel, the data guide Chi 1210 imports the payment data from the payment data transmission module 1130, that is, the box number, the shipping company, the sales type, the material number, the material quantity and the sales unit price, etc. The message is stored in the receipt form 1221. At step S402, the material import module 121 imports the payment data from the client system 3 and stores the payment data in the payment form 1222. In the present embodiment, the data importing module 121 imports the payment information from the client system 3 by means of a business-to-business method, that is, the box number of the payment, the shipping plant, the sales type, the material material breaking, and the material quantity. And lock the unit price and other information, and store the payment information in the payment form 1222. In step S404, the data comparison module 123 compares the payment information in the 2008 2008 456 data and the payment form 1222 in the payment form 1221. In step S406, the data comparison module 123 determines whether the payment information and the payment schedule lack key information match. In the present embodiment, the key messages include the box number, the shipping site, the material item number, and the sales type. The data comparison module 123 compares the box number, the shipping plant, the material item number and the pin type of each item in the payment data and the payment data. When the box number, shipping plant, material item number and sales type of the item in the receipt data are the same as the box number, shipping plant, material quantity and sales type of the item in the payment data, the data comparison The module 123 determines that the two items are items in which the key messages match. When the box number, the shipping plant, the material item number and the sales type of the item in the receipt data cannot find the corresponding item in the payment data, the data comparison module 1230 determines that the item in the payment data does not match the key information. Project. Similarly, when the box number, shipping plant, material item number and sales type of the item in the payment data cannot find the corresponding item in the payment data, the data comparison module 1230 determines that the item in the payment data is a key message. Items that do not match. If the data comparison module 1230 determines that an item in the payment data or the payment data is a key message, the data comparison module 1230 stores the item in the missing table 1241 in step S408. If the data comparison module 1230 determines that the payment data and the payment data are items in which the rain item is a key message, then in step S410, the data comparison module 123 determines whether the sales information of the two items matches. In the present embodiment, when the payment information and the key information in the payment data match the sales unit price of the item 0 and the number of materials 19 200834456. The same as the % phase specific k 'then the comparison module 1230 determines that the two items are key messages A project that matches the sales message and matches the sales message. Otherwise, the data comparison module 123 determines that the two items are items whose key messages match but the sales message does not match. If the data comparison module 1230 determines that the two items in the payment data and the payment data are the key messages and the sales information matches, then in step S4i6, the data comparison module 1230 will respectively be in the payment form 1221 and the payment form ι 222. Items with matching key messages and matching sales messages are marked as normal. If the data comparison module 1230 determines that the two items in the payment data and the payment data are the key messages but the sales information does not match the items, then in the step U, the poor material comparison module 1230 is in the payment form 1221 and the payment form 1222, respectively. The item that matches the key message but does not match the sales message is marked as abnormal. In step S414, the data comparison module 1230 stores the items whose key messages match but the information does not match, in the exception table 1242. "
在本發明實施方式中，收款資料產生系統11〇〇與對帳資 料處理系統12〇〇相結合，收款資料產生系統n〇〇為企業資源 規劃系統之構成部件’對帳資料處理系統12GG為資料倉儲系 統之構成部件，從而可減輕企業資源規難統之負擔，同時^ 發揮資料倉儲系統處理大量:#料的優勢。 對帳資料處理系統1200採用差異結果緩存技術，g 將關鍵m符之項目儲存於缺失表1241，並將關鍵訊 但鎖售訊息不爲：夕造曰蚀+ 、付 ⑽^ 存於異常表1242,從而可有致縮短對 帳的速度。 』 20 200834456 證了收款資料之準確:::時:恤 即先藉二二 =1::採用兩段式資料㈣^ 清單表1114,缺後㈣士產物料帳目清單並儲存於物料In the embodiment of the present invention, the receipt data generating system 11 is combined with the reconciliation data processing system 12, and the collection data generating system is a component of the enterprise resource planning system 'reconciliation data processing system 12GG As a component of the data warehousing system, it can alleviate the burden of enterprise resource regulations, and at the same time, the data warehousing system handles a large number of: The reconciliation data processing system 1200 uses the difference result caching technology, g stores the key m-character items in the missing table 1241, and the key information but the lock-selling information is not: 夕 曰 + +, 付 (10) ^ stored in the abnormal table 1242 , which can shorten the speed of reconciliation. 』 20 200834456 The accuracy of the receipt information is verified:::Time: First, borrow two or two =1:: Use two-stage data (4)^ List 1114, after the (four) item product account list and store in the material
廠之物料料號轉換為客=物Γ欠資料模組113G能將生產工 料與付款資料的自動龍。4料號，進而有餅實現收款資 查詢分I的1GGG還藉由查詢分析模組1250提供資料 請。=:發明符合發明專利要件，麦依法提出物 案技藝之人士，tr林發明之較佳實施方式，舉凡熟悉本 杈依本案發明精神所作之等效修飾或變化， 白應包含於以下之申請專利範圍内。 【圖式簡單說明】 圖1係本發明對帳系統-實施方式之環境圖。 圖2係本發料帳方法—實施方式之流程圖。 圖3係圖2中對帳方法之具體流程圖。 圖4係圖3中節點A之後的流程圖。 【主要元件符號說明】 對帳系統 1000 21 200834456 .收款資料產生系統 1100 键存模組 1110 交易資料表 mi 工單表 1112 庫存表 1113 物料清單表 1114 料號對照表 1115 •銷售單價表 1116 清單產生模組 1120 收款資料傳送模組 1130 對帳資料處理系統 1200 資料導入模組 1210 資料儲存模組 1220 收款表 1221 馨付款表 1222 資料對比模組 1230 資料緩衝模組 1240 缺失表 1241 異常表 1242 查詢分析模組 1250 SFC 系統 2000 客戶系統 3000 .22The material number of the factory is converted into the automatic data of the production materials and payment materials. 4 item number, and then there is a cake to realize the payment. The 1GGG of the query point I also provides information by the query analysis module 1250. =: The invention meets the requirements of the patent for invention, and the person who has proposed the technical skills of the law in accordance with the law, the preferred embodiment of the invention of the invention, and the equivalent modification or change made by the invention in accordance with the spirit of the invention, Bai Ying shall be included in the following patent application. Within the scope. BRIEF DESCRIPTION OF THE DRAWINGS Fig. 1 is an environmental diagram of a reconciliation system-embodiment of the present invention. Figure 2 is a flow chart of the method of the present invention. FIG. 3 is a specific flowchart of the reconciliation method in FIG. 2. 4 is a flow chart subsequent to node A in FIG. [Main component symbol description] Reconciliation system 1000 21 200834456 . Collection data generation system 1100 Key storage module 1110 Transaction data table mi Work order table 1112 Inventory table 1113 Bill of materials table 1114 Item number comparison table 1115 • Sales unit price table 1116 List Production module 1120 Collection data transmission module 1130 Reconciliation data processing system 1200 Data import module 1210 Data storage module 1220 Collection form 1221 Xin payment form 1222 Data comparison module 1230 Data buffer module 1240 Missing table 1241 Exception table 1242 Query Analysis Module 1250 SFC System 2000 Customer System 3000 .22