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 fulfill 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 fulfill 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. Example
I have an order for 80 items. The Batch quantity is 50. The Economic order quantity is 200. I need to make or buy 4 batches of the item for the order to be economically viable. |
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:
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. Example
I have an order for 80 items. The Batch quantity is 50. The Economic order quantity is 200. I need to make or buy 4 batches of the item for the order to be economically viable. 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:
Refer to Create a work order from a sales order for more information. |
Preferred process |
The preferred replenishment process. Production: Displayed for manufactured items.
Purchasing: Displayed for purchased items and for items that are not managed in stock.
|
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.
|
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 Labor 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, Labor, 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. |