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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013656
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Accruals and Deferralsmajoralways2010-06-15 09:182010-06-18 14:00
ReporterpsanjuanView Statuspublic 
Assigned Tobalamurugan 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision451183449ab1
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

0013656: Acc&Def Plan-amount divided by periods (monthly). Constrains to the "To Date"

Descriptionmonthly 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.
Proposed Solution    the 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.
- monthly - if the user select this one system should behavied as explained below:
Monthly:
Constraint for the ‚To’ date: The day in the To-date must be the predecessor from the day in the From-date (with 28/29/30/31, according to the month as predecessor of 1)
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.

From 01.06.2010 To 31.12.2010 Net Amount = 7000 => 1000 in every month

From 15.06.2010 To 14.08.2010 Net Amount = 2000 => 500 in June, 1000 in July, 500 in August

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

Daily:

No constraints for the ‘To’ date and it should work as it currently works.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on feature request 0013440 closedvmromanos Accruals and Deferrals enhancements - amount divided by period - New Calculation Type = Monthly 

-  Notes
(0028431)
psanjuan (manager)
2010-06-15 09:19

 This inmediate is due to a wrong requirements definition in Feature Request 13440.
(0028545)
hgbot (developer)
2010-06-17 12:10

 Repository: erp/pmods/org.openbravo.accrualsanddeferrals
Changeset: 0d027143487f0ed541b9e44e7d76bd6214f23122
Author: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com>
Date: Thu Jun 17 15:40:20 2010 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.accrualsanddeferrals/rev/0d027143487f0ed541b9e44e7d76bd6214f23122 [^]

Fixes Issue 13656: Acc&Def Plan-amount divided by periods (monthly)

---
M src-db/database/model/functions/ACCDEF_GENERATE_PLAN.xml
M src-db/database/sourcedata/AD_MODULE.xml
M src-db/database/sourcedata/AD_MODULE_DEPENDENCY.xml
---
(0028556)
hgbot (developer)
2010-06-17 14:15

 Repository: erp/pmods/org.openbravo.accrualsanddeferrals
Changeset: 451183449ab1e74dab54f7f8af4517716bcb4389
Author: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com>
Date: Thu Jun 17 17:45:06 2010 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.accrualsanddeferrals/rev/451183449ab1e74dab54f7f8af4517716bcb4389 [^]

Fixes Issue 13656: Acc&Def Plan-amount divided by periods (monthly)

---
M src-db/database/model/functions/ACCDEF_GENERATE_PLAN.xml
---
(0028583)
arunkumar (reporter)
2010-06-18 14:00

 Tested working fine

- Issue History
Date Modified Username Field Change
2010-06-15 09:18 psanjuan New Issue
2010-06-15 09:18 psanjuan Assigned To => sathiyan
2010-06-15 09:18 psanjuan Description Updated View Revisions
2010-06-15 09:19 psanjuan Note Added: 0028431
2010-06-15 09:19 psanjuan Proposed Solution updated
2010-06-15 09:20 psanjuan Relationship added depends on 0013440
2010-06-15 09:20 psanjuan Assigned To sathiyan => balamurugan
2010-06-17 12:10 hgbot Checkin
2010-06-17 12:10 hgbot Note Added: 0028545
2010-06-17 12:10 hgbot Status new => resolved
2010-06-17 12:10 hgbot Resolution open => fixed
2010-06-17 12:10 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.accrualsanddeferrals/rev/0d027143487f0ed541b9e44e7d76bd6214f23122 [^]
2010-06-17 14:15 hgbot Checkin
2010-06-17 14:15 hgbot Note Added: 0028556
2010-06-17 14:15 hgbot Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.accrualsanddeferrals/rev/0d027143487f0ed541b9e44e7d76bd6214f23122 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.accrualsanddeferrals/rev/451183449ab1e74dab54f7f8af4517716bcb4389 [^]
2010-06-18 14:00 arunkumar Note Added: 0028583
2010-06-18 14:00 arunkumar Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker