I designed and saved my document template as (LedgerJournalLineTemplate_ST). In my example, it ends with _ST.
You will be able to see the new designed template when you use MS Office add in - Open in excel from General Journal page
When a template listed in the Common > Common > Office integration > Document templates form (DocuTemplate) has ShowInOpenInOfficeMenu set to Yes and has the same root datasource (table) as the current form, it will be added as an option in the Open in Excel section of the Open in Microsoft Office menu. The following image shows the Document templates form with two of my custom templates with "List in Open in Office" ticked.
If you've found this thread useful, dive deeper into User Group community content by role