3381844 - Incorrect data format in fields "Start of Life" and "End of Life" within app Review Purchase Order Accruals

The "Review Purchase Order Accruals" application's export function produces unreadable date formats for the "Start of Life" and "End of Life" fields.

SAP S/4HANA Cloud

Export the excel file in app "Review Purchase Order Accruals.

This date format issue can be resolved using an Excel formula. To convert the incorrect date fields (assuming $G2 represents the cell containing the incorrectly formatted date), insert the following formula:

=( MID($G2, 7, 10) / 86400)  + DATE(1970, 1,1) 

Remember to change the cell format to "Date". Then apply this formula and format to the entire column by dragging the mouse from the cell with the inserted formula downwards.

The fix is planned with CE2308.3, please test again on 13th November. Please note this is only a planned date and could be changed later.

Review Purchase Order Accruals, export, data format, "Start of Life", "End of Life". , KBA , FI-GL-GL-POA-2CL , Purchase Order Accruals (Public Cloud) , Problem