Create Dropdown Filter for PO creation by Fiscal Year

Hello,

we want to add two dropdown filters to select purchase order items by creation year.
One by calender year and one by fiscal year.

The one for calender year would just be YEAR(“EKKO”.“AEDAT”).

For the fiscal year the dropdown option ‘2019’ should contain all purchase order items with EKKO.AEDAT between 1st of May 2018 and 30th of April 2019 and so on. Can this be implemented?
I tried the following, but the error “not implemented yet” appears.

CASE
WHEN “EKKO”.“AEDAT” BETWEEN ‘2018-05-01’ AND ‘2019-04-30’ THEN ‘2019’
ELSE …
END

Hey pdehn,

The function BETWEEN is what kills your CASE WHEN statement here. You could just do a

CASE WHEN
“EKKO”.“AEDAT” > {d ‘2018-04-30’} AND “EKKO”.“AEDAT” < {d ‘2019-05-01’} THEN ‘2019’
ELSE …
END

This should do the job for you. The additional brackets {d …} convert the following string to a d = date. I chose < instead of <= just for personal preferences, I like it more this way.

Best Regards,

Benedict

2 Likes

Hello Benedict,

that solved the problem. Thank you very much.

Best Regards, Philipp

Hey Philipp,

Glad to help! I realized that probably BETWEEN would have worked with the correct date statement ({d ‘2018-04-30’}) rather than just the string, I didn’t test it though.

Best Regards,

Benedict