Inventory > Setup > Warehouse Maintenance

Warehouse Maintenance

You use this program to capture and maintain details of warehouses required within the system.

Once the warehouses are defined, you use the Warehouses for Stock Code program (accessed from the Browse on Stock Codes program) to link stock items to these warehouses.

Warehouse Maintenance

Field Description
Warehouse Indicates the code of the warehouse you are currently maintaining.
Description

Indicates the name associated with the warehouse. This assists you in verifying that the correct warehouse has been entered.

Next stock take ticket number Generates the next number that will be printed on tickets/labels for this warehouse when next you perform a stock take.
Multiple bins in use

You can only access this field from the Warehouses function of the Multiple bins section within the Inventory Setup program.

Refer to Multiple bins for additional information on multiple bins in SYSPRO.

Yes This is the default entry if you have enabled the multiple bins setup option (Inventory Setup). This will require the entry of a specific bin when you receive items into stock, issue items from stock or transfer items between warehouses.
No

The bins against each stock item stocked in the warehouse are deleted and replaced by a single default bin with the entire quantity on hand for the stock code/warehouse against it.

The default bin location is generated from the warehouse code if no default bin is setup against the stock code/warehouse combination (Warehouse Maintenance for Stock Code).

Bins allocated to sales order lines are replaced with an allocation for the newly-created bin.

The bin associated with existing lot records (and their transactions) against traceable and ECC-controlled items is replaced with the newly-created bin. All transactions are then processed against the newly-created bin.

When you select this option against a warehouse, no other action is required, as the default bin will already be defined against lots and sales order ship quantities.

Negative stock allowed

Indicates whether stock in the warehouse is allowed to go negative.

This defaults to the setting at the option: Stock on hand allowed to go negative (Inventory Setup). However, when this setup option is set to Dependent on w/h list and you are adding a new warehouse, then this defaults to No and you need to use the Inventory Setup program to add the warehouse to the list of warehouses that allow negative stock if required.

The applies only when the Dependent on warehouse at the Stock on hand allowed to go negative option is enabled (Inventory Setup).

Costing level This option enables you to define different costing methods for individual warehouses and only applies if you have enabled the Costing per warehouse setup option (Inventory Setup).

You can only access this field from the Warehouses function of the Costing method section within the Inventory Setup program.

FieldDescription
CompanyUses the costing method defined against the company (Inventory Setup) for this warehouse (i.e. you do not want to define a costing method which is different from the company costing method for this warehouse).
WarehouseUses the costing method defined against the warehouse (Warehouse Maintenance) for this warehouse.
Costing method

Selects the costing method required for this warehouse which determines how your inventory is valued for the warehouse.

By default, the costing method is set to that defined against the company (Inventory Setup).

Average Averages out the unit cost of an item that is received into this warehouse. This is calculated as the average between the new cost of the item and the existing cost of the item held on file.
Standard Updates costs in this warehouse only when the Cost Changes function is used within the Inventory Movements program.
Last cost Values inventory in this warehouse according to the last cost that was entered for an item when it was received into this warehouse.
FIFO

All stock receipts create a new FIFO bucket and all issues/sales are made from the oldest bucket held on file for items held in this warehouse.

You can only select this option if you enabled the FIFO valuation setup option (Inventory Setup).

LIFO LIFO costing can only be applied across all warehouses for a company and not at individual warehouse level.
Language If you enabled the Multi-language for document printing setup option (System Setup) then you can indicate the language code to use (see Multi-language capability).
Intrastat details  
Nationality

Indicate the nationality code for the country in which the warehouse is located.

[Note]

If the EC Vat system required option is in force (Admin Tax Options), then this field is mandatory.

Your entry here is used as the default:

Delivery terms You use this field to optionally define the default three-character alphanumeric Incoterms code, denoting the terms of delivery for the warehouse.
[Note]

The Incoterms code indicates the portion of costs and risks agreed to by the parties in a contract of purchase or sale.

For example, the Delivery term CIP (Carriage and Insurance Paid), indicates that the seller pays the cost of carriage and insurance necessary to bring the goods to a named destination (i.e. Shipping location).

Shipping location You use this field to optionally define the default Shipping location associated with the Delivery terms for the warehouse.
Cost implosion, suggested jobs  
Component warehouse to use

Indicates the warehouse from which material allocations must be allocated to suggested jobs created by the Requirements Calculation program.

You can access this field only if you are using Costing by warehouse (Inventory Setup) and either the Bill of Materials or the Requirements Planning module is installed.

If you enabled the Consolidate selected warehouses setup option (Requirements Planning Setup) then this warehouse is used by the consolidation routine in the Requirements Calculation program. If this is blank, then MRP cannot raise suggested supply.

You can also set a preference for this to be the default warehouse from which material allocations must be allocated when creating a job (Job Entry).

If this is not specified, then material allocations are allocated from the warehouse to use assigned to the component.

Routing

Indicates the routing that must be used for materials and operations that are assigned to suggested jobs using this warehouse.

You can access this field only if the Bill of Materials and Requirements Planning modules are installed and you enabled the Alternate routings required setup option (Bill of Materials Setup).

Sales Order entry always uses route 0. Therefore to sell Kit type items, route 0 must be used for the components.

You can also set a preference for this to be the default route to use for materials and operation assigned when creating a job (Job Entry).

Suggested jobs are created by the Requirements Calculation program.

Include warehouse in requirements planning calculation

Includes the warehouse in the calculations performed by the Requirements Calculation program.

This option is displayed only if you selected By warehouse at the Warehouse selection option (Requirements Planning Setup).

GL accounts Entries made here are validated only if the Inventory module is integrated to General Ledger in summary or detail (General Ledger Integration).
Warehouse control

Indicates the control account for all inventory transactions processed against the warehouse.

Warehouse variance Indicates the ledger account to which all variances are posted arising from rounding errors when processing receipts into stock.
GRN suspense

Indicates the ledger account to which all receipts of stocked items are posted for the purpose of Accounts Payable invoice matching and checking.

For non-stocked receipts, the GRN suspense account defined in the Purchase Orders Setup program is used.

You can access this field only if you indicated that the GRN suspense system is required (Purchase Orders Setup).

Goods in transit control

Indicates the control account to which postings are made for all goods in transit transactions that are processed for this warehouse.

If no entry is assigned to the warehouse, then the Goods in Transit control account defined at company level, is used (General Ledger Integration).

Dispatched but not invoiced

Indicates the clearing account that is used when dispatching items from the warehouse using the Dispatch Note system.

This account is debited at the time of creating and printing the dispatch note (i.e. stock on hand is reduced for each item on the dispatch note, even though an invoice has not yet been produced). This account is credited when the dispatch note is invoiced against the customer. This account is also credited when a dispatch note is cancelled or an adjustment made that decreases the value of the dispatch note (e.g. the quantity is decreased).

[Note]

Dispatches involving non-stocked items use the account defined at company level (General Ledger Integration).

WIP inspection

Indicates the account to which the WIP value of goods received into inspection for this warehouse must be posted.

You can only access this field if you enabled the Work in Progress inspection required setup option (WIP Setup).

If you leave this field blank then the account configured at company level is used (General Ledger Integration).

[Note]

You will be unable to receive items from inspection into stock using the WIP Inspection Maintenance program if you have not defined this account here or against the company (General Ledger Integration) and you did not enable the Request ledger code for inventory transactions setup option (Inventory Setup).

Work in progress

Indicates the default account to which the value of work in progress is posted when a job is created.

This account is only used if a work in progress account is not defined against the Stock item (Stock Code Maintenance).

If you leave this field blank (and a work in progress account is not defined against the Stock item) then the account configured at company level is used (General Ledger Integration).

WIP variance

Indicates the account to which postings are made during the Backflushing function of the Inventory Movements program if there is a variance between the entered cost of the manufactured item and the cost of the item's material and labor allocations calculated by the system.

If left blank, then the account configured at company level is used (General Ledger Integration).

Automatically cleared variances

Indicates the default account to which work in progress variances (falling below your specified value) are posted automatically when receiving a finished part into stock from a completed job (if standard costing is in use).

If left blank, then the account configured at company level is used as the default (General Ledger Integration).

The General Ledger cleared variances account to use when receipting items in from inspection can be defined using the Preferences option of the WIP Inspection Maintenance program.

Delivery address  
Delivery address line 1-6

You use these fields to assign up to six lines of delivery address information for the warehouse.

This address can be printed on inventory documents.

Delivery address postal/zip code Indicates the postal zip code for the delivery address.
Geolocation This indicates the geographic location of the address in terms of longitude and latitude and includes a hyperlink to the map directions.

An additional hyperlink is available (Resolve GeoLocation from address) to resolve addresses using the long or short name.

Load planning  
Delivery route

Indicates the default delivery route code to use for Supply Chain Transfer deliveries to this warehouse.

Delivery route codes are maintained using the Browse on Delivery Routes program.

This field is only enabled if you selected the Load planning required setup option (Sales Order Setup).

Delivery distance/sequence

Indicates the default delivery distance or sequence number to use for Supply Chain Transfer deliveries to this warehouse.

For example, you may want to assign this delivery warehouse as the first one to which deliveries must be made on the delivery route specified in the previous field, in which case you enter 1 in the sequence field. Alternatively, you may enter the distance of the target warehouse delivery location from the source warehouse as the sequence. If you specify this distance against all the warehouse addresses on this route, then you can sequence the loads on the route based on the delivery distance from the source to the target warehouses.

This field is only enabled if you selected the Load planning required setup option (Sales Order Setup).

Supply chain transfer documents  
Fax SCT documents Enables you to fax transfer documentation when ending the supply chain transfer order.
SCT fax number Indicates the default fax number that must be used when you end the supply chain transfer order and fax the transfer document.

This number can be printed on SCT documents (S/O Document Formats).

SCT contact name Indicates the contact person who must receive the transfer document that is faxed when you end the supply chain transfer order.
SCT default document format

Defines the default document format to use for Supply Chain Transfer documents.

The Sales Order Entry program uses this default format defined against the source warehouse if the option: Use source branch for numbering SCT documents is selected (Sales Order Setup). In all other cases, the Sales Order Entry program uses this default format defined against the target warehouse when generating the SCT document.

Warehouse management  
Warehouse under control of WMS This option is intended for use in a future version of the program.

Define Numbering

Field Description
Goods in Transit  
Goods in Transit Branch

Indicates the branch that must be used for the warehouse when processing a supply chain transfer order (SCT).

A supply chain transfer order is captured using the Sales Order Entry program. It enables you to raise an order against a warehouse designated as a source warehouse for the supply of a particular Stock item.

The branch assigned to the warehouse is used to validate the product class assigned to the Stock item.

If the AR branch is not defined against both the source and target warehouses, then the error message: Branch to be used for SCT is invalid is displayed when you attempt to process a SCT using the Sales Order Entry program.

Goods in Transit Geographic area

Indicates the regional location of the warehouse.

The geographic area is used when processing a supply chain transfer order using the Sales Order Entry program.

GIT Reference number  
GIT Reference number

Indicates the first two characters that you want to appear in front of the goods in transit reference number generated for this warehouse.

You can only access this field if you selected the By warehouse - with prefix setup option (Inventory Setup).

GIT Next reference number Indicates the goods in transit reference number that will be used when next you process an inter-warehouse or supply chain transfer of goods. This number is incremented by one (1) each time you process a transfer of Stock into transit.

You can only access this field if you selected the By warehouse - with prefix setup option (Inventory Setup).

Purchase orders  
Purchase order prefix Indicates the single character that you want to appear in front of the next purchase order number generated for this warehouse.

You can only access this field if you selected By warehouse with prefix at the Purchase order numbering method setup option (Purchase Orders Setup).

Next purchase order number Indicate the next order number to use when capturing purchase orders for the warehouse.

You can only access this field if you selected By warehouse at the Purchase order numbering method setup option (Purchase Orders Setup).

Goods Received Note  
GRN Prefix Indicates the two characters that you want to appear in front of the Goods Received Note number that is next generated for this warehouse when processing a purchase order receipt.

You can only access this field if you selected By warehouse with prefix at the GRN Numbering setup option (Purchase Orders Setup).

Next GRN number Indicates the Goods Received Note number that will next be used when processing a purchase order receipt.

You can only access this field if you selected By warehouse at the GRN Numbering setup option (Purchase Orders Setup).

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 Added Warehouse

Controls access to the Add function in the Browse on Warehouses and Warehouse Maintenance programs.

Inv Changed Warehouse

Controls access to the maintenance of Warehouses in the Browse on Warehouses and Warehouse Maintenance programs.

Inv Deleted Warehouse

Controls access to the Delete function in the Browse on Warehouses and Warehouse Maintenance programs.

Intrastat considerations

  • Delivery Terms and Shipping Location's can only be captured if:

    • a valid Nationality code has been entered, and EC Vat is in force, or

    • the option to Capture delivery terms for non EC members is enabled in the Admin Tax Options program.

  • The Delivery Terms and Shipping Location defaults defined in AP Supplier Maintenance and AR Customer Maintenance take precedence over those defined in the Admin Tax Options program.

  • To reflect the Delivery Terms and Shipping Location on sales order and purchase order documents, ensure that these fields are enabled in the document format setup programs (only available with Word and SRS document printing).

  • Delivery terms are maintained using the Browse on Intrastat Delivery Terms program.

  • Shipping locations are maintained using the Intrastat Shipping Location Maintenance program.

  • Nature of transaction codes are maintained using the Browse on Intrastat Transaction Nature program.

Coding considerations

  • The warehouse is a 10-character alphanumeric field. Although you can use special characters such as /, *, + this is not recommended.

    The warehouse code ** is reserved for use by the system to represent a non-stocked warehouse.

    Once you have decided on the coding structure of your warehouses you need to consider the costing method you want to use. SYSPRO caters for different costing methods per warehouse (i.e. average, standard, last cost and FIFO).

Deletion considerations

  • You will be unable to delete a warehouse if any of the following conditions apply:

    • the quantity on order is not zero
    • the quantity on hand is not zero
    • the quantity allocated is not zero
    • the quantity on back order is not zero
    • the allocated WIP quantity is not zero
    • the quantity in transit due to be received into the warehouse is not zero
    • the quantity in inspection is not zero
    • the quantity dispatched but not invoiced is not zero

    • the quantity in the previous 2 periods is not zero

    • the month-to-date quantity received is not zero

    • the month-to-date quantity adjusted is not zero

    • the month-to-date quantity transferred is not zero

    • the warehouse exists in the stock take file
    • forecasts exists for the stock code/warehouse combination
    • master production records exist
    • build schedules exist in the warehouse

    • the stock item is serialized
    • journals have been assigned to the warehouse
  • If you delete a warehouse in which an item is stocked, then all movement records for the warehouse are removed.

Costing method considerations

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.