1. Navigation in K3S
2. Filter Options
3. Reading the report
The Obsolete Product Report is very easy to generate and review. Start by selecting the Obsolete Product Report using the printer icon on the left side of your screen.
2. Filter Options
You will then see several filter options within the Request Criteria. To keep it simple, you can enter you Buyer Group. This will run the report on all of your suppliers. If you would like to drill down to a specific supplier, location, supplier group, or product group, you can enter this as well.
In the middle, you will see the ability to select a number of periods you would like to analyze. By default, it will look at the last year. Depending on how you are set up (13X4 weekly, 12 months, or 52 weeks), you can edit the periods using the fields here.
It is recommended that you NOT include the products with 0 quantity. It is likely that these will be discontinued or products you have already eliminated from your warehouse.
After you are satisfied with the request criteria, run the report. K3S will then email you two different files for the report. These include a CSV (spreadsheet file) and a PDF. The CSV will be great for certain reports if you want to drill down and edit the spreadsheet in excel. The PDF will be best for viewing the straightforward results. You can choose what will work best for you.
*Note: If you do not receive the reports in your email inbox, please email [email protected] we will get you set up.
3. Reading the Report
Now let’s quickly look at the PDF version of the report. You may also want to review the CSV report. It will allow you to generate a total inventory cost of your obsolete products.
The image above shows us that there are three main sections. These include:
1. The blue section represents the product’s basic information
2. The red section shows the user and system status of the product.
3. There are 3 columns in the green section.
On Hand: This tells you how many units are on hand.
Product Cost Each: This column represents the cost of 1 unit of that product.
Product Extension: This tells you how much inventory you have on hand in dollars. This is found by multiplying the units by the cost of each.
You now know how to:
1. Navigate to the report
2. Use the filter options