|
Posted by Shaun on August 26, 2008, 4:57 pm
Please log in for more thread options
Hi we use a sub description field to mark items as "DEAD STOCK" where:
1. item has SOH >0
2. item was received more than 90 days previous (last received < today - 90)
We have written a few sql queries to perform this at group and store level
and then to mark down all items with "DEAD STOCK" in sub description.
"Prima" wrote:
> Thanks! Very helpful.
>
> "convoluted" wrote:
>
> > You mention another serious weakness in the item wizard - task whatever to
> > adjust item prices (sale prices) - the filter does not let you filter for
> > either date last sold or current on hand quantity. As a workaround, add the
> > following column to the item quantity list report
> >
> > Begin Column
> > FieldName = "Item.LastSold"
> > DrillDownFieldName = ""
> > DrillDownReportName = ""
> > Title = "Date Last Sold"
> > VBDataType = vbDate
> > Formula = ""
> > ColHidden = False
> > ColNotDisplayable = False
> > FilterDisabled = False
> > ColWidth = 930
> > GroupMethod = groupmethodNone
> > ColFormat = ""
> > End Column
> >
> > When you run the report filter for your date range (it's easier if you use
> > the NEGATE option) AND On Hand > 0.
> >
> > If it's not a lot of items on the report, print it and enter these manually
> > into your inventory wizard. If it's a lot of items, experiment with the
> > report so that you can export the contents to excel, clean it up, then
import
> > the excel after you save it as a csv file into the inventory wizard. The
csv
> > file must have the same columns and data types as those the inventory wizard
> > uses.
> >
> > It's a little convoluted...
> >
> > Repost if you need additional help doing this - hope this helps....
> >
> > "Prima" wrote:
> >
> > > Is there a way to get a report that shows inventory that was received
before
> > > a certain date that still has >0 in stock? The item movement report does
not
> > > have an "on hand" filter option. If we set quantity sold to zero, we find
> > > some, but not those items in which we sold several, but have 1 or 2 that
have
> > > been sitting around for years.
> > >
> > > It would be great if a wizard could then put these items on sale...
> > >
> > >
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap