Inventory Analysis Report

 

Function

Use this task to create a report showing the sales ranking of the inventory. A report may be created analyzing total sales or usage, and show items in all warehouses or for a single location.

 

=> To access this task...

Select Inventory Analysis Report from the Reports menu.

 

Inventory Item Analysis menu

Inventory Analysis Report

 

About the Fields

 

In the Sales or Usage field...

  • Select Sales (S) from the drop down list to analyze sales.

  • Select Usage (U) from the drop down list to analyze usage.

  • Click the "Close Window" button to return to the Reports menu.

In the Beginning/Ending Period/Year field...

  • Enter the first/last period/year <MM/YYYY> to include on the report.

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 product to include on the report.

  • Press [Tab] to select the first 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 find button to select from a list of item types.

When finished making selections...

  • Click Run Process button to create the Inventory Analysis Report.

  • Click New button to clear the form and re-enter options.

Inventory Analysis Report output

Sample Inventory Analysis Report

The report displays the item, product type, unit of measure, unit cost, total sales, cumulative percentage of sales, quantity on hand, total value, and cumulative percentage of value. When the cumulative percentage of sales reaches 100%, a dotted line on the report separates the items.

 

See Output Options.



______________________________________________________________________________________

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