Difference between revisions of "ItemWarehouse Index"

From SkySuite Wiki
Jump to navigation Jump to search
 
(11 intermediate revisions by 3 users not shown)
Line 1: Line 1:
'''Please use our [[Tips and Tricks]] page for understanding how the SkySuite portal works and how to navigate faster and easier.'''
+
{{Tips and tricks}}
  
 
__TOC__
 
__TOC__
  
<H1>Item Warehouse Creation</H1>
+
=Introduction=
  
Item warehouse records are what links a stock item to a warehouse, these can be created manually when creating or updating a stock item via the 'Warehouse' tab (details on this can be found [[StockItem_Index#Warehouse|'''here''']]), or instead via the stand alone 'Item Warehouse' page which creates links for '''<u>any</u>''' item/warehouse combinations, and can be achieved by selecting the new record button.
+
Item warehouse records link a stock item to a warehouse, these can be created manually when creating or updating a stock item via the 'stock items' menu under the "Reference Data" menu (details on this can be found [[StockItem_Index#Warehouse|'''here''']]). This is the most common way because each time a new item is created you will at the same time identify and create an ItemWarehouse record for each warehouse where that item will be stored.  
  
[[File:Item_Warehouse_1.PNG|750px]]
+
However if you create a new warehouse you don't want to have to go individually into each item and create the warehouse link therefore with the ItemWarehouse page you can create a link for all items needed in one go, you can also use this page to update the stocking parameters for all item warehouse records against a particular warehouse.
  
-
+
When you select the 'Item Warehouse' page you will first see a list of all the existing ItemWarehouse links.
  
[[File:Item_Warehouse_2.PNG|750px]]
+
[[File:ItemWarehouseIndex.PNG|1000px]]
  
You can then select the main data in regards to bulk updating any missing records;
+
=Creating New Links=
  
• '''Direct Delivery''' – Stock is delivered to this warehouse directly from the supplier.
+
To create new links press the plus icon  and the window below will be displayed;
  
• '''Parent Warehouse Code''' - If stock is not delivered directly to this warehouse and instead it is first delivered to a consolidation point then you will need to select the parent warehouse.
 
  
• '''Security Stock (Days)''' – Minimum number of days of stock required at the warehouse, also know as buffer stock.
 
  
• '''Is the Item Contracted''' – Is the item associated with a contract.
+
[[File:Item_Warehouse_2.PNG|750px]]
  
 +
If you are a user with access to only one Airline then the Airline field will be automatically populated. Then select the warehouse to which you want to add update ItemWarehouse links.
  
Once done you have the option to 'Create and Overwrite' or 'Create New Only'
+
You can then select/input the data for any Item/Warehouse link that will be created;
 +
 
 +
* '''Direct Delivery''' – Select "Yes" if tock is delivered to this warehouse directly from the supplier, if this warehouse is resupplied by another warehouse then select "NO".
 +
* '''Parent Warehouse Code''' - If stock is not delivered directly to this warehouse and instead it is first delivered to a consolidation point or a a regional warehouse and then transferred to this warehouse then you will need to select the parent warehouse.
 +
* '''Security Stock (Days)''' – Minimum number of days of stock required at the warehouse, also known as buffer stock.
 +
* '''Is the Item Contracted''' – Say yes if the item is associated with a purchase contract?
  
• '''Create and Overwrite''' – Will overwrite any existing records as well as creating new records.
 
  
'''Create New Only''' – Will leave existing records intact and only create new records for any item/warehouse combination.  
+
Once done you have the option to 'Create and Overwrite' or 'Create New Only'
 +
* '''Create and Overwrite''' – Will overwrite any existing records as well as creating new records.
 +
* '''Create New Only''' – Will leave existing records intact and only create new records for any item/warehouse combination that are missing.  
  
  
Line 35: Line 40:
 
[[File:Stock_Items_7.PNG|500px]]
 
[[File:Stock_Items_7.PNG|500px]]
  
 +
* '''Warehouse''' – The relevant warehouse where the stock will be stored, you will need to make multiple records if the stock is stored at other warehouses.
 +
* '''Direct Delivery''' – Select "Yes" if stock is delivered to this warehouse directly from the supplier, select "No" if it is resupplied from another warehouse.
 +
* '''Parent Warehouse Code''' - If stock is not delivered directly to this warehouse and instead it is first delivered to a consolidation point or master/regional warehouse then you will need to select the parent warehouse.
 +
* '''Security Stock (Days)''' – Minimum number of days of stock required at the warehouse, also known as buffer, safety or security stock.
 +
* '''Is the Item Contracted''' – Is the item associated with a purchase contract In this case things like the MOQ and EOQ (see below) will be taken from the contract. If there is no contract the quantities defined at the ItemWarehouse level will be used.
 +
* '''Minimum Order Quantity (MOQ)''' – Minimum amount of stock that can be ordered from the supplier.
 +
* '''Economic Order Quantity (EOQ)''' – The ideal order quantity that should be purchased to minimize inventory, ordering  and transportation costs. If transportation cost is not relevant because it is included in the purchase price this will most often be the same as the MOQ, if transport is not included and is a significant part of the overall cost then this may be equal to a truck load or a container load. This then becomes the round up/down integer when stock is ordered.
 +
* '''Targeted Days Between Orders''' – If a supplier delivers regularly then this field can be populated with the days between when stock is delivered.
 +
* '''No Days Total Lead Time''' – The time taken from the supplier to the warehouse. This is "Total" lead time so supplier manufacturing/processing plus transport time. If an item is contracted then the lead times as per the contract will take precedence and the time entered here is used as a default when the particular supplier to be used is not known or the contract is expired or missing.
  
'''Warehouse''' – The relevant warehouse stock can be delivered too, you will need to make multiple records if the stock is delivered to other warehouses.
+
The next group of fields also exist at Item level and the values entered here will take precedence over the item level but the meaning is the same so please see the Stock Item WIKI for more details [[StockItem_Index#Warehouse|'''Click here for details on Stock Items''']])
  
'''Direct Delivery''' – Stock is delivered to this warehouse directly from the supplier.
+
* '''Item Status''' – Separate status to the stock item status but cannot be updated until setup is complete.
 +
* '''Buyer''' – Same as the stock item setup.
 +
* '''Material Controller''' – Same as the stock item setup.  
  
> '''Parent Warehouse Code''' - If stock is not delivered directly to this warehouse and instead it is first delivered to a consolidation point then you will need to select the parent warehouse.
 
  
'''Security Stock (Days)''' – Minimum number of days of stock required at the warehouse, also know as buffer stock.
+
* '''Warehouse Demand Forecast Source''' – When planning this item for this warehouse what is the forecasting source to be used? There are three options which will greatly affect planning if the wrong one is selected so please ensure you select the one that best fits your need.
 
+
• '''Is the Item Contracted''' – Is the item associated with a contract.
 
 
 
• '''Minimum Order Quantity''' – Minimum amount of stock that can be ordered from the warehouse.
 
  
• '''Economic Order Quantity''' – The ideal order quantity that should be purchased to minimize inventory costs such as holding costs, shortage costs, and order costs. This then become the round up/down integer when stock is ordered.
+
* Auto-Calculated demand forecast based on historical transactions - As per the name this option uses historic transactions to calculate future demand.
 
+
* LogistiX Flight Schedule Network Analysis - This uses the state of the art forecast algorithm developed by SkyLogistiX that takes your airlines flight schedule, passenger numbers, bill of material (galley planning) data and other data to predict future demand.
• '''Targeted Days Between Orders''' – If a supplier delivers regularly then this field can be populated with the days between when stock is delivered.
+
* Third Party forecast loaded and editable by the user via the portal - A manually crafted forecast can be created in CSV or received from a 3rd party system and uploaded into SkyLog .
 
 
• '''No Days Total Lead Time''' – The time taken from the supplier to the warehouse.
 
 
 
• '''Item Status''' – Separate status to the stock item status but cannot be updated until setup is complete.
 
 
 
• '''Buyer''' – Same as the stock item setup.
 
 
 
• '''Material Controller''' – Same as the stock item setup.
 
 
 
• '''Warehouse Demand Forecast Source''' – This is how the item for this warehouse would be calculated for the forecast, there is three options which will greatly affect planning if the wrong one is selected so please ensure you select the one that your airline currently uses.
 
 
 
Auto-Calculated demand forecast based on historical transactions - As per the name this option uses historic transactions to calculate how much stock is required for the future.
 
 
LogistiX Flight Schedule Network Analysis - The state of the art forecast algorithm developed by SkyLogistiX which takes your airlines flight schedule, passenger numbers, bill of material data and other complex data to accurately predict how much stock is required to be ordered.
 
 
Third Party forecast loaded and editable by user via the portal - A manually crafted forecast can be created in CSV and uploaded into SkyLog for the item to forward plan.
 

Latest revision as of 13:11, 30 November 2021

Please use our Tips and Tricks page for understanding how the SkySuite portal works and how to navigate faster and easier.


Introduction

Item warehouse records link a stock item to a warehouse, these can be created manually when creating or updating a stock item via the 'stock items' menu under the "Reference Data" menu (details on this can be found here). This is the most common way because each time a new item is created you will at the same time identify and create an ItemWarehouse record for each warehouse where that item will be stored.

However if you create a new warehouse you don't want to have to go individually into each item and create the warehouse link therefore with the ItemWarehouse page you can create a link for all items needed in one go, you can also use this page to update the stocking parameters for all item warehouse records against a particular warehouse.

When you select the 'Item Warehouse' page you will first see a list of all the existing ItemWarehouse links.

ItemWarehouseIndex.PNG

Creating New Links

To create new links press the plus icon and the window below will be displayed;


Item Warehouse 2.PNG

If you are a user with access to only one Airline then the Airline field will be automatically populated. Then select the warehouse to which you want to add update ItemWarehouse links.

You can then select/input the data for any Item/Warehouse link that will be created;

  • Direct Delivery – Select "Yes" if tock is delivered to this warehouse directly from the supplier, if this warehouse is resupplied by another warehouse then select "NO".
  • Parent Warehouse Code - If stock is not delivered directly to this warehouse and instead it is first delivered to a consolidation point or a a regional warehouse and then transferred to this warehouse then you will need to select the parent warehouse.
  • Security Stock (Days) – Minimum number of days of stock required at the warehouse, also known as buffer stock.
  • Is the Item Contracted – Say yes if the item is associated with a purchase contract?


Once done you have the option to 'Create and Overwrite' or 'Create New Only'

  • Create and Overwrite – Will overwrite any existing records as well as creating new records.
  • Create New Only – Will leave existing records intact and only create new records for any item/warehouse combination that are missing.


When you have selected the appropriate option you can then manually update records via the main 'Item Warehouse' page, by clicking the edit pencil button, the following popup will be displayed;

Stock Items 7.PNG

  • Warehouse – The relevant warehouse where the stock will be stored, you will need to make multiple records if the stock is stored at other warehouses.
  • Direct Delivery – Select "Yes" if stock is delivered to this warehouse directly from the supplier, select "No" if it is resupplied from another warehouse.
  • Parent Warehouse Code - If stock is not delivered directly to this warehouse and instead it is first delivered to a consolidation point or master/regional warehouse then you will need to select the parent warehouse.
  • Security Stock (Days) – Minimum number of days of stock required at the warehouse, also known as buffer, safety or security stock.
  • Is the Item Contracted – Is the item associated with a purchase contract In this case things like the MOQ and EOQ (see below) will be taken from the contract. If there is no contract the quantities defined at the ItemWarehouse level will be used.
  • Minimum Order Quantity (MOQ) – Minimum amount of stock that can be ordered from the supplier.
  • Economic Order Quantity (EOQ) – The ideal order quantity that should be purchased to minimize inventory, ordering and transportation costs. If transportation cost is not relevant because it is included in the purchase price this will most often be the same as the MOQ, if transport is not included and is a significant part of the overall cost then this may be equal to a truck load or a container load. This then becomes the round up/down integer when stock is ordered.
  • Targeted Days Between Orders – If a supplier delivers regularly then this field can be populated with the days between when stock is delivered.
  • No Days Total Lead Time – The time taken from the supplier to the warehouse. This is "Total" lead time so supplier manufacturing/processing plus transport time. If an item is contracted then the lead times as per the contract will take precedence and the time entered here is used as a default when the particular supplier to be used is not known or the contract is expired or missing.

The next group of fields also exist at Item level and the values entered here will take precedence over the item level but the meaning is the same so please see the Stock Item WIKI for more details Click here for details on Stock Items)

  • Item Status – Separate status to the stock item status but cannot be updated until setup is complete.
  • Buyer – Same as the stock item setup.
  • Material Controller – Same as the stock item setup.


  • Warehouse Demand Forecast Source – When planning this item for this warehouse what is the forecasting source to be used? There are three options which will greatly affect planning if the wrong one is selected so please ensure you select the one that best fits your need.


  • Auto-Calculated demand forecast based on historical transactions - As per the name this option uses historic transactions to calculate future demand.
  • LogistiX Flight Schedule Network Analysis - This uses the state of the art forecast algorithm developed by SkyLogistiX that takes your airlines flight schedule, passenger numbers, bill of material (galley planning) data and other data to predict future demand.
  • Third Party forecast loaded and editable by the user via the portal - A manually crafted forecast can be created in CSV or received from a 3rd party system and uploaded into SkyLog .