Due date calculation - business days

nostranostra Member Posts: 3
Hello.
i have searched and cannot see a way of doing this, any assistance would be greatly appreciated.

I would like to setup a payment terms of '14 business days'. I can not work out a formula for due date calculation. Does anyway have any ideas?

example, if Invoice dated today '25/05/2011', then 14 business days (mon-fri) would make it due on 14/06/2011.
i don't see how it could take weekends and public holidays into account, but there might be a way to get close..

thanks in advance.

Comments

  • kinekine Member Posts: 12,562
    I am afraid that there is no such standard functionality and you will need some customization.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • nostranostra Member Posts: 3
    thanks for the reply.
    i thought as much.. will need to use a calender table to get all holidays etc i suppose.
  • vaprogvaprog Member Posts: 1,139
    You chould use a base calendar an CalcDateBOC from codeunit 7600 Calendar Management.
Sign In or Register to comment.