Inventory Turns Report

 

Function

Use this task to create a report showing the total usage, total cost, average on hand, average value, and turns of inventory for the last 12 periods. The report may be created for a single warehouse and list items within a specific warehouse or product category.

 

=> To access this task...

Select Inventory Turns Report from the Inventory Control Reports menu.

 

Inventory Turns Report menu

Item Turns Report

 

About the Fields

 

In the Period field...

  • Enter the period on which to base the report.

  • Press [Tab] to accept defaults as displayed.

In the Year field...

  • Enter the year of the period turns are annualized.

In the Sequence dropdown...

  • Select Ascending (A) from the drop down list to list the inventory items in ascending order.

  • Select Descending (D) from the drop down list to list the inventory items in descending order.

In the Above or Below dropdown...

  • Select Above (A) from the drop down list to list the items above a certain number of turns.

  • Select Below (B) from the drop down list to list the items below a certain number of turns.

In the Inventory Item Turns field...

Field becomes active with a selection of Above or Below.

  • Enter the number of turns for the inventory.

In the Beginning/Ending Warehouse field...

  • Enter the code of the first/last warehouse to include on the report.

  • Press [Tab] to select the first/last warehouse code record.

  • Click Click to select from a list of warehouse codes.

In the Beginning/Ending Product Type field...

  • Enter the type of the first/last product to include on the report.

  • Press [Tab] to select the first/last product type record.

  • Click Click to select from a list of product types.

In the Beginning/Ending Item ID field...

  • Enter the number of the first/last item to include on the report.

  • Press [Tab] to select the first/last item number record.

  • Click Click to select from a list of item numbers.

In the Item Type field...

  • Enter the item type to include on the report.

  • Press [Tab] to select all item types.

  • Click Click to select from a list of item types.

When done making selections...

  • Click Run Process button to create the report.

  • Click Clear Form button to clear the form and start over.

Sample Inventory Turns Report

 

See Output Options.



______________________________________________________________________________________

Copyright BASIS International Ltd. AddonSoftware® and Barista® Application Framework are registered trademarks.