I am attempting to DMT a new memo onto a specific Order/Line/Release combination (Line 2 Release 3), but when it creates the memo, it’s assigning it to Line 1 and Release 1 instead.
Why is it not using the Key2 and Key3 entries in the DMT file that I have entered?
DMT file I am using is attached (company number removed intentionally for posting here)
DMT_OrderRel_inputMemo_TestEmail_123022.xlsx (8.9 KB)
.
There is certainly some funkiness with DMT and memos. I recall not being able to add memos via DMT. The end of this thread shows that I escalated this to support and got no resolution.
DMT - Add Memo Table Record - Unable to call method - Kinetic 202X - Epicor User Help Forum (epiusers.help)
I see that you did not produce an error, so that is a good sign. Keep working trial and error steps to see if you can find a configuration that works. If you do, we would love to hear about it!
Good Luck!!
For now you need to use column RelatedToSysRowID, with the SysRowID value from the actual OrderRel record.
It used to work like this but was later changed to use Keys, it was meant so that memos could be created without knowing the row id in advance, but it is not working properly as you found.
There is an open bug to fix this, DMT-1870
Exact conclusion I was working on testing when you posted, and spot on! Used the SysRowID from the release record and it put the memo where I wanted.
I knew that coming here (to the real experts) would get me where I needed to go, rather than support just telling me to contact one of their consultants.