Adaco: Fast Slow Moving Items Report – Fourth & HotSchedules Customer Success Portal

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

Report Criteria

Enter report criteria to get desired results, as per Fig.2

Fig.2 - Report Criteria for the Fast/Slow Moving Items report

Fields	Description
Outlet	Select the outlet from the drop-down. Only outlets designated as perpetual under Property > Setup > Location > Outlets will be available. Blank [Default]
Top Items	Fast Moving: Select to generate a report for the products that have the most movement. [Default] Slow Moving: Select to generate a report for the products that have the least movement. Zero Movement: Select to generate a report for products with no movement. Blank Box- Enter the number of products to report on the report. Quantity 20 [Default]
Period Selection: 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. All Categories: Select to choose all categories. [Default] Selected Categories: Select to choose only specific categories.

Report Results

When the Fast/Slow Moving Items report is generated, the results should look similar to Fig.3

Fig.3 - Fast/Slow Moving Items results

Fields	Description
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	Units: The current month's usage product quantity. Currency: The current month's usage value in currency.
Current Inventory	Units: The sum of each period inventory if more than period was selected. Currency: The current period inventory monetary value.
Avg. days held	This column indicates the average number of days it will take to deplete stock based on the current rate of use. Calculation: AVG. DAYS HELD = CURRENT USAGE/NUMBER OF DAYS IN A PERIOD = AVG.DAILY USAGE then, CURRENT INVENTORY/AVG.DAILY USAGE The calculation is more complex when run for multiple periods, most namely the 'Current Inventory' which adds the Inventory quantities from all included periods. 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.

Related articles