× Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…

HOLIDAY table issue for COB

  • Jacky2015
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 3 weeks ago #17187 by Jacky2015
HOLIDAY table issue for COB was created by Jacky2015
Dear All,

For test requirement of R13MB, I only want to set up two working days per month in HOLIDAY table.
How can I do?

Thanks

Please Log in or Create an account to join the conversation.

  • armin
  • armin's Avatar
  • Offline
  • Elite Member
  • Elite Member
  • “So long - and thanks for all the fish!”
More
9 years 3 weeks ago #17189 by armin
Replied by armin on topic HOLIDAY table issue for COB
Use JED to directly change the day-by-day flags in MTH.nn.TABLE (set W to H for each Holiday you need).

using R11 on Unix
The following user(s) said Thank You: Jacky2015

Please Log in or Create an account to join the conversation.

  • Jacky2015
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 3 weeks ago #17192 by Jacky2015
Replied by Jacky2015 on topic HOLIDAY table issue for COB
Dear Armin,

Thank you very much.
And if I update the HOLIDAY table by useing JED, is there any rule I must notice?

Please Log in or Create an account to join the conversation.

  • armin
  • armin's Avatar
  • Offline
  • Elite Member
  • Elite Member
  • “So long - and thanks for all the fish!”
More
9 years 3 weeks ago #17196 by armin
Replied by armin on topic HOLIDAY table issue for COB
What rule do you think of ?
Formal rules to jed the record or rules related to setting a day a holiday (e.g. NEXT.WORKING.DAY can't be set as a holiday)?

using R11 on Unix

Please Log in or Create an account to join the conversation.

  • Jacky2015
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 3 weeks ago #17197 by Jacky2015
Replied by Jacky2015 on topic HOLIDAY table issue for COB
I have been set up HOLIDAY table by T24 online version.
I knew the next working day can not be changed.
I set up the weekend days are from Monday to Sunday. (7 days per week)
And then the days of the whole year are holidays.
Then I set up the working day by setting up "Wrk Wknd XXXXXXX(Month)" Fields.
I can see the correct result at "Mth xx table" fileds.
But Someone told me I can not set up HOLIDAY table by this way.
If I do this, the result of COB will be incorrect.
I can not believe that. So I want to know if I set up two working days per month by any way in HOLIDAY, is there any rule I must to follow.

Please Log in or Create an account to join the conversation.

  • armin
  • armin's Avatar
  • Offline
  • Elite Member
  • Elite Member
  • “So long - and thanks for all the fish!”
More
9 years 3 weeks ago #17200 by armin
Replied by armin on topic HOLIDAY table issue for COB
From my knowledge the next working day in EB.CYCLE.DATES is set to the next day after TODAY that has a W in the MTH.nn.TABLE without any additional checks.
Another point may be that there are jobs running on specific dates that you might miss (e.g. FREQUENCY = W and you don't run on any Friday).

using R11 on Unix

Please Log in or Create an account to join the conversation.

  • Jacky2015
  • Topic Author
  • Offline
  • New Member
  • New Member
More
9 years 3 weeks ago #17201 by Jacky2015
Replied by Jacky2015 on topic HOLIDAY table issue for COB
I think FREQUENCY is no problem because Friday also might be a holiday.
So I think it is OK and I will try it.
Thank you very much.

Please Log in or Create an account to join the conversation.

Time to create page: 0.109 seconds