Generate a shortage report

Login

Shortage Report
Product code Product name Shortage Next delivery Expected quantity Enough to cover
 
This report does not take into account stock that is ONHOLD or on GIPOSR.

If there is a need to combine several shortages into one table, mark the checkbox below. You can also add an order name or location in case multiple orders have been sent in one email.

Update deliveries

Last update: ...loading...

How to generate a shortage report

To generate a shortage report, simply copy text from the shortage sheet as shown in the picture, past it into input field at the top left on this page and press Generate button.

Generating shoortage sheet

IMPORTANT!

In order for this to work correctly a text pasted from shortage sheet should look like this:

M9001
 Carrot Dice 10x10x20 Unriddled
 KG
 2700.000

The first M or P code must be at the top left corner. If there are multiple items, they must be seperated by an empty line like this:

M9001
 Carrot Dice 10x10x20 Unriddled
 KG
 2700.000
   
M9042
 Carrot Batton Riddles
 KG
 1500
   
M9340
 Potato Skin Off 10mm Dcd Raw
 KG
 300.000

How to update deliveries

First open 'Expected Receipt Inquiry" on Protean. Then Select 'GI STORES', after that go to 'Dates' section and select current date for 'Expected from' field.

Updating deliveries

Then go to 'Receipt' section and select 'Open' delivery status and press search.

Updating deliveries

Once the search result appear, they need to be copied. This can be done by pressing the right mouse button on results. Then from a menu select 'Copy Table to Clipboard'. Paste this table into the deliveries field on this page and press 'Update' button.

Updating deliveries