Due Date Calculation on Customer Card

icarus1306
icarus1306 Member Posts: 14
edited 2009-03-31 in NAV/Navision Classic Client
Hello,

I need to know what date formula to enter to achieve the following:

To show you the calculation I need to happen I give you 2 examples:

30days EOM = invoice date 13/03/09 due date 30/04/09
60days EOM = invoice date 13/03/09 due date 31/05/09

If you quote me the formula for each separately I would be obliged.

The same formula would also need to cater for February.

Regards


Andrew

Comments

  • matttrax
    matttrax Member Posts: 2,309
    I believe you can do

    1M+CM
    2M+CM

    You can't easily do 30 and 60 days I don't think because on January 31st, adding 30 days will get you into March.
    Matt Traxinger - ArcherPoint
  • DenSter
    DenSter Member Posts: 8,307
    Just to elaborate a little:
    -CM gives you the 1st day of the Current Month
    +CM gives you the last day of the Current Month

    So from 03/13/2009;
    +2M gives you 05/13/2009
    +CM from there gives you the last day of month 05: 05/31/2009

    This works from any month. If you start with 01/31, and you do +1M, you end up with 02/28, so that is already smart enough to know not to go into the month after that.
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories