Fast/Slow Moving Items Report
This article explains how to run the Fast/Slow Moving Items report.
- To run the Fast/Moving Moving Items report go to Report Center > Accounting Reports > Fast/Slow Moving Items Report
- To open the report criteria screen, double-click Fast/Slow Moving Items or select the report and click Run Report, as per Fig.1
Fig.1 - Running the Fast/Slow Moving Items report
Enter report criteria to get desired results, as per Fig.2
Fig.2 - Report Criteria for the Fast/Slow Moving Items report
|Outlet||Select the outlet from the drop-down. Only outlets designated as perpetual under Property > Setup > Location > Outlets will be available. Blank [Default]|
From - To
|Select the From and To periods as defined in Property > Setup > Accounting > Fiscal Calendar. Blank [default]
Start Date and End Date: Populates based on the periods chosen.
|Category||Choose the category to run the report.
When the Fast/Slow Moving Items report is generated, the results should look similar to Fig.3
Fig.3 - Fast/Slow Moving Items results
|Fiscal Period From||Displays the start date of the 'From' period entered.|
|Fiscal Period To||Displays the end date of the 'To' period entered.|
|Top Items||Displays the quantity entered in the box.|
|Product||The Adaco product number.|
|Product Description||The description of the product entered under Property > Products.|
|Purchase Information||Displays the purchase Information from the Property > Products > Purchase Info field.|
|Inventory Size||The products inventory size as defined Property > Products > Inventory Unit.|
|Retail Attributes||Displays additional characteristics defined for retail Retail Attributes for retail product under Property > Products > Retail button [If applicable].|
|Pur.Par Stock||Displays the purchase requisition par stock level for the outlet entered under Property > Inventory > Maintain Guides. [If Applicable].|
|Pur.Reorder||Displays the purchase requisition re order stock level for the outlet entered under Property > Inventory > Maintain Guides. [If Applicable].|
|Current Month Usage||
|Avg. days held||This column indicates the average number of days it will take to deplete stock based on the current rate of use.
Running a Product Bin Card is recommended if wishing to validate the calculation.
Avg .Days Held = If there was no movement (transfers or requisitions) in the selected period then: Difference between last purchase date and current date
If purchase date is NULL then 0
If there was movement in selected periods:
(Sum of inventory quantities for selected periods * Sum of days in selected periods) / Sum of all transfers and requisitions for selected periods
|Outlet||The outlet number and name as defined under Property > Setup > Location > Outlet.|
|Category Total||The report will total the Current Month Usage-Currency and Current Inventory-Currency for each category.|
|Outlet Total||The sum of all categories Current Month Usage-Currency and Current Inventory Currency for the outlet.|
Please sign in to leave a comment.