Daily Outbound Report - to add new field in Grid

ISSUES             

1) Unable to add new column LOTTABLE5 from table inv_lot_att into daily outbound report

 

WMS = PROD & UAT

WAREHOUSE ID = 90300

MODULE = Daily Outbound Report

Table  = inv_lot_att

Column = LOTTABLE5

Setting and column update

Error Message

Step by step:

1. In the Data Source for the Daily Outbound report, you will need to put in alias because lottatt05 was in the SQL selection originally. Therefore the setting will be as below.

Click on the INV_LOT_ATT.LOTATT05 and the right screen will appear with the field. Put in alias, in this case as LOTTABLE05, you can put in any alias. Click on the Group because the SQL SELECT has a Group by to prevent the error from triggering. Save the scheme.

2. You will see in the UDF GRID, that Lotatt05 appears in the selection. You will need to drag that field from the left into the UDF Grid. Arrange the position in the grid. Save the scheme.

3. Go to the Daily Outbound Report and run query. You will see the new field lottable05.