Print Purchase Price History By Item – Filter Condition
|
|
|
|
|
This page allows you to generate a report that is used to analyze the procurement cost of items. The procurement cost analysis can be done for single or multiple items. If the item code and variant code are known then, you can enter the same at the top of the page and click “Print Report” to print the report. Else the relevant values can be provided in the in the filter criteria and a corresponding report can be generated. The item details such as item, variant code, and description are also displayed in the header. The average unit cost and the average delivered cost is calculated and displayed in the first level of the report.
In the second level detail of the report all the transactions that have contributed to the values of Average Unit Cost and Average Delivered Cost are displayed. The corresponding transaction details like the document number, supplier code, supplier name, buyer code, the number of units ordered, the unit of measurement of the item in the ordering document, the standard purchase unit of measurement of the item, the unit rate of the item and total cost of the item are displayed.
Select the “Print Purchase Price History By Item– Filter Condition” link under the “Purchase Reports” business component.
The “Print Purchase Price History By Item - Filter Condition” page appears.
Enter the following in the header:
|
Item |
The unique code identifying the item (Alphanumeric, 30) |
|
Variant |
The variant of the item (Alphanumeric, 32) |
Enter the following details in the “Filter Criteria” group box
|
From Date |
The starting date in the range of dates from which the analysis of the cost of item is done (Date Format). Leave this field blank, to analyze the cost of the item irrespective of its ordering date |
|
To Date |
The ending date in the range of dates till which the analysis of the cost of item is done (Date Format) Leave this field blank, to analyze the cost of the item irrespective of its ordering date |
|
Supplier |
The supplier of items (Alphanumeric, 16) You can enter the supplier code in full or specify it partially using the “*” character. Cost analysis would be done for items procured from the specified supplier. |
|
Buyer |
Use the drop-down list box to analyze costs by the respective buyers of items. Leave this field blank, to analyze costs irrespective of the buyers of the item. |
For Printing the Report
Click the “Print Result” pushbutton to print the report
