Access PEDYN

Engineering And Manufacturing Operations ERP Software  

Using MS Access Database

Go to Main Page

 

Introduction

The P2000 is a powerful Engineering and Manufacturing Operations Program that uses Microsoft Access as a platform. The graphical design and drill down navigation make the P2000 very easy to learn and use. Since the program is completely written using Microsoft Access, it interfaces well with other products, and can be easily customized to fit your business requirements. The P2000 is expandable, flexible and provides the perfect low cost solutions for small to mid size engineering and manufacturing companies.  (See the PEDYN Main Page for graphics)

Program Navigation

The program layout makes it extremely easy to  navigate through the program forms. The Main Switchboard is a launching pad that opens top level program forms. Each top level form contains drill down navigation buttons that take the user to the next level of record detail, related forms or sub-form. The lower level forms have navigation buttons that allow the user to navigate back one step at a time, or to go directly to the main switchboard. This layout puts related information one or two clicks away. The color coded display helps the user to navigate between open forms with a single glance.

Item Master

The Item Master is a complete parts list of all company items. The main screen gives a quick summarized list of parts, descriptions, vendors, and drawing information. Drill down to the item detail form to set item cost, units of measure, quantity in stock, and low stock level alerts.  There is a navigation filter on the main screen that makes item filtering and grouping quick and easy. The form also provides quick navigation to item notes, bill of materials, and where used information. There is a hyperlink that allows direct online access to any component drawing or data sheet, provided that the appropriate drawing viewers are installed. 

Inventory Log and Inventory Details

The Inventory Log is a complete summarized parts list of stocked company items. It provides a quick and easy means for reviewing company inventory. It features low level stock alert settings and visual alarms. There are also quick component filters that allow you to easily narrow your search. Drill down to Inventory Details to review unit cost, work order and sales order allocation information for each item. The form displays where used details, and quantity on order. 

Purchase Orders

The Purchase Order Form allows the buyer to select components directly from the Item Master. The descriptions, vendor information and cost are automatically inserted onto the form. Each item on the order form has it's own order date, delivery date, and detail notes for documenting tracking and receiving information. Total costs are automatically calculated based on quantity and unit prices. Department and project information is also captured with this form. All signatures for request, approval, ordering and receiving are made directly to the online form, and are password protected.

 

Work Orders

The Work Order Forms consist of a summary page and detail form. The work order items can be built to stock or built to order.  Sales order items can be selected directly from an active order list. The information required to open the work order is automatically inserted. The details can be manually adjusted if desired. If the Documentation for a given order item is not complete or if an engineering change notice is active for the work order item, visual warnings will appear on the screen to indicate all issues that must be resolved. The stock is checked for all required components and low quantities will be clearly evident. Once an item has been built it will automatically be added to finished goods inventory and the used components will be back-flushed from stock when the work order is closed.

 

Order Entry

The most crucial  process at any company  would undoubtedly be order entry. It is critical that all customer requests are recorded  accurately and completely. The Sales Order Form is setup to be straightforward and easy to use. 

Just select the customer from the auto-dropdown  combo box, and all address information is automatically entered. If the order is from a new customer or the customer address information needs to be updated, a simple click on the ADD or EDIT button will open a detailed customer form.  Other combo boxes are used to select such things as salesman, shipping information, and market details. Detailed market information can be very helpful when analyzing your company's business. 

Ordered items are selected from a dropdown combo box that is linked to the company item master and  product query. Selecting an item from the list will automatically provide, descriptions, list price, and company stock information. Order entry personnel simply fill out the quantity ordered, sales price, customer request date, and company commit date for each item sold. There is also a note window for each item that can be used when more specific order information is required. 

A sales commission sub-form is also included on the Sales Order form. 

We know that company order enter requirements are very specific. It is assumed that no standard order entry form would meet all the requirements of any company. This form however, can be easily modified, as well as all of the P2000 program forms, to meet the specific needs of your company. 

 

Shipping Form

The Shipping Form is a sub-form of the sales order. The form provides a means for the manufacturing and shipping departments to enter sales item manufacturing notes, serial numbers, courier tracking information, and item shipped date. This form also back-flushes the quantity shipped from the company's inventory.

 

Customer List

The Customer List is a sub-form of the Sales Order form. It provides a quick and easy way to add and maintain an accurate customer database for your company order entry form.

 

Product and Price List

The product list is a convenient form that quickly references all products sold and displays unit cost information, price list and profit margin calculations

 

Released Order Item Summary

The Released Order Item Summary provides a summarized list of all sales order items in one convenient form.  By monitoring this form, manufacturing planners will be immediately notified of all newly released sales items, allowing them to actively open any or all necessary work orders to cover each sales item.

 

BOM Processor

The BOM Processor is a costed bill of materials used by the engineering department to create and edit company bill of materials. This form makes it easy to create and edit BOMs by selecting parts directly from a dropdown combo box. The descriptions, and other detail information are automatically inserted onto the form. There is a large area for reference designator information and  hyperlinks that go directly to each component data sheet. From the BOM Processor one can quickly drill down to the next BOM level or display where used information for each part on the list. There is also a navigation button on each record that opens the item master and displays component specific information.

 

BOM with Phantom Blow-Through

Phantom BOMs are often used for kits of components that are common to multiple products but are not built up or stocked as an item. The blow-through option allows the user to blow through these phantom BOMs  and thus shows these second level components as if there were on the top level list. 

 

Multi-Level BOM

The Multi-Level BOM blows-through all sub-assembly levels and displays every component that makes up a product. These components are  grouped by parent items. 

All BOM Forms are accessed using a common BOM Log that makes navigation extremely simple.

 

ECN (Engineering Change Notice / Documentation Control)

The ECN form is a powerful tool designed to simplify documentation control and document all engineering changes. This form allows the engineering department to clearly define and document changes made to all controlled documents, from component and assembly drawings to bills of materials. The ECN form is linked to the Item Master allowing quick entry to any company component or drawing. When an item is entered onto the ECN form, the description, revision  as well as component stock information is automatically displayed. Effectivity details and notes can also be entered for each item on the ECN form. The ECN has a password protected  approvals column for department signatures along with signature controls for drafting, checker, and final implementation verification.  An active status control is displayed at the top of the form and is automatically updated at each process stage until final implementation has been verified. 

The ECN provides a well documented history of all changes made to company drawings. This information is easily accessed making documentation control and revision tracking quick and painless. The ECN form is just one of several powerful tools in the P2000 program designed to guaranty accurate documentation control.

 

Controlled Drawings

The Controlled Drawings Form lists all documents that have been defined as controlled drawings. This form provides  quick and easy reference to documentation revision, status, as well as information on any active ECNs written against a document. From the Controlled Drawings Form you can drill down to the Initial Drawing Release and Approvals Form, or quickly check where-used information provided in the Used On Sub-form.

 

Initial Drawing Release Approvals

In today's electronic age where hardcopies are quickly becoming a thing of the past. The Initial Release Approvals Form provides a means for online drawing release and sign-off. All signatures are password protected through individual user logon. Using this form as the initial approval master, the drafting department can transfer the approval information to the actual drawing file as part of any formal release process. This form is accessed from a navigation button on the Controlled Drawings Form

 

Print Request

The Print Request Form provides a means for anyone in the company to request a hardcopy of any company document. This form is intended to be monitored by the drafting or documentation department. When a print request has been entered, the documentation personnel will be immediately notified by a visual and audible chime and will be continually reminded until they respond with input to the request status. 

Note: Item Master provides a hyperlink to all company drawings and allow each employee to have direct online access to any company drawing provided that the appropriate drawing viewers are installed.

 

Engineering Request

The Engineering Request Form is an important  tool that provides employees with a way to make requests for engineering support, such as part number assignments, new BOMs, and drawing corrections. Using this form to request support from engineering means that the request will be permanently documented and it will be promptly reviewed and responded to. The request form is linked to the company item master making it easy to reference any company part number or drawing. The form provides a detailed request status, priority, and indicates the initials of the engineer assigned to the request. The real time status on the Engineering Request Form allows any employee making a request the ability to monitor the request progress. 

Note: The Engineering Request Form is not intended to set or direct engineering priorities or to initiate projects. It is simply a way for company associates to communicate critical day-to-day design and operation issues to the engineering department.

 

Engineering Task List

The Engineering Task Form is a powerful engineering management tool. The engineering manager enters tasks, assigns an engineer to the task and sets the task priorities. The interactive status control is used by both the engineers and the manager to communicate task issues and provide real time task status and feedback to all engineering department employees. This form makes department project communication  and engineering priorities clear to all that have a need to know. 

 

Drafting Task List

The Drafting Task Form is a very important document control tool. Draftsmen should work exclusively from this form. The tasks and priorities are set by the documentation manager, and the draftsmen use the interactive status control to communicate the status of their progress back to the manager. The form also provides communication to the engineers responsible for a drafting project so that they may provide support and respond to request from drafting when it is time to review or sign-off a drawing. The drafting task form is linked to the Controlled Drawing Form and to the ECN Form. The task may be triggered by the approval of an engineering change notice. The form captures draftsmen workload, response time, and makes drafting priorities clear to all that have a need to know.

 

Accounting And Program Interface

Since the P2000 program is written using MS Access it can be easily interfaced with most accounting software.  Link to Excel, Word, AutoCAD, PDF files, Outlook, and more.  Write customized Access reports. Create new forms, build and expand the program to meet your ever-changing needs. The P2000 program provides the perfect low cost solution for small to mid size engineering and manufacturing companies.

 

Summary of P2000 Key Features

  • Switchboard / Drill Down Navigation
  • Item Master (Company Parts List)
  • Inventory List
  • Inventory Details and Allocations
  • Where Used List
  • Product List
  • Purchase Orders
  • Work Orders
  • Order Entry
  • Customer List
  • Salesman and Commission Details
  • Released Order Item Summary
  • Shipping Order
  • Expandable and Flexible
  • Low Cost
  • Bill Of Materials Processor
  • BOM with Phantom Blow-Through
  • BOM with Multi-Level Blow-Through
  • Engineering Change Notice
  • Documentation Control
  • Controlled Drawings List
  • On Line Drawing Sign-off
  • Print / Document Request Form
  • Engineering Support Request Form
  • Engineering Task Management
  • Drafting Task Management
  • Project & Department Management
  • Multi-Level User Security & Permissions
  • Interfaces with Accounting Programs
  • Write Custom Reports and Create New Forms

Go To PEDYN.COM Main Page

 

 

 

 

 

Manufacturing and Operations Modules:

Manufacturing Software, Manufacturing Program, Operations Software, Operations Program, Manufacturing Solutions, Production Management Program, Production Control Management, Discrete Manufacturing, Production Planning, Manufacturing Resource Planning, Material Requirement Planning, MRP,  Material Requirements Planning, ERP, Enterprise Resource Planning, ERP Software, MIS,  Stock Replenishment 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, Product Management

Engineering Modules:

Engineering Management Software, Engineering Software, Engineering Program, Engineering Project Management Software Programs, Design Management Software, Engineer Task Management, Engineering Task Management, Tasks, 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 Management

Documentation Modules:

Documentation Control, Document Control Management, Drawing Control, Configuration Control Management, Configuration Management, Drafting Management, Document Change Order, Change Orders, BOM,  Bill Of Materials, Bill Of Material, Bills Of Material, Bills Of Materials, Multi Level, Blow Through, Phantom, Reference Designators, Drafting Task Management, Draftsman, Draftsmen, CAD, AUTOCAD, Configuration Management, Electronic Document Management, Enterprise Document Management Systems, Specification Management, Release Control, Revision Control, Workflow Systems, Specification Control Drawing, Specification Control Drawings, Source Control Drawing, Source Control Drawings, SCD, Fabrication Drawing, Fabrication Drawings, Assembly Drawing, Assembly Drawings,  Online Sign-off and Approval Forms

Processes:

Make To Order, Assemble To Order, Build To Order, Make To Stock, Configure To Order, Cellular Manufacturing, Backflushing, Backflush, Back flush, Forecasting, Standard Costing, Material Receiving, Shipping, Resources, Master Scheduling, Production Capacity, Shop Loading and Capacity Planning, Discrete, Business Processes,  Job Shop, Routing, Electronic Order Processing, Demand, Scheduling, Scrap, 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 Planning, 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, Work Orders, Sales Order, Sales Orders, Order Entry, Customer Order Processing, Shop Order, Back Order, Shipping Order, Parts Allocation, Allocations, Product Costing, Master Production Scheduling,  Dock-to-Stock,  Inspection, Testing, ISO9000, Finance and Accounting Interface, Accounts Payable, Accounts Receivable, General Ledger, Invoicing, Cost Management,  Financial Control, Cash Flow Forecasting, Financial Forecasting, Planning System, Invoice, Tracking, Time, Analysis, Attendance, Labor, Human Resources, Payroll, Time, Personnel

Plateform:

MS Access Database Platform, Microsoft Access Database, MS Access, MS Access97, MS Access2000, MS Access 97, MS Access 2000, MS Access Forms, MS Access Reports, Microsoft Windows 98, Microsoft Windows 2000, Microsoft NT, PEDYN, Pedyn, pedyn, PEDYNE, PEDYNAMICS, P2000, Software, Program, Custom, Customized, Access Programming, Custom Database, Low Cost, LOW COST, Free Demo, Free Trial

Other:

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, Distribution Center Operations,  Warehouse Management Systems, WMS, Managed Warehouse Systems, 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 Resource Planning, DRP,  Resource Monitoring,  Administrative Management, Just In Time, JIT, Demand Planning, Demand Chain, Business Intelligence, Intelligent Enterprise,  Flow Technology, Flow Techniques, Business Solutions, E-Business, Quality Management

 

GO  To PEDYN.COM Main Page