You use this program to assign a stock item to a warehouse and to define the warehouse information for a stock item. Before you can process transactions for stock items, they must be assigned to (i.e. stocked in) at least one warehouse.
You use the Browse on Warehouses program to define and maintain warehouses.
The Warehouses for Stock Code listview displays details of warehouses in which the selected stock item is currently stocked.
Field | Description |
---|---|
New | Select this to indicate a new stock code to which you want to assign a warehouse. |
Delete | Select this to remove the stock item from the warehouse currently displayed (i.e. remove the stock code to warehouse link). |
Save | Select this to save the details you entered or changed. |
Stock code | Indicate the stock item you want to link to a warehouse or to several warehouses. |
Warehouse | Enter the warehouse to which you want to link the stock item. This is the warehouse in which the item must be stocked. |
Add Multiple Warehouses |
Select this to assign the stock item to multiple warehouses with the same information against the item in each warehouse. This means you only enter the data for the item once and this data is then transferred to each warehouse into which you add the item. For example, if you set the cost of the item to 1000 and add the item to four warehouses, then the cost of the item is 1000 in all four warehouses. To define different data for the item (for example a different cost or different policy details) in the different warehouses, you need to add the item to each warehouse individually (i.e. do not use this function). If you select this option, then you use the Warehouse list > Click to add a list option to indicate the warehouses you want to add to the stock item. |
If you want to assign a stock item to more than one warehouse, you can use the Add Multiple Warehouses option.
Field | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Stock code | This indicates the code of the stock item you selected to link to the warehouse(s). | ||||||||
Stock code description | This indicates the description of the stock code you selected to link to the warehouse(s). | ||||||||
Warehouse | Enter the warehouse to which you want to link the stock
item. This is the warehouse in which the item must be stocked.
Operator access to the warehouse is checked and rejected when access is denied. |
||||||||
Warehouse description | This indicates the description of the warehouse you selected to link to the stock item. | ||||||||
Warehouse list | This option is only enabled when you select the option: Add Multiple Warehouses. | ||||||||
Click to add a list | Select this to indicate a list of warehouses to which the stock code must be linked (see Warehouse List Selection). | ||||||||
Cost multiplier |
This indicates what portion of the transaction value of the stock item comprises non-merchandise costs (e.g. freight, duty, tax, etc.). The cost multiplier is used within the Inventory Movements program when processing a receipt, but only if you have indicated that you want to apply a cost multiplier when processing receipts (Inventory Setup). If you selected the option: Include non-merchandise costs in last cost (Inventory Setup - Options tab), then the Last cost of the item is calculated as the Receipt cost plus the calculated cost multiplier value. If the option: Include non-merchandise costs in last cost (Inventory Setup - Options tab), is not selected, then the Last cost is the Receipt cost entered when processing the receipt using the Inventory Movements program. |
||||||||
Cost |
This indicates the cost of one unit of the stock item in the selected warehouse. Where applicable, it includes additional charges such as freight, customs duty, packaging, etc, and any purchase price variances. Once you have entered and saved the Unit cost for a stock item, you will be unable to change it using the Warehouses for Stock Code program. This cost is saved against the current period and prior periods. This ensures that when a transaction is processed for a previous period, the cost of the transaction is not zero.
If your costing method is set to Standard (Inventory Setup - General tab or Browse on Warehouses if you are using costing per warehouse), then you need to use the Inventory Movements or Transfer BOM Costs to Wh Costs program to change the unit cost. If your costing method is not set to Standard, then the unit cost is adjusted automatically by the movements that affect the unit cost (for example when using Purchase Order Receipts). Irrespective of your costing method, the unit cost of an item can be changed using the Cost Change function of the Inventory Movements program.
|
||||||||
Minimum quantity | This indicates the minimum quantity of the item
required to be stocked in the warehouse at any point in time.
It is used as a stock control feature, and you can report on items where the on hand quantity is less than this figure using the Warehouse Exception program. This field is updated by the calculation performed by the Minimum Quantity Calculation program. |
||||||||
Maximum quantity | This indicates the maximum quantity of the item
required to be stocked in the warehouse at any point in
time. It is used as a stock control feature, and you can report on items where the on hand quantity exceeds this figure using the Warehouse Exception program (providing that the entry made here is non-zero). It is also using together with batching rule D (i.e. order to maximum quantity) within the Requirements Planning module.
|
||||||||
Safety stock level |
This stock control feature highlights instances where stock falls below a prescribed level and is used within the Requirements Planning module. The safety stock level is usually set to be above the minimum stock level. It is the quantity of stock kept in the warehouse to protect against fluctuations in demand or supply. You can report on items where the on hand quantity falls below this figure, using the Warehouse Exception program. |
||||||||
Re-order quantity |
This indicates when you should place an order for more of a particular stock item. If you are using costing by warehouse (Inventory Setup) and are retaining the BOM Costs by warehouse then the Re-order quantity is used as the EBQ (Economic Batch Quantity) in all calculations. The re-order quantity is printed on the Purchasing Work Sheet report. |
||||||||
Pallet quantity | This indicates a default quantity of the stock item that is required to be held in each bin, and is used when processing a purchase order receipt. | ||||||||
Default bin location |
This indicates the specific location of the stock item in a particular warehouse. If Multiple bins in use is selected against the warehouse (Warehouse Maintenance), then the default bin can be defined here. The Default bin location is used to generate the default bin for the warehouse. If this is not defined, then the default bin location for the warehouse defaults to the warehouse code itself. The default bin location is also the location from which stock is issued during the Backflushing function of the Inventory Movements program. Refer to Multiple bins for additional information. |
||||||||
User defined 1-3 |
This indicates extra information you want to store against the warehouse. You can specify your own wording for these fields (Inventory Setup). |
||||||||
Order policy details |
These options enable you to indicate the batching rules you require for the stock item in this warehouse. The batching rule (or buying rule) is used by the Requirements Planning module to indicate how you want to address quantity shortages encountered for the stock item. Although a buying rule is applied to bought-out items and a batch rule is applied to made-in items, the term is interchangeable within the Requirements Planning system because the buying or batch rules can apply to either bought-out or made-in items. These options are only enabled if you selected the Batching rule: Q - Apply warehouse order policy for the item (Stock Code Maintenance). |
||||||||
Order policy |
The order policy you select depends on the equivalent batching rule you require. See Batching Rules and Order Policy Equivalents. If you selected the setup option: Consolidate selected warehouses (Requirements Planning Setup - Warehouses tab), then the order policy defined against the warehouse to use (Stock Code Maintenance) is applied. The following order policies can be selected:
|
||||||||
Major order multiple | If this field is set to anything other than zero, then the order quantity is calculated as a multiple of the entered value. | ||||||||
Minor order multiple | If this field is set to anything other than zero, then the order quantity is calculated as a multiple of the entered value. | ||||||||
Minimum order quantity | If this field is set to anything other than zero, then the order quantity is at least the entered value even if the requirement is for less. | ||||||||
Maximum order quantity | If this field is set to anything other than zero, then the order quantity will not exceed the entered value. If the requirement is greater than the entered value, then multiple orders will be required. | ||||||||
Fixed time period |
This indicates the number of working days that represents a fixed time period. The entry made here is used for all time-based buying rules (i.e. C, K, L, M and N) within the Requirements Planning module. The fixed time period is ignored when the order policy is M - Order to max if less than min or S - Order to max if shortage. All order policies take the entry in this field into account. If you enter one or zero in this field, then orders are raised on the date required. Any value greater than zero will cause requirements planning to apply the time period to scheduling demand and raising suggestions. |
||||||||
Transfer supplied details |
These options enable you to assign defaults that you want to use when transferring this stock item from a source warehouse to this warehouse. |
||||||||
Transfer supplied item |
This indicates whether the stock item for this warehouse can be supplied by another warehouse. You must select this option if you want to be able to create supply chain transfer orders for this warehouse/stock code combination using the Back Order Review program. This option must also be selected if you want the Requirements Planning system to take account of supply chain transfer orders. |
||||||||
Source warehouse | Indicate the supplying warehouse from which stock will be transferred to replenish the warehouse you are maintaining for the stock item. This cannot be the same warehouse that you are currently maintaining. | ||||||||
Lead time (days) |
Indicate the number of days it takes to move the stock item from the source warehouse to the target warehouse. It is used to calculate the expected delivery date. Non-working days are not taken into account when calculating the expected delivery date if the Use absolute days when applying lead time to transfer supplied items option is enabled (Inventory Setup). When this option is not enabled, non-working days are accounted for when calculating the due date or receipt date for the transfer supplied items. If this field is left blank, then the program uses the entry defined in the Browse on Warehouse Move Matrix program. If the entry in the matrix is blank, then this field defaults to zero (0). Within MRP, the lead time entered here is added to the dock to stock days and the entry defined at the Number of days after stock arrives that it can be used field (Requirements Planning Setup). |
||||||||
Dock to stock (days) |
Indicate the number of days after a stock item arrives in the target warehouse that it is available to use. Within MRP, the dock to stock days entered here is added to the lead time and the entry defined at the Number of days after stock arrives that it can be used field (Requirements Planning Setup). |
||||||||
Use warehouse buying rule |
Select this to indicate that the buying rule specified against the warehouse must be used by the Requirements Planning system to calculate order quantities in the event of a stock shortage. If you select to use the warehouse buying rule, then the Re-order quantity assigned to the warehouse is used instead of the Economic Batch Quantity and the Pallet quantity is used instead of the pan size. |
||||||||
Replenishment rule |
This field is enabled only if you selected the option: Use warehouse buying rule. The buying rule selected here is used by the Requirements Planning system and indicates how you want to address quantity shortages encountered for the stock item. |
||||||||
Fixed time period (days) |
This field is enabled only if you selected the option: Use warehouse buying rule. It indicates the number of working days that represents a fixed time period. For example: A fixed time period of 1 day indicates that if a shortage is encountered, that the total shortage for today and the next working day is used as if the shortage falls today. The entry made here is used for all time-based buying rules (i.e. C, K, L, M and N) within the Requirements Planning module. |
||||||||
Transfer cost multiplier |
This is used to calculate the additional non-merchandise costs that you want to add to the cost of transferring goods (e.g. Freight and handling charges) The multiplier is only applied if you selected to apply a cost multiplier when processing receipts (Inventory Setup). |
||||||||
Ledger code | This indicates the ledger account to which you want to disburse the non-merchandise value arising from the transfer of goods. | ||||||||
BOM costing |
You use these fields to indicate the BOM costs to use for all items in the currently selected warehouse. If you do not select the option: Manual cost, then these BOM costs are updated for all parent parts by the Bill of Materials Cost Implosion program. These options are only enabled if you selected the option: Apply warehouse BOM costs (Inventory Setup - General tab). |
||||||||
BOM operations cost | This indicates the total cost of all operations for each item included in this warehouse. | ||||||||
BOM material cost | This indicates the total cost of all materials for each item included in this warehouse. | ||||||||
BOM fixed overhead | This indicates the total cost of all fixed overheads for each item included in this warehouse. | ||||||||
BOM variable overhead | This indicates the total cost of all variable overheads for each item included in this warehouse. | ||||||||
BOM subcontract cost |
This indicates the total cost of all subcontract operations for each item included in this warehouse. This field is only enabled if you selected the setup option: Split subcontract operation costs from material costs (Bill of Materials Setup - General tab). |
||||||||
Manual cost |
Select this if you do not want the Cost Implosion program to update the BOM costs defined against the warehouse. If you select this option, you will need to update the costs manually as required. |
This screen is displayed when you select the Warehouse list > Click to add a list option to assign the stock item to multiple warehouses with the same information against the item in each warehouse.
Field | Description |
---|---|
Accept and Close | Select this to assign the warehouses in the Selected Warehouses list to the stock code and to return to the previous screen. |
Cancel | Select this to return to the previous screen. If you made any changes, then you are prompted to save these before returning to the previous screen. |
Available Warehouses | This listview displays the warehouses currently defined in SYSPRO to which the selected stock code can be assigned. |
Assign Selected | Select this to assign the warehouses highlighted in
the Available Warehouses listview to
the Selected Warehouses list. These are
the warehouses you want to assign to the stock code.
You can use the Ctrl and Shift keys together with your mouse pointer to individually highlight the warehouses you want to assign to the stock code. |
Assign All | Select this to assign all the warehouses in the Available Warehouses list to the stock code. All the warehouses in the Available Warehouses list are added to the Selected Warehouses list. |
Selected Warehouses | This listview displays the warehouses to which you selected to assign the stock code. |
Remove Selected | Select this to remove the currently highlighted
warehouse(s) from the Selected
Warehouses listview. The warehouses which are
removed will not be linked to the stock code. You can use the Ctrl and Shift keys together with your mouse pointer to individually highlight the warehouses you want to remove from the Selected Warehouses list. |
Remove All | Select this to remove all the warehouse(s) from the Selected Warehouses list. |
If you selected the Batching rule: Q - Apply warehouse order policy for the item (Stock Code Maintenance), then you use the Order Policy Details options against the warehouse to define the batching rule for the item.
For each batching rule you can define against the stock item (Stock Code Maintenance), an equivalent rule can be defined against the warehouse for the stock item using the order policies.
This is illustrated in the tables below:
Batching Rule: A - Lot for lot | The order quantity is the shortage quantity. |
Order policy | C - Cover shortage |
Major order multiple | 0 |
Minor order multiple | 0 |
Minimum order quantity | 0 |
Maximum order quantity | 0 |
Fixed time period | Set to 1 |
Batching Rule: B - Multiples of EBQ | To calculate the order quantity, the shortage quantity is rounded up to the next multiple of the economic batch quantity. |
Order policy | C - Cover shortage |
Major order multiple | Set this to the same as the EBQ against the stock item (Stock Code Maintenance) |
Minor order multiple | Set this to the same as the EBQ against the stock item (Stock Code Maintenance) |
Minimum order quantity | 0 |
Maximum order quantity | 0 |
Fixed time period | Set to 1 |
Batching Rule: C - Fixed Time Period | When a shortage is encountered, the order quantity is calculated by adding all the shortages in the fixed time period ahead. |
Order policy | C - Cover shortage |
Major order multiple | 0 |
Minor order multiple | 0 |
Minimum order quantity | 0 |
Maximum order quantity | 0 |
Fixed time period | Set to 1 and 99 depending on the time period you require. |
Batching Rule: D - Order to Maximum if Shortage | When a shortage is encountered, the order quantity is calculated to increase the stock holding up to the maximum defined against the warehouse. |
Order policy | S - Order to max if shortage |
Major order multiple | 0 |
Minor order multiple | 0 |
Minimum order quantity | 0 |
Maximum order quantity | 0 |
Fixed time period | Set to 1 |
Batching Rule: E - Order to Maximum if Less Than Minimum | As soon as the result field (during netting-off) falls below the minimum quantity, an order quantity is calculated to order sufficient to increase the quantity available up to the maximum quantity. |
Order policy | M - Order to max if less than minimum |
Major order multiple | 0 |
Minor order multiple | 0 |
Minimum order quantity | 0 |
Maximum order quantity | 0 |
Fixed time period | Set to 1 |
Batching Rule: F - Multiples of Pan | To calculate the order quantity, the shortage quantity is rounded up to the next multiple of the pan size. |
Order policy | C - Cover shortage |
Major order multiple | Set this to the same as the Pan size against the stock item (Stock Code Maintenance) |
Minor order multiple | Set this to the same as the Pan size against the stock item (Stock Code Maintenance) |
Minimum order quantity | 0 |
Maximum order quantity | 0 |
Fixed time period | Set to 1 |
Batching Rule: G - Multiple EBQ Lots | If a shortage occurs, then multiple orders should be created to satisfy the shortage, each the size of the EBQ. |
Order policy | C - Cover shortage |
Major order multiple | Set to 0 |
Minor order multiple | Set to 0 |
Minimum order quantity | Set this to the same as the EBQ against the stock item (Stock Code Maintenance) |
Maximum order quantity | Set this to the same as the EBQ against the stock item (Stock Code Maintenance) |
Fixed time period | Set to 1 |
Batching Rule: H - Multiple Pan Lots |
If a shortage occurs, then multiple orders should be created to satisfy the shortage, each the size of the Pan. |
Order policy | C - Cover shortage |
Major order multiple | Set to 0 |
Minor order multiple | Set to 0 |
Minimum order quantity | Set this to the same as the Pan size against the stock item (Stock Code Maintenance) |
Maximum order quantity | Set this to the same as the Pan size against the stock item (Stock Code Maintenance) |
Fixed time period | Set to 1 |
Batching Rule: I - Minimum of EBQ |
If a shortage occurs, the order quantity is the quantity required to meet the shortage, unless this is less than the EBQ (in which case the EBQ is used). |
Order policy | C - Cover shortage |
Major order multiple | Set to 0 |
Minor order multiple | Set to 0 |
Minimum order quantity | Set this to the same as the EBQ against the stock item (Stock Code Maintenance) |
Maximum order quantity | Set to 0 |
Fixed time period | Set to between 1 and 99 depending on the time period you require. |
Batching Rule: J - Minimum of Pan |
If a shortage occurs, the order quantity is the quantity required to meet the shortage, unless this is less than the Pan size (in which case the Pan size is used). |
Order policy | C - Cover shortage |
Major order multiple | Set to 0 |
Minor order multiple | Set to 0 |
Minimum order quantity | Set this to the same as the Pan size against the stock item (Stock Code Maintenance) |
Maximum order quantity | Set to 0 |
Fixed time period | Set to between 1 and 99 depending on the time period you require. |
Batching Rule: K - Multiples of EBQ (fixed time period) |
This rule is a combination of rules B and C. The order quantity is calculated by adding all the shortages in the fixed time period ahead. Once this total shortage quantity has been calculated, then this is rounded up to the next multiple of the economic batch quantity. |
Order policy | C - Cover shortage |
Major order multiple | Set this to the same as the EBQ against the stock item (Stock Code Maintenance) |
Minor order multiple | Set this to the same as the EBQ against the stock item (Stock Code Maintenance) |
Minimum order quantity | 0 |
Maximum order quantity | 0 |
Fixed time period | Set to between 1 and 99 depending on the time period you require. |
Batching Rule: L - Multiples of Pan (fixed time period) | This rule is a combination of rules F and C. This rule is identical to rule K, except that the pan quantity is used instead of the economic batch quantity. The order quantity is calculated by adding all the shortages in the fixed time period ahead.Once this total shortage quantity has been calculated, then this is rounded up to the next multiple of the pan size. |
Order policy | C - Cover shortage |
Major order multiple | Set this to the same as the Pan size against the stock item (Stock Code Maintenance) |
Minor order multiple | Set this to the same as the Pan size against the stock item (Stock Code Maintenance) |
Minimum order quantity | 0 |
Maximum order quantity | 0 |
Fixed time period | Set to between 1 and 99 depending on the time period you require. |
Batching Rule: M - Multiple EBQ Lots (fixed time period) |
This rule is a combination of rules G and C. The order quantity is calculated by adding all the shortages in the fixed time period ahead. Once this total shortage quantity has been calculated, then multiple orders (each the size of the EBQ) are suggested. |
Order policy | C - Cover shortage |
Major order multiple | Set to 0 |
Minor order multiple | Set to 0 |
Minimum order quantity | Set this to the same as the EBQ against the stock item (Stock Code Maintenance) |
Maximum order quantity | Set this to the same as the EBQ against the stock item (Stock Code Maintenance) |
Fixed time period | Set to between 1 and 99 depending on the time period you require. |
Batching Rule: N - Multiple Pan Lots (fixed time period) |
This rule is a combination of rules H and C. This rule is identical to rule M, except that the pan quantity is used instead of the economic batch quantity. The order quantity is calculated by adding all the shortages in the fixed time period ahead. Once this total shortage quantity has been calculated, then multiple orders (each the size of the pan) are suggested. |
Order policy | C - Cover shortage |
Major order multiple | Set to 0 |
Minor order multiple | Set to 0 |
Minimum order quantity | Set this to the same as the Pan size against the stock item (Stock Code Maintenance) |
Maximum order quantity | Set this to the same as the Pan size against the stock item (Stock Code Maintenance) |
Fixed time period | Set to between 1 and 99 depending on the time period you require. |
Batching Rule: O - Minimum of EBQ, thereafter multiples of pan | If a shortage occurs, the order quantity is at least the EBQ. However, if the EBQ is insufficient to satisfy the shortage, then the remaining shortage is rounded up to the next multiple of the pan quantity. |
Order policy | C - Cover shortage |
Major order multiple | Set this to the same as the Pan size against the stock item (Stock Code Maintenance) |
Minor order multiple | Set this to the same as the Pan size against the stock item (Stock Code Maintenance) |
Minimum order quantity | Set this to the same as the EBQ against the stock item (Stock Code Maintenance) |
Maximum order quantity | Set to 0 |
Fixed time period | Set to between 1 and 99 depending on the time period you require. |
Batching Rule: P - Suppress MRP ordering | Demand generated for this item will not result in any suggested purchase orders, unless you have indicated that batching rules must be overridden (Requirements Planning Setup). |
Order policy | P - Suppress MRP Ordering |
Major order multiple | Not applicable |
Minor order multiple | Not applicable |
Minimum order quantity | Not applicable |
Maximum order quantity | Not applicable |
Fixed time period | Not applicable |
Q - Apply warehouse order policy | The batching rule against the individual warehouse in which the item is stocked (Warehouse Maintenance for Stock Code) is used. |
Electronic Signatures provide security access, transaction logging and event triggering. This enables you to increase control over your system changes.
Access to the following eSignature transactions within this program can be restricted at Operator, Group, Role or Company level. You configure this using the Electronic Signatures program.
eSignature Transaction | Description |
---|---|
Inv Stock warehouse added |
Controls access to the New Warehouse function in the Inventory Movements, Warehouses for Stock Code and Warehouse Maintenance for Stock Code programs. |
Inv Stock warehouse changed |
Controls access to the Warehouse maintenance in the Warehouses for Stock Code and Warehouse Maintenance for Stock Code programs. |
Inv Stock warehouse deleted |
Controls access to the Delete function in the Warehouses for Stock Code and Warehouse Maintenance for Stock Code programs. |
Inv Stock warehouse add multiple |
Controls access to the Add Multiple Warehouses function in the Warehouse Maintenance for Stock Code program. |
When you add a stock code to a warehouse, the cost entered is saved against the current period and prior periods. This ensures that when a transaction is processed for a previous period, the cost of the transaction is not zero.
However, if an operator adds the warehouse from within a posting program, then only the current period is updated with the cost entered.
You cannot assign an ECC stock item to a warehouse if it has been put on hold in the Change Orders program (i.e. If the Hold stock maintenance checkbox is ticked in the Affected Items listview of the Change Orders program). The message: Stock code xxxx held by engineering change control is displayed, where xxxx is the actual code.