Home Page Case Studies Products Services Technical Support About Us Client Log In Contact Us

 

PRODUCTS> products

The 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 tables.

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

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, UPC-7, TUN).

Customers - Sets the product / customer(s) link (pricing, buying departments, customer codes / keycodes etc.)

Inventory - Defines product inventory data (Primary pick face, On hand Qty, Last stocktake and cycle count dates.)

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 customer orders.

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.

 

Reference Tables

Suppliers

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

Companies

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.

Customers

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.

Categories

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.

Stores

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.

Carriers

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 delivery.

Cartons

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.

Dimensions

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.

 



© Copyright IPT - Information Process Technology 2001