Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
| Metric | Description |
|---|---|
| Unit Cost | Displays the unit cost of the item. If the cost unit of measure is not EA, then it also displays the UOM (e.g. 2.00 USD per KG). The currency used for the cost differs based on the information shared by the screen where it is displayed: |
| • If the item, supplier, country and location is passed to the report, then Unit Cost for the given item /supplier /country of origin / location is used. | |
| • If the item, supplier, country is passed but no location is passed to the report, then Unit Cost for the given item /supplier/country of origin is used. • If the item and location is passed to the report, but not the supplier and country, then primary supplier/country is used with the location. In case of a physical WH associated primary Virtual WH is used to get the unit cost. • Otherwise, if only item is passed then cost of primary supplier/ country is used. | |
| Unit Retail | Displays the unit retail of the item. If the selling unit of measure for the item is not EA, then it also displays the UOM (e.g. 10.00 USD per LB). If the screen where it is displayed does not pass the currency code, then the following will be used to determine which currency to use: |
| • If the location is passed to the report, then selling unit retail and selling UOM for the item/location is shown in local currency. • If the location is not passed, then current retail at the base zone is used in primary currency. | |
| VPN | Displays the VPN for the item associated with the supplier site displayed. If supplier is not passed from the screen to the report then VPN of primary supplier is used. |
| Origin Country | Displays the ID of the country of origin associated with the item and the supplier site. |
| • If the country is passed to the report, then displays the country of sourcing passed from the RMS screen. | |
| • If not, then the primary supplier/country is used. | |
| Pack Size | Displays the pack size of the item/ supplier site/ country of sourcing. • If the supplier and country is passed to the report, then supplier pack size for the given item /supplier site /country of sourcing is shown. • If not, then the primary supplier/country is used. |
This report is displayed in the contextual pane of the following screens by default.
-
Item Search
-
Item
-
Item Children
-
Item Children by Diff
-
Simple Pack Setup
-
Simple Pack View
-
Related Items
-
Order Distribution
-
Order Details
3-3
-
Transfer Details
-
Mass Return Transfer
-
Stock Count Results
-
Contract
Margin Impact Report
Margin Impact report provides additional information about item margin in the Cost Change by Item and Cost Change by Location screens. The report shows the cost, retail and margin values for cost and retail change events as they relate to the effective date of the given cost change. The blue line plots the cost change events for a time period based on the Margin Impact Month Range report system option from the effective date of the cost change being viewed. The red line plots similar points, but for retail price changes. It is contextual to the item, supplier, origin country and effective date in Cost Change by Item screen and to the item, location and effective date in the Cost Change by Location screen.
The report is displayed only for cost changes that have an effective date on or later than the current business date.
3-4
Metric Description Date Displays the event date when a cost change is occurring or will occur in the future. Unit Cost Displays the cost retrieved from the future cost table for the date. If that is not available, then the current cost for the item/supplier/country or item/supplier/country/location is shown. Additional notes: • In the case of cost change by item, if a given item has differing costs by location, then the average of these costs will be displayed in the report for the dates plotted on the graph. • In the case of a parent item, the average unit cost across the children for the given date is displayed. • Cost will be displayed in the currency show in the cost change screen for the row selected. Unit Retail For each cost change event plotted, the unit retail of the item on the date will also be plotted. When this report is displayed in Cost Change by Item screen, the unit retail used for display will be based on a location in the primary zone. This location is used to retrieve both past and future retail values for consistency. When this report is displayed in Cost Change by Location screen, the unit retail displayed corresponds to the location selected in the table. Additional Notes: • Retail will be displayed in the currency show in the cost change screen for the row selected. • In the case of a parent item, the average unit retail across the children for the given date is displayed. Margin The margin of the item is computed based on the cost/price identified for date and the markup calculation type of the item’s department. For retail: Margin% = (Unit Retail - Unit Cost) / Unit Retail * 100 For cost: Margin% = (Unit Retail - Unit Cost) / Unit Cost * 100
This report is displayed by default in the contextual pane of the following Screens:
-
Cost Change by Item
-
Cost Change by Location
Note:
The Margin Impact Report is also displayed in the contextual pane on the Price Inquiry screen of the Pricing system.
Open to Buy Report
This report shows open to buy (OTB) impact for the subclasses of items on an order summarized by merchandise hierarchy. Report level filters allow the information to be viewed by order type and by different levels of the hierarchy - department, class, or
3-6
Order 123456789
Moreno Knit Sweater BLUE:LARGE Minneapolis
Table 3-1 Timeline Report
| Metric | Description |
|---|---|
| On Hand | Expected quantity at the location for the item on the calendar date. |
| On Order | Projected quantity ordered for the item at the location on the calendar date. |
| Forecast | Sales forecast for the item at the location on the calendar date. |
Item Ownership Report
For consignment or concession items, a transfer between locations may result in a change in ownership, if the item is owned at one location and not the other. This report shows the ownership details of the item on the transfer at both sending and receiving locations. The following will be shown for both the from and to locations for the item passed to the report:
-
Ownership type (Owned, Consignment, Concession)
-
Primary supplier site
-
Primary origin country
-
Cost basis
-
For owned items, this will be either the average cost or standard cost, depending on the Cost Method system option.
-
For consignment or concession items, this will be the purchase cost from the supplier. This could be either a set cost or a purchase rate based on the retail price. If a purchase rate is used, the rate will also be displayed.
-
The currency for the cost information will be based on the currency passed into the report.
Because it is not permitted to transfer between some locations for consignment or concession items due to the ownership change impacts, if the transfer falls in any one of the restricted transfer cases, then there will be an error icon ( ) displayed in the to location section.
3-16
Details
Order 123456789
x ts
Replenishment Approval Errors
Approval Threshold Exceeded
| Threshold | 100.000.00 USD |
|---|---|
| Total Order Cost | 127,348.56 USD |
| uantity Variance Limit Exc Threshold | eeded 20% |
| Item Location | Variance% |
| 123451500 123941234 | 2d |
| 123451811 12345551 | at |
| 1234571500 123541234 | 23 |
| 123451811 42345551 | a4 |
Quantity Variance Limit Exceeded
< Previous Next >
Vendor Minimum not Met Details Inadequate Supplier Availability 5 Items
‘er
a
Table 3-2 (Cont.) Error Report
| Metric | Description |
|---|---|
| Total Order Quantity | The total value of the order in the UOM specifed for vendor minimum. Detail Table: |
| Location | The location Identifer. |
| Name | The name of the location |
| Amount | The value of the item at the location in the UOM specifed for vendor minimum. |
| Approval Threshol | d Exceeded |
| Threshold | The maximum order cost allowed for automatic approval. |
| Total Order Cost | The total cost of the order. |
| Quantity Variance | Limit Exceeded |
| Threshold | The item/location quantity variance percentage threshold. |
| Item | The item number. |
| Location | The location where the item is going. |
| Quantity Variance | The calculated quantity variance for the item/location. |
| Inadequate Suppli | er Availability |
| Item | The item number. |
| Order Quantity | The ordered quantity for the item. |
| Available | The supplier’s declared availability for the item/date. |
Supplier Evaluation Report
In a setup where Merchandising is integrated with the Brand Compliance Cloud Service application, this report displays the data that is sent from the Supplier Evaluation (SE) module (within Brand Compliance) for the set of evaluation types configured in Merchandising. It is available in the contextual pane of the Supplier Site Maintenance UI and the Purchase Order Maintenance header UI and shows the evaluated data based on the Supplier Site that is present in the related screen. You are expected to review this data on a regular basis and take the data points into consideration for selecting an appropriate supplier while initiating any transaction. Custom validation rules can also be defined within Merchandising using the elements of this evaluated data.
3-19
4 Supplier Evaluation
Coca Cola - Charlotte (2300) Coca Cola (2400)
In this guide
- Guide: Merchandising Reports User Guide
- Previous: 2 Dashboards and Reports
- Next: 4 BI Publisher Reports