Project:
| View Revisions: Issue #13440 | [ Back to Issue ] | ||
| Summary | 0013440: Accruals and Deferrals enhancements - amount divided by period - New Calculation Type = Monthly | ||
| Revision | 2010-08-31 12:19 by psanjuan | ||
| Steps To Reproduce | Purchase Management || Transactions || Purchase Invoice || Header and enter a new invoice by entering below information: Transaction document = AP invoice Invoice date = Accounting Date = Tax Date = 10-01-2010 Acc & Def Type = Prepaid Expenses Date From = 10-01-2010 Date To = 09-09-2011 Go to Lines and enter a line with a Line Net Amount = 21.000 Go back to the header and complete/Post the invoice. Realize there is no way for a monthly calculation. |
||
| Revision | 2010-08-31 12:08 by psanjuan | ||
| Steps To Reproduce | Purchae Management || Transactions || Purchase Invoice || Header and enter a new invoice by entering below information: Transaction document = AP invoice Invoice date = Accounting Date = Tax Date = 10-01-2010 Acc & Def Type = Prepaid Expenses Date From = 10-01-2010 Date To = 09-09-2011 Go to Lines and enter a line with a Line Net Amount = 21.000 Go back to the header and complete/Post the invoice. Realize there is no way for a monthly calculation. |
||
| 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 | ||
| Steps To Reproduce | |||
| 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 |
 |