Applications
System Manager
General Ledger
Accounts Receivable
Accounts Payable
Currency Manager
Inventory
Sales Orders
Purchase Orders
Project/Job Costing
Bill of Materials
U.S. Payroll

Learn more
View Web Help

AdaptAccounts source code accounting software for Microsoft SQL Server

 


Bill of Materials

N-level Bill of Materials Processor. AdaptAccounts for SQL Server 2012 provides a true N-level Bill of Materials processor.

Common subassembly definitions. Subassemblies can be common to more than one higher level assembly. You only need to define that subassembly once and then just refer to that definition from all higher level assemblies. Changing the subassembly definition reflects it automatically in all those higher level assemblies.

Easy to extend. Bill of Materials is designed for easy extension to suit your own requirements. Bill of Materials definitions and the input and output of an explosion are saved in standard database tables.

Easy maintenance. Maintenance of Bill of Materials specifications is easy to do. You can either specify a Master or Detail part by entering its Product code or simply select it from the Product table using the lookup help feature which is always available.

Bill of Materials maintenance task supports maintaining all Master and Detail specifications and also provides these views and reports...

  • The Master-Detail view shows the Details for each Master. All Masters are available, including both top-level and intermediate.
  • The Indented Bill of Materials view shows the complete Indented Bill of Materials view for each top-level Master. This view includes all intermediate masters and details.
  • The Exploded Bill of Materials view shows the fully exploded details for each top-level Master. This provides the aggregate Quantity for each Detail and suppresses intermediate Masters.
  • The Where Used view shows all the Masters in which a Detail occurs and the aggregate total Quantity of that Detail in that Master.

Click here for a sample screen-shot for "Bill of Materials maintenance" showing the "Master-Detail" page.

Click here for a sample screen-shot for "Bill of Materials maintenance" showing the "Where Used" page.

View Bill of Materials task provides these immediate views that can be accessible to users who may not have rights to the maintenance task...

  • The Master-Detail view shows the Details for each Master. All Masters are available, including both top-level and intermediate.
  • The Indented Bill of Materials view shows the complete Indented Bill of Materials view for each top-level Master. This view includes all intermediate masters and details.
  • The Exploded Bill of Materials view shows the fully exploded details for each top-level Master. This provides the aggregate Quantity for each Detail and suppresses intermediate Masters.

Click here for a sample screen-shot for "View Bill of Materials maintenance" showing the "Exploded" page.

Bill of Materials reports

  • The Master and Detail report lists the component Detail parts for each Master part. All Masters are included, both top-level and intermediate.
  • The Indented Bill of Materials report provides a full listing of the complete Indented Bill of Materials view for each top-level Master. This includes all intermediate masters and details.
  • The Exploded Bill of Materials report provides the fully exploded details for each top-level Master. This provides the aggregate Quantity for each Detail and suppresses intermediate Masters.
  • The Where Used report lists all the Details with all the Masters in which the Detail occurs with the aggregate total Quantity of that Detail in that Master.

Integration with Purchasing. Bill of Materials works closely with Purchasing. Internal Purchase Orders specify the Products and Quantities to be exploded.

Integration with other Applications. Bill of Materials is designed for easy integration with other applications. BmInput demand and the resulting exploded BmOutput demand are saved in database tables so that information can be easily passed to other applications.

General operation. Bill of Materials definitions are set up and maintained using the maintenance task. When you run the Explosion task, internal Purchase Orders requested for explosion provide the input into the Bill of Materials and are saved in the BmInput table. Alternatively, you can load the BmInput table from some other source before running the explosion task and then explode that previously loaded data. The exploded demand from BmInput is put into the BmOutput table. You can print either of both of these tables after the explosion. The BmInput and BmOutput tables are not emptied until you run the next explosion. This supports easy extension and integration with other applications.

Easy report changes. All reports are based on a visual report designer so they can be readily changed. Additional reports may also be readily created using any of the various report designer tools for Microsoft SQL Server.

Company   Products   Downloads   Support   Partners   Contact Us

Copyright 1995-2012 Adapta Software Inc. All rights reserved.  Legal Notices.