Trigger Transfer Refresh from Jan 1, 2019, To Jan 14, 2020, to get the most updated data in JDA.
Generate the Transfer report and attached it to the email report to Carrisa Banzon of ICG
As per advise the issue still occur
Open the report to Pentaho report designer to check the script
Open the stored procedure 'Transfer_Out_Report_by_SKU' and check the script
As per checking, I saw that the script only display status shipped (C) even the transfer number is already received (S)
Modified the script line 25 From CASE WHEN transfer_status = "C" THEN "RECEIVED"  END
To (CASE WHEN transfer_status = "C" THEN "RECEIVED" ELSE "SHIPPED" END)
Drop create the store procedure
Tried to generate the file again and saw that the status of the sample transfer number changed from Shipped to Received
Advise Carrissa to cross-check the attached file
Waiting for her advise if the issue has been resolved.
