Report

- K
- Kris
  
  Contact options for registered users
posted
17 years ago

Thu, Nov 16, 2006 10:08 PM

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.

- N
- Nashat
  
  Contact options for registered users
Vote on answer
posted
17 years ago

Mon, Nov 20, 2006 11:03 AM

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"

- G
- Glenn Adams [MVP - Retail Mgmt]
  
  Contact options for registered users
Vote on answer
posted
17 years ago

Mon, Nov 20, 2006 11:43 PM

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,