Flexfield value set in Flexfield value set
Hi Guru's,
I created conccurent program (Report) with these parameters.
Sample data in database
SUBINV LOCATOR1 FLAG
SUB01 A01 100
SUB01 A02 200
SUB02 B01 100
SUB02 B02 300
SUB02 C01 500
SUB03 C02 100
Created 4 Flexfield value set
XX01 : as subinv column
XX02 : as flag value
XX03 : as from locator1 value
XX04 : as to locator1 value
How to create the logic in the flexfield value set with this condition
1. If XX01 = null then shows all locators value (XX03 and XX04)
2. IF XX01=A01, then shows all locators value (XX03 and XX04) with subinv = A01
3. IF XX01=A01, and XX03=100, then shows all locators value (XX03 and XX04) with subinv = A01 and FLAG = 100
I created conccurent program (Report) with these parameters.
Sample data in database
SUBINV LOCATOR1 FLAG
SUB01 A01 100
SUB01 A02 200
SUB02 B01 100
SUB02 B02 300
SUB02 C01 500
SUB03 C02 100
Created 4 Flexfield value set
XX01 : as subinv column
XX02 : as flag value
XX03 : as from locator1 value
XX04 : as to locator1 value
How to create the logic in the flexfield value set with this condition
1. If XX01 = null then shows all locators value (XX03 and XX04)
2. IF XX01=A01, then shows all locators value (XX03 and XX04) with subinv = A01
3. IF XX01=A01, and XX03=100, then shows all locators value (XX03 and XX04) with subinv = A01 and FLAG = 100
Tagged:
0