Difference between revisions of "Average Price Calculation"

Latest revision as of 12:06, 14 October 2016

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:

Example for particular situation:

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