Transaction Analysis Reports

Question 1

This report shows all of the part numbers that were returned in a specified date range. Criteria includes current quantity on hand, cost, extended inventory value, etc., Also helps identify obsolete parts that have recently been sold

Answer 1

Returns Analysis

Question 2

Displays part inventory sorted by month of last sale. Also includes parts that have never sold and parts that haven’t sold in more than a year.

Answer 2

Inventory Aging Analysis

Question 3

Displays all parts within a given date range that have been logged as a lost sale

Answer 3

Lost Sales Analysis

Question 4

Shows any adjustments to the on hand quantity of parts. Does not create journal entries

Answer 4

Inventory Adjustments Analysis

Question 5

Tracks changes to inventory and which parts have phased in from Inactive to Active. Also shows parts that will be phased out due to lack of demand.

Answer 5

Phase-In/Phase-Out Analysis

Question 6

Shows quantity and value of all parts currently in inventory. Can be used to compare against value of G/L

Answer 6

Inventory Analysis

Question 7

Displays sales taking place from what is currently stocked from the shelf and which parts have been sold through emergency purchases and special orders

Answer 7

Sales Source Analysis

Question 8

Shows which transactions are still pending and tracks the parts transactions that are getting completed

Answer 8

Unrealized Sales Analysis

Question 9

Displays all regular and special stock orders within a given date range. Also displays factory returns

Answer 9

Stock Order Analysis

Question 10

Analyzes parts sales. Also gives information about returns. Includes information from both Counter and RO tickets

Answer 10

Sales Analysis