Skip to Main Content

DevOps, CI/CD and Automation

Announcement

Testing banner

Need help on Journal Line Level DFF

User_E97G7Dec 29 2020

Hi Team,

We are using R12.2.3 version.

Let me clarify one thing before going to detailed subject which is we are looking for customization. But, the basic requirement which I am going to raise is for standard functionality
Below is our requirement in JE Line Level DFF
1. We have created different Contexts on JE Line Level DFFs like: AP Invoice, AR Transactions etc.,
2. If user selected AP Invoice context, then corresponding segments like: Vendor Name, PO# and Invoice# segments should enable (Other then Vendor remaining 2 are optionally required). Here, the dependency is:
a. System has to show only the POs based on vendor selected
b. System has to show only the Invoices based on PO# selected
3. If user selected AR Transactions context, then corresponding segments like: Customer Name, Sales Order# and Transaction# segments should enable (Other than Customer, remaining 2 are optionally required). Here, the dependency is:
a. System has to show only the SOs based on Customer selected
b. System has to show only the Transactions based on SO# selected

As of now, we achieved this. But again we got a requirement (For AP Invoice Context)), where if user didn't selected any PO# then system has to show all the Invoices on that Vendor. Which is what we are facing issue.

Here, we created VENDOR_VS, PO_VS and INVOICE_VS for Vendor, PO and Invoice. PO_VS is dependent on VENDOR_VS(:$FLEX$.VENDOR_VS) and INVOICE_VS is dependent on PO_VS(:$FLEX$.PO_VS). Because of this, Invoice# DFF is getting enabled only when PO# is given. But, we want the Invoice# DFF to be enabled even when PO# is not given. Is there any way to achieve this?

Thanks,
Srivathsava

Comments
Post Details