Overview
The Inventory Report by Property Report shows cumulative inventory of a selected products across selected Properties. The report can show quantity details only or quantity and cost values.
This article describes the process of accessing and running the report.
Inventory Report by Property Report
This report can only be run at CP level, not within Properties.
- To run this report, log in to Purchasing & Inventory at CP level and go to the Report Center
- Expand Report Module: Inventory
- To open the ‘Report Criteria’ screen, double-click Inventory Report by Property
- Alternately, select the required report and then select Run Report (see Fig.1)
Fig.1 - Running the Inventory Report by Property Report
Report Criteria
- Enter the relevant Report Criteria to receive the desired results, as per Fig.2
- To run the report, select Generate
Fig.2 - Report Criteria
|
Fields |
Description |
|
Properties |
Select All: chooses all the Properties available |
|
Categories |
Allows a selection of one or more categories to generate the report with products assigned to those categories. |
|
Products |
Select the required Product(s). |
| Display Options | Quantity Only: will show quantities of products but not costs Include Cost Details: will show costs and quantities of products |
Report Results
When the Inventory Report by Property Report is generated, the result should look similar to Fig.3.
Fig.3 – Inventory Report by Property Report Results
|
Fields |
Description |
|
Category |
The name of the category. |
|
SubCategory |
The name of the sub category. |
|
Product |
The Product number. |
|
Description |
Description of the Product. |
|
Property Name |
Quantities/costs (depending on Display Options chosen) of Product at that particular Property. |
|
Grand Total |
Total quantities/costs (depending on Display Options chosen) of Product(s) at Properties. |
Comments
2 comments
The quantities and cost value for this report - is this based on current inventory period? if not what is the quantity based on. is there a report which shows all inventory units for all hotels?
Hey Elaine Reilly
Great question! - the quantities & costs that you see in this report are indeed based on the current Inventory on hand, however, the cost is a calculation of the current inventory on hand quantity at the Property multiped by the Inventory Cost to give you the Cost value that you see in this report,
In regards to your second point around a report that shows all inventory units for all hotels from CP, unfortunately there is not such a report. If this is something that you would like at CP, i would recommend posting this as an idea on our Ideas Portal to be reviewed by our Product Team,
Hope this helps,
Best,
Pritesh
Fourth
Please sign in to leave a comment.