Invoicing error in due date calculation for 01/31/2013

Asked by Damien D.

Hi all,

due date is not calculated correcty only for an invoice date of 01-31-2013 (and 01-31-2014, and so on ...)
invoicing date: 01-31-2013
Payment term: 90 days end of month
due date should be 04-30-2013

I set this payment term in Accounting > Configuration > Payment Term
Valuation: balance
Number of days: 90
Day of the month: -1

With that OpenERP gives me 05-31-2013 for the due date

What is very strange is that OpenERP computes correctly the due date for all the other days of the years...
invoicing date due date
02-28-2013 05-31-2013 OK
03-31-2013 06-30-2013 OK
etc....

You can try this here:
http://54.228.22.65:48080
db: Test_Compta
user: admin
pwd: kazacube

Thanks for your help!

Question information

Language:
English Edit question
Status:
Expired
For:
Odoo Addons (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Shahin Belim(OpenERP Trainee) (shahin.belim-openerp-deactivatedaccount) said :
#1

Hello Damien,
 I have gone through your suggested bug,
there is no error in calculation of due date. Here you set payment term 90 Days end of month.
If invoice date is: 01-31-2013. so, according to payment term if we calculate 90 days after 31st January it will be 5/1/2013. Because there are 28 days in February.
Now if you set payment term in Accounting > Configuration > Payment Term
Valuation: balance
Number of days: 90
Day of the month: -1 (If you set Day of Month : -1 Return last day of the current month
                             : 0 Return net days
                          :+ve It gives day of the next month)

It will give last date of month(5/31/2013).

Revision history for this message
Amit Parik (amit-parik) said :
#2

Yes, Agreed with Shahin.

Damian you misundestood the meaning of 90 Days end of month payment term.
The meaning of this payment term is caculate the 90 days form the invoice date and due date will become that months last day.

for Example: Credit card bill normaly it used the 30 days end of the months payment term.

Thank you!

Revision history for this message
Damien D. (ddelangle) said :
#3

Hi,

First, please note that due date was correctly computed for 01-30-2013 (returned 04-31-2013) but not for 31-01-2013 (returned 05-31-2013)

Anyway, what is expected is having a unique payment term which computes the invoicing due date like this:

invoicing date: any day of the month M
invoicing due date: last day of month M+3

Examples:
invoicing date --- due date
01-14-2013 --- 05-31-2013
01-30-2013 --- 04-31-2013
01-31-2013 --- 04-31-2013
02-28-2013 --- 05-30-2013
03-13-2013 --- 06-31-2013
... and so on

What should I set in the payment term:
  - Valuation: balance
  - Number of days: 90
  - Day of the month: -1, 0 or +ve

Thanks,

Damien D.

Revision history for this message
Launchpad Janitor (janitor) said :
#4

This question was expired because it remained in the 'Open' state without activity for the last 15 days.