Receiving Value Report
The Receiving Value Report shows item quantity, valuation, and detailed receipt information for your receiving inspection location.
Note: If you choose a currency other than your functional currency, all value fields are multiplied by the exchange rate.
The Average Unit Price is calculated by dividing the total receiving value by the total receiving quantity on hand, using the primary unit of measure.
The Total Purchase Value is the quantity times the average unit price.
The Current Value is the sum of the quantity times the supplier cost for the cost type. This is the total cost of the item less any material overheads for the item. If material overheads are included, then the Purchase Price Difference column would be incorrect.
The Purchase Price Difference is the difference between the Total Purchase Value and the Current Value columns. You see this column only for inventory and shop floor (outside processing) destinations. This report also displays Outside Processing items with no associated resource value. You can use this information to manually accrue potential purchase price variances, before you deliver into inventory or work in process.
Report Submission
In the Cost and Period Close Reports (for Inventory) or Submit Requests (for Cost Management) window, select Receiving Value Report in the Name field.
Report Parameters
Organization Name
Enter the organization to restrict the report to a specific organization.
Cost Type
Optionally, enter a cost type to change the reported values for the Current Value column. If you do not enter a cost type, the report uses the Frozen or Average cost type, depending on your costing method. If you specify a cost type, the report values the items at this cost type, for the respective supplier cost. This is the total cost of the item less any material overheads for the item. If the item is not in the specified cost type, the report values the item at the default cost type. For example, if you choose Quarter1 as the cost type and Quarter1 has Frozen as the default cost type, the report values the item at the Quarter1 cost. If Quarter1 is not available, it values the items at the Frozen cost type.
Report Option
Choose one of the following options:
| Detail
| Include detail receipt information, such as receipt date, receipt number, shipment number, current location, deliver-to location, packing slip, document type, document number, and item revision.
|
| Summary
| Include only summary information for the item, such as item description, quantity, average unit price, and total purchase value.
|
Sort
Choose one of the following options:
| Category
| Sort the report by category set and category.
|
| Destination
| Sort the report by purchase order destination and then by item.
|
| Destination and Category
| Sort the report by destination, by category set/category and then by item.
|
| Item
| Sort the report by item.
|
| Location
| Sort the report by current receiving location and then by item.
|
| Supplier
| Sort the report by supplier and then by item.
|
Item From / Item To
Enter a beginning and an ending item to restrict the report to a range of items.
Category Set
Enter a category set to restrict the report to that category set.
Category From / Category To
Enter a beginning and an ending category to restrict the report to a range of categories.
Currency
Enter a currency. When you enter a currency other than your functional currency, item costs are converted to the selected currency using the End of period rate you choose in the Exchange Rate field.
Exchange Rate
Choose an exchange rate. If you choose a currency other than your functional currency, the default is the most recent End of period rate. However, you can choose any prior End of period rate. See: Entering Period Rates.
Quantities by Revision
Enter Yes or No to indicate whether you want to display item quantities by the revision of the item on the report. You can see revision quantities only when you choose Detail for the Report Option.
Display Zero Costs Only
Enter Yes or No to indicate whether you want to display items with zero costs only on the report. You use this option to identify any items that have a zero standard cost, before you deliver into inventory.
Document Type
Enter Purchase Order or Requisition to limit the reported information. If you do not enter a document type, the report displays both document types.
See Also
Submitting a Request
