I want to qty variance in the report, i try so many coding but still does work..please help:confused:

Hi Dhaniah,

Please post your script.

Regards,
Bhushan.

Hi,

Herewith the script, i want QTY VARIANCE between safety stock & Inventory stock.

select
whwmd215.item, | Item
tcibd001.dsca, | Description
whwmd215.cwar, | Warehouse
tcibd001.citg, | Item Group
tcibd200.sfst, | Safety Stock
whwmd215.stoc, | Inventory On Hand
tcibd001.ctyp, | Product Type
tcibd001.csel, | Selection Code
tcibd200.maxs | Maximum Inventory
from
tcibd001, | General Item Data
tcibd200, | Item Ordering Data
whwmd215 | Item Inventory by Warehouse
where
whwmd215.cwar >= whwmd215.cwar.f and
whwmd215.cwar <= whwmd215.cwar.t and
tcibd001.citg >= tcibd001.citg.f and
tcibd001.citg <= tcibd001.citg.t and
tcibd200.item = tcibd001.item and
whwmd215.item = tcibd001.item and
whwmd215.stoc > tcibd200.maxs
order by
whwmd215.item,
tcibd001.citg





Hi Dhaniah,

Please post your script.

Regards,
Bhushan.

select
whwmd215.item, | Item
tcibd001.dsca, | Description
whwmd215.cwar, | Warehouse
tcibd001.citg, | Item Group
tcibd200.sfst, | Safety Stock
whwmd215.qhnd, | Inventory on Hand
tcibd001.ctyp, | Product Type
tcibd001.csel, | Selection Code
tcibd200.maxs | Maximum Inventory
from
tcibd001, | Items - General
tcibd200, | Items - Ordering
whwmd215 | Item Inventory by Warehouse
where whwmd215.item refers to tcibd001
and whwmd215.cwar >= whwmd215.cwar.f and
whwmd215.cwar <= whwmd215.cwar.t and
tcibd001.citg >= tcibd001.citg.f and
tcibd001.citg <= tcibd001.citg.t and
tcibd200.maxs < whwmd215.qhnd and
tcibd200.item = whwmd215.item

dhaniah,

Make the changes to your Report Layout.

Select your Query and then Specific ... Query Report Data.

Then Edit All Layouts and add a new field with a Print Expression of:
tcibd200.sfst - whwmd215.stoc

Mike