1、基于微軟的Access數據庫ERP/MRP PEDYN是一家專門針對開發小企業的生產操作系統、工程管理和文件控制軟件的公司。縱觀公司的P2000企業資源方案ERP/MRP工程，采用微軟Access數據庫平臺所設計開發。P2000系統是一款能完全解決你業務上所有問題的低本錢軟件，從設計觀念，到方案管理和對購置,物料控制，生產和訂購的文件控制。它采用圖解式設計，而且設計了向導，使P2000易學易用。而且因為它采用微軟的Access數據庫開發，所以能與其他產品很好的兼容，并能很容易地根據客戶的需要，做二次開發。這個軟件還能根據所需的模塊和貴公司的其他ERP/MRP軟件同時使用。P2000是可擴展的,

2、有柔性的，而且為中小型的工程或制造公司提供了是近乎完美的低費用解決方案。那為什么還要把資金投入到那些昂貴而復雜卻并不適合公司的特殊要求的東西上去呢？由于使用了微軟的Access作為前置操作系統，這意味著你能擁有完整的控制性和靈活性。在你需要的時候，能生成新的報表，無論你選擇哪一個操作系統都能得到擴展。ERP軟件的種類和特征1. 制造和操作模塊：制造軟件、生產方案、操作軟件、操作方案、制造解決方案、產品管理方案、產品控制管理、離散制造、產品方案、制造資源方案、物料需求方案MRP、制造資源方案MRPII、企業資源規劃ERP、企業資源規劃軟件、MIS、庫存補給系統、產品工作流程管理、產品管理、供給鏈

3、管理、SCM、材料管理、業務管理、企業的方案與調度、多用戶制造控制軟件、物料清單管理、物料清單控制、產品管理、庫存控制軟件、小企業解決方案、小企業MRP 、小企業ERP。:工程管理軟件、工程軟件、工程方案、工程工程管理、軟件方案，設計管理軟件、工程師任務管理、工程任務管理、每日任務管理、工作、工程變更通知、工程變更請求、工程變更順序、工程變更命令、 ECN 、 ECO 、 DCO 、 DCN 、 ECR、 DCR、工程操作、工程工程方案和日程安排、在線任務管理。:文件控制軟件、文件控制管理、發票簽發控制、結構控制管理、結構管理軟件,結構控制軟件、匯票管理,文件變更順序、變更命令 、BOM 軟件

4、、物料清單BOM、多層次訂貨、參考指示、制圖任務管理、制圖人員、CAD 、AUTOCAD ，結構管理、電子文檔管理、企業文件管理系統、規格管理、提貨控制，修正控制、工作流程系統、規格控制圖，資源控制圖、SCD ，制造生產圖畫，集成圖、在線信號開關表、工程變更命令、ECN 、ECO 、DCO、DCN 、ECR 、DCR 、BOM 、PDM 產品數據管理，PDM 軟件、PDM Access數據庫。:制造命令 、 集合命令 、 建立命令 、 配置命令、網狀自動化制造、預測、標準的本錢計算、物料接收，裝載運送，資源，主要的日程安排，生產能力、 車間裝載和能力方案、業務流程、工作車間、工序路線安排、電子

5、命令流程、要求命令、行程安排，廢料，生產本錢、勞動力、 WIP 、完成的貨物、庫存控制、物料清單控制、標準本錢，標準本錢的計算、平均本錢的計算、平均費用、預測、傳輸、精選目錄、廠商目錄、成份、匯總、材料方案、需求方案，預測、銷售方案、分配方案、制造方案、工作順序管理、客戶順序管理、命令輸入、定價，裝運、載入廠房、 工藝路線安排、工程主管、零件清單、零件說明書、 采購單 、購置命令、PO、采購、工作指令、銷售順序 , 命令輸入、客戶需求流程、入庫單,退貨單、裝載運送、零件裝配、總裝，產品本錢計算、主要產品安排、 碼頭庫存、驗貨、測試、參照ISO 9000、參照ISO 9001 、財政和會計接口、

6、可付帳目、帳戶應收帳款、主要分類帳、開發票、本錢管理、 財政控制、現金流動預測、財政預測、方案系統、發票、追蹤、分析、人力資源、薪資帳冊、人事管理。:MS Access 數據庫平臺、 Microsoft Access數據庫、 MS Access97、 MS Access2000、 WindowsXP( 2002 2003)、 MS Access Forms、Microsoft Windows 98、 Microsoft Windows 2000, Microsoft NT、 Microsoft XP、 Excel、 SQL、MySQL、 ACCESS 、EDYNE、 PEDYNAMICS, P

7、2000, Software, Program, Custom, Customized, Access Programming, Custom Database, Low Cost, LOW COST, Free Demo, Free Trial 等等。:PDM產品數據管理, 重復產品經營、 商業方案、出售和操作方案、 發布需求方案、 能力需求方案、 CRP、 業務管理、 產品數據管理、 信息管理系統、 倉庫、 配送中心操作、 倉庫經營系統、WMS、 電子的數據交換、 EDI、 客戶關系管理、 CRM、 公司解答、QRM、 快速反響生產、補給鏈方案、供給商管理、存貨清單、 VMI、位置定位方案

8、、資源配送方案、 DRP、 資源監測、 行政管理、 JIT、需求方案、 需求鏈、商業智囊、智能企業、流程技術、 商業解答、 敏捷電子商務、 QuickBooks、 PeachTree、 質量管理。物質的需求方案概論物質的需求方案 (MRP)是為協助制造商管理存貨清單和產品而設計的。使用MRP能保證原材料得到充分的使用，生產時間也更為適當，而不會因為原材料到貨太早而過度地消耗掉。MRP能夠配合預期需求和補給生成如果需要的話或修正產品方案，以保證及時地消耗掉原材料和全部的零部件。MRP為每一個終端產品或零部件從頭到尾地編制物料清單BOM，這些清單是生產終端產品或零件所需要的。從理論上講，這些物料的

9、編制要繼續循環，例舉出每一個所需零部件的子部件，一直到新的原材料物料清單的出現。在實踐中，某一個制造商可能會比擬喜歡去擴展一個專門例舉的，并且是假設建立在零件或原材料同一水平需求上的那種物料清單。其次，MRP需要與每一個制造或裝配生產過程有關的引導時間信息，以生產出需要的零件或終端產品。引導時間是將零件制造或裝配成為終端產品或更高一級的零件所需要的時間，并且包含全部所需要的已有零件的生產和裝配的時間。這些引導時間可能將根據每個單位的零件/產品或預期要生產的一批零件的尺寸進行編碼。MRP結合物料清單、引導時間和對所需終端產品的預計，生成一個主產品方案表，這個方案表是一個生產和裝配的詳細安排，能讓

10、生產商到達預期的產量。這個時間表只表示出裝配或生產的最終水平即產生終端產品，并且包括了產品的用時和產量。主產品方案表為MRP更高一級的信息提供源信息。采用主產品方案表就如同有了一個起點，這在概念上是個很簡單的事但對計算機語言的要求很高，結合引導時間的數據和物料清單去推動零件也可能是原材料需求的時間方案，盡管有多種裝配和生產方式供制造商選擇。這個時間表這些工程：中間產品、當前庫存、原材料和零件的待辦定單、零件的直接需求作為要解決的因子。使用了這個需求時間表，制造商肯定會決定出一個滿足這些需求的原料補給解決方案。廣泛而多樣的排序規那么和直觀推斷法要合并到基于計算機的MRP模塊中。除了物料需求，其他

11、有用的數據也從主產品方案表中生成，這包括方案中每個終端產品的清單、方案中每個裝配和生產過程的時間表，還包括方案中對特殊產品能力的利用。這些數據信息都應該能幫助我們估算出當前或潛在的物料補給需求策略。計算機對MRP的真正實施有著很大幫助，因為大量數據處理需要原始的物料需求數據。另外，整個分析有時可能必須在條件不斷變化之中重復很屢次比方，命令的變化，生產流程的變化，物料需求的變化等。這就需要條理清晰的電腦了。這里有個例子說明了在SAS/AF實際運用中使用SAS/OR軟件尤其是PROC CPM和PROC GANTT平臺。假定一個服裝制造商采用了物料需求方案，只有少局部數據步和相關的簡單流程來自SAS

12、/OR, Base SAS,和SAS/GRAPH所需的計算操作，來支持這個運作。其實很少會用單一地假定去限制這個樣板運作的范圍，在實際運用中，是會放開手腳地把更為繁雜、更為實際的MRP設置運用起來。這個運用也可以在更加廣泛的生產和物料清單控制系統中去實現MRP模塊。MS Access MRP Manufacturing Resource PlanningSmall Business MRP - Small Business ERP Microsoft Access Database ERP MRP Program ERP / MRP Manufacturing S

13、oftware ProgramPEDYN specializes in Small Business Manufacturing Operations, Engineering Management, and Document Control Software. See the all in one P2000 Enterprise Resource Planning (ERP / MRP) program that uses Microsoft Access as the program platform. The P2000 is a powerful Low Cost solution

14、for your complete business operations, from design concept, project management and documentations control to purchasing, material control, manufacturing, and order entry. It's graphical design and drill down navigation make the P2000 very easy to learn and use. Since the program is completely wr

15、itten using Microsoft Access, it interfaces well with other products, and can be easily customized to fit your ever changing business requirements. The program can be used along with other ERP / MRP programs that your company may be using by activating only the modules that you require. The P2000 is

16、 expandable, flexible and provides the perfect low cost solutions for small to mid size engineering and manufacturing companies. Why spend a fortune on expensive complicated system programs that are not easily adaptable to your specific needs. Using Microsoft Access as a front-end operating sys

17、tem means that you have full control and flexibility. Create new forms and reports as you need them. Expand your operating system anyway you choose. ERP software Categories and Features 1.Manufacturing and Operations Modules:Manufacturing Software, Manufacturing Program, Operations Softwar

18、e, Operations Program, Manufacturing Solutions, Production Management Program, Production Control Management, Discrete Manufacturing, Production Planning, Material Requirement PlanningMRP， Manufacturing Resource Planning MRP II, Enterprise Resource Planning, ERP Software, MIS,  Stock Reple

19、nishment Systems, Production Workflow Management, Product Management, Supply Chain Management, SCM, Supply Management, Materials Management, Business Management, Planning and Scheduling Enterprise, Multi-User Manufacturing Control Software, Inventory Management, Inventory Control, Product Manag

20、ement, Stock Control software, Small Business Soluitions, Small Business MRP, Small Business ERP2.Engineering Modules:Engineering Management Software, Engineering Software, Engineering Program, Engineering Project Management Software Programs, Design Management Software Engineer Task Management, Eng

21、ineering Task Management, Daily Task Management, Tasking, Engineering Change Notice, Engineering Change Request, Engineering Change Order, Engineering Change Orders, ECN, ECO, DCO, DCN, ECR, DCR, Engineering Operations, Engineering Project Planning and Scheduling, Online Task Management3.Docume

22、ntation Modules:Documentation Control software, Document Control Management, Drawing Control, Configuration Control Management, Configuration Management Software, Configuration Control Software, Drafting Management, Document Change Order, Change Orders, BOM software,  Bill Of Materials, Indente

23、d Multi Level, Reference Designators, Drafting Task Management, Draftsman,CAD,  AUTOCAD, Configuration Management, Electronic Document Management, Enterprise Document Management Systems, Specification Management, Release Control, Revision Control, Workflow Systems, Specification Control Drawing

24、s, Source Control Drawings, SCD, Fabrication Drawing, Assembly Drawings,  Online Sign-off and Approval Forms, Engineering Change Orders, ECN, ECO, DCO, DCN, ECR, DCR, BOM, bom, PDM Product Data Management, PDM Software, PDM Access Database4.Processes:Make To Order, Assemble To Order, Build To O

25、rder, Configure To Order, Cellular Manufacturing, , Forecasting, Standard Costing, Material Receiving, Shipping, Resources, Master Scheduling, Production Capacity, Shop Loading and Capacity Planning, Business Processes,  Job Shop, Routing, Electronic Order Processing, Demand, Scheduling, Scrap,

26、 Product Cost, Labor, WIP, Finished Goods, Stock Control, Inventory Control, Standard Cost, Standard Costing, Average Costing, Average cost, Forecasting, Delivery, Pick List, Vendor List, Components, Sub Assemblies, Material Planning, Demand Planning, Forecasting, Sales Planning, Distribution Planni

27、ng, Production Planning, Work Order Management, Customer Order Management, Order Entry,  Pricing, Shipping, Load Building, Routing, Item Master, Parts List, Parts Book, Purchase Order, Purchase Orders, PO, Purchasing, Work Order, Sales Order, Order Entry, Customer Order Processing, Shop Or

28、der, Back Order, Shipping Order, Parts Allocation, Allocations, Product Costing, Master Production Scheduling,  Dock-to-Stock,  Inspection, Testing, ISO 9000 Compliant, ISO 9001 Compliance, Finance and Accounting Interface, Accounts Payable, Accounts Receivable, General Ledger, Invoicing,

29、Cost Management,  Financial Control, Cash Flow Forecasting, Financial Forecasting, Planning System, Invoice, Tracking, Time, Analysis, Human Resources, Payroll, Time, Personnel5.Platform:MS Access Database Platform, Microsoft Access Database, MS Access97, MS Access2000, MS Access 97, MS Access

30、2000, Access XP 2002 2003, MSAccess Forms, MSAccess Reports, Microsoft Windows 98, Microsoft Windows 2000, Microsoft NT, Microsoft XP, Excel, SQL, MySQL, ACCESS PEDYNE, PEDYNAMICS, P2000, Software, Program, Custom, Customized, Access Programming, Custom Database, Low Cost, LOW COST, Free Demo, Free

31、Trial6.Other:PDM Product Data Management, Repetitive Production Management, Business Planning, Sales and Operations Planning,  Distribution Requirements Planning, Capacity Requirements Planning, CRP, Process Management, Product Data Management,  Information Management Systems, Warehousing,

32、 Distribution Center Operations,  Warehouse Management Systems, WMS, Electronic Data Interchange, EDI, Customer Relationship Management, CRM, Company Solutions, QRM, Quick Response Manufacturing, Supply Chain Planning, Vendor Managed Inventory, VMI, Site Location Planning, Distribution Res

33、ource Planning, DRP,  Resource Monitoring,  Administrative Management, JIT, Demand Planning, Demand Chain, Business Intelligence, Intelligent Enterprise,  Flow Techniques, Business Solutions, Agile E-Business, QuickBooks, PeachTree, Quality ManagementMaterial Requirements Planning Ove

34、rviewMaterial Requirements Planning (MRP) is designed to assist manufacturers in inventory and production management. Using MRP helps ensure that materials will be available in sufficient quantity and at the proper time for production to occur, without incurring excess costs by having the materials

35、on hand too early. MRP assists in generating and (as needed) revising production plans to meet expected demands and replenishment plans to assure the timely availability of raw materials and all levels of product components.MRP begins by compiling a Bill of Materials (BOM) for each end product or co

36、mponent of interest. This is a listing of the components and quantities that are needed to manufacture the end product or component. Theoretically, the compilation of BOMs continues recursively, enumerating the subcomponents that are needed to manufacture each component, until only raw materials app

37、ear in the generated BOMs. In practice, a manufacturer may prefer to extend the BOM enumeration for only a specified number of levels and to assume that components and/or raw materials beneath that level are available on demand.Next, MRP requires information on the lead times associated with each ma

38、nufacturing or assembly procedure that is required to produce the components and end products. Lead time is the time required to assemble or manufacture the needed components into the end product (or higher-level component), and thus is the time elapsed between the point at which all needed componen

39、ts are present and the end of assembly or manufacturing. These lead times may be compiled per unit of each component/product or may be based on predetermined batch sizes.MRP combines the BOMs, the lead times, and estimates of demand for end products to generate the Master Production Schedule, which

40、details a schedule of assembly and production that enables the manufacturer to meet the estimated demand. This schedule addresses only the final level of assembly or production (resulting in end products), and includes both the timing and quantities of production. The Master Production Schedule serv

41、es as the basis for all further output information from MRP.Using the Master Production Schedule as a starting point, it is a conceptually simple (but computationally demanding) task to combine it with the data on lead times and BOMs to derive a schedule of component (and possibly raw materials) req

42、uirements, through as many levels of assembly and production as the manufacturer chooses. This schedule can account for such factors as work-in-progress, current inventory of and pending orders for materials and components, and direct demand for components as service items. Using this schedule of re

43、quirements, the manufacturer must determine a material replenishment strategy that satisfies these requirements. A wide variety of ordering rules and heuristics can be incorporated into computer-based MRP models.In addition to the material requirements, other useful data can be generated from the Master P