Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013440
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Modules] Accruals and Deferralsmajoralways2010-05-26 11:072010-09-10 18:54
ReporterpsanjuanView Statuspublic 
Assigned Tovmromanos 
PriorityurgentResolutionfixedFixed in Version1.0.10
StatusclosedFix in branchFixed in SCM revision9c98ac73a4e2
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.6
OS VersionUbuntu 8.04.1Database version11.1.0.6.0Ant version1.7.0
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0013440: Accruals and Deferrals enhancements - amount divided by period - New Calculation Type = Monthly

DescriptionCalculation 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.

 
Steps To ReproducePurchase 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.
Proposed SolutionThe way to implement this new feature request is:
There should be a new system key at client level (application path: General Setup || Client || Client || Client >> Information )
sistem key name: "Acc&Def calculation"
that system key should have 2 options:
- daily - if the user select this one system should behavied the way it behavies now, see issue 13984 for more information.
- monthly - if the user select this one system should behavied as explained below:

(1) It is only possible to enter full months in Periods fields, therefore:
The day of the Date to must be the day of the Data from -1

(2) If the day in the "Date From" is not the first day of a month, the amount for the first and the last month is distributed proportionally for the count of days in the first month

(3) all of the above according to below formulas

- Avg. monthly amount = Line Net Amount / Nº of months
- First month amount = (30-Day in "date from"+1) x Avg. monthly amount/30
- Last month amount = Line net amount - accumulated amount

It is important to highlight that for the Monthly Calculation: 30 days to be consider for each month


Example 1
Accounting date: 01.05.09
Date From: 01.5.09
Date To: 31.7.10
Amount 15.000,-
 => Number of months = 15 month => Average amount per month = 1000,-
System will generate 15 lines in the Plan.

05/09 1000,-
06/09 1000,-
.
.
.
06/10 1000,-
07/10 1000,-


Example2 :
Accounting Date=10-01-2010
From Date = 10-01-2010
To Date = 09-09-2011
Nº of months = 20
Amount = 20.000
Average amount = 20.000/20 = 1.000
system will create 21 lines
line 1 = First month amount (from 10-01-2010 to 30-01-2010)) = (30-10+1)*1.000/30 = 700
Line 2 to 20 = Middle months (from 01-02-2010 to 01-08-2011) = 1000 x 19 months = 19.000
Line 21 = Last month amount (from 01-09-2011 to 09-09-2011) = 20.000 - 19.700 = 300

Total = 700 + 19000 + 300 = 20000

TagsNo tags attached.
Attached Filespng file icon 13440.png [^] (67,879 bytes) 2010-08-31 12:25


png file icon 13440_1.png [^] (56,565 bytes) 2010-08-31 12:25


png file icon 13440_2.png [^] (56,626 bytes) 2010-08-31 12:25

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0013656 closedbalamurugan Acc&Def Plan-amount divided by periods (monthly). Constrains to the "To Date" 

-  Notes
(0028305)
hgbot (developer)
2010-06-11 13:04

 Repository: erp/pmods/org.openbravo.accrualsanddeferrals
Changeset: 8a22f25e073110fc61b77d9afc889271a5fb6eaf
Author: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com>
Date: Fri Jun 11 16:33:58 2010 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.accrualsanddeferrals/rev/8a22f25e073110fc61b77d9afc889271a5fb6eaf [^]

Fixes Issue 13440: Accruals and Deferrals enhancements - amount divided by period

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
A src-db/database/model/modifiedTables/AD_CLIENTINFO.xml
---
(0028584)
arunkumar (reporter)
2010-06-18 14:02

 Tested working fine
(0029363)
psanjuan (manager)
2010-07-16 13:30

 Hi Patricia, Bala,

 

to 4.: We can presume that every month has 30 days. This makes things easier and so it works in every financial accounting software I know.

         So case 1 is correct and case 2 would be calculated like case 1.

 

To 5.: I would count the day of the date from field to the first month. Let’s do so!

 

Regards

Anja

Von: Patricia San Juan [mailto:patricia.sanjuan@openbravo.com]
Gesendet: Mittwoch, 16. Juni 2010 11:21
An: Bochmann, Anja Katharina; Gerke, Michael
Betreff: Re: Fwd: Re: FR 13440 - new requirements

 

Hi Anja,

can you please check just point 4 and 5 below and let me know if we get it right?
This is what Bala was referring to, he is still missing a confirmation from us.

#4: For "Monthly" basis calculation, Please confirm the following formula to calculate the first month amount.
(Patricia = I think it is right, but I'll check with HIS)


    First Month Amount = No.of Days in "DateFrom" X Avg. Monthly Amount / Total No. of Days in the month of "DateFrom"

For Example,

Case 1:

From 10.06.2010 To 09.08.2010 Net Amount = 1800 => 600 in June, 900 in July, 300 in August

    I. Avg. Monthly Amount = Net Amount / ( No. of Months Between "DateFrom" and "DateTo" - 1) => 1800/(3-1) = 900
    II. First Month Amount = No.of Days in "DateFrom" X Avg. Monthly Amount / Total No. of Days in the month of "DateFrom" => 20 X 900/30 = 600.00
    III. Last Month Amount = 900 - 600 = 300

Case 2:

From 10.07.2010 To 09.09.2010 Net Amount = 1800

    I. Avg. Monthly Amount = Net Amount / ( No. of Months Between "DateFrom" and "DateTo" - 1) => 1800/(3-1) = 900
    II. First Month Amount = No.of Days in "DateFrom" X Avg. Monthly Amount / Total No. of Days in the month of "DateFrom" => 21 X 900/31 = 609.68
    III. Last Month Amount = 900 - 609.68 = 290.32

#5: For "Monthly" basis calculation, Should we count the day itself in "Date From" field for calculating the first month amount? Please confirm.
For Example,

(Patricia = I think it is right, but I'll check with HIS)


If 12.03.2010, then No. of days in the first month would be either 20 or 19? Why this question arises is, in the proposed solution, it was given like,

From 10.06.2010 To 09.08.2010 Net Amount = 1800 => 600 in June, 900 in July, 300 in August

Here it is assumed that the day of "Date From" is not taken into account to calculate the first month amount.



thanks and regards,
Patricia.

On 15/06/10 13:01, Patricia San Juan wrote:

Hi Anja,
Can you please review below Bala's email and let me know if we are right or not?
Bala sent few questions and I've answered them inline..please see below.

Thanks and regards,
Patricia.
(0030533)
psanjuan (manager)
2010-08-31 12:27

 This feature request has been modified as it is not working properly, see screens attached.
This Feature request has been now better explained.
In case of any doubts please add the corresponding notes.
(0030909)
hgbot (developer)
2010-09-09 18:47

 Repository: erp/pmods/org.openbravo.accrualsanddeferrals
Changeset: 9c98ac73a4e265c3d1ecc3f939e815bf29cfeed5
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Sep 09 18:49:15 2010 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.accrualsanddeferrals/rev/9c98ac73a4e265c3d1ecc3f939e815bf29cfeed5 [^]

Fixed bug 13440 in module version 1.0.10
Adde new Calculation Type = Monthly

---
M src-db/database/model/functions/ACCDEF_GENERATE_PLAN.xml
M src-db/database/sourcedata/AD_MODULE.xml
---
(0030950)
psanjuan (manager)
2010-09-10 18:54

 fixed in version 1.0.10

- Issue History
Date Modified Username Field Change
2010-05-26 11:07 psanjuan New Issue
2010-05-26 11:07 psanjuan Assigned To => sathiyan
2010-05-26 11:45 psanjuan Description Updated View Revisions
2010-05-26 16:47 psanjuan Priority normal => urgent
2010-06-09 12:01 psanjuan Proposed Solution updated
2010-06-10 07:54 balamurugan Assigned To sathiyan => balamurugan
2010-06-10 15:19 psanjuan Proposed Solution updated
2010-06-11 13:04 hgbot Checkin
2010-06-11 13:04 hgbot Note Added: 0028305
2010-06-11 13:04 hgbot Status new => resolved
2010-06-11 13:04 hgbot Resolution open => fixed
2010-06-11 13:04 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.accrualsanddeferrals/rev/8a22f25e073110fc61b77d9afc889271a5fb6eaf [^]
2010-06-14 16:25 psanjuan Proposed Solution updated
2010-06-14 16:27 psanjuan Description Updated View Revisions
2010-06-15 09:20 psanjuan Relationship added blocks 0013656
2010-06-18 14:02 arunkumar Note Added: 0028584
2010-06-18 14:02 arunkumar Status resolved => closed
2010-07-16 13:30 psanjuan Note Added: 0029363
2010-08-27 13:57 psanjuan Proposed Solution updated
2010-08-31 11:17 psanjuan Summary Accruals and Deferrals enhancements - amount divided by period => Accruals and Deferrals enhancements - amount divided by period - New Calculation Type = Montly
2010-08-31 11:17 psanjuan Description Updated View Revisions
2010-08-31 12:08 psanjuan Description Updated View Revisions
2010-08-31 12:08 psanjuan Steps to Reproduce Updated View Revisions
2010-08-31 12:08 psanjuan Proposed Solution updated
2010-08-31 12:19 psanjuan Summary Accruals and Deferrals enhancements - amount divided by period - New Calculation Type = Montly => Accruals and Deferrals enhancements - amount divided by period - New Calculation Type = Monthly
2010-08-31 12:19 psanjuan Steps to Reproduce Updated View Revisions
2010-08-31 12:20 psanjuan Proposed Solution updated
2010-08-31 12:25 psanjuan File Added: 13440.png
2010-08-31 12:25 psanjuan File Added: 13440_1.png
2010-08-31 12:25 psanjuan File Added: 13440_2.png
2010-08-31 12:27 psanjuan Note Added: 0030533
2010-08-31 13:18 psanjuan Assigned To balamurugan => dalsasua
2010-09-06 10:04 psanjuan Status closed => new
2010-09-09 12:47 psanjuan Proposed Solution updated
2010-09-09 12:57 psanjuan Proposed Solution updated
2010-09-09 16:23 psanjuan Proposed Solution updated
2010-09-09 17:22 vmromanos Status new => scheduled
2010-09-09 17:22 vmromanos Assigned To dalsasua => vmromanos
2010-09-09 17:22 vmromanos fix_in_branch => pi
2010-09-09 18:47 hgbot Checkin
2010-09-09 18:47 hgbot Note Added: 0030909
2010-09-09 18:47 hgbot Status scheduled => resolved
2010-09-09 18:47 hgbot Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.accrualsanddeferrals/rev/8a22f25e073110fc61b77d9afc889271a5fb6eaf [^] => http://code.openbravo.com/erp/pmods/org.openbravo.accrualsanddeferrals/rev/9c98ac73a4e265c3d1ecc3f939e815bf29cfeed5 [^]
2010-09-10 16:43 psanjuan fix_in_branch pi =>
2010-09-10 16:43 psanjuan Proposed Solution updated
2010-09-10 18:41 psanjuan Status resolved => closed
2010-09-10 18:54 psanjuan Note Added: 0030950
2010-09-10 18:54 psanjuan Fixed in Version => 1.0.10

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker