How to display of LOV in a DFF on Invoice distribution based on Supplier Number of Invoice Header

Summary:

Here is my requirement with some explanation

1. I have two suppliers as Supplier-1 and Supplier-2
2. I have a look up where I store some notes for suppliers. Let us assume I stored following values:
   1. 100-Supplier-1
   2. 101-Supplier-1
   3. 200-Supplier-2
   4. 201-Supplier-2
3. I have a DFF as Supplier Instruction in Payable Invoice Distribution now

What I want as follows:

When I select Supplier 1 where supplier number is 100 in the invoice the DFF LOV should only show my following values

• 100-Supplier-1

• 101-Supplier-1

Similarly, when I select Supplier-2 where supplier number is 200 in the invoice the DFF should show only values

• 200-Supplier-2

• 201-Supplier-2

• 
  

Content (please ensure you mask any confidential information):