Warehouses

This screen allows you to maintain Warehouses that are used in Ostendo.   These Warehouses are referenced extensively throughout Ostendo.  Each Warehouse record contains details of where it is located and if it should be taken into account during the Stock Replenishment routine

 

List Tab

 

Display fields

 

Warehouse Code: The Warehouse Name as entered into the ‘Detail’ tab.  

 

Description: Description of the Warehouse taken from the Warehouse record.  

 

Site Name: Place where the Warehouse is located taken from the Warehouse record.  

 

Status: The default status is 'Active'.  If you wish to make this status 'Inactive' then select it from the drop-down list.  Once selected the Warehouse will NOT be visible in Warehouse drop-downs

 

Data Display Options

 

Field Position - On the List screen you can move the field position by dragging the column heading left or right to the position where you want it to appear.

 

Filtering and Sorting - If you ‘check’ the checkbox then the displayed data is available for filtering and sorting:

To sort the data in a selected column simply click on the column heading.  Clicking against will sort in descending order.

Click on the black ‘down arrow’ to the right of your selected column heading and you can either select a specific entry to display all records containing that entry, or you can select (Custom…) to enter detailed selection criteria.

 

Searching - If you enter some text into the ‘Search’ field and click on the ‘binoculars’ Icon then all records will be interrogated and those records that contain the entered text will be displayed.  To revert back to displaying all records click on the ‘Eraser’ Icon

 

Buttons

 

Close: This will close the Warehouse screen.  If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

 

Add: This will bring up the ‘Detail’ tab for entry of a new Warehouse.

 

Save: Not applicable to the List panel

 

Cancel: Not applicable to the List panel

 

Delete: This removes the current Warehouse from this table

 

Related: This will bring up a list of functions that are related to the Warehouse.  You may open and maintain information in those screens whilst still remaining in the Warehouse screen.

 

Reports: This will bring up a list of Reports that are related to the Warehouse.  You can immediately run the report whilst still remaining in the Warehouse screen.

 

 

Detail Tab

 

Entry and Display fields

 

Warehouse Code: Entry is only allowed during an Add transaction.   Enter the name of the new Warehouse.   Duplicate Warehouse Codes are not allowed.

 

Status: The default status is 'Active'.  If you wish to make this status 'Inactive' then select it from the drop-down list.  Once selected the Warehouse will NOT be visible in Warehouse drop-downs

 

Description: Enter a brief description of the Warehouse.  This description will accompany the Warehouse wherever it is used in Ostendo.  No validation checks are carried out on this entry.

 

Company:  From the drop-down list select the site where this Warehouse is located.  The options are:

Site - You own (company owned) Site

Customer - A Customer’s Site

Supplier - A Supplier’s Site

 

Exclude Inventory from Replenishment: If this is ‘checked’ then the Warehouse’s Inventory will be excluded from the Inventory Replenishment routine

 

Name: From the drop-down list select the address this Warehouse is located.  The displayed drop-down list is directly related to the ‘Site’ selection made above.  I.e:

If ‘Site’ selected then drop-down will show only Company sites

If ‘Customer’ selected then drop-down will show Customers only

If ‘Supplier’ selected then drop-down will show Suppliers only

 

Cost Centres: If you wish to have Financial Controls at a Warehouse Level then, from the drop-down list, select the Cost Centres to cover the following transactions.  If nothing is selected then the system defaults identified in Cost Centre Mapping will be used

 

Inventory: All Stock in this Warehouse will be posted to this Cost Centre. 

Adjustments: Stock Adjustments against this Warehouse are ‘received from’ or ‘issued to’ this Cost Centre.

Negative Stock: Stock adjustment variances can occur whenever you receive Stock but the current stock levels are negative.  In this case the Average Cost for the Item is not amended but the difference between the Average Cost and the Cost of this receipt is ‘posted’ to this Cost Centre

Re-Valuation: Whenever the Stock is re-valued  (Standard Cost or Average Cost) the difference between the old value and the new value is ‘posted’ to this Cost Centre

Stock Count: Stock variances (plus or minus) as a result of a Stock Count are ‘posted’ to this Cost Centre. 

Receipt Cost Var: Used if the Inventory Costing method is ‘Standard Costing’ and this stores the cost difference between the Purchase Receipt actual Cost and the Standard Cost of the Item.

Assembly Cost Var: Used if the Inventory Costing method is ‘Standard Costing’ and this stores the cost difference between the Assembly Order actual Cost and the Standard Cost of the Item.

 

Notes: You can enter unlimited amount of Notes that are related to this Warehouse.  These notes will be available wherever the Warehouse record is accessed.  Whenever you click on this field an icon will appear in the top-right.  By clicking on this Icon you can bring up the Frequently Used Text table.   Select the text to be copied and either press the OK Button in that screen or double-click the selected record.

 

Categories Tab

 

This panel allows you to define Financial Controls at an Item Category level within each Warehouse.  From the drop-down list, select the Cost Centres to cover the following transactions.  If nothing is selected then the Warehouse defaults identified in the Warehouse Cost Centre Mapping will be used

 

Category: From the drop-down list select the Category to which the following Cost centres will be applied.

 

Cost Centres: For each Warehouse/Category combination you can select the following Cost centres

Inventory: All Stock in this Category/Warehouse will be posted to this Cost Centre. 

Adjustments: Stock Adjustments against this Category/Warehouse are ‘received from’ or ‘issued to’ this Cost Centre.

Negative Stock: Stock adjustment variances can occur whenever you receive Stock but the current stock levels are negative.  In this case the Average Cost for the Item is not amended but the difference between the Average Cost and the Cost of this receipt is ‘posted’ to this Cost Centre

Re-Valuation: Whenever the Stock is re-valued  (Standard Cost or Average Cost) the difference between the old value and the new value is ‘posted’ to this Cost Centre

Stock Count: Stock variances (plus or minus) as a result of a Stock Count are ‘posted’ to this Cost Centre. 

Receipt Cost Var: Used if the Inventory Costing method is ‘Standard Costing’ and this stores the cost difference between the Purchase Receipt actual Cost and the Standard Cost of the Item.

Assembly Cost Var: Used if the Inventory Costing method is ‘Standard Costing’ and this stores the cost difference between the Assembly Order actual Cost and the Standard Cost of the Item.

 

Buttons

 

Close: This will close the Warehouse screen.  If you have any unsaved data then you will be asked if you wish to save it before the screen is closed.

 

Add: Not applicable to the Detail panel

 

Save: This will save the current data without exiting the screen

 

Cancel: Any changes made since the screen was opened or the last time the ‘Save’ Button was pressed will be lost.

 

Delete: Not applicable to the Detail panel

 

Related: This will bring up a list of functions that are related to the Warehouse.  You may open and maintain information in those screens whilst still remaining in the Warehouse screen.

 

Reports: This will bring up a list of Reports that are related to the Warehouse.  You can immediately run the report whilst still remaining in the Warehouse screen.