Dynamics Community Forum Thread Details

How to combine default dimension into ledger dimension in X++

Hi,

In one of my task, I'm creating General Journal by code, and in each of Journal Line we have Account Type and if it is Ledger, the Account number field will need to be fill in with main account and its financial dimension ->

I have a custom table with list of account with its Financial dimension already setup.

Question is how to make my Journal line field Account is filled in with Main account with its Financial dimension ? So if I have the account 71120 setup with Fin Dim for example Department: AABB, Cost center: Cost1, the Account field should filled in as 71120-AABB-Cost1

During insert Journal line (LedgerJournalTrans) I have insert these 2 field in order :

ledgerJourTrans.DefaultDimension = MyTable.DimensionDefault;

ledgerJourTrans.LedgerDimension = LedgerDefaultAccountHelper::getDefaultAccountFromMainAccountId(MyTable.mainAccount);

If debug each line, MyTable record is filled in with the correct record I wanted. Only after insertion, and take a look at that General Journal, the Account field only show the main account, just like the picture.

May I know what is missing ?

Thanks

Quick Links