← Back to team overview

openerp-india team mailing list archive

[Bug 1126282] Re: Invoicing error in due date calculation for 01/31/2013

 

Shahin while the computation is teorically correct it is not 'practically'.
Suppose i want to set up a payment term that sets the due date to the last day of next month (which is extremely common).
At the moment, *there is no way to do that*.

If you use 
    number of days: 30
    day of the month: -1

It won't work for invoices with date 31 January: +30 days goes to 1
March, -1 goes to 31 March.

If you use
   number of days: x < 30
   day of the mont: -1

It won't work for invoices with date 1 January: +x goes at most to 30
January, -1 goes to 31 January.

Strictly speaking this is not a matter of wrong calculations, but missing functionalities.
An alternative found in some community modules written explicitly to solve this issue is to let the user specify, in addition to number of days, the number of months.

** Changed in: openobject-addons
       Status: Invalid => Confirmed

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1126282

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

Status in OpenERP Addons (modules):
  Confirmed

Bug description:
  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!

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1126282/+subscriptions


References