You use this program to capture and maintain details of warehouses required within the system.
Once the warehouses are defined, you use the Inventory Warehouses for Stock Codes program (accessed from the Browse on Stock Codes program) to link stock items to these warehouses.
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 Show warehouses function at the Multiple bins option in the Inventory Setup program.
|
||||||||||||
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 Show warehouses function in the Costing method section of the Inventory Setup program.
|
||||||||||||
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).
|
||||||||||||
Language | You can indicate the language code to use if you enabled the option:
Multi-language for document printing in the System Setup
program.
|
||||||||||||
Fixed bins in use | You can only access this field from the Show
warehouses function at the Multiple
bins option in the the Inventory Setup
program.
|
||||||||||||
Intrastat details | |||||||||||||
Nationality |
Indicate the nationality code for the country in which the warehouse is located. This field is mandatory when the EC Vat system required option is enabled (Company Tax Options Setup). 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.
|
||||||||||||
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. This applies only when using Costing by warehouse (Inventory Setup) and either the Bill of Materials or the Requirements Planning module is installed. This warehouse is used by the consolidation routine in the Requirements Calculation program when the Consolidate selected warehouses option is enabled (Requirements Planning Setup). 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 the Alternate routings option is enabled (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 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. 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).
|
||||||||||||
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 (Work in Progress Setup). If you leave this field blank then the account configured at company level is used (General Ledger Integration).
|
||||||||||||
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 Codes). 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 |
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. The Use short names when resolving addresses option (System-wide Personalization) determines which name to use by default. SYSPRO reads the name returned from the map provider in XML. If the short name returned in the XML is the same as the long name, then no short names are available from the map provider. |
||||||||||||
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 applies only when the Load planning required option is enabled (Sales Orders 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 applies only when the Load planning required option is enabled (Sales Orders 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 (SO 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 SCT numbering is enabled (Set Key Information). 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. |
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 |
Indicate the first two characters that you want to appear in front of the goods in transit reference number generated for this warehouse. This applies only when GIT numbering is By warehouse prefix (Set Key Information). |
||||
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. This applies only when GIT numbering is By warehouse (Set Key Information). |
||||
Purchase orders | |||||
Purchase order prefix | Indicate the single character to add in front of the
next purchase order number generated for this
warehouse. This applies only when Purchase order numbering is set to Prefixed warehouse (Set Key Information). |
||||
Next purchase order number | Indicate the next order number to use when capturing
purchase orders for the warehouse when your Purchase order
numbering is set to Warehouse
(Set Key Information).
|
||||
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.
This applies only when GRN numbering is set to Prefixed warehouse (Set Key Information). |
||||
Next GRN number | Indicates the Goods Received Note number that will next
be used when processing a purchase order receipt. This applies only when GRN numbering is set to Warehouse(Set Key Information). |
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 Capture non EC members delivery terms is enabled in the Intrastat Setup program.
The Delivery Terms and Shipping Location defaults defined in Suppliers and Customers take precedence over those defined in the Intrastat Setup 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 Intrastat Delivery Terms program.
Shipping locations are maintained using the Shipping Locations program.
Nature of transaction codes are maintained using the Intrastat Transaction Nature program.
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).
You cannot delete a warehouse if any of the following conditions apply:
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
build schedules exist in the warehouse
If you delete a warehouse in which an item is stocked, then all movement records for the warehouse are removed.
Stock on hand cannot be allowed to go negative in any warehouse. However, items defined as floorstock (Stock Codes) can have a negative balance (WIP Issue Floor Stock Allocations).
Inventory costs cannot be held in a unit of measure other than stocked.
The Last cost is updated by the following programs:
Transfer BOM Costs to Warehouse Costs
Inventory Movements
All cost transactions regardless of costing method and part type.
Purchase Order Receipts, Purchase Order Inspection, Job Receipts and Shipment Receipt
Inventory Price-Cost Percentage Change
All cost change transactions.
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 Added Warehouse |
Controls access to the Add function in the Browse on Warehouses and Warehouses programs. |
Inv Changed Warehouse |
Controls access to the maintenance of Warehouses in the Browse on Warehouses and Warehouses programs. |
Inv Deleted Warehouse |
Controls access to the Delete function in the Browse on Warehouses and Warehouses programs. |