JDE_MP
Active Member
Hi Listers,
I have a requirement from client. Need my data selection in the following way:
(UPMJ greater than equal to ProcessingOption.BeginDate AND UPMJ less than equal to ProcessingOption.EndDate)
AND
(TNAC = UA OR TNAC = UB)
I framed the following logic for data selection:
Set Selection Append Flag(<Yes>)
Set User Selection(UPMJ, <Greater Than or Equal To>, PO jdBeginningDate_DTBG, <And>)
Set User Selection(UPMJ, <Less Than or Equal To>, PO jdEndDate_TREN, <And>)
Set User Selection(BC Transaction Action (F03012Z1)(TNAC), <Equal To>, "UB", <And>)
Set User Selection(BC Transaction Action (F03012Z1)(TNAC), <Equal To>, "UA", <Or>)
It does not work as expected. So I tried it in the following way:
Set User Selection(UPMJ, <Greater Than or Equal To>, PO jdBeginningDate_DTBG, <And>)
Set User Selection(UPMJ, <Less Than or Equal To>, PO jdEndDate_TREN, <And>)
Set User Selection(BC Transaction Action (F03012Z1)(TNAC), <Equal To>, "UB", <And>)
//
Set User Selection(UPMJ, <Greater Than or Equal To>, PO jdBeginningDate_DTBG, <Or>)
Set User Selection(UPMJ, <Less Than or Equal To>, PO jdEndDate_TREN, <And>)
Set User Selection(BC Transaction Action (F03012Z1)(TNAC), <Equal To>, "UB", <And>)
Set User Selection(BC Transaction Action (F03012Z1)(TNAC), <Equal To>, "UA", <And>)
This works properly. I know this has been discussed earlier many times.
But is it possible to avoid this repetition and get my selection right? Coz I have to repeat this selection for 2 more tables in the section.
Help appreciated.
Thanks.
I have a requirement from client. Need my data selection in the following way:
(UPMJ greater than equal to ProcessingOption.BeginDate AND UPMJ less than equal to ProcessingOption.EndDate)
AND
(TNAC = UA OR TNAC = UB)
I framed the following logic for data selection:
Set Selection Append Flag(<Yes>)
Set User Selection(UPMJ, <Greater Than or Equal To>, PO jdBeginningDate_DTBG, <And>)
Set User Selection(UPMJ, <Less Than or Equal To>, PO jdEndDate_TREN, <And>)
Set User Selection(BC Transaction Action (F03012Z1)(TNAC), <Equal To>, "UB", <And>)
Set User Selection(BC Transaction Action (F03012Z1)(TNAC), <Equal To>, "UA", <Or>)
It does not work as expected. So I tried it in the following way:
Set User Selection(UPMJ, <Greater Than or Equal To>, PO jdBeginningDate_DTBG, <And>)
Set User Selection(UPMJ, <Less Than or Equal To>, PO jdEndDate_TREN, <And>)
Set User Selection(BC Transaction Action (F03012Z1)(TNAC), <Equal To>, "UB", <And>)
//
Set User Selection(UPMJ, <Greater Than or Equal To>, PO jdBeginningDate_DTBG, <Or>)
Set User Selection(UPMJ, <Less Than or Equal To>, PO jdEndDate_TREN, <And>)
Set User Selection(BC Transaction Action (F03012Z1)(TNAC), <Equal To>, "UB", <And>)
Set User Selection(BC Transaction Action (F03012Z1)(TNAC), <Equal To>, "UA", <And>)
This works properly. I know this has been discussed earlier many times.
But is it possible to avoid this repetition and get my selection right? Coz I have to repeat this selection for 2 more tables in the section.
Help appreciated.
Thanks.