Inventory Turnover ReportThe Inventory Turnover report compares inventory versus usage to gauge how quickly inventory moves.
- To run the Inventory Turnover report go to Report Center>Accounting Reports>Inventory Turnover report
- To open the report criteria screen, double-click Inventory Turnover report or select the report and click Run Report, as per Fig.1
Fig.1 - Running the Inventory Turnover report
- Enter report criteria to get desired results, as per Fig.2 below
Fig.2 - Report Criteria for the Inventory Turnover report
|Outlet||Allows Selection the Outlet[s] that are flagged as inventory under Property > Setup > Location > Outlet Blank [Default].|
|Turns||Select > greater then or < less than and enter a number of turns. > and blank number [Default]|
|From - To Dates||Select the period in which to generate the report.|
|Start - End Date||Auto populate upon selection of the period enter in the From and To field as defined under Property > Setup > Accounting > Fiscal Calendar Blank [Default].|
All Categories- auto generate s for the outlet categories. All Categories [Default]
Selected Categories- open a selection box to allow choosing selected categories.
When the Inventory Turnover report is generated, the result should look similar to Fig.3.
Fig.3 - Inventory Turnover report results
|Product||The Adaco product number.|
|Product Description||The description of the product as entered under Property > Products.|
|Purchase Information||Displays the purchase information from the Property > Products > Purchase Info field. [If Applicable].|
|Inventory Size||The products inventory size as defined under Property > Products.|
|Retail Attributes||Displays additional characteristics defined for retail attributes for retail product under Property > Products > Retail button [If applicable].|
|Pur. Par Stock||Displays the outlets purchase par quantity as defined under Inventory > Maintain Guides > Purchase Par Stock field. [If applicable].|
|Pur. Reorder||Displays the outlets purchase reorder quantity as defined under Inventory > Maintain Guides > Purchase Par Stock field. [If applicable].|
|Current month Usage||The current months usage displayed in product quantity.
|Current Inventory||Displays the ending inventory for the period the report is ran for. If you run the report for just one period.
|Turns||Displays the number of turns per the period)s) entered.
|Outlet||The outlet number and name.|
|Category||The category number and name.|
|Sub Category||The sub category number and name.|
|Outlet||Displays the outlet Current Month Usage and Current Inventory Currency totals.|
Please sign in to leave a comment.