Required T-Code does not prepopulate in Excel Add-On batches

I have made the settings that each revenue and expense account transaction requires a T-Code (for location). I have large Excel worksheets of payroll data that I manipulate to import via the Excel add-on every other week. T-Code (for location) does not prepopulate, I must manually enter T-Code location for every single line, this entry is 4 pages long in webview. This creates additional data entry work and increases the probability of data entry ERRORS.

  • Guest
  • Jul 17 2020
  • Needs review
  • Attach files
  • barnett helzberg commented
    2 Oct, 2020 01:36pm

    We're only now just moving to NXT, so for our Finance users, this issue makes the excel add-on feels like a downgrade in functionality. I've setup a macro enabled journal entry template file (xltm) to help smooth this over, but dealing with macros brings a different set of issues. Hoping blackbaud will put my macro out of business soon!