Field descriptions: Item-site

This page describes the fields for the Item-site page. The fields in each tab and section are listed in alphabetical order.

General tab

Field Description
Expected quantity The quantity of the item currently on order.
Item name

The name of the item.

Item tax group

The tax group for the item.

The item might be exempt from tax or taxed at a specific rate.

An item can only be assigned to a specific tax group if the Specific item tax group checkbox is selected.

Required quantity

The quantity of the item needed to fulfil existing orders.

Site

The site name the item is stored at or managed from.

Specific item tax group

Indicates if the item is assigned to a specific tax group.

Stock block

This block displays if the Stock management switch is turned on. The values are updated automatically.

Field Description
Accepted

The quantity of the item that has been accepted into stock.

Allocated

The quantity of the item that has been allocated to undelivered sales orders.

Last count date

The last stock count date at the site.

On quality control

The quantity of items in inspection and quality assurance control.

Rejected

The quantity of the item that has been rejected and not accepted into stock.

Total The total of the Allocated, Accepted, On quality control and Rejected quantities.

Projected stock window

Displays when you select Projected stock from the Stock block.

You can view stock projections after you save the Item-site record.

Field Description
Frequency

The value of the horizontal axis in the stock projections graph.

Day: Display each date from the current date and the next 6 days.

Week: Display each date from the current date and the next 6 weeks.

Item

The item name.

Stock available The unallocated stock quantity.
Stock site

The site name the item is stored at or managed from.

Legend

Field Description
Available The unallocated stock quantity.
Expected The quantity of the item on order.
Horizontal axis

The stock levels on the date or week.

If Frequency is Day: The stock projections are daily from the current date.

If Frequency is Week: The stock projections are weekly from the current date.

Reorder point The minimum amount of stock required.
Required The quantity of the item needed to fulfil existing orders.
Safety level The projected stock level needed to protect the stock item against unforeseen circumstances such as non-delivery and damaged stock.
Vertical axis

The projected stock quantity.

Cost block

Field Description
Average unit cost

The average unit cost of one stock item.

The average unit cost is the result of the total quantity of items in stock divided by the cost of the items at stock receipt.

This field displays if the Valuation method is Average unit cost.

Note that the average unit cost of the item can change with each stock receipt.

FIFO unit cost

The FIFO (first-in, first-out) cost of one stock item based on its average cost at purchase receipt.

This field displays if the Valuation method is FIFO cost.

Note that the FIFO cost of the item can change with each stock receipt.

Last valuation report date

The date the costs were last revalued.

Standard cost

The current standard cost of the item.

You can view the complete costs history on the Costs tab.

Note that the cost of an item at stock receipt can be different from the item standard cost.

Stock valuation at average unit cost

The result of the average unit cost multiplied by the total quantity of items in stock.

This field displays if the Valuation method is Average unit cost.

Stock valuation at FIFO cost

The result of the FIFO unit cost multiplied by the total quantity of items in stock.

This field displays if the Valuation method is FIFO cost.

Stock valuation at standard cost

The result of the standard cost multiplied by the total quantity of items in stock.

The total quantity of items in stock is displayed in the Total field in the Stock block.

Valuation method

The stock valuation method.

Standard cost: This is the default stock valuation method. The cost is typically established at the beginning of a period to value the item and the stock movements.

Average unit cost: A valuation method which averages the value of all stock of the item by dividing the total cost of all items in stock by the total quantity of all units in stock.

FIFO cost: First in, first out valuation method, where the first item received into stock is the first to be issued. Unique cost tiers are created as items are received into stock. The tiers are then consumed in chronological order as the stock is sold or issued.

Replenishment tab

Defines when a stock item needs to be replenished at the site and how. Replenishment rules control stock levels and stock overhead costs.

For items not managed in stock you only need to enter the Purchase lead time; service items are not replenished.

Field Description
Batch quantity

The number of items that will be produced in a single batch run or purchased in a single "lot".

For manufactured items, the figure should be the optimal size of the production batch.

For purchased items, the figure should be the most cost effective order quantity.

The item needs to be made or purchased in multiples of the batch quantity.

Buy-to-order

Indicates if a purchase order for the item can be created from a sales order.

This checkbox displays when the following requirements are met:

  • The item is purchased.
  • The preferred process is Purchasing.
  • The OrdertoOrder option is activated on the Service options page.

Refer to Create a purchase order from a sales order for more information.

Economic order quantity

The minimum reorder quantity as a multiple of the Batch quantity.

The item needs to be made or purchased in multiples of the batch quantity.

This quantity is used in the standard cost calculation.

Make-to-order

Indicates if a work order for the item can be created from a sales order.

This checkbox displays when the following requirements are met:

  • The item is manufactured.
  • The preferred process is Production.
  • The OrdertoOrder option is activated on the Service options page.

Refer to Create a work order from a sales order for more information.

Preferred process

The preferred replenishment process.

Production: Displayed for manufactured items.

  • If the Replenishment method is By reorder point, a new work order is suggested when the stock level drops to the Reorder point.
  • If the Replenishment method is By MRP, the MRP calculation request generates a production suggestion if the item is manufactured and there is insufficient stock available.

Purchasing: Displayed for purchased items and for items that are not managed in stock.

  • If the Replenishment method is By reorder point, a new purchase order is suggested when the stock level drops to the Reorder point.
  • If the Replenishment method is By MRP, the MRP calculation request generates a purchasing suggestion if the item is purchased and there is insufficient stock available.
Production lead time

For manufactured items, the average number of days it takes between placing an order for the item, producing it, then receiving it into stock.

Purchase lead time

For purchased items, the average number of days it takes between placing a purchase order for the item and the receipt of the goods.

This is the default value that is applied if a lead time has not been entered for a specific supplier.

Reorder point

The minimum amount of stock required when the Replenishment method is By reorder point.

A new purchase order or work order is automatically suggested when the stock level drops to the reorder point.

Replenishment method

The replenishment method for items managed in stock.

Not managed: There is no replenishment method.

By reorder point: A new work order or purchase order is suggested when the stock level drops to the reorder point.

By MRP: The item will be considered for inclusion in the MRP reorder calculations.

Items are only included in the MRP calculation result if they are replenished By MRP.
Safety stock The amount of stock needed to protect against unforeseen circumstances such as non-delivery and damaged stock. This is normally set lower than the Reorder point.

Suppliers tab

Defines supplier-specific rules for the item-site if the management policy identifies the item as Purchased.

You can add supplier-specific rules after you save the Item-site record and only for a supplier included in the list of suppliers of the item.

This table also describes the fields for the New and Edit item-site-supplier panels.

Field Description
Default
Default item-site-supplier
Indicates if the supplier is the default supplier of the item for the site.
Item-site The item and site codes.
Minimum purchase quantity The minimum quantity of the item to purchase from the supplier to replenish stock levels.
Purchase lead time The average number of days it takes between placing a purchase order for the item with the supplier and the receipt of the goods.
Supplier name The supplier name.
Supplier
Supplier ID
The supplier code.
Unit
Purchase unit
The purchase unit for the item from the supplier.

Costs tab

Defines specific costs for the item-site.

You can add costs after you save the Item-site record.

This table also describes the fields for the New and Edit item-site cost panels.

Field Description
Calculated

Indicates if the item-site-cost is calculated automatically based on the bill of material (BOM) and routing associated with the item-site.

Purchased items: The Calculated switch is always turned off. You need to enter the Cost detail fields manually.

Manufactured items: You can calculate the Cost detail manually or automatically.

  • ON: Select the Calculate action. The fields in the Cost detail block are updated automatically based on the BOM and routing associated with the item-site.
  • OFF: Enter the Material, Machine, Labour and Tool costs.
Cost category

The default item-site stock valuation method.

Standard cost: The cost is typically established at the beginning of a period to value the item and the stock movements.

This field is available if the item is managed in stock.

Cost chart

The breakdown of the costs in a graphical format.

Item-site The item and site codes.
Material
Machine
Labour
Tool
The total cost of the individual resource for the item-site quantity entered in the Quantity field.
Quantity The item-site-cost quantity. The Unit cost is obtained by dividing the Total cost by this quantity.
Start date

The date the item-site-cost applies from. The default start date is the current date. The item-site-cost applies indefinitely or until the next cost period start date.

You can add multiple cost periods. From the More actions icon, select Add period.

Total cost The sum of the Material, Machine, Labour and Tool costs for the item-site quantity entered in the Quantity field. You cannot edit this figure.
Unit cost The cost of a single item at the site. This is the optimum unit cost for the selected Cost category. It is calculated as the Total cost divided by the item-site quantity entered in the Quantity field. You cannot edit this figure.

Dimensions window

Defines default and individual attributes and dimensions that can be used to aggregate financial information for analytical purposes. Default values apply to all document lines where the item is used according to the document and origin rules created for a company.
You can only select dimensions and attributes that already exist.

Field Description
Channel

Identifies a channel dimension.

Department

Identifies a department dimension.

Employee Identifies an employee attribute.
Project

Identifies a project attribute. When you include a project, the Task field is available.

Region Identifies a region dimension.
Task If you selected a project, identifies a task. Tasks are linked to projects.

Stock rules tab

Default storage locations and quality control statuses. Stock transactions use the defaults which increase stock transaction entry rates and reduce data entry errors.

Field Description
Inbound The default location or quality assurance status for good inwards transactions, including a purchase receipt.
Outbound The default location for stock issue transactions, including shipping the item for a sales order.
Released item The default location or quality assurance status for finished items received from production, including when tracking a receipt from production.