|
|
The Stock Maintenance is used to add, change or delete stock records.
A stock record must be created for the system to operate successfully ( example; before an order in order entry or a purchase order for inventory can be entered ).
Stock records allow for the products (defined on a whole to your company in the Product File Maintenance – IN0100) to be assigned to different warehouses and as a result carry certain attributes based upon this. Some examples of these may be the product supplier (vendor) or disposition of the item ie. It is a ‘Drop Shipped’ item in this warehouse location. For this warehouse location the item may be a lot controlled item or a purchased item supplied from the manufacturing warehouse where it is defined as a “Finished Good” and holds a “Bill of Material”. In the case of distribution, the cost of the item in this location may be higher than in another location eg. East Cost as opposed to West cost with possibly different suppliers.
Note : Up to ten user defined custom fields (flex fields) are available to be set up on this screen. Flex fields are alphanumeric fields allowing up to 2000 characters per field. These flex fields will display in a separate user named button once they have been defined in Flex Field Maintenance (gb1200).
Note (If program is called from Product Maintenance IN0100): If a stock record, regardless of the warehouse, already exists the Stock Master File Maintenance (IN0200) will display a stock record for a warehouse that the user has access to and at this time the Stock Master Maintenance is in inquiry mode. If user does not have access to the warehouse where a stock record already exist, then the program will be in entry mode thereby allowing user to enter new stock record. To enter a stock record for a new warehouse the Stock Master File Maintenance (IN0200) must be put to entry mode first by pressing/clicking the insert toolbar or the arrow key. Stock record for other warehouse, other than the one display by the system right after the button is press can also be queried by doing the standard query operations.
Enter the product code. The description will be displayed. A list of values is available when in query mode.
Enter the warehouse code of the stock record being created. The description will be displayed.
The product group code and description will be displayed. This is the product group where the product belongs and this is setup in the Product File Maintenance (IN0100).
Enter the product type of the product. The system will default to product type 4 ( Purchased Item )
1 - Assemblies ( products made up
of other products ),
2 - Fabricated Items ( products
augmented on site ),
3 - Raw Material ( products used
to make other products ),
4 - Purchased Items ( products
bought from outside the organization ),
5 - Finished Goods ( products
created on site ),
6 - Scrap ( products that are a
by-product of manufacturing ),
7 - Tool ( products used in
manufacturing ),
8 - Option ( product code
designated to represent other product code(s) ),
9 - Kit - ( product that
represents a kit is made up of an established number of other products ),
10 - Phantom Part - ( fictitious
product used for information but for which no stock is kept ),
11 - Routing Code - ( fictitious
product used only for routing purposes in manufacturing ),
12 - Feature ( a product that
represents other products )
The following are used only in
the Quotations ( QT ) Module and Job Costing ( JC ) module.
13 - Labour Activity - used for
labour entry in Job Costing ( JC ) module,
14 - Plant Hire Activity - used
for entry of rental equipment used in the quotation, as example a Bulldozer
rental as part of the quotations,
15 - Sub Contract - used for
entry of sub contracts for quotations in Job Costing ( JC ) module,
16 - Service
This code is used to identify
what type of item the product belongs to. Used by Purchasing to identify purchased
items ( code 4 ), Manufacturing to identify manufactured products, raw
materials, assemblies, etc.
Assembly items are assembled from
fabricated items, raw or purchased items. Fabricated items are made from raw
and purchased items.
Enter the primary vendor code from whom the product is normally purchased from. The vendor name is displayed.
Note. Product is assumed to be supplied from either a vendor or a warehouse. Either the vendor code or the supplying warehouse must be entered for non-manufactured and non-phantom product types NOT both. Entry of the Vendor will automatically clear out any entry or default in the Supplying Warehouse. For manufactured items the products is supplied from a warehouse. The vendor code may also be entered but is for information only (Useful if the item is also purchased from time to time).
Automatic purchasing will use either the vendor or the supplying warehouse to create the suggested purchase orders or inter warehouse transfers for non-manufactured products. For manufactured products the manufacturing resource planning module (if activated) will also utilize these fields to create suggested work orders or transfers into the master production schedule.
For further explanation and example of Supplying Warehouse use, please see Dynamic 3i Multi-Warehouse Capabilities.
Enter the buyer code of the product. The buyer code is used to determine who is responsible for purchasing the product. ( This is not a mandatory field. ) The buyer codes are maintained in the Employee Maintenance Program.
Where
Used :
Extract Posting to Purchase Orders (PO1300)
Purchase
Order Receipts by Vendor (PO5900)
Unmatched
Purchase Order Report (PO5800)
Purchase
Order Analysis Report by Product (PO3000)
Reschedule
Report (RP0300)
Purchasing
Requirement Extract (RP1200)
Enter the supplying warehouse code from where the product is supplied. This field is used when there are multiple warehouses set up in the distribution environment. The warehouse name is displayed.
Note. Product is assumed to be supplied from either a vendor or a warehouse. Either the vendor code or the supplying warehouse must be entered for non-manufactured and non-phantom product types NOT both. Entry of the Supplying Warehouse will automatically clear out any entry in the Vendor. The Supplying Warehouse cannot be the same as the Warehouse
Automatic purchasing will use either the vendor or the supplying warehouse to create the suggested purchase orders or inter warehouse transfers for non-manufactured products. For manufactured products the manufacturing resource planning module (if activated) will also utilize these fields to create suggested work orders or transfers into the master production schedule.
For further explanation and example of Supplying Warehouse
use, please see Dynamic 3i Multi-Warehouse
Capabilities.
Enter the country where the product originates. By default it is set at the country of the warehouse if the products types are Assemblies, Fabricated Items or Finished Goods. If the product is not one of these types then the Country, by default, is set to either the Vendor's location or the Supplier's Warehouse location.
Enter the planner code of the product. The planner code is used in the planning process to control production of goods manufactured. ( This is not a mandatory field. ) Planners are employees flagged as such on the Employee Master Maintenance – GB0090
Where Used :
Master Scheduling Production report (PP2200)
Release Planned Orders (RP1700)
Requirements Planning Reports
Job Status Report (PC2400) etc.
Enter
the bin type requirement of the product. The bin type identifies what kind of
bin the product can be placed in.
An example of this may be allergen products. Based upon the bin type definition in the Bin Master Maintenance (GB1800), bins with a matching bin type defined
can be used for this item. Note. This is a free format informational
field. The only restriction
is that the bin type exists for at least one bin within the warehouse on the Bin Master Maintenance (GB1800).
Enter the bin location of the product. The bin location will appear on the inventory checklist to identify where the product is located. This is not to be confused with bin-controlled items. It is simply the primary location where this item can be found in the warehouse location. When the Bin Location is set up in Product Default Maintenance (IN0050) the default bin will default from this when new stock record is being setup.
Select the
product's ranking code. This is for informational purposes. This code is used
for cycle counting. i.e. "A" codes are counted more often than
"C" codes.
Examples: Physical
Inventory Count Sheet (IN4110)
Enter the product's units per master carton. ( that is, An item may be sent in 100ml bottles, 24 per a case. Your master pack would be set to 24. )
Enter the vendor code with which any warranty claims will be honored. The vendor name is displayed.
Enter the warranty period that the vendor supplies on the part.
Enter the warranty period that the vendor supplies on the labour.
Click on this tab to enter the cost information page.
This button is inside cost information window. Click on this button with the mouse, or press [ Enter ] to enter the Product Cost File Maintenance (IN1110) program.
Click on this tab to enter the additional charges page.
Click on this tab to enter the reorder parameters page.
Click on this tab to enter the lead time days page.
Click on this button with the mouse, or press [ Enter ] to enter the product flags window.
Click on this tab to enter the sales page.
Click on this button with the mouse, or press [ Enter ] to enter the material safety window.
Click on this button with the mouse, or press [ Enter ] to enter the dangerous goods window.
Click on this button with the mouse, or press [ Enter ] to enter the custom fields window. This is only visible if custom fields are defined for this application. See Program Flex Fields Maintenance(GB1200) for help on setting up custom fields.
Click on this button with the mouse, or press [ Enter ] to drill down to the Product Structure (SR0500) application. This button is only active for product types ‘Assembly’ (1), ‘Fabricated Item’ (2) and ‘Finished Good’ (5).
Click on this button with the mouse, or press [ Enter ] to drill down to the Inventory Movement Inquiry (IN6000) application.
The stocking unit of measure is displayed by the system. This information is derived from stocking unit of measure defined for the product in Product Maintenance (IN0100).
The last date the product’s on hand was reduced in shipping confirmation, inventory issues, usage in manufacturing, inventory adjustments, kit building and inter warehouse transfers.
This is the quantity of the item that was received into quality control by Automatic Job Confirmation – PC5200 based upon the setting of the Quality Control Required flag or Purchase Order Receipt – PO5100 with a receipt type of ‘Quality Control’. This quantity is already incorporated in the quantity on hand of the item. To move quantity out of quality control the Quality Control Testing – PO5150 must be used.
This is the quantity of the item that is currently in Quarantine. This quantity is already incorporated in the quantity on hand of the item . To move quantity out of quarantine the Quarantine Stock - IN4910 must be used.
The last stock take quantity will be displayed.
The last stock take date will be displayed.
Total tag quantity processed by last physical inventory update is displayed. This field is cleared out when the pre-physical inventory update – IN4000 is run.
The quantity on order will be displayed as the total amount of the product that is on all purchase orders. This amount will only appear on records that do not have a lot code.
The quantity on hand will be displayed as the total amount of the product that has been received or manufactured. This field will not appear on lot control records.
The quantity on work order will be displayed as the quantity of the product this is currently in the manufacturing process.
The quantity allocated sales will be displayed as the total amount of the product that has been ordered, or is to be transferred, or is to be requisitioned. This field will not appear on lot control records.
The quantity allocated manufactured will be displayed as the total amount to be used for manufacturing. This field will not appear on lot control records.
The quantity back ordered will be displayed as the total amount back ordered of the product on all orders. This field will not be displayed on records that have a lot code.
The quantity in transit between warehouses is displayed. When inventory inter-warehouse transfers occur the quantity of the transfer is updated to this field until in the sending warehouse until such time that it is received in the receiving warehouse.
Information found in these fields will depend upon the product type having been updated from the Product Cost File Maintenance – IN1110 or one of the cost updates CC0300 to CC0600 in the Cost Control Module ( CC ).
The material cost of the product will be displayed.
The Duty cost of the product will be displayed.
In the case of a manufactured item the labour cost of the product will be displayed.
In the case of a manufactured item any set up cost of the product will be displayed.
The variable overhead cost of the product will be displayed .
The fixed overhead cost of the product will be displayed.
The last cost of the product will be displayed. This is the last receiving cost from purchase order receipts.
The last cost is the cost in stocking units. For example
if the cost on the last purchase order was 0.61 but the purchase stock factor
for this product is 0.888889.
Last cost = 0.61/0.888889 = .686.
The weighted average cost of the product will be displayed. This is system calculated and is always calculated and displayed even if the costing flag on System Flags Maintenance – GB2800 is NOT set to ‘Average’
The standard cost of the product will be displayed.
The quantity of the product that the cost applies to will be displayed. The system defaults to 1.
Enter the freight percent for this product. User can only go to this field when the extra purchase order match flag is set in System Flags Maintenance – GB2800.
Enter the duty percent for this product. User can only go to this field when the extra purchase order match flag is set to 'X' in GB2800.
Enter any other charges percent for this product. User can only go to this field when the extra purchase order match flag is set in System Flags Maintenance – GB2800.
Select the reorder type. The reorder type is used to determine the replenishment method to be used by manufacturing. A purchase order or work order will be generated depending on the product type.
"Fixed Lot Quantity"
Create as many orders as needed to fill demand.
"Maximum Order
Quantity"
Combine demand up to the maximum quantity. If a single demand exceeds the
maximum, the demand will be used. Adjusted by minimum / multiple.
"Maximum Order Value"
Combine demand up to the maximum. If a single demand exceeds the maximum, the
demand will be used. Adjusted by minimum / multiple.
"Maximum number of
days"
Combine demand for the number of days specified.
"Least Cost"
Set-up versus carrying cost for build items or purchasing cost versus carrying
cost for purchased items. Adjusted by minimum / multiple.
"Lot for Lot"
Create supply order for each demand.
Enter parameters for the reorder logic. This is only valid for selections 1 - 4.
The
reorder parameters button displays the reorder flags used for automatic purchasing,
distribution requirements planning and manufacturing requirements
planning. They define and tune the
system as to how these items are ordered into inventory.
The Reorder Qty is for product types
3,4 & 6 only. It is used strictly for Automatic Purchasing (Purchase Order
Extract – PO1000), in the purchase order module. The extract does not use the reorder parameter or
re-order flag.
Their
settings are discussed with examples below:
The
reorder flag and reorder parameter work together. The reorder parameter is
only used for the following re-order flag values:
1) Fixed
Lot Quantity
2) Maximum
Order Quantity
3) Maximum
Order Value
4) Maximum
# of days
The minimum and
multiple values are used for 2, 3, and 4 above
Fixed Lot Quantity : Create as many fixed lot quantity
(reorder parameter) orders as needed to fill demand
Reorder Parameter Demand Qty PO/Work
Order Qty
10 5 10
50 5
Lines with qty of 10
Maximum Order Quantity : Combine demand up to the maximum quantity
specified. If a single demand
exceeds the maximum, the demand will be used.
Adjusted by minimum and multiple
Reorder Parameter Demand Qty PO/Work
Order Qty
100 01-Jul
for 25 25
02-Jul
for 10 35
03-Jul
for 50 85 90
if multiple set to 10
04-Jul
for 30 (115)
30
05-Jul
for 30 60…
Maximum Order Value : Combine demand up to the maximum
value specified. If a single
demand exceeds the maximum, the demand will be used
Adjusted by minimum and multiple.
Reorder Parameter Demand
Qty Value PO/Work
Order Qty
$150 01-Jul
for 25 50
02-Jul
for 10 20
03-Jul
for 50 100
04-Jul
for 30 (170)
60 90
If multiple set to 10
05-Jul
for 30 120
Maximum # of Days : Combine
demand up to the maximum number of days specified.
Adjusted by minimum and multiple
Reorder Parameter Demand
Qty PO/Work
Order Qty
4 01-Jul
for 25 25
02-Jul
for 10 35
03-Jul
for 50 85
04-Jul
for 30 115 120
if multiple set to 10
05-Jul
for 30 30…
Least Cost : Setup versus carrying cost for build items or purchasing cost
versus carrying cost for purchased items.
Adjusted by minimum and multiple
The demand
for an item is grouped together and then the value is compared to a calculated
value based upon a formula which uses ordering cost and the average holding
cost which is set up in the global master maintenance (GB0100)
Lot for Lot : Create
supply order for each demand
Demand
Qty PO/Work
Order Qty
01-Jul for 25 50
min. set to 50 mult. set to 10
02-Jul for 15 15
No min. or mult.
03-Jul
for 50 50
04-Jul
for 60 60
05-Jul for 60 60
Used strictly for Automatic Purchasing in the Purchase Order module. Enter the quantity of the reorder point for the product. This is the typical level of stock that is to be maintained (Safety Level). When the Reorder Extract – PO1000 is run, an extract record will be produced if the available quantity of the item is less than or equal to this reorder quantity.
Enter the economic quantity. This is the most economical quantity at which the product can be purchased or manufactured. The extract from inventory in automatic purchasing calculates the quantity to order based on economic order quantity and re-order point. Since economic ordering quantity is used to calculate order quantity that is later converted into purchase order quantity, in order to get an integer value in purchase order quantity buy-sell economic order quantity should be evenly divisible by buy-sell factor. If the 'Order In Economic Multiples' flag is set in System Flags Maintenance – GB2800, then an entry made here, will also automatically appear in the 'Multiple' field below.
Enter the minimum quantity that is to be purchased or manufactured for the product.
Enter the maximum quantity that is to be purchased or manufactured for the product.
Enter the multiple of how the product will be purchased or manufactured.
Enter the safety quantity of the product. The safety quantity represents the point at which the stock level should be maintained without jeopardizing production or sales.
Enter the number of months usage the Gordon Graham replenishment method should look at when analyzing usage.
Enter the total number of lead days to purchase this item. This is the total number of days required to ship the item from the primary vendor to your site. The ship days (below) is included in these lead days. It should also be noted that the lead days are the only days used by the Automatic Purchasing (PO1000) for product types 3 - raw material and 4 - purchased items.
Means nothing in the grand scheme of calculating days requirements. It is for information purposes only and shows the amount of ship days that are included in the lead days above.
Enter the number of lead days required for manufacturing. The manufacturing lead days is only used for manufactured items if no routing exists for that item.
Enter the number of days required for rescheduling. The reschedule days is only used by the MRP Requirements planning explosion to display alert messages based upon the targeted start date less these number of days.
Enter the number of days required for quality control. The QC (Quality Control) Days and the Safety Days are used as a buffer to get item into stock before it’s actually due. User can put numbers in either Quality Control or Safety Days but calculations will always add the two together to come up with a date. Therefore entering 6 quality control days and 0 safety days or 4 quality control days and 2 safety days makes no difference as far as software is concerned. It’s only information for the user if they want to put a value into both fields.
Example: A sales order is placed (or a work order requires a product) on a Friday. Product has a safety of 3 days. Therefore a suggested purchase order (or work order if it’s a manufactured item) will be created so that item will be received into warehouse on a Tuesday, 3 days before it is due on Friday.
Enter the number of days required for safety before making another purchase order.
See Quality Control Days for how this field impacts date calculations.
Set the flag by clicking the mouse in the field if the product is to include in a physical inventory. The flag is set by default. The SDC software does not allow inbound/outbound serial controlled products to be processed through the normal/standard physical inventory process as it not the most efficient way of doing physical inventory for serial controlled products. As adjustments to a physical count are not entered into the system until discrepancies are reconciled and items costs determined, the adjustment to physical count should be entered through inventory adjustment. Example: If your have a product showing inventory of 100 but the count only shows 99, then you really need to make one adjustment entry for the missing 1. There is no need to re-enter the information that is already correct (the 99 units on inventory which already have the correct serial numbers).
Physical
Inventory steps for serial controlled products:
Use the Physical Inventory Check List (IN4100) for serial controlled products, which will list only serial controlled products and their serial numbers. Matched these serial numbers with what the warehouse really have physically. Through this process missing serial numbers can be easily identified. Enter an inventory adjustment for the missing serial numbers.
Select the value of the disposition flag. This flag is used in the Order Entry process to determine the method of purchasing the stock for this purchased item.
Acceptable entries are:
“Blank” - Normal Product
“Automatic Purchase Order”-
A purchase order will automatically be
generated when a sales order is entered
(for delivery to warehouses locations).
"Drop Ship" - (Automatic
Purchase Order) - Handled the same as the automatic purchase except the
delivery will be made from supplier to customer.
Process:
1. order entry of stock item - a Purchase Order is generated by the system.
2. print the Purchase Order.
3. receive the Purchase.Order when ship-to-customers receives the stock - an
invoice is generated by the system.
4. print the invoice in Order Entry
"Hold" - Puts
product on hold. This product
cannot be purchased or sold.
"Non-Stock" - An item that will
create a purchase requisition, which must go through the requisition approval
stage, before a drop-ship purchase order can be generated.
"Cannot Purchase or Make" - This product
can be sold but cannot be purchased (or allowed to be made or manufactured).
Note. This flag is not used in the MRP or PO
extract. If an item were to be set
to say ‘Cannot Purchase or make’ these applications would still see them as
valid items and process them.
Click on this field if the product is serial controlled. This field can only be updated if the quantity on hand in the Current Activity pop up window is 0 or null. A lot controlled item or a lot and bin controlled item cannot be set up as a serial controlled product.
Select "Lotted Item" for lot controlled, "Binned Item" for bin controlled, "Binned and Lotted Item", or leave blank. A lot controlled item or a lot and bin controlled item cannot be set up as a serial controlled product.
This flag relates to the processing of orders within the manufacturing system and this flag should be left blank if manufacturing modules are not activated. Demand Flow Materials Requirement Planning bypasses the traditional Materials Requirement Planning routines and creates jobs directly in the Production Control Module upon creation of a firm order (stock demand). A job will be created for each demand. The system will create the job utilizing the expected delivery date as the 'stop date' or expected completion date of the job. The quantity to manufacture will be set to the quantity that is being ordered. Once the job is completed the stock is made available and can then be released to the order. If the 'Demand Flow' flag is set then the system will skip Production Planning, Requirements Planning and Capacity Planning and proceed directly to Production Control. If the flag is not set, the Materials Requirement Planning system will follow the traditional flow by means of the Master Production Schedule, Capacity and Requirements Planning. The planning steps can still be superseded for 'rush' type production orders by creating a job directly in the Job Entry program (PC0100) in the Production Control Module.
Check this box if you want this product receipt type to default to quality control when it is received from the purchase order module via the Stock Receipt By Purchase Order (PO5100) or if it is a manufactured item to be automatically received into Quality Control Quantity from the Automatic Job Confirmation – PC5200.
Select the purchase order Goods and Services Tax taxation code. If this flag is not set then system will default to flag set in System Flags Maintenance (GB2800)
Select the purchasing Provincial Sales Tax taxation code. If this flag is not set then system will default to flag set in System Flags Maintenance (GB2800)
Enter the default lot number to be assigned to the current onhand. This information is only applicable when switching a non-lot controlled product to a lot controlled product.
Enter the default lot expiry date to be assigned to the current onhand. This information is only applicable when switching a non-lot controlled product to a lot controlled product.
Enter the default bin location to be assigned to the current onhand. This information is only applicable when switching a non-bin controlled product to a bin controlled product.
Select ‘Saleable Dynamic 3i’ selection if product is to be sold via the Dynamic 3i software, ‘Saleable Dynamic 3i and Web Store’ selection if product is to be sold via Dynamic 3i software and Dynamic Web Store or Not For Sale if product is not going to be sold.
Check this box if Invoice Update (OE4100) should update orders with this product if it does not have a cost. This flag is only used if Invoice No Cost flag in System Flags Maintenance (GB2800) is not checked.
Select the sales order Goods and Services Tax taxation code. If this flag is not set then system will default to flag set in System Flags Maintenance (GB2800)
Select the selling Provincial Sales Tax taxation code. If this flag is not set then system will default to flag set in System Flags Maintenance (GB2800)
Enter the number of selling lead days. The Selling Lead Days is only used in Order Entry (oe2100) for expected ship date calculation.
Enter the maximum quantity of product that can be ordered.
Select the deposit rate if the item will be charged a deposit fee when the item is purchased in sales order entry. The actual amount charged, will be based on the rate retrieved from province/state maintenance (gb1300). This rate is based on the province/state where the item is being shipped.
Select the ecology fee rate if the item is charged an ecology fee when sold. The amount charged is based on the rate retrieved from province/state maintenance (gb1300). This rate is based on the province/state where the item is being shipped.
Material Safety
The Material Safety page is used to enter information required to generate the Material Safety Data Sheet (MSDS) summary sheet for the product via the Material Safety Data Sheet (IN8910) program. The summary sheet contains information about the MSDS and vendor contact information and is usually used to locate the actual MSDS for the product. The Material Safety Data Sheet(MSDS) for a product is generally supplied by the vendor of the product. Copies of the MSDS are kept onsite and sent with the product whenever the product is shipped. The information in this window links the product’s actual Material Safety Data Sheet (MSDS). The number is the actual MSDS number, the date is the date of the MSDS sheet and the location is the physical location in the warehouse/office where the MSDS is kept/located. With all these information available and printed on the data summary sheet the user can easily locate and find the actual Material Safety Data Sheet (MSDS) to attached to the shipping document.
Enter the Material Safety Data Sheet number for the product.
Enter the Material Safety Data Sheet date.
Location
Enter the location in the warehouse/building/office where the Material Safety Data Sheet is kept.
Dangerous Goods
The Dangerous Goods window contains important information regarding the transportation of the product. The information in the following five fields (class, packing group, unit number, weight and emergency phone), prints with the product on the packing slip for products that are classified as dangerous goods. A product is defined as a dangerous good when there is a hazardous code associated with it on Product Maintenance (IN0100).
This information will print on packing slip formats 1 and 4.
Class
Enter the dangerous goods classification for the product.
Enter a packing group for the product.
Enter the unit number for the product
Enter the weight for the product.
Enter an emergency phone number. This is the phone number that the customer or party transporting the product can contact if an emergency situation arises.