Prepayment DFF Values Filtered
SummaryValue Set must be filtered by Business Unit and Prepayment Type
Hi Dear All,
I want to open new DFF for Invoice which type is Prepayment. DFF inculedes Order Numbers status is OPEN and CLOSED FOR RECEIVING.
So I want to establish an inorganic bond between Order and Prepayment Invoice.
- This DFF should appear just Prepayment Type in Invoice
- Our Value set' validation type is table. So I wrote a sql query. I need to filter for chosen Business Unit
I added a picture about my query
How can i do that ?