Question

National Holiday's In Invoice Generation

Hello Everyone,

 

We have an Orders page from which our invoices are generated. The rate of Invoices depends upon the Day of the Week. (Different rate for weekdays & Weekends). However, one key thing is missing which are UK Holidays. Is there any way to define UK holidays in the system or in my process, so that the system knows that this day is a holiday and the rate should be the holiday rate?

Like 1

Like

3 comments
Best reply

Hello Hassan,

 

You can achieve this in the following manner:

 

1) Create a custom object (parent object should be "BaseLookup") where two integer columns should be added: UsrDayOfHoliday and UsrMonthOfHoliday. They will be used to store the day and the month of holiday respectfully.

 

2) Create a lookup in the "Lookups" section based on the object from step 1 and fill it in:

3) Your business process that generates orders should be modified and additional check for the current day to be UK holiday should be added. Like in the example below:

The logic here is simple: get current day and month and set it as process integer parameters, then use these integer parameters in the "Read data" filtration. Then we have the "It's holdiday!" conditional flow with the following condition:

 

[#Get possible UK holiday.First item of resulting collection.Id#] != Guid.Empty

 

It will check if any record was found in the "Read data" element and if so the "It's holiday today!" autogenerated page will be displayed. Otherwise the process will be terminated. 

 

In your process you need to use the same approach but instead of the autogenerated page you need to trigger the logic you need to be triggered when it's holiday in UK. Otherwise trigger regular logic for other days.

 

Hope it helps!

Hi Community, Any Ideas for this?

Hello Hassan,

 

You can achieve this in the following manner:

 

1) Create a custom object (parent object should be "BaseLookup") where two integer columns should be added: UsrDayOfHoliday and UsrMonthOfHoliday. They will be used to store the day and the month of holiday respectfully.

 

2) Create a lookup in the "Lookups" section based on the object from step 1 and fill it in:

3) Your business process that generates orders should be modified and additional check for the current day to be UK holiday should be added. Like in the example below:

The logic here is simple: get current day and month and set it as process integer parameters, then use these integer parameters in the "Read data" filtration. Then we have the "It's holdiday!" conditional flow with the following condition:

 

[#Get possible UK holiday.First item of resulting collection.Id#] != Guid.Empty

 

It will check if any record was found in the "Read data" element and if so the "It's holiday today!" autogenerated page will be displayed. Otherwise the process will be terminated. 

 

In your process you need to use the same approach but instead of the autogenerated page you need to trigger the logic you need to be triggered when it's holiday in UK. Otherwise trigger regular logic for other days.

 

Hope it helps!

Oleg Drobina,

 

Hi Oleg,

 

This looks promising really! Will try this and update. Thanks for you help!!

Show all comments