StationCount Index

Station Inventory Reporting

The airline you represent will require that you enter your locations inventory counts on agreed timelines, this page will walk you through how it is possible to do this via SkyLog.

Station Inventory Reporting Location

Pressing the “Inventory Counts” option from “Daily Activities” -> “Inventory Counts” will display the following page;

In the above screen I am logged in as someone at the Los Angeles caterer of British Airways so I see all the reports for Los Angeles (LAX) but each station will only see their own reports.

The counts are listed with the most recent at the top, in the example above the top line show a count at “Pending” status which means it has not taken place yet but is expected to happen on the 7th of November (The expected date). Below this line you see all the previous counts will have all been completed and approved or cancelled in the past.

You can view the detail of a report by pressing the Show Icon on the line you want to view.

If the report is pending you can also edit it and enter/change count figures by pressing the Edit Icon on the line you want to edit.

General Tips and Guidelines about Stock Counting

This section is not related to the system but just provides some general tips and guidelines concerning inventory counting in general.

• It is best to count at the end of the operational day, i.e. after all departing flights have left and all arriving flights have been unloaded. 

• If required to count floating stock, you need to count everything in the kitchen that also includes stock waiting to be loaded to outbound aircraft and stock unloaded from arriving aircraft that has not yet been processed. 

• The unit of measure in which quantities should be entered is the stocking unit and this is shown on the count screens (see later). You should be aware that for some items the stocking unit may be a box and others it may be a piece. You will always enter both back up and floating quantity in the same unit (the stocking unit). This means that you are likely to have to convert one or the other. For example, if the stocking unit is a box then counting the backup stock which is usually in boxes will be straight forward but the floating stock will typically be in pieces (opened) so whatever you count will need to be converted to boxes. On the other hand, if the stocking unit is a piece then it will work the other way around and floating stock will be straight forward but when you count boxes in the backup store you will need to convert them to pieces before entering them in the system. 

• Pay special attention to any receipts received on the day of the count. If you have such a situation, you should receive the shipment with that day’s date and include it in your count figures. If you do not include the figures in your count, for example if the receipt was late just before the count was finished and there is not time for you to include it, then you must receive it into the system the next day with the next day’s date. If you don’t do this the forecasting system will think that the count included that shipment and miscalculate the suggested order quantities.

Editing an Inventory Count

As described in the previous section if you have a count at “Pending status” you can enter the count figures by pressing the Edit Icon.

The following screen will be displayed;

In this screen you are required to enter the “Actual Count Date” in which the inventory count took place, this is a vital piece of information which will need to be accurate for the planning and forecasting side of Skylog.

If your station is setup for uploading the count details via an excel update you will be sent an email with it attached when the count is created but if you misplace it you can download a fresh copy from the same screen as the “Download Blank Count Sheet” button will be presented;

Once you click “Save” you will be presented the page to enter the amount of stock you have counted against each item setup for your station;

In the detail section against each line you may see two quantity fields, “Backup” quantity is the amount you have in your store room/ area and “Float” quantity is any inventory you have outside the backup store e.g. on the kitchen floor. You will need to enter a figure against each line so if there is no inventory you should enter a zero. If you only see a backup quantity it means that you are not expected to count the floating stock but if you do see a floating quantity field, then you must count the floating stock. Floating stock means all stock on your facility at the time of the count which includes stock waiting to be loaded to outgoing aircraft and stock that has been received from arriving aircraft but not yet processed. It is most efficient and will help to get accurate and consistent measures of the floating stock if you perform the count at the close of the operational day after all departing aircraft for that day have been loaded and all arriving aircraft have been unloaded.

The detail section will always display in pages of 10 at a time in the example below we can see there are 338 items in the count and this is shown over 34 pages.

You can move backwards and forwards through the pages with the arrow keys. You can also display everything on one screen by changing the drop down for “10” to “All” or select a certain number between 10 and 100 as well.

At the bottom of the page you will see the following buttons;

Upload Completed Count Sheet – If your station is setup to accept population of the count via an excel upload this will be presented to you, please follow the steps when clicked on uploading the completed document.

• View Uploaded File Errors – Again only visible for stations that upload counts via excel, this will detail any errors once you have attempted an upload.

• Save and Continue - Allows you to save what you have entered but will leave you in the screen. 

• Save and Exit – Saves anything you have entered but will exit the page and return you to the main “Inventory Count” page.

• Submit - Will save your work and mark the count as complete and change the status to “Pending Review” after this you will no longer be able to change any of the figures. The next step is that Skylogistix will review what you have entered and may come back to you to do a recount – see later section in this manual for details of recounts.

Adding an Item to a Count

The list of items shown on the count detail page should include all the items you are expected to have at your location. If, however you have an item that is not showing you can add it with the add item button at the top of the page.

This will display the following;

Press the “Select Stock Item” button to search and choose the item you want to add. (Use the three dots under “Code” or “Description” to filter for a specific item) then click “Select”.

Once the item is added you can then fill in the “Float” and “Backup” quantities.