Difference between revisions of "Average Price Calculation"
| Line 1: | Line 1: | ||
| + | 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'''''. | 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|1200px]] | ||
Revision as of 11:49, 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:
