Using the base calendar

sabzam
sabzam Member Posts: 1,149
edited 2007-10-02 in NAV/Navision Classic Client
Dear All,

I need to create a report in which I have to find out the number of working days i.e. by deducting the non-working days listed on the base calendar. By any chance does anyone know in which table is the base calendar saved?

Comments

  • Nagi
    Nagi Member Posts: 151
    Hi,

    I believe the two tables you have to use are table 7600 Base Calendar and 7601 Base Calendar Change. Use the first one to set a filter on the second one, to get the number of non-working days listet to any given calendar.

    Cheers!
  • nunomaia
    nunomaia Member Posts: 1,153
    You also have Calendar Management Codeunit that have functions to tell working and non working days.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • sabzam
    sabzam Member Posts: 1,149
    Hi thanks for your replies. I have managed to find another way round by using the smae code used in the sales order to find out the date along with the base calender changes table were the non-working days are recorded.

Categories