Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

2. Click the Reports dropdown and select Product Pricing Pivot.

Image Modified

The Pricing Pivot dialog appears. 

...

5. Click the Description field and drag it to the left side of the Name field.

The result looks like this.

6. Click and drag the following fields into the Grand Total section of the dialog.

Quantity Available

This field displays the count of each Product that is available in the Branch Office or Sub-Branch.

Quantity On Rent

This field displays the count of each Product that is on rent by Job Sites reporting to this Branch Office or Sub-Branch.

Calculated Avg Cost Each

This field displays the average cost of each Product based on Branch Office purchase.

The result looks like this.

7. Click the Total Calculated Avg. Cost field and drag it onto the Grand Total section.

The result shows the available and on-rent inventory counts per Product and the total calculated average cost of each Product for that Branch Office or Sub-Branch location. 

8. Click the Save Pivot Layout button ().


The Layout Name dialog appears.

9. Click in the Name text field and enter a name for the layout .

...