Data Manager Database Module is the Hub of the DMS (Data Manager
Systems) and is the central storage point for all Products and
their Properties. All other Modules are linked to the Data Manager
Database Module and access the Product Properties and it's Reference
All product related data is stored in reference tables. This
allows the user to configure a product or range of products
with four dimensions, grouped in up to four categories, linked
to one or many customers, and suppliers. General data tables
defining stores for a customer, Freight carriers used, the
range of carton sizes used to pack finished goods etc.
The DMS Module also has an optional feature to allow a user
to Import Data from or Export Data to an external source e.g.
Excel spreadsheet, an Accounting package or a Business software
package, etc. It enables a user to define the file format
and save the file as a template for future use.
click to enlarge
Product properties are either defined at the time of entering
a new product or changed on existing products as updates to
products. This is done using the property tabs. There are
nine Property Tabs. They are:
General - Defines the basic product structure
(Costs, UOM, Categories, Weight and Effectivity dates).
EAN/TUN - Generates unique barcode ID's
for each product and it's dimensions (EAN-13, EAN-8, UPC-12,
Customers - Sets the product / customer(s)
link (pricing, buying departments, customer codes / keycodes
Inventory - Defines product inventory data
(Primary pick face, On hand Qty, Last stocktake and cycle
Suppliers - Sets the product / supplier(s)
link (Costs, Purchase currency, supplier codes, Pack sizes.
Summary - Displays Average Sales for a specific
period for the selected item ( the specific period is set
in the tools, Setup function in the inventory Tab See the
Set up Function), the expected future sales as a sales forecast
by month for the selected item, all past due sales orders
and all outstanding sales orders by month for the selected
item, all past due purchase orders and all outstanding purchase
orders by month for the selected item, current SOH (Stock
On Hand) for the selected item, Projected SOH (Stock On Hand)
by month for the selected item.
Labels - Allows the printing of product
labels for the parent and children of the selected item.
BOM - This tab allows a user to create a
BOM (Bill Of Materials) for a product. This BOM is used to
establish product costs and is used in the MRP / DRP module
to establish material requirements to meet a forecast and
MRP/DRP - This tab allows a user to set
up the planning rules and parmeters for a product. These planning
parameters are used in the MRP / DRP module to run MRP /DRP
material requirements calculations.
Picture - Displays a picture of the Item
selected. To insert a picture copy the picture file to the
DMServer\Pics folder or scan picture and save in pics folder.
The recommended size of the picture should be 470 x 380 pixels.
The DMS sytem will resize the picture if the picture is larger
than 470 x 380 pixels.
Packaging - Allows the setup of the packaging
requirements for the selected item.
Each product also contains links to other references listed
in their respective tables. This allows a company to tailor
their products and product database to suit their unique environment
and give them the flexibility to setup their business information
to minimise administration.
This Option is used to establish supplier information and
allow the user to set up the relationship between a product
and a supplier record, including supplier EDI and Email addresses,
and Purchase order formats. This format is the default format
used by the system to electronically transfer the official
company purchase Order to the supplier via EDI or Email. Each
supplier record has the standard Menu layout File, Edit, View,
Tools, Help. Refer Menu Items
This Option is used to establish your company information
and allow the user to set up the relationship between a product
and your company information, including your company EDI addresses,
and EAN manufacturing numbers. Each company record has the
standard Menu layout File, Edit, View, Tools, Help.
This Option is used to establish a Customer record and allow
the user to set up the Properties of a customer using four
Property tabs. Each customer record has the standard Menu
layout File, Edit, View, Tools, Help.
Provide the ability to define up to four separate Categories
or groups for a product or range of products e.g. Range, Brand,
Type, Season, etc. The categories or groups are Hierarchical
and must be carefully structured to give the user maximum
flexibility in using categories for reporting and effective
sorting of the product database.
A listing of stores and it's parameters for a customer, in
order to set up a stores listing a customer must exist in
the customer table. In future versions the user will be able
to load a stores file for a customer from the IPT Website.
A listing of preferred carriers used by a company to freight
finished goods to customers. The carrier table is used by
the Scan packing Module to allocate a carrier to a customer
A listing of carton sizes used by a company to pack finished
goods to a customer order. The carton table is used by the
Scan packing Module to allocate a carton to a customer delivery.
Provide the ability to define up to four separate Dimensions
for a product or range of products. e.g. Colour, Size, width,
Length, etc. The Dimensions are Hierarchical and must be carefully
structured to give the user the correct dimensional relationship.
Each Dimension is considered by the software as a unique saleable
item and the user can allocate EAN and TUN codes to each product
dimension if required.