Sub-ledger accounts financial dimensions in Excel add-in in Microsoft Dynamics 365 Finance and Operations

Almost every implementation one needs to update the Ledger journal Excel template to allow financial dimensions to be used the ledger and sub-ledger

Simple steps to modify is to go to 'Document Templates', download the one 'LedgerJournalLineEntryTemplate' and then design to edit the journal lines and add in the financial dimensions.

Note for using financial dimensions for sub-ledger accounts viz. vendor/customer..... one should add the financial dimensions columns starting with Account dimensions.<<FD>>

e.g.  Account dimensions.BusinessUnit