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...
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 additi> Is there a way to get a report that shows inventory that was received before
Hi we use a sub description field to mark items as "DEAD STOCK" where:
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" > Thanks! Very helpful.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required