Show PartLot.ShortChar01 on Pack SLip

Kinetic ERP
1

Hello,
Has anyone successfully retrieved PartLot custom fields into Pack Slip?
I am trying to show the PartLot.ShortChar01 field on the Pack Slip SSRS report. I added the PartLot table to the ShipHeadShipDtl dataset:

LEFT OUTER JOIN PartLot_" + Parameters!TableGuid.Value + " T4
ON T2.Company = T4.Company AND T2.PackLine = T4.Calc_PackLine
AND T2.PackNum = T4.Calc_PackNum which is not returning any PartLot information.
I linked the Lot table to ShipDtl, still nothing. I even add the PartLot table by using the T4.JobLotNum and T4.PartNum without any luck.

2

Did you add ShortChar01 to PartLot? In My PartLot table I only have Character, Number, Date, and Checkbox fields as user fields, not ShorChars.

3

No, the ShortChar01 thru ShortChar10 are standard.