Example: Calculating the Value of Goods Received
The following example illustrates the how the value of goods received is calculated differently at data record level and at aggregated level.
In the case of material A, there is exactly one purchase order in the month 01.97 and one purchase order in 02.97 involving the vendor Major Inc.. This results in exactly 2 data records in the information structure for which the value of goods received is calculated.
You perform a vendor analysis and perform a drill-down for material A according to period. The following list is displayed in the standard analysis:
Vendor analysis | |||||
Month |
PO quantity |
PO value |
PO price |
GR quantity |
GR value |
Total: |
30 PC |
$320.00 |
$10.66 |
10 PC |
$105.00 |
01.97 |
10 PC |
$100.00 |
$10.00 |
5 PC |
$50.00 |
02.97 |
20 PC |
$220.00 |
$11.00 |
5 PC |
$55.00 |
In the totals line, the values of goods received of the lines below are added together. The value of goods received is consequently not identical to the product of the purchase order price and goods receipt quantity of the totals line (this means it is $105.00 and not $106.60).
The value of goods received of the lower-level list is written to respective higher-level lists. This results in the following list at material level.
Vendor analysis | |||||
Material |
PO qty |
PO value |
PO price |
GR quantity |
GR value |
Total: |
130 PC |
$1,320.00 |
$10.15 |
100 PC |
$1,005.00 |
A |
30 PC |
$320,00 |
$10.66 |
10 PC |
$105.00 |
B |
100 PC |
$1,000.00 |
$10.00 |
90 PC |
$900.00 |
In this list the value of goods received in the totals line is also derived from the goods receipt values of the lines below and does not correspond to the product of the purchase order price and the goods receipt quantity of the totals line (this means it is $1,005.00 and not $1,015.00).