Hi everyone!
For INVENTORYHOLD event I am trying to set a custom xml message. In the base one, the parameter is the HOLDTRNGROUP but I'd like to use the HOLDTRNKEY instead. I tried to set the xml like this, setting the Parameter to HoldTrnKey but it is not working, it is still using the HoldTrnGroup.
Am I missing something?
Thanks!
<?xml version="1.0" encoding="UTF-8"?>
<MessageBuilder Name="InventoryHold">
<Parameter>HoldTrnKey</Parameter>
<Query Name="InventoryHoldHeader"
Output="on">
<Column Output="on">Origin</Column>
<Column Output="on">WhseId</Column>
<Column Output="on">HoldTrnGroup</Column>
<Column Output="on">StorerKey</Column>
<Column Output="on">SKU</Column>
<Column Output="on">Lot</Column>
<Column Output="on">Loc</Column>
<Column Output="on">HoldTRNAddDate</Column>
<Column Output="on">CountSequence</Column>
<Column Output="on">Comments</Column>
<Column Output="on">ProdStageLoc</Column>
<Column Output="on">HoldCode</Column>
<Column Output="on">Qty</Column>
<Column Output="on">HOrigin</Column>
<Column Output="on">ID</Column>
<SQL>SELECT DISTINCT INVENTORYHOLDCODE.UDF AS Origin ,htrn.HoldTrnGroup ,htrn.StorerKey ,htrn.WhseId ,htrn.SKU ,htrn.Lot ,htrn.Loc ,htrn.EDITDATE AS HoldTRNAddDate ,htrn.CountSequence ,CASE WHEN htrn.qty > 0 THEN UDF2 ELSE NULL END AS Comments ,ABS(htrn.QTY) AS ProdStageLoc ,htrn.HoldCode ,htrn.Qty ,htrn.Origin AS HOrigin ,htrn.ID FROM HOLDTRN htrn INNER JOIN TRANSMITLOG tl ON htrn.HoldTrnKey = tl.KEY1 LEFT OUTER JOIN LOC ON LOC.loc = htrn.loc LEFT JOIN INVENTORYHOLDCODE ON htrn.HOLDCODE = INVENTORYHOLDCODE.CODE WHERE (htrn.HoldTrnKey = :HoldTrnKey) AND (tl.TABLENAME = 'INVENTORYHOLD')</SQL>
