Local Time Conversion for PO PDF Report

We have a requirement in our project to develop a custom PO PDF report. A header-level DFF is used to capture the appointment date and time, which is updated by a third-party transportation system through integration. The client has 21 requisitioning Business Units (BUs) spanning across the US, and there is a requirement to display the DFF value in the PO PDF in the respective BU's local time.

The proposed design is to create a lookup type with all 21 BUs as lookup codes and store the UTC offset in the description field. The query will then retrieve the corresponding offset for each BU and convert the UTC timestamp to local time. However, the major concern with this approach is that users would need to manually update the UTC offsets twice a year to account for Daylight Saving Time.