Engineering And Manufacturing Operations Software Programmed in MS Access

P2000 Features

P2000 Details

Solutions

Demo

Contact

P2000  Details

Forms

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

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 customer detail button will open a detailed customer form.  Other combo boxes are used to select such things as salesman, shipping information, and market details.

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, and sales price for each item sold. There is also a note window for each item that can be used when more specific order information is required. 

We know that company order enter requirements are very specific. It is understood 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, Sales Rep, and Vendor Lists

There are three independent lists and detail forms for Customers, Vendors, and Sales Reps. Go to your contact website or send e-mail directly from this form with a single click. Add detail notes, and maintain accurate history information. 

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 a hyperlink that allows direct online access to any component drawing or 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.

Engineering Support

The Engineering Support 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 support 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 Support Form allows any employee making a request the ability to monitor the support request progress. 

Note: The Engineering Support 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 Management

The Engineering Management 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 Management

The Drafting Management 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 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.

Microsoft Access

Click here to see how you can receive more information and a working DEMO of the PEDYN P2000 software program.

  Home      Top of Page    Demo    Contact