This question has been flagged
2 Replies
4371 Views

Hello, we need to define new payment terms in V8. Most of them are easy but one is tricky: 30 days starting on the 1st of next month.

Current literature I can access is for V6.1 https://doc.odoo.com/v6.1/book/3/3_9/payment_terms/

 and the columns shown there are very different from what the system is presenting in V8. Any pointer in the proper direction will be gratly appreciated.

 

Avatar
Discard
Author

Testing several options but there seems to be a bug in the system. I Define A payment term named "Current Month + 30 days" in Accounting > Miscellaneous > Payment terms with Computation = Balance Amount = 0.00000 Number of days = 30 Day of the month = -1 The result is 31/1 and not 30/1 -------------- If I put 0 in number of days, computed date is December 31st (which seems correct) ------ If I use number of days = 45 I still get 31/1 (instead of 14/2) as response. ------- Thanks for any pointer

Best Answer

Payments terms are defined this way: for example (today 15.12.2014) :

  • Number of days = 90  and   Day of the month = 0  then ... payment date =  current date + 90  = 15.03.2015
  • Number of days = 90  and   Day of the month = -1  then ... xxx = ( current date + 90 )  ...  payment date = last_day_of_month(xxx) = 31.03.2015
  • Number of days = 90  and   Day of the month = 13  then ... xxx = ( current date + 90 )  ...  payment date = day 13 of next_month(xxx) = 13.04.2015

Day of the month - set -1 for the last day of the month. If it's positive, it gives the day of the next month. Set 0 for net days.

Avatar
Discard
Author Best Answer

I can not comment on previous answer as I do not have 50 karma. So here goes my comment.

Thank you for your response.

Regulat days intervals work fine: 15, 30 or whatever number of days.

The way you describe the handling of the "Date of the month" is innovative from my previous beliefs. I will have to test different scenarios but somehow I feel it will not really help me. 

Of all the cases where I used -1, only with 90 days (starting on 15.12) did I get a perfect hit. I tried current month + 30, 45, 60 , 75 and 90. The responses should have been 30/1; 14/2; 1/3; 16/3 and 31/3. Instead I got 31/1; 31/1 (really off the mark); 28/2; 28/2 (another gorss miscalculaton) and, finally, yes, 31/3. 

Avatar
Discard

First opearation is + 30, 45, 60 , 75 and 90. Next is "-1". Inversely then you assume.

Oh, darn ..... so that is the bloody thing .... I will check that right now



Luis Panozzo (Lp)
Technology Manager
Elmatica AS
luis.panozzo@elmatica.com
Skype: luispanozzo

On 15 December 2014 at 15:44, zbik <darek@mail.odoo.com> wrote:

First opearation is + 30, 45, 60 , 75 and 90. Next is "-1". Inversely then you assume.

--
zbik
Sent by Odoo S.A. using Odoo about Forum Post False
Darek,
To be very honest, this thing is driving me crazy.
Your description led me think with a different perspective.
So I created several different custom Payment Terms
They are all named "Custom (number of days)(Day of the month)
So, these are the results I got
Custom 0+5 yielded a 5/1 due date - Perfect (nothing now and then move to day 5 of next period)
Custom 5-1, 31/12 which also seems correct (five days now and the go to the end of the resulting month -December- with the -1)
Custom 20-1, 31/1 - right again (add 20 days to now -Jan 4th_ and then skip to the end of that month; 31/1/15)

but 
Custom 20+13 returned me 13/2 instead of the expected 13/1
Similar to 20+9 which resulted in a new date of 9/2 instead of 9/1

Any thoughts?

And the same question then comes up: How to move to the end of the month and then + 30 days? So due date is 30/1 and not 31/1. 



Luis Panozzo (Lp)
Technology Manager
Elmatica AS
luis.panozzo@elmatica.com
Skype: luispanozzo

On 15 December 2014 at 15:53, Luis Panozzo <luis.panozzo@elmatica.com> wrote:
Oh, darn ..... so that is the bloody thing .... I will check that right now



Luis Panozzo (Lp)
Technology Manager
Elmatica AS
luis.panozzo@elmatica.com
Skype: luispanozzo

On 15 December 2014 at 15:44, zbik <darek@mail.odoo.com> wrote:

First opearation is + 30, 45, 60 , 75 and 90. Next is "-1". Inversely then you assume.

--
zbik
Sent by Odoo S.A. using Odoo about Forum Post False

....Custom 20+13 returned me 13/2 instead of the expected 13/1........ My calculation - 13/2 is OK. December+20 = january ... next step ... (+13) = january + 13 day of next month after january = 13 february. ........ How to move to the end of the month and then + 30 days? .... Unfortunately, I dont know :)

Well, that is an odd behaviour of the sw to say the least.
I would have expected today + 20: 4/1 and then 13 ..... move to 13/1.
But your reasoning fits the result of what Odoo showed. 
Really strange (from my humble point of view).

Thank you for the guidance. 
Even if I do not like it, that is what we have and what we have to live with.



Luis Panozzo (Lp)
Technology Manager
Elmatica AS
luis.panozzo@elmatica.com
Skype: luispanozzo

On 15 December 2014 at 17:08, zbik <darek@mail.odoo.com> wrote:

....Custom 20+13 returned me 13/2 instead of the expected 13/1........ My calculation - 13/2 is OK. December+20 = january ... next step ... (+13) = january + 13 day of next month after january = 13 february. ........ How to move to the end of the month and then + 30 days? .... Unfortunately, I dont know :)

--
zbik
Sent by Odoo S.A. using Odoo about Forum Post False