I am creating a BAQ that link Transfer Order line detail to the Memo. When we create a line memo, it puts it in the Ice.Memo table. The Key1, I thought that’s the transfer order number, but doesn’t seem like it is. If I create a new memo, the ID in the Key1 is totally different. Anyone know which other table needs to be linked? I can go into Transfer Order Entry to the line detail and the memo is there. Other memo seems to match though. For example, in Order Entry if I create a line memo, the Order Number matches. Why transfer order does not match, no clue.
I figured it out now. Thinking it’s like the other tables, TFOrdDtl have a field called TFLineNum. After joining this, it worked.
The Memo Table has a “RelatedtoSysRowID” column. Join the SysRowID of the Line Detail record to the RelatedtoSysRowID of the Memo to get all the Memo rows related to the Line.
1 Like
Ah thank you. Didn’t know you can do that as well.