Where does GLTBDetail.GLAccountDesc come from?

The data definition for the Trial Balance report uses a magical black box called GLTBDetail that doesn’t seem to correspond to any one table or view. It has a field called GLAccountDesc that seemed to come from GLAccount.AccountDesc. However, when I updated some of the descriptions in GLAccount.AccountDesc, the values in GLTBDetail.GLAccountDesc did not change.

Where does GLTBDetail.GLAccountDesc come from?

Possibly related: I noticed we have a big yellow button in COA Maintenance labeled “Run Rebuild Display GL Accounts”. Exactly what does that button do?

That button rebuilds the GL account display name by combining the name of each segment.

If I had:

  • GL Acct 1151-11-01, with the display name manually set to GUTHRIE, INVENTORY

And account segment values:

  • Chart 1151 - with the display name RAW MATERIAL INVENTORY
  • Div 11 - with the display name GUTH
  • Dept 01 - with the display name GA

pressing the button would change the display name of account 1151-11-01 to:
RAW MATERIAL INVENTORY-GUTH-GA