Item Sales v All Inventory: Track Inventory against Sales History

Track Inventory levels against past Sales History 

This reports on All Items in Inventory v Items that have sold over the past 12 months.

To help with reorders it compares the Qty sold Monthly to the:

• On hand
• - Committed (SO)
• = Available Now (On Hand Less committed on Sales Orders) New
• + On Order (PO)
• = Available Qty 
  
• Monthly Sales Qty for up to 12 months
• Average Monthly Sales Qty (over Last 12 months)
• Number of weeks since item last sold
• Number of weeks since item was last purchased

This Article covers the following:

1. Run any Favourite Report based on the report Item Sales v All Inventory. 
2. Manage Inventory better by checking Purchase History
3. To See a longer or shorter period of Sales History (up to 12 Months or last 6 weekly) Show more Columns
4. Track Current Inventory levels against past Seasonal Demand
5. Check Inventory against Minimum Stock Levels
6. Identify Inventory that is Not Selling
7. Identify Inventory that has Not been Purchased recently

1. Run any Favourite Report based on the report Item Sales v All Inventory. 

   The standard Favourite Inventory Reorder - Sales History by Item by Supplier  report shows Qty Sold for:
   - This Month
   - Each of the Last 3 months - Mth-1, Mth-2, Mth-3
   - Total for the Last 12 Months - 12 Mth Total
   - Average for the Last 12 Months (12 Mth Total/12) - 12 Mth Avg
   - No. weeks since item was Last Sold - Last Sold Wks
   - No. weeks since item was Last Purchased - Last Purchased Wks
   
   
   
   

2. Manage Inventory better by checking Purchase History

   Click the blue arrow next to an item to launch an Open Purchase Orders report to check when items are due in.
   
   
   
   
   Change the Purchase Status from Order to see full Purchase History to assist with reorders.
   
   

3. To See a longer or shorter period of Sales History (up to 12 Months or last 6 weekly) Show more Columns

   - Click on the icon +/- Columns
   - Select Columns to Show  - e.g. extend to go back for 6 months
   - Use Green Arrows to reorder the Columns
   
   
   
   

   The report now shows 6 months past Sales History

   
   
   

4. Track Current Inventory levels against past Seasonal Demand

   If your business is Seasonal then recent sales history is not so useful.
   What you may want to see is what sold last year, for the upcoming season.
   To achieve this you can set the Sales to pick up Mth-12, Mth-11, Mth-10 and Mth-9. This will show the Sales for this time last year and the next 3 months, last year.
   
   
   
   

5. Check Inventory against Minimum Stock Levels
   

   For core products that you never want to run out of set Minimum Stock levels: 
   - Click on the icon +/- Columns
   - Select Columns to Show  - e.g. Min Level, ReOrder Qty, SOH Below minimum
   - Use Green Arrows to reorder the Columns
   - Filter to only see Items where SOH is Below Minimum is negative
   - Save the report to auto email as an Alert (Enterprise version)
   
   

6. Identify Inventory that is Not Selling

   Filter on the Last Sold Weeks column to focus on inventory that has not sold for X weeks.
   Note: Recommend you also remove the Item is Active Filter to see all Inventory on hand.
   
   
   
   
   

7. Identify Inventory that has Not been Purchased recently

   Filter on the Last Purchased Weeks column to focus on inventory that has not been purchased for over X weeks.
   
   
   

8. Save your report to re-use

BI4Cloud.com