Custom Report: Inventory Turns

Report Description:
Generates a report showing turns on inventory, based on a sales period. Average inventory balances are based on a daily average so it is extremely accurate, provided your inventory is accurate (restocks, adjustments, sales, etc.).

Note: This report may run a bit slow. Whenever possible, use the Account Filter to reduce the number of items reported on.

Columns Displayed:

• Item description
• Account
• Inventory Turns
• Quantity Sold
• Avg Inventory
• COGS Turns
• COGS
• Avg Inventory Value
• Retail Sold
• Retail Margin
• GMROI

Download the SQL code as a .txt file

Disclaimer: Custom SQL reports can be used or modified by RGP customers at their own discretion. However, due to the custom nature of each report and the varying size of a customer's database, some reports may be slow to run (or may not run at all).  All support and/or modifications requested of these public, custom reports will follow the standard Custom SQL Report fee structure.

Please also see: Adding Custom SQL Reports