Average Price
The average price for an on-hand balance is the price calculated each time a stock transaction is entered. It is saved for each item/facility and is used mainly for calculating inventory value and capital tied up.
Averages prices are calculated as follows:
Average Price = [TP * TQ + AP * (AQ+IQ+RQ-TQ)] / (AQ+IQ+RQ)
|
TP |
Stock transaction price |
|
TQ |
Stock transaction quantity |
|
AP |
Valid average price. If AP = 0, TP is used. |
|
AQ |
Approved on-hand balance |
|
IQ |
On-hand balance under inspection |
|
RQ |
On-hand balance rejected |