On-the-fly Stock Level Reporting for specific items from Ticket Screen

[QMcKay]

On-the-fly Stock Level reporting for specific Items straight from the Ticket Screen

You need this (which is mentioned in V5 Feature Compilation topic) …

@emre

{REPORT INVENTORY:<inventory item name>:<warehouse name>}

This Report tag added to read specific inventory item’s inventory level. Other than reporting we can use this tag to display inventory level on specific menu item buttons or test specific inventory levels on the fly.

IMPORTANT: Inventory level calculation needs processing of all tickets and all inventory transactions created in current work period (for each inventory item). So to avoid unnecessary network traffic try to use this feature for few menu items that really have mission critical meaning.

NOTE: Inventory Level calculation is approximate. It will round the value to the nearest whole value. So if you currently have 4.78 Cases of Beer, this Report Tag will simply show 5 instead.

---

This assumes that your Product Name is the same as your Inventory Name

###Action - Update Application Subtitle

###Automation Command for Stock Level button

Map the Automation Command to Order Line

###Rule - Handle Automation Command

Code for Title

This assumes that your Product Name is the same as your Inventory Name

<font Calibri><bold><block 0,0,0,0 orange center 600><size 30>STOCK LEVEL {REPORT INVENTORY:{NAME}:Local Warehouse}</size></block></bold> <br/> <block 0,0,0,0 orange center 600><size 30>{NAME}</size></block>

###Reset the Ticket Header when Ticket Closes …

[RickH]

add order to ticket

select order

press stock level button to display quantity and product name in ticket header

[RickH]

create auto command button

create update application subtitle action

create auto command executed rule

My title formatting

<font Calibri><bold><block 0,0,0,0 orange center 600><size 70>STOCK LEVEL {REPORT INVENTORY:{ITEM TAG:Inventory Name}:Local Warehouse}</size></block></bold> <br/> <block 0,0,0,0 orange center 600><size 35>{NAME}</size></block>

[RickH]

instead of using the ticket header you could simply use a display message action or ask question action to display the stock level information in a ‘pop up’ box that you can close

[spanky]

Great! very simple!
Now, how do I install qsl localdp on a pendrive?
I would like to have the db and all the data on a flash drive!

[emre]

@spanky you can find more information about that on SQL Server forums but I won’t recommend it as there is a high chance to have performance and stability issues.

[KuriGohan_And_Kameha]

<block 0,0,0,0 orange center 600><size 30>STOCK LEVEL {REPORT INVENTORY:{NAME}:Local Warehouse}
<block 0,0,0,0 orange center 600><size 30>{NAME}

My Show Message Command is not reading this correctly and is displaying exactly like this.
Any Ideas why?

[RickH]

Can you show screen shots of where youre using it, actions and rules

Also did you change you warehouse name from local warehouse?

[Emre_Yilmaz]

Not Work

code

<block 0,0,0,0 orange center 600><size 30>{REPORT INVENTORY:{NAME}:Local Warehouse}
<block 0,0,0,0 orange center 600><size 30>{NAME}

[haithem_pro]

How can i add Blue Header Total / nbr Item ?

Thanks

[emre]

@Emre_Yilmaz did you created Inventory Items and Recipes to keep track of the inventory?

[Emre_Yilmaz]

works… thank you
Can we make the same “product purchase price button”?
@emre

[EDER]

Hello RickH I tried to follow your tutorial about
On-the-fly Stock Level Reporting for specific items from Ticket Screen
but I cant see the quantity in the ticket header

here my action and rules

My warehouse name is Local Warehouse
hope you could help me have a nice day

[RickH]

Its all case sensitive too so is your item tag Inventory Name correct? And not inventory name or Inventory name etc

The expression itself looks ok, im just going to check my on my system now to double check

[RickH]

yep so it definitely works, this is my expression:

<color black><bold><size 60>{NAME}\rStock Level: {REPORT INVENTORY:{ITEM TAG:Inventory Name}:Local Warehouse}</size></bold></color>

and this is my result on the POS screen:

Things to check

1. Case sensitivity and spelling of your ITEM TAG and Local Warehouse
2. Have you setup the inventory item
3. Have you assigned the inventory tag in the product setup screen
4. Show screenshots of all of the above so we can see

[EDER]

these screenshots help?

[EDER]

I could not understand what do you mean by :
Have you assigned the inventory tag in the product setup screen

[JTRTech]

@EDER

Have you assigned the inventory tag in the product setup screen

Your refering to {ITEM TAG:Inventory Name} which is looking at the product custom tags, on the product tag editor tab you should have a Inventory Name which presumeably should be the name of the inventory item relating to that product in order for it to know what inventory item to look at.

[RickH]

You need to firstly have setup the Item Tag here:

Settings>Program Settings>General Settings

Enter Inventory Name in the Product Tag Captions Box as below (comma separate list with no spaces)

This then adds those product tags to the product setup screen as shown below:

Next to the Inventory Name field add the inventory name for your product, ive kept my inventory name the same as the product name

[RickH]

the only other things you need are

• Inventory Item
  

  

• Recipe