You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DFF Attribute to be populated based on Standard UI field

edited May 7, 2025 11:39AM in General Ledger & Intercompany 1 comment

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

  1. If the Accounting Period is selected as same as the Current Period, the the DFF value = "No"
  2. 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"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!