Page tree
Skip to end of metadata
Go to start of metadata

You can use the Product Pricing pivot to display current inventory available and on-rent with pricing (cost, last cost, average cost) for the purposes of an Asset report.

Note: The example below uses average cost data.

To use the Product Pricing pivot to display current inventory with pricing:

1. Locate and click the appropriate Branch Office.

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

The Pricing Pivot dialog appears. 

3. Click the Part Number field and drag it to the left side of the Name field.

4. Click the Number field and drag it up into the top area.

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 .

 

10. Click OK.





  • No labels