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 Warehouses program to define and maintain warehouses.
The Inventory Warehouses for Stock Codes 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 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 entered or changed. |
| Stock code | Indicate the stock item to link to a warehouse or to several warehouses. |
| Warehouse | Enter the warehouse to which 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. |
| 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 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 | This indicates the warehouse entered at the Warehouse field on the toolbar. | ||||||||||||||||||||||||||||||||||||
| Warehouse description | This indicates the description of the warehouse you selected to link to the stock item. | ||||||||||||||||||||||||||||||||||||
| Warehouse list | This only applies when the Add Multiple Warehouses option is enabled. | ||||||||||||||||||||||||||||||||||||
| Define list | Select this to indicate a list of warehouses to which the stock code must be linked (see Warehouse List Selection). | ||||||||||||||||||||||||||||||||||||
| Cost multiplier |
Indicate what portion of the transaction value of the stock item comprises non-merchandise costs (e.g. freight, duty, tax, etc.). The cost multiplier can be applied in the following programs:
The Last cost of the item is calculated as the Receipt cost plus the calculated cost multiplier value when the Include non-merchandise costs option is enabled (Inventory Setup). When the Include non-merchandise costs option is not enabled, 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 cannot change it using the Inventory Warehouse Maintenance 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 or Warehouses if you are using costing per warehouse), then you need to use the Inventory Movements or Transfer BOM Costs to Warehouse 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 | Indicate 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 Inventory Minimum Quantity Calculation program. |
||||||||||||||||||||||||||||||||||||
| Maximum quantity | Indicate 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 |
Indicate the quantity at which you should place an order for more of a particular stock item. The re-order quantity is printed on the Purchasing Work Sheet report. 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 cost calculations. The warehouse re-order quantity is only used in the MRP requirements calculation when an item is transfer-supplied and suggested supply chain transfers are being created. |
||||||||||||||||||||||||||||||||||||
| Pallet quantity | Indicate 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 |
Indicate the specific location of the stock item in a particular warehouse. 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. If Multiple bins in use is selected against the warehouse (Warehouses) then the default bin can be defined here. The Default bin location is only created when adding a warehouse to a stock code, and is not updated if the location is changed. The default bin location is also the location from which stock is issued during the Backflushing function of the Inventory Movements program. When you create a new stock code and attach it to a warehouse, then a default bin is created for the item using the warehouse as the bin if Multiple bins is enabled at company level. This record is saved in the InvMultBin table with no quantities and the bin equal to the warehouse. |
||||||||||||||||||||||||||||||||||||
| User defined 1-3 |
Optionally indicate extra information you want to store against the warehouse. You can specify your own wording for these fields (Inventory Setup). |
||||||||||||||||||||||||||||||||||||
| Order policy details |
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 Codes). |
||||||||||||||||||||||||||||||||||||
| Order policy |
The order policy you select depends on the equivalent batching rule you require. See Batching Rules and Order Policy Equivalents. The order policy defined against the warehouse to use (Stock Codes) is applied when the Consolidate selected warehouses option is enabled (Requirements Planning Setup). The following order policies are available:
|
||||||||||||||||||||||||||||||||||||
| 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 |
Indicate 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 |
Assign defaults to use when transferring this stock item from a source warehouse to this warehouse. |
||||||||||||||||||||||||||||||||||||
| Transfer supplied item |
Indicate whether the stock item for this warehouse can be supplied by another warehouse. You must enable this option if you want to be able to create supply chain transfer orders (SCTs) for this warehouse/stock code combination using the Back Order Review program, and if you want the Requirements Planning system to take account of supply chain transfer orders. This option is disabled if the item is defined as bought-out at warehouse level (see Bought out item). |
||||||||||||||||||||||||||||||||||||
| 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. | ||||||||||||||||||||||||||||||||||||
| Transfer 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 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 GIT 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 Days after stock arrival it can be used option (Requirements Planning Setup). |
||||||||||||||||||||||||||||||||||||
| Transfer 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 Days after stock arrival it can be used option (Requirements Planning Setup). |
||||||||||||||||||||||||||||||||||||
| Use warehouse buying rule |
Enable 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 applies only when the Use warehouse buying rule option is enabled. 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 applies only when the Use warehouse buying rule option is enabled. It indicates the number of working days that represents a fixed time period. This is set to 1 when the Replenishment rule is C - Fixed time period and you do not enter 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 | Indicate the GL account to which the non-merchandise value arising from the transfer of goods must be disbursed. This field is only enabled when the Transfer cost multiplier is not 1. | ||||||||||||||||||||||||||||||||||||
| BOM costing |
Indicate the BOM costs to use for all items in the currently selected warehouse. These BOM costs are updated for all parent parts by the Bill of Materials Cost Implosion program when the Manual cost option is not enabled. These options are only enabled when the Apply warehouse BOM costs is enabled (Inventory Setup). See Field considerations in Notes and warnings. |
||||||||||||||||||||||||||||||||||||
| BOM operations cost | Indicate the total cost of all operations for each item included in this warehouse. | ||||||||||||||||||||||||||||||||||||
| BOM material cost | Indicate the total cost of all materials for each item included in this warehouse. | ||||||||||||||||||||||||||||||||||||
| BOM fixed overhead | Indicate the total cost of all fixed overheads for each item included in this warehouse. | ||||||||||||||||||||||||||||||||||||
| BOM variable overhead | Indicate the total cost of all variable overheads for each item included in this warehouse. | ||||||||||||||||||||||||||||||||||||
| BOM subcontract cost |
Indicate the total cost of all subcontract operations for each item included in this warehouse. This field is only enabled if you selected the Subcontract operation and material costs setup option (Bill of Materials Setup). |
||||||||||||||||||||||||||||||||||||
| Manual cost |
Enable this if you do not want the Cost Implosion program to update the BOM costs defined against the warehouse. Costs must be manually updated as required when you enable this option. |
||||||||||||||||||||||||||||||||||||
| Bought out details |
These options enable you to define the supplier, lead time and dock to stock time for an item at warehouse level rather than stock code level. This typically applies in a distributed environment, where warehouses are in different locations and goods are typically ordered from different suppliers within these locations. The lead time and dock to stock for these goods often differ from location to location. The scope of this feature is currently limited to planning. See also: Notes and warnings. |
||||||||||||||||||||||||||||||||||||
| Bought out item | Enable this to set bought-out, made-in or subcontracted
parts as bought-out at warehouse level and to use the
warehouse values for replenishment. When enabled, the supplier, supplier's lead time and dock to stock values entered at warehouse level (instead of stock code level) are used to calculate due dates in purchasing and planning, and to raise suggestions against the relevant supplier in Requirements Planning. This option is ignored when using consolidated warehouses. This option is disabled when the item is defined as transfer-supplied (see Transfer supplied item). |
||||||||||||||||||||||||||||||||||||
| Supplier | Indicate the code of the primary supplier from whom you usually purchase this stock item. Where relevant, the supplier entered here replaces the default supplier defined at stock code level. The code is validated only if the Accounts Payable or Purchase Order module is installed. Leave blank to use the supplier defined against the stock code. | ||||||||||||||||||||||||||||||||||||
| Supplier name | This is the name of the selected supplier. | ||||||||||||||||||||||||||||||||||||
| Bought out lead time (days) | This is the number of days in which to buy out the
stock item. For bought-out items, you enter the number of days it takes the supplier to deliver the item from the date the order is placed. This must be manually buffered for non-working days (e.g. if your supplier takes 3 days from the date of order to delivery, then this represents 3 working days. You will therefore need to buffer the lead time to account for weekends). The lead time is used in the calculation performed by the Inventory Minimum Quantity Calculation program to establish the minimum quantity required for each stock code and warehouse. It is also used in the Requirements Planning and Bill of Materials modules. |
||||||||||||||||||||||||||||||||||||
| Bought out dock to stock (days) | This is the number of days that a bought-out item must
be in stock prior to usage. This lets you calculate an earlier
due date for purchase orders and, from these, an earlier start
date. Non-working days on the factory calendar are taken into account when the delivery date is calculated to add to the ship date. |
||||||||||||||||||||||||||||||||||||
![[Note]](images/note.png)
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 Codes) 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 Codes) 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 Codes) |
| Minor order multiple | Set this to the same as the EBQ against the stock item (Stock Codes) |
| 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 Codes) |
| Minor order multiple | Set this to the same as the Pan size against the stock item (Stock Codes) |
| 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 Codes) |
| Maximum order quantity | Set this to the same as the EBQ against the stock item (Stock Codes) |
| 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 Codes) |
| Maximum order quantity | Set this to the same as the Pan size against the stock item (Stock Codes) |
| 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 Codes) |
| 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 Codes) |
| 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 Codes) |
| Minor order multiple | Set this to the same as the EBQ against the stock item (Stock Codes) |
| 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 Codes) |
| Minor order multiple | Set this to the same as the Pan size against the stock item (Stock Codes) |
| 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 Codes) |
| Maximum order quantity | Set this to the same as the EBQ against the stock item (Stock Codes) |
| 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 Codes) |
| Maximum order quantity | Set this to the same as the Pan size against the stock item (Stock Codes) |
| 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 Codes) |
| Minor order multiple | Set this to the same as the Pan size against the stock item (Stock Codes) |
| Minimum order quantity | Set this to the same as the EBQ against the stock item (Stock Codes) |
| 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 (Inventory Warehouse Maintenance for Stock Code) is used. |
-
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-controlled stock item to a warehouse if it has been put on hold in the ECC Change Orders program (i.e. If the Hold stock maintenance checkbox is ticked in the Affected Items listview of the ECC Change Orders program). The message: Stock code xxxx held by engineering change control is displayed, where xxxx is the actual code.
-
Before deleting a warehouse (i.e. removing the stock code to warehouse link) you need to ensure that you do not have any Scheduled orders (irrespective of ship or back order) that are not allocated (i.e. fall outside the date range for allocation of scheduled orders).
The Inventory Warehouse Maintenance for Stock Code program does not check whether such scheduled orders exist before allowing you to delete the warehouse against the stock code.
Once deleted, an error message is displayed indicating that the scheduled order can only be cancelled when you maintain these unallocated scheduled sales orders for that stock code/warehouse combination.
The following table indicates a list of programs affected by the enhancement released in SYSPRO 7 Update 1 Port 015 (the facility to set replenishment values for stock codes at warehouse level).
| Affected program(s) | Description of change |
|---|---|
| Requirements Calculation |
If an item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the supplier, lead time and dock to stock days defined against the warehouse is used instead of the values held against the stock code. This is ignored if using consolidated warehouses. |
| MRP Forecast Depletion Take-on |
If an item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) and the Forecast depletion period type setup option (Requirements Planning Setup) is defined as Planning time fence, then the lead time and dock to stock days defined against the warehouse is used instead of the values held against the stock code. |
| MPS Review |
If reviewing an item that is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the Stock Information pane shows the supplier, lead time and dock to stock days defined against the warehouse instead of the values held against the stock code. The Production Information pane shows the lead time defined against the warehouse instead of the value held against the stock code. This is ignored if using consolidated warehouses. |
| MRP List of Forecasts |
If an item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the lead time defined against the warehouse is used to calculate time fences (PTF, DTF and PH) instead of the value held against the stock code. This is ignored if using consolidated warehouses. |
| Multiple Forecast Additions, Forecast Maintenance, Build Schedule Maintenance |
If an item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the Stock Information pane will show the supplier, lead time and dock to stock defined against the warehouse instead of the values held against the stock code. The dock to stock days and lead time defined against the warehouse is used in the calculation of time fences (PTF, DTF and PH). |
| MRP Potential Oversupply Report |
If a made-in item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then filtering on part category B returns the item. The supplier and dock to stock days defined against the warehouse is used instead of the values held against the stock code. This is ignored if consolidating warehouses. |
| Purchase Order Review, Requisition Review |
If an item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the dock to stock days defined against the warehouse is used to calculate the due date instead of the value held against the stock code. |
| MRP Master Production Schedule |
If an item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the lead time defined against the warehouse is used instead of the value held against the stock code. The item is always flagged as a bought-out item. This is ignored if consolidating warehouses. |
| MRP Purchase Order Action Report |
If an item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the supplier, lead time and dock to stock days defined against the warehouse is used instead of the values held against the stock code (the dock to stock days is used to calculate the supply demand date). |
| MRP Material Requirements Report |
If an item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the supplier defined against the warehouse is output and the part category will be bought-out. The lead time and dock to stock defined against the warehouse is used to calculate the planning time fence instead of the values held against the stock code. |
| Multi-level Trial Kitting - Legacy, Multi-level Trial Kitting, Advanced Trial Kitting (Legacy) |
If an item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the supplier and lead time defined against the warehouse is used instead of the values held against the stock code. The Warehouse to use defined against the item is used if consolidating warehouses. |
| BOM Advanced Trial Kitting Query |
If a component is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the supplier and lead times defined against the warehouse is used instead of the values held against the stock code. |
| Lead Time Calculation |
Component lead times are used to calculate the lead time of the parent. If the component is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the lead time value of components defined against the warehouse is used instead of the values held against the stock code. |
| BOM Scheduling Profile |
If an item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the supplier and lead time defined against the Warehouse to use of the component is used instead of the values held against the stock code. The item will always be bought-out in the specified warehouse. |
| Purchase Order Entry, PO Purchase Order Import |
If an item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the lead time defined against the warehouse is used to calculate the due date instead of the value held against the stock code. |
| Contract Maintenance, Requisition Entry Maintenance, Purchase Order Inspection, Purchase Order Receipts, Requisition List, PO Build Purchase Order Line, PO Build Req Line Information |
If an item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the supplier defined against the warehouse is used instead of the supplier held against the stock code. |
| Sales Order Entry, Sales Order Entry Express |
For scheduled orders, if the Use LDT + DTS to calculate ship date when there is insufficient stock preference is enabled (Sales Order Entry) and the stock item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then at the time of creating the purchase order the ship date is calculated using the lead time defined against the warehouse instead of the values held against the stock code. |
| Time Fences |
If an item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the lead time and dock to stock days defined against the Warehouse to use for the item is displayed instead of the values held against the stock code. |
| Inventory ATP Query, Inventory Available to Promise Query |
If an item is defined as bought-out at warehouse level (Inventory Warehouse Maintenance for Stock Code) then the supplier and lead time defined against the warehouse is used to calculate the various time fences instead of the values held against the stock code. |
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 eSignature Setup program.
| eSignature Transaction | Description |
|---|---|
| Inv Stock warehouse added |
Controls access to the New Warehouse function in the Inventory Movements, Inventory Warehouses for Stock Codes and Inventory Warehouse Maintenance for Stock Code programs. |
| Inv Stock warehouse changed |
Controls access to the Warehouse maintenance in the Inventory Warehouses for Stock Codes and Inventory Warehouse Maintenance for Stock Code programs. |
| Inv Stock warehouse deleted |
Controls access to the Delete function in the Inventory Warehouses for Stock Codes and Inventory Warehouse Maintenance for Stock Code programs. |
| Inv Stock warehouse add multiple |
Controls access to the Add Multiple Warehouses function in the Inventory Warehouse Maintenance for Stock Code program. |
Operator access to the following fields within this program can be restricted. You configure this using the Security Fields function of the Operators program.
| Field | Description | ||||
|---|---|---|---|---|---|
| INV Show costs in stock code maintenance | Controls whether an operator can access the cost fields of the
Stock Codes and Inventory Warehouse Maintenance for Stock Code programs, and view costs in the Browse on Stock Codes program.
|
||||