Difference between revisions of "Average Price Calculation"
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | [[Category:Inventory]] | ||
| + | [[Category:Prices]] | ||
| + | |||
The '''Average Price''' is a calculated measurement of the average of a range of prices paid for goods or services. | 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. | In Agility the average price is calculated by taking the sum of the values and dividing it by the number of prices being examined. | ||
| Line 19: | Line 22: | ||
'''NOTE:''' | '''NOTE:''' | ||
| + | |||
1. Goods Receipts and Return To Supplier generated for "''Direct Purchase''" also is taken into accout. | 1. Goods Receipts and Return To Supplier generated for "''Direct Purchase''" also is taken into accout. | ||
| Line 27: | Line 31: | ||
'''Example for empty parameter:''' | '''Example for empty parameter:''' | ||
| − | [[File:AveragePriceCalc.png| | + | [[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.''' | ||
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.
