R365 App: Variance Review Screen

Prev Next

The Inventory Count Variance Review tab can be viewed in the R365 App. On the Inventory Count screen, tap the Review Variances button to open the Variance Review - Theoretical screen.

Read more about the variance review tab for web.

The View Variance Tab permission is required to access this screen. When users do not have the View Variance Tab permission, the Review Variances button will be disabled.

Organizations with variance reviews disabled will not see the Review Variances button and will not have access to this screen.


Variance Review - Theoretical Screen

Button/Field

Description

1

Cancel

Exits the Variance Review -Theoretical screen and returns to the open inventory count.

2

Search

Searches the item list for entered keywords.

3

Filter

Opens the filter options.

4

Quick Filters

Filters the item list to show either all items or all items with variance violations.

5

Dollar Tab

Shows the item list data in terms of dollar values.

6

Quantity Tab

Shows the item list data in terms of item quantity.

7

Item Entry

Individual item entry that shows the actual and theoretical variance of an item. Tapping an item will open the item details.

8

Complete

Marks the inventory count as complete.

If count percentage is not at 100%, this button will remain disabled.

  • To return to the count, tap Cancel. Determine the storage location(s) that are not counted to 100%. Adjust the counts as needed. Then, return to the Variance Review - Theoretical screen.

Item Entry

Each item that was counted in the inventory count appears as an item entry on the variance review list.

 

Button/Field

Description

1

Item Name

Name of the item counted.

2

UofM

Unit of measure used to count the selected item.

3

Violation Notice

Indicates that the item has a variance threshold violation.

4

Variance Percentage/

Efficiency %

The efficiency percent. This is the calculation of theoretical cost divided by the actual cost of the item.

The efficiency percent is always calculated using cost in dollars and displays the same value whether reviewing the items in Quantity or Dollars.

5

Actual Bar

Shows the actual usage of the item in dollars or in quantity.

  • This bar will be orange when the item variance is above the acceptable variance threshold.

  • This bar will be green when the item variance is within the acceptable variance threshold.

6

Theoretical Bar

Shows the theoretical usage of the item in dollars or in quantity.

Item Details Screen

When an item is tapped, the item details will appear. This screen shows additional details about the counted item and is where users can edit the count of the item.


Button/Field

Description

1

Dollar / Quantity Tabs

Switches the view of the item data from dollar view or quantity view.

  • Dollar shows the item data in dollar values based on the cost and quantity.

  • Quantity shows the item data based on the item quantity.

2

Actual / Theoretical Bars

The actual and theoretical usage of the item in either dollars or quantity.

  • The actual bar will be orange when the item variance is above the acceptable variance threshold.

  • This actual bar will be green when the item variance is within the acceptable variance threshold.

3

Item Name

Name of the item counted.

4

Date Last Counted

The last time this item was counted.

5

UofM

Unit of measure used to count the selected item.

6

Efficiency %

The efficiency percent. This is the calculation of theoretical cost divided by the actual cost of the item.

The efficiency percent is always calculated using cost in dollars and displays the same value whether reviewing the items in Quantity or Dollars.

7

Variance

The variance between the theoretical and actual usage. This is the actual usage minus the theoretical usage.

8

Previous Qty

Quantity of the item counted on the last count.

9

Current Qty

Quantity of the item entered on the current inventory count.

Values can be edited by storage location and unit of measure by tapping the edit button  beside the value.

10

Purchases

The cost or quantity of the item purchased between the last count and the current count.

11

Transfers

The cost or quantity of the item transferred in or out of the store between the last count and the current count.

12

Waste

The cost or quantity of the item logged as waste between the last count and the current count.