Inventory > Browses > Warehouses for Stock Code > Warehouse Maintenance for Stock Code

Warehouse Maintenance for Stock Code

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.

Toolbar and menu

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.

Warehouse Maintenance for Stock Code

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.

[Note]

If the warehouse is added from a posting program, then only the current period is updated with the cost entered.

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.

[Note]

You can suppress the display of stock item costs (i.e. normally visible in the Cost column of the listview pane) selectively by operator. To achieve this, you must deny operators access to the Show costs in Stock code maintenanceSecurity Fields.

Take care not to deny an operator access to the viewing of costs in stock code maintenance, while allowing the same operator the facility to maintain stock codes. In this scenario, the operator will still be able to view details of BOM costs held against the item.

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.

[Note]

SYSPRO does not allow any order policy (Stock Code Maintenance - Batching rules) to exceed the Maximum quantity defined.

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:

  • C - Cover shortages

    This is the same as I - Cover shortages if less than min except that it ignores the minimum - i.e. the order point is reached when available is insufficient for demand (effectively the minimum equals zero).

    For example, if Available = 7, Demand = 40 and Minimum = 33, then MRP will suggest supply of 33. This is the 33 required to meet the demand (7-40 =33) and the 33 to meet the minimum is ignored.

  • I - Cover shortages if less than min

    If available minus demand is less than the minimum level, then MRP will recommend supply to meet demand and to top up to the minimum level.

    For example, if Available = 7, Demand = 40 and Minimum = 33, then MRP will suggest supply of 66. This is the 33 required to meet the demand (7-40 =33) plus 33 to meet the minimum. The opening available for the next period (in this example) will be 33, which is the minimum.

    This ignores the Fixed time period option. It uses the Inventory Optimization min/max levels.

    The rule orders up to the minimum regardless of whether the min/max levels are defined against the warehouse or against the IO model.

  • S - Order to max if shortage

    This ignores the minimum. The order point is reached when available is insufficient for the demand.

    This ignores the Fixed time period option.

  • M - Order to max if less than minimum

    If demand causes available to be less than the minimum, then MRP will recommend supply up to the maximum.

    This ignores the Fixed time period option.

    When using Inventory Optimization, the goal of this policy is to suggest supply that will satisfy the target service level defined against the IO policy (IO Policies).

  • P - Suppress MRP ordering

    Demand generated for this item will not result in any suggested purchase orders, unless you indicated that batching rules must be overridden (Requirements Planning Setup).

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.

Warehouse List Selection

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.

Batching Rules and Order Policy Equivalents

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.

Notes and warnings

eSignature considerations

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.

Coding considerations

  • 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.