Menu
Index

The Part / Item Database

 
Note:  MasterQ can be used by companies offering products or services to their customers.  We often refer to these offerings as "Parts" or "Items" but they could just as easily be "Services". 
 
 
MasterQ includes Agenda Development's powerful Parts database.  This tool will hold a vast amount of information about the items you sell and allows all of your authorized users to access this information quickly.  If you add other Agenda Development programs, additional features will be included in the part database.
 
The parts database can be used to track:
  • Standard Pack quantities
  • Drawings & Product Information Sheets
  • Certifications on file
  • Current, available and allocated inventory
  • Purchased part lead time (requires additional modules)
  • Kan-Ban status (requires Targets program)
  • Forecast and Historical sales records
  • Bill of Material & Where-Used listing (requires additional modules)
  • Current open customer orders (requires additional modules)
  • Quotes issued for a selected part
  • Related parts that should be suggested to the customer as up-sell items
  • Unlimited notes about the part.
  • Information about your competitors
  • Much more
 

New Part records may be created in one of three ways:

 

Adding one record at a time, as needed

The simplest way to add new parts is to manually add them to your database when you need to issue a quote.  You enter the information one time manually and the information is available for you to use over and over in future quotes.  This is an easy way to get started especially if you do not have a large number of parts. 
 
On the other hand, if you have a significant number of items it may take a long time before you have all your information available.  In this case, you may choose to import the part information from another system as explained below.
 
See how to manually create a new part number record here:
 
 

Importing part information from another system

If you have another system and the ability to export information from the other system into an ASCII or CSV file, importing the information is the quickest way to get your database set up.
 
See how to import part information here.
 
 
 

Creating new part records while importing sales history

The benefits of MasterQ are enhanced if you have another system and the ability to export sales history information from the other system into an ASCII or CSV file.  When new items are found when importing your shipment history, a new part record is automatically created.
 
How to import part information:
 
 
 

Importing part information from another program

You may choose to add parts one at a time as needed, or you can import a CSV file that has been exported from some other program that you already have in place.  While you will still want to "tweak" the information, importing this way can save you a lot of time.
 
To do this, you will need some other existing program that contains your part numbers and descriptions and the ability to export information from that application in an ASCII or CSV file format.
 
For more information see Creating Part Records by Importing