What’s the trick to get the GL Accounts populated on the PO Release DMT file? I’ve seen some chatter regarding the GLCTranNum. So, I added that as a column but leaving it blank didn’t work, populating numbered values all the way down didn’t work (started with 1 and continued from there).
Any ideas? All other relevant data from the load seemed to take so it’s not the entire file that’s the problem; just need some direction on how to get the preferred GL Accounts to the Releases.
1 Like
You probably already know this, but not all releases get accounts. Lines for inventory do not, for example. I don’t think I have ever tried to populate it with DMT, though.
I just made a massive BAQ a couple weeks ago for accounting so they could know what account went with each release.
A snip of part of the logic I had to do:
Thank you for the feedback but all of my lines are bought to OTHER so it’s imperative that I include GL Account info in my DMT loads. I’ve tried removing the separators, changing the separators, etc. No matter what I do I just can’t get a good return on these file runs. The GL Account is valid/active.
1 Like
Well I don’t know off hand then. Had to ask.
No worries. Really do appreciate your responding at all. DMT fun 
1 Like
In the DMT file for PORel, there are additional fields related to POReoTGLC# which appear to relate directly to the TranGLC table. If I look at an existing database and link the two tables in a BAQ, it appears where there is an entry in the TranGLC for records related to PORel it also appears on the PO Release as the GL Account. Is this what need?
1 Like
Quick workaround, setup a part class expense specific, then your PO Rel DMT should include the field ClassID and should automatically pick the account assigned to that class.
3 Likes
Good idea Juan
I don’t know that I would call it a workaround but in the past we have made it a part of our setup in Epicor. We will create a Part Class specifically for Expense Items and assign at the Part level so that the appropriate GL Account is assigned on the PO. For incidences where the PO is for a part-on-the-fly, we have required the Part Class on the PO Line. Therefore, for the PO Line to be saved, a Part Class needed to be selected in our case the Expense Class. Just another approach.
In the PORel DMT upload, you need these fields IN ADDITION to whatever you have on the PORel itself:
PORelTGLC#Company (set to your CompanyID)
PORelTGLC#RelatedToFile (set to PORel)
PORelTGLC#Key1 (set to the PO Number)
PORelTGLC#Key2 (set to the PO Line number)
PORelTGLC#Key3 (set to the PO Release number)
PORelTGLC#BookID (set to your Fiscal Book)
PORelTGLC#COACode (set to your COA Code)
PORelTGLC#GLAccount (set to your GL Account number with segments separated by the | (pipe) character)
OR instead of using the GLAccount field you can use
PORelTGLC#SegValue1
PORelTGLC#SegValue2
PORelTGLC#SegValue3
and set the values to the various segments, using as many segments as necessary
1 Like
I have gotten it to work using the PO Combined template. I used the following columns:
Company
PONum
VendorVendorID
PODetail#POLine
PODetail#PartNum
PORel#PORelNum
PORelTGLC#RelatedToFile
PORelTGLC#Key1
PORelTGLC#Key2
PORelTGLC#Key3
PORelTGLC#TGLCTranNum
PORelTGLC#BookID
PORelTGLC#GLAccount
PORel#TranType
I used 0 for all TGLCTranNums and ‘|’ delimitators for the GLAccount column. If I recall correctly, the column that finally made it work was the PORel#TranType column. Just adding that and setting it to PUR-UKN seemed to do the trick.
2 Likes