DFF Attribute to be populated based on Standard UI field
Summary:
Hi Team
We need to populate a Descriptive Flex field attribute values based on an existing standard field in the UI page
But we do not find any option to refer the value of existing column inside the SQL Query of the DFF
Content (please ensure you mask any confidential information):
General Accounting > Journals > Create Subledger Journal
We have a requirement to populate a DFF attribute at Subledger Journal Header as Yes or No based on the logic as below
- If the Accounting Period is selected as same as the Current Period, the the DFF value = "No"
- If the Accounting Period is less than the Current Period and Accounting Date is within 2 days of current day (e.g. current day 01-Apr-24, Accounting Date is 31-Mar-2025), then DFF Value = "No"
0