Skip to Content

Looking for workday table

Trying to identify where Business One stores workdays. We can see the holidays, and we know how to define workdays, but we cannot find the file that says Friday, October 6 is a workday and Saturday, October 7 is a non-workday. At one point system information shows me a table named CLND, but this does not come up in queries.

The information has to be stored somewhere, otherwise MRP would not know how to skip over non-workdays.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 03, 2017 at 01:42 PM

    Hi,

    If I am not wrong, there seems to some linking with the OHLD and HLD1 table. Because all the Holidays are listed in these tables, rest seems to be considered as working days only.

    Kind regards,

    ANKIT CHAUHAN

    SAP SME Support

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Russ,

      Following the ANKIT CHAUHAN 's answer. I believe that MRP consider the information on OHLD and HLD1 table.

      In OHLD table you are able to see what is the first day of the weekend(WndFrm) and the last day of the weekend(WndTo), and together with this there is a flag to ignore Weekend (ignrWnd).

      In general WndFrm have the value 7 that is the Saturday in day of the week, and WndTo have the value 1 that is the Sunday in day of the week.

      Hope it helps.

      Kind Regards,

      Diego Lother