Question

Supplier Schedule Delivery Dates incorrect due to the Bank Holiday

  • 17 May 2021
  • 6 replies
  • 271 views

Userlevel 1
Badge +2

Hi All, we have an ongoing issue with incorrect delivery dates pulling through onto Supplier Schedules.  Our scheduled suppliers have set delivery days of the week and these are set up as a part of the supplier schedule agreement. However when we have bank holidays, the dates shift as a result and continue to shift with dates into the future.  In the attached example, the schedule date is Monday but as soon as a Bank Holiday approaches the day moves out to Wednesday and then Thursday & Friday.  Any suggestions as to why this happens and how it can be resolved? Thanks, Peter


This topic has been closed for comments

6 replies

Userlevel 2
Badge +4

You could be having exceptions for the site calendar. If you review the calendar attached to the site, you should be able to see this. if there are exceptions I would expect delivery dates to get changed.

 

Lakmal

Userlevel 7
Badge +20

Hi @GILPETEG 

When it comes give details , I believe either there are exceptions or after adding exceptions calendar was not generated properly.

So are you having calendar status “ Change pending” ? in that case , please generate calendar correctly to get correct value for schedule dates.

 

Userlevel 5
Badge +8

Once you have checked what is suggested above where you have to verify the calendar exceptions, what are the values in the Horizon definitions of the Schedule Template that is connected to the Supplier Sched Agreement in Supplier Schedule Basic Data?

If it is like this,

Then you can change it to below by making sure the 'Period size' is 1 Day (Period Unit).

 

However, in instances where you need more span of time to aggregate demand, increase the 'Number of Periods' in the Horizon.

Userlevel 1
Badge +2

Hi @Lakmal, Thanks for your comment. We do have bank holidays (generally Monday) as exceptions in calendars and would expect the date to move at that point. However, we would expect the schedule to revert to Mondays again the following & subsequent weeks but it doesn’t.

Hi @Xavier, Thanks for the feedback. At the start of each year we add our bank holidays to the Schedule Exception and then we regenerate the calendars – all are fully generated.

Hi @Nethmie, Thanks for your input.  Having checked and verified the calendar exceptions & calendars generated, I’ll have a chat with our users re your suggestion on Horizon definitions.

Userlevel 1
Badge +2

Hi all,

Having been back to our users, we’re not sure this is what they want really and doesn’t resolve the issue as changing the period to 1 instead of 5 means that a schedule line comes out for every single day instead of just the 1 day a week.

According to our users, the comments from the Community only relate to how the schedule is set up, and do not address the bank holiday problem as far as our users can see. Perhaps we are misunderstanding how schedules and routes work together. We have a Supplier Schedule Agreement that specifies a ‘Delivery Route ID’ = MON (Mondays). The ‘Delivery Route Day’ says Monday and we have added ‘Route Schedule Exceptions’ for bank holiday dates.

The Delivery Date on the Supplier Schedule shows Monday dates until a bank holiday is due and then it throws a wobbler from then on, so how does the system arrive at these different days?

Thanks

Peter

Userlevel 1
Badge +2

Hi - just thinking - forgot to mention we are on Apps9 in case that makes a difference. Thanks, Peter