Has anyone put together a simple report that lists all items that are overstocked - on hand is above the Restock Level? It would be great to have the ILC, Descpription, Qty Above Restock Level, and Qty On Hand. That way if a vendor wanted to know what you're overstocked in, you could quickly generate a report with the exact information. Right now I generate a report that shows On Hand, Restock Level and export to Excel, then do a column subtracting the On Hand from the Restock Level and that gives me my overage.
Report
Nov 16, 2006
2 Replies
Kris, just open the report u r currently using in notepad, locate "SelCriteria" line in the first section, just below the TableQueried line then make the SelCriteria as follows SelCriteria = "Item.RestockLevel < Item.Quantity"
Anything in SelCriteria should always be enclosed in Parentheses - this ensures that any additional filters added at runtime work as expected.
SelCriteria = "( Item.RestockLevel < Item.Quantity )"
Also, you probably want to memorize a copy of the report and modify that one, rather than adding this to the base report - the base reprot is probably used in other ways in addition to finding 'overstock' items.
Glenn Adams Tiber Creek C> Kris,
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required