Inventory Counts: Print Count Review Report

Prev Next

The Print Count Review Report is a printable PDF summary of an approved Inventory Count. This report allows the User to view the following summary information:

  • Location Name

  • Inventory Count by Inventory Item

  • Current Values by Inventory Item and Storage Location

  • Previous Values by Inventory Item and Storage Location

  • Adjustments by Inventory Item, Storage Location, Inventory Account, and Cost Account


Navigation

To navigate to the Print Count Review report: 

  1. Open the Inventory app.

  2. Expand Inventory.

  3. Click Inventory counts.

  4. From the grid, select an approved Inventory Count.

  5. On the open inventory count, click the menu icon  .

  6. From the dropdown, select Print.

  7. Then, select Print Count Review.


Print Count Review

The Count Review is separated into three sections:

  • Total by Inventory Account

  • Total by Cost Account

  • Details and Total by Storage Location

Totals by Inventory Account

Field

Description

1

Account Name

Inventory GL account that the 'Adjustment' will be applied to.

2

Current Value

Current cost total for all inventory items listed in the 'Details and Total by Storage Location' section that are associated with the inventory account.

3

Previous Value

Previous cost total for all inventory items associated with the inventory account from the last count with the same inventory template.

4

Adjustment

Difference between the 'Previous Value' and 'Current Value'.

Total by Cost Account

Field

Description

1

Account Name

Cost GL account that the 'Adjustment' will be applied to.

2

Current Value

Current cost total for all inventory items listed in the 'Details and Total by Storage Location' section that are associated with the cost account.

3

Previous Value

Previous cost total for all inventory items associated with the cost account from the last count with the same inventory template.

4

Adjustment

Difference between the 'Previous Value' and 'Current Value'.

Details and Total by Storage Location

 

Field

Description

1

Storage Location

Name of the storage location.

2

Inventory Item

Name of the inventory item.

3

Count Unit

Unit of measure.

4

Qty

Count of the inventory item in the storage location.

5

Each Amount

Item cost at time of inventory count.

6

Current Value

'Qty' x 'Each Amt'.

7

Previous Value

'Current Value' from last inventory count with the same inventory template.

8

Adjustment

Difference between the 'Previous Value' and 'Current Value'. This is the amount posted as inventory adjustments to the inventory account and the cost account associated with the inventory item.