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

This page contains the following:

Creating a Product History Pivot Report

The Product History Pivot Report provides location-based, historical information of inventory daily balances at Job Sites. If updated regularly, this report provides accurate balances based upon the date the calculations were generated. Unlike other reports that display balances and information based upon current levels in Quantify, the Product History Pivot calculates daily location balances based on shipment Delivery and Return Actual dates. These report results are saved to the database and reflect a snapshot of inventory levels that can be used for future reporting.

Before using this report, you must configure each Job Site that needs to be included in this report, editing Job Site Product history settings. For more information, refer to Include Location in Product History Pivot.

To create a Product History Pivot:

1. Locate and click the appropriate Job Site

Note: You can view this report for individual Job Sites or for multiple Job Sites. To view a Product History Pivot for multiple Job sites, click a location such as a Branch Office.

2. Click the Product history pivot for selected location button ().

The Product History dialog appears.

Initially, this report does not contain any data. Monthly calculations need to be generated, then balances and other information may be queried based on the date range entered.

3. To calculate monthly data, click the Add button ().

The Calculate Product History for Month dialog appears.

Quantify saves Product History by the month/year of the information.
IMPORTANT: Calculations must be performed chronologically. Begin product history calculating at the first month shipment history begins. 

4. Click the calendar icon ().

A calendar appears.

5. Locate and click any day within the starting month for calculations.

6. Click in the Months to calculate field and enter the number of months to be calculated, including the starting month.

7. Click Calculate.

For example, if you enter the date June 15, 2018 with months to calculate of 3, Quantify calculates history for June, July and August.

Warning: Quantify will not include any shipment data created after product history is calculated in the report. Refer to Recalculating Product History article for more information.

The months calculated appear in the column on the left.

You are now ready to run the report for any dates that occur within the calculated months.

8. Click the Start calendar icon.

A calendar appears.

9. Locate and click the start date for the report.

10. Click the End calendar icon.

A calendar appears.

11. Locate and click the end date for the report.

12. Click Refresh.

Quantify generates the relevant information and displays it.

Including a Job Site in the Product History Pivot

The Product History Pivot report only displays inventory balance information for locations configured to be included in this report. This enables you to exclude any locations that may be for internal use or managed differently, or to isolate the report to just a few locations. 

Product History data is based on shipment Delivery and Return Actual dates.

To include a Job Site or Group in the Product History Pivot:

1. Locate the appropriate Job Site and click the Edit Selected Item button ().

2. Click the Include this location in product history pivot checkbox, to put a check in it.

3. Click the Rate profile to use dropdown and select the appropriate Rate Profile.

This can be the same Rate Profile the Job Site uses for billing or a different Rate Profile. Quantify uses the selected Rate Profile for reporting the Job Cost and Rent within the Product History Pivot report.

4. Click OK.

Recalculating a Product History

Calculated Product History represents a snapshot of product history for the month at the time the month was calculated. Quantify will not include any shipments created after a month is calculated (such as Returns), even if dated within the calculated month. Therefore, if you notice certain records that you want to include in a report are not being included, you may need to recalculate certain months.

Notes:

When recalculating Product History, all location product history calculations will be recalculated.

Remain aware that product history calculating is chronological.  In a case where product history has been calculated through August, 2018, and shipment Returns were entered that affect inventory balances in July, both July and August will need to be recalculated.

To recalculate Product History:

1. Click any location, then click Product History Pivot for Selected Location.

The Product History dialog appears.

2. Click the month to be recalculated.

3. Click the Delete button ().

4. Repeat for any additional months that may be affected or you wish to recalculate.

Now, you are ready to recalculate for the deleted months.

5. Click the Add button (image2018-4-30_21-14-37.png).

The Calculate Product History for Month dialog appears.

6. Click the calendar icon ().

A calendar appears.

7. Locate and click any day within the starting month for calculations.

8. Click in the Months to calculate field and enter the number of months to be calculated, including the starting month.

9. Click Calculate.

For example, if you enter the date July 10, 2018 with months to calculate of 2, Quantify calculates history for July and August. 

Quantify recreates a new snapshot of data as of the time of the new calculation. You can recalculate any month that does not appear in the month column. For more information about calculating months, refer to Creating a Product History Pivot Report.





  • No labels