RE: how to get foreign Holidays into BC, so purchasing can better estimate the lead times?
Hi - You can leverage some assistance from a BC Developer, if you are one, do follow:
1. You'll have to do an API integration which will fetch data into Business central, once a year. Make sure to have a provision to delete all data for years gone by
2. You can use https://www.abstractapi.com/api/holidays-api to fetch all the data into a custom staging table into Business Central. Or use a similar link. These APIs will either accept JSON or in many cases XML Requests. There are plenty of blogs out there to guide you on both formats
3. Now you need a provision to make sure correct country code is entered into the PO/PQ. You can use any default fields available or create a custom one of your own. Either way make sure you have data in this particular field
4. Next, write a subscriber on the "Email" button of a purchase order/quote which will check (1) If your PO/PQ's country matches with any country code in your custom table & (2) then check if Today's date is a holiday in that country (3) If today is a holiday, showcase a confirmation message or an error
5. End
This task above is time consuming to say the least. Only if it adds value go for it and develop an extension in Business Central. Do let the community know if you need any assistance with the AL code
Alternatively, since all emails from BC are sent from a designated outlook/office365 account, check if similar "global holiday" setting configuration is available via your Exchange Server or Outlook Server. There may be apps there to assist you with this on outlook itself, which will consume less time
Do verify the answer by clicking "YES" for "Did this answer your question" - if you feel it helped you in anyway, so that others can get benefit out of it too. Thankyou very much for taking out time to read
Share
Report
350
All responses (
Answers (
