OnAfterSave macro in the shipper window.

Legacy Contributor

We are trying to get the Transaction_ID's for the lines in a shipped packlist. i.e. shipper_line.transaction_ID

The section of the macro below returns all the fields except the Transaction_ID

Is this just because it's not available in shipper window macros?

Regards

Alan

'**********************
'Loop through PL Lines
'**********************
Set PLLINES = LINES.Value
Lcnt = PLLINES.Count
For i = 0 To (Lcnt - 1)
Set PLLINE = PLLINES(i)
LnCnt = LnCnt +1
stApplyIssue = "N"
stLnNo = PLLINE("LINE_NO")
stPart = PLLINE("PART_ID")
stQtyShip = PLLINE("SHIPPED_QTY")
stTransID = PLLINE("TRANSACTION_ID")

charles-hooper

Hi Alan,

You will need to use a database connection in the OnAfterSave macro to find the matching row in the SHIPPER_LINE table to determine the TRANSACTION_ID that is associated with the pack list line.

Charles Hooper
Senior Software Engineer
Meadville Forging Company