Welcome to Maxim Help Articles > PRMST Product Master

Access to Notes, Keywords, Supersession, and ChangeGroup functions and being able to change the Product Code, Category or Sub Category is only available from the Company that 'owns' the product file.

Maintain Keywords

Keywords are automatically built when a product is created. See Product Group for setting options.

To view and maintain the products keywords select the Keywords button. You can change keywords or add a new keyword using User as the identifier. Remember, that you can change a Long or Short Name keyword, but if the Long Name or Short Name description is changed the keywords will be deleted and rebuilt. Therefore you should use the User identifier to add new keywords or change the items description.

Change Product Group

Items can be moved to a different product group within the following rules:

•	The Group Item Type and Group Properties are the same for both product groups.

•	A non inventory item can be moved to an inventory group.

•	An inventory item can be moved to a non inventory group if the stock on hand quantities are zero for all stock locations for the item.

All inventory transactions for the item will be deleted. To adjust stock on hand quantities refer to Adjust SOH Quantity.

Select the Change Group button to move an item.

Class And Activity Input Fields

These fields are used in the job costing and quoting modules. Job costing analyses costs by Materials, Labour, Plant and Sub Contracts and therefore when non inventory items are selected job costing needs to know this information.

The Class and Activity fields only need to be an option for non inventory product groups. Inventory product group items will automatically be analysed as Materials.

For non inventory items to be selected for jobs or job quoting the Class code has to be completed to be able to select any of these items. The valid Class codes are:

Code

M Materials

L Labour

P Plant

S Sub Contracts

The Activity code on the Product Masterfile can also be completed by selecting the appropriate activity from the list. The activity needs to relate to the class. The activity code is then used as the default activity code into the job or quote.

Product Pack Information

When a new product is created a Product Pack Information record is created with a coding structure based on the following Product Group Options:

Option Used	Record Created Using Code
Standard	Default Input else STANDARD
Item Code	Item Product Code
Property Item Mnemonic	Using Property Items.

Default Input refers to the Product Field Input Options setting for Pack Ref:

Change Period Moving Average Cost

Changing a non current period's moving average cost for an item should be made with caution and the resultant current moving average transaction cost should be checked. The cost adjustment, which is calculated using the stock on hand and the moving average cost at that period end, is applied to the current quantity on hand to give a new current moving average cost.

The moving average costs of periods subsequent to the period being updated are not changed.

The moving average cost for the selected period can be changed if the quantity on hand for the period is a positive. The stock on hand and cost of sales adjustments are made to the selected accounting period and the moving average cost for the period is changed. The cost of sale adjustment is reflected through to the current moving average transaction cost.

Note that this change will only change the moving average cost of the IVPBA summary record for the selected period. For example:

Period MvgAvgCost

200011 30.00

200012 35.00 This period is changed to $30.00

200101 35.00

200102 35.00

A change was made to period 200012. The IVPBA average cost for periods 200101 and 200102 will not be changed. If 200102 is the current period the moving average cost will be adjusted as cost of sale transactions are made.

When running Stock On Hand period reports the following will occur:

Period 200012 will reflect the correct stock on hand cost values.

Period 200101 will show the correct stock on hand quantities, but the cost will be based on the period movements and existing period costs.

Period 200102, if it is the latest period, will reflect the correct stock values. Note that running the stock on hand report within the current month uses the latest IVTRN transaction to obtain the stock on hand and cost figures.

To change the moving average cost for a period select the required Stock Location and the Moving Avg Unit Cost button.

There is an Inventory Adjustment report available to list stock on hand adjustments.

Refer also to the Adjust SOH Quantity screen.

Stock Locations

Loose

Items are purchased and sold by units, ie EA

Batch / Serial

Items are purchased and sold by tracking a batch or serial number.

To sell this stock type requires a valid batch or serial number to be entered or selected.

Supplier

The supplier client code becomes part of the stock location code.

This enables the cost and quantities of the same product, but purchased from different suppliers, to be tracked independently. For purchase orders and stock receipts the supplier code automatically becomes part of the stock location code. For sales the relevant stock location / supplier has to be selected.

NOTE # 1: All product items that are allocated to a product group with the Stock Type Supplier have to use Supplier as the stock location stock type. Stock locations for other product groups can not select Supplier as the stock type. The stock locations will be created automatically when purchase orders or stock receipts are created. An initial default stock location is created when a new product is created with a blank supplier code. This location is deleted by the system as soon as the first purchase order or stock receipt is created.

NOTE #2: Supplier can also be specified for Non Inventory product groups. When used in this situation the need for the supplier client code is ignored, but the supplier code is added to the item description when receipting items via the APRECPT screen.

Preferred Supplier

Entering a Preferred Supplier will also create a Supplier Link record. Also, creating a Supplier Link record for a product, will update the Preferred Supplier for all stock locations records for the product if a preferred supplier has not been entered.