Good afternoon,

We now have a way to check stock while XT/Green screen is unavailable. On the R drive in Information Technology > Public, there is now a shortcut called ‘whsbalances’. This shortcut will open a spreadsheet that lists warehouse, part number, description, location, stock on hand, stock reserved for an order, C price. This spreadsheet is updated every night at 7PM.

To check stock open the shortcut, then on your keyboard press ctrl + F. This will bring up the Find and Replace dialog. On the Find tab, next to Find what: type your part number, then click find next.

This will take you to the first occurrence of the item.  Take note of the warehouse, and if this is not the warehouse you want then click Find Next again. You can continue to click Find Next as many times as you like to cycle through warehouses and locations. Warehouses may be out of order, we will try to fix this in the future, but for now you can just hit Find Next to jump to the next one..

If you see a message box similar to the below, just click the Read Only button. This message just means that someone else is also looking at the spreadsheet.

You will see a yellow bar at the top of the spreadsheet. You can either click ‘Don’t show again’ or just ignore it.

If you have any questions please submit a ticket through the helpdesk.