emre
February 20, 2016, 5:12pm
2
There are two samples but they assumes product and inventory item names are equal. I think you can find more discussions regarding topic if you search. I didn’t implemented something like that before so I hope it helps.
I was in the need of something simple, that would allow me to add a field for the minimal point of stock of items and just a report to show me that… so here I go:
ADD a Product TAG
[image]
ADD some values to check that I made things good… LOL
[image]
ADD this script:
@@StockMinimo:
SELECT [InventoryItemName],
CONVERT(Integer,
CASE WHEN CharIndex(’{“TN”:“StockMinimo”,“TV”:"’,cast([CustomTags] as nvarchar(4000))) <> 0
THEN
CONVERT(Integer,substring(cast([CustomTags] as nvarchar(…
Dear everybody… I noticed that if in the last work period I did either not buy or have stock 0 and no consumption (We have some negatives like Ham or Cheese) of an invertory item, Samba automatically discarded it from the PeriodicConsumptionItems table. So my Custom Report Minimun Stock would not work properly, becuase those maybe you want to know wich items were left out or maybe you want to rebuy something that you stoped buying (seasonal prodcts). So I took a different approach, and instead…
2 Likes