Wednesday 6 January 2021

Create ledger dimension for LedgerJournalTrans, to use in LedgerDimension and OffsetLedgerDimension fields

This simple code below may be used, when you want to get a RecId for LedgedDimension of OffsetLedgerDimension field in LedgerJournalTrans table.
It is working in Dynamics AX 2012 and in Dynamics 365, but it is good to know that in Dynamics 365 it is rather obsolete, and it is advised to create ledger dimension value in different way.


container ledgerDimensionContainer;


RefRecId ledgerDimension;


//First two items in contaner is MainAccountId, in that example "430-01"

//Third element is number of dimensions which you want to use. In that example is '3'

//As fourth, sixth, eights, ...., you have to put dimension name. In that example are "Department", "CostCenter", "Project"

//As fifth, seventh, nineth, ...., you have to put dimension's values, in that example are "Warsaw", "IT", "Scrum"

ledgerDimensionContainer = ['430-01', '430-01', 3, 'Department', 'Warsaw', 'CostCenter', 'IT', 'Project', 'Scrum'];


ledgerDimension = AxdDimensionUtil::getLedgerAccountId(ledgerDimensionContainer);


//Here in ledgerDimension variable is LedgerDimension ready to use in LedgerJournalTrans table

return ledgerDimension;