Project:
| View Revisions: Issue #13440 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0013440: Accruals and Deferrals enhancements - amount divided by period - New Calculation Type = Monthly | ||
| Revision | 2010-08-31 12:08 by psanjuan | ||
| Description | Calculation of acc&def-plan should be done in two ways which can be chosen by the user (only once can be setup in the system as the one to use by default, see proposed solution below). - Daily = daily basis calculation which is the way it works now. For an explanation on daily calculation see issue 13984 - Monthly = monthly bases => which is the new one explained in this Feature Request. |
||
| Revision | 2010-08-31 11:17 by psanjuan | ||
| Description | Calculation of acc&def-plan should be done in two ways which can be chosen by the user (only once in the system). - daily bases which is the way it works now - monthly bases => neq one. Example: 01.5.09 - 31.7.10 amount 14.000,- => 14 month => amount per month = 1000,- 05/09 1000,- 05/09 1000,- . . . 06/10 1000,- 07/10 1000,- If the day in From-date is not the first of a month, the amount for the first and the last month is distributed proportionally for the count of days in the first month, according to below formulas: - Avg. monthly amount = Line Net Amount / Nº of months - First month amount = Number of days in "date from" x Avg. monthly amount/30 - Last month amount = Avg. monthly amount - Fist month amount. Besides: For the Monthly Calculation: 30 days to be consider for each month For the monthly calculation it is only possible to enter full month, therefore below restriction should happen: The day of the data to must be the day of the data from -1! |
||
| Revision | 2010-06-14 16:27 by psanjuan | ||
| Description | Calculation of acc&def-plan should be done in two ways which can be chosen by the user (only once in the system). - daily bases which is the way it works now - monthly bases => Example: 01.5.09 - 31.7.10 amount 14.000,- => 14 month => amount per month = 1000,- 05/09 1000,- 06/09 1000,- . . . 06/10 1000,- 07/10 1000,- If the day in From-date is not the first of a month, the amount for the first and the last month is distributed proportionally for the count of days in the first month. |
||
| Revision | 2010-05-26 11:45 by psanjuan | ||
| Description | Calculation of acc&def-plan should be done in two ways which can be chosen by the user (only once in the system). - daily bases which is the way it works now - monthly bases => every month should be the same amount unless the number of days it has. But the first month amount depends on the date the period begins. Example: 25.5.09 - 26.7.10 amount 14.000,- => 14 month => amount per month = 1000,- => first month => 1000 : 31 X 6 = 193,55 05/09 193,55 06/09 1000,- . . . 06/10 1000,- 07/10 806,45 => last month => monthly amount - first month amount (1000 - 193,55) |
||
| Revision | 2010-05-26 11:07 by psanjuan | ||
| Description | Accruals and Deferrals enhancements - amount divided by period | ||
| Copyright © 2000 - 2009 MantisBT Group |
 |