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

Openbravo Issue Tracking System - Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0013440

Modules

Accruals and Deferrals

public

2010-05-26 11:07

2010-09-10 18:54

Reporter

psanjuan

Assigned To

vmromanos

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Ubuntu 8.04.1

Product Version

Target Version

Fixed in Version

1.0.10

Merge Request Status

Regression date

Regression introduced by commit

Regression level

Review Assigned To

Support ticket

OBNetwork customer

Regression introduced in release

Summary

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

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.

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.

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, 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

Additional Information

Tags

No tags attached.

Relationships

blocks

defect

0013656

closed

balamurugan

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

Attached Files