[TDA] Export Error "No corresponding data, configuration error"

For the TDA report error, 
I checked TD(WMS2)’s “incomplete report” is using same SQL but able to export report by ticking all,
suspect due WMS version difference.

I find out in TDA, these 4 reports having same error.

When further check with flux:
1) Incomplete report

Have to change:
‘soh.orderNo AS WMS_SO’ to ‘soh.orderNo AS ORDERNO,’ in SELECT

2) MULTI_SO_PICKLIST

Have to add 2 parts:
‘h1.orderNo AS ORDERNO’ in SELECT,
‘h1.orderNo’ in GROUP BY

3) PREOREDER_LABEL

Have to add: 
‘dlh.ldlNo AS LDLNO’ in SELECT,
change ‘… AS ldlno’ to ‘… AS LDLNO' 

4) SOINFO:

Have to change:
‘soh.orderNo AS WMS_SO’ to ‘soh.orderNo AS ORDERNO’ in SELECT

In short, ways to fix these: