Hi! I’ve been asked to modify a spreadsheet to be used in DMT, to do this, I need the field name of “Override Default GL Account” I can’t find it anywhere for love nor money - if anybody knows I would be massively grateful.
thanks!
Welcome to the forum, Alex!
What table are you DMTing against? GLs are used all over the place. Not sure where to start looking to help you find an answer.
1 Like
Hi David thanks so much for your response, I believe it’s getting DMT’d into AR Invoice combined, the actual GL Field name I need is within AR Invoices, in Line/Detail.
thanks!
You could test against this one…
… actually, I highlighted the wrong one… you need the EpiBinding.
Try this one on AR Invoice Combined template:
2 Likes
Thanks David, that’s really helped!
I feel like i’m looking in the right direction now, unfortunately when I’ve filled the sheet out under the “InvcDtlTGLC#GLAccount” Epicor doesn’t seem to like the format, as when I DMT the sheet - all columns Validate but when I “Process” it, Epicor says “Please review GL Account format” - Apologies, im very new to all this haha
Use the pipe symbol.
We use dots in the UI (1300.RID.00), but in a DMT, I think it has to always be the pipe (1300|RID|00).
(Shift + backslash, that’s the key above the Enter key… usually.)
1 Like
I took a look at our GL control accounts and the pipe is the separator for each of the segment values…
