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

Openbravo Issue Tracking System - Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0013656

Modules

Accruals and Deferrals

public

2010-06-15 09:18

2010-06-18 14:00

Reporter

psanjuan

Assigned To

balamurugan

Priority

immediate

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Ubuntu 8.04.1

Product Version

Target Version

Fixed in Version

Merge Request Status

Regression date

Regression introduced by commit

Regression level

Review Assigned To

Support ticket

OBNetwork customer

Regression introduced in release

Summary

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

Description

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.

Steps To Reproduce

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.

Additional Information