View source for Average Price Calculation

[[Category:Inventory]]
[[Category:Prices]]

The '''Average Price''' is a calculated measurement of the average of a range of prices paid for goods or services.
In Agility the average price is calculated by taking the sum of the values and dividing it by the number of prices being examined. 

The '''Average Price''' calculation depending on the system parameter '''''AverageCalculationMode'''''.
Format of that parameter is "''[AlsoReturns] <unsgined integer> m|months|y|years|w|weeks|d|days''" . 

For example "''AlsoReturns 5 m''" means calculate AveragePrice basing on Goods Receipts and Return To Supplier in last 5 monts.

If it is empty, system calculates '''Average Price''' after saving all Goods Receipts and Return To Supplier and take for account all these historical movements.
To calculation Agility uses:

For Goods Receipts:
'''AveragePrice = (ActualStoredGoodValue + ReceivedGoodValue)/(ActualStoreQuantity + ReceivedGoodQuantity)'''

For Return To Supplier:
'''AveragePrice = (ActualStoredGoodValue - ReturnedGoodValue)/(ActualStoreQuantity + ReturnedGoodQuantity)'''



'''NOTE:''' 

1. Goods Receipts and Return To Supplier generated for "''Direct Purchase''" also is taken into accout.

2. Depending on system parameter ''AverageCalculationMode'' the value of:

       ''ActualStoredGoodValue'' is sum of Values from Goods Receipts and Return To Supplier(if ''AlsoReturn'' is set) in set period.
       ''ActualStoreQuantity''  is sum of Quantities from Goods Receipts and Return To Supplier(if ''AlsoReturn'' is set) in set period.

'''Example for empty parameter:'''
[[File:AveragePriceCalc.png|1000px]]

'''Example for particular situation:'''
[[File:AveragePriceCalcDiv.png|1000px]]

'''NOTE:'''
'''For showed situation system leave price unchanged and after next Goods Receipt set price using price from this new document.'''