I am trying to DMT load PO Releases using the Buy For Tran Type of - Other and loading in a GL Account.
I am unable to find the correct way to load the GL Account using the Purchase Order Release in DMT.
The DMT template builder offers a PORelTGLC#GLAccount. This is very close the the actual field name of PORelTGLC.GLAccount. This is my first guess.
I have loaded what I can pull for the field in a BAQ of - 20020|100|100. Acount, Location, Dept.
I have loaded 100-100-20020. Same data in how it looks on the screen.
DMT loads my data. No errors. However, my GL Account in the Release remains the Default GL account - Suspense.
Has anyone successfully loaded the GL Account?
Scott
Realize replying to old question but for any future users doing a DMT these two fields have to be added PORelTGLC#TGLCTranNum and PORelTGLC#BookID as well as POReITGLC#GLAccount.
I was testing DMT on updating some GL Account code and hoping this will help others. I was using DMT 10.2.500.12
Make sure the PO Released is Open
Make sure the PO Header is not Approved
DMT will NOT show any errors even though the GL Account didn’t update as the Approved flag actually blocked the update
Here is the list of DMT field that is required for updating GL Account. GL Account uses ‘|’ internally rather than ‘-’, I also added the ReOpenRelease to 1 to make sure Releases are open.
Company ReOpenRelease PONum POLine PORelNum TranType PORelTGLC#TGLCTranNum PORelTGLC#BookID PORelTGLC#GLAccount