Financial dimensions in Excel with general journal in Microsoft Dynamics 365 Finance and Operations
Rahul Mohta
21,032
Like
Share
ReportFinancial dimensions in Excel with general journal in Microsoft Dynamics 365 Finance and Operations
Download document template 'LedgerJournalLineEntryTemplate.xlsx' and click on design and edit the journal lines table source in Excel
Select below set of fields for main account financial dimension, main non-ledger account (customer, vendor, project....) default dimension financial dimension and like wise for offset as well
Select fields and add and then update Excel template
Below is set of fields typically needed
| Date | |
| Company | |
| Currency | |
| Account type | |
| Main account | |
| FD for ledger account | Account.BusinessUnit |
| Account.CostCenter | |
| Account.Department | |
| Account.ProductionUnit | |
| Non-ledger account | |
| FD for customer/vendor | Account dimensions.BusinessUnit |
| Account dimensions.CostCenter | |
| Account dimensions.Department | |
| Account dimensions.ProductionUnit | |
| Description | |
| Debit | |
| Credit | |
| Offset company | |
| Offset account type | |
| Offset Non-ledger account | |
| Offset main account | |
| Offset account.BusinessUnit | |
| Offset account.CostCenter | |
| Offset account.Department | |
| Offset account.ProductionUnit | |
| Do not change | Line number |
Upload with same template name 'LedgerJournalLineEntryTemplate.xls' , allow override and then create a general ledger journal and open in Excel and create lines with financial dimensions and then publish.
Upon successful publish from Excel, in D365FO below is how financial dimensions shows up in lines
*This post is locked for comments