How to: Update 1 financial dimension of ledger dimension in D365FO in X++

 I received a request to update the cost center financial dimension for the posted GL transactions for the fixed asset depreciation journal. There was an issue with master data, and the default financial dimensions were corrected after the journal was posted.  Below is the job that I created to update the FD on the Ledger dimension using the default dimension. 


public static void main(Args _args)

    {

        GeneralJournalAccountEntry          GeneralJournalAccountEntryUpd;

        GeneralJournalEntry                 GeneralJournalEntryUpd;

        AssetTrans                          assetTrans;

        AssetBook                           assetBook;

        DimensionAttribute                  dimAttr;

        DimensionAttributeValueSetStorage   defaultDimStorage;

        DimensionAttributeValue             dimAttrValue;

        DimensionAttributeValueSetStorage   newDimStorage;

        RecId                               newDimSetRecId;

        RecId                               mergedLedgerDim;

        str                                 dimValue;

        ttsBegin;

        while select forUpdate GeneralJournalAccountEntryUpd

            where  (GeneralJournalAccountEntryUpd.PostingType == LedgerPostingType::LedgerJournal)

            join GeneralJournalEntryUpd

            where GeneralJournalEntryUpd.RecId          ==  GeneralJournalAccountEntryUpd.GeneralJournalEntry

&& GeneralJournalEntryUpd.SubledgerVoucherDataAreaId == "US01"

&&  GeneralJournalEntryUpd.SubledgerVoucher like "DPL-00*"

        {

            select firstonly assetTrans where assetTrans.Voucher == GeneralJournalEntryUpd.SubledgerVoucher && assetTrans.DataAreaId == GeneralJournalEntryUpd.SubledgerVoucherDataAreaId;

            select firstonly assetBook where assetBook.AssetId == assetTrans.AssetId  && assetBook.DataAreaId == GeneralJournalEntryUpd.SubledgerVoucherDataAreaId ;

            dimAttr = DimensionAttribute::findByName('CostCenter');

            defaultDimStorage = DimensionAttributeValueSetStorage::find(assetBook.DefaultDimension);

            dimValue = defaultDimStorage.getDisplayValueByDimensionAttribute(dimAttr.Recid);

            dimAttrValue = DimensionAttributeValue::findByDimensionAttributeAndValue(dimAttr, dimValue, false, true);

            newDimStorage = new DimensionAttributeValueSetStorage();

            newDimStorage.addItem(dimAttrValue);

            newDimSetRecId = newDimStorage.save();

            mergedLedgerDim = LedgerDimensionFacade::serviceCreateLedgerDimForDefaultDim(newDimSetRecId,GeneralJournalAccountEntryUpd.LedgerDimension);

            GeneralJournalAccountEntryUpd.LedgerDimension = mergedLedgerDim;

            GeneralJournalAccountEntryUpd.LedgerAccount   = DimensionAttributeValueCombination::find(GeneralJournalAccountEntryUpd.LedgerDimension).DisplayValue;

            GeneralJournalAccountEntryUpd.MainAccount   = DimensionAttributeValueCombination::find(GeneralJournalAccountEntryUpd.LedgerDimension).MainAccount;

            GeneralJournalAccountEntryUpd.DoUpdate();

            info(strFmt("%1",GeneralJournalAccountEntryUpd.RecId));

        }

        ttscommit;

    }

Hope this helps someone.



Comments

  1. JackAugust 20, 2026 at 11:13 AM

    This comment has been removed by the author.

    ReplyDelete
  2. JackAugust 20, 2026 at 11:16 AM

    I would like to understand whether it is technically possible to update a value in the GeneralJournalAccountEntry table through custom X++ code using doUpdate() without any access restricted error thrown

    Microsoft documentation states:
    "Dynamics 365 Finance defines the books of accounts as the official accounting entries that are created and posted to the general ledger. The accounting entries are stored in the GeneralJournalEntry and GeneralJournalAccountEntry tables, together with their related references. The transaction records contain date, amount, text, creation date, and created-by fields. An accounting entry can be corrected only by adding new reversing and correcting entries, not by changing the existing records. Dynamics 365 Finance doesn't provide any way for users to alter these records."

    Based on the above statement, my understanding is that users cannot modify these records through standard application functionality. However, is it still possible for a developer to update records in the GeneralJournalAccountEntry table directly using custom X++ code or other backend methods (I'm a system admin) without throwing an access resticted erroe thrown.

    Additionally, if a record is updated directly in the backend and Database Logging has not been configured for this table, would there be any audit trail or logging available to identify that the record was modified, including details such as who made the change and when it was changed?

    I would appreciate your help in clarifying this.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to: Get ledger dimension from string in D 365 FOE

I came across a requirement where financial dimensions were coming in XML from integration and Account number was to be determined using business logic. I had to create a general journal from this integration. So situation is : Find the account number from business login in D 365. Get the financial dimensions from integration. Create a journal line from above info. Code to do above is as follows: DimensionDynamicAccount ledgerAccount; switch(<AccountType>) { case (LedgerJournalACType::Cust) : ledgerJournalTrans.AccountType = LedgerJournalACType::Cust; ledgerAccount = LedgerDynamicAccountHelper::getDynamicAccountFromAccountNumber(<AccountNum>, LedgerJournalACType::Cust); ledgerJournalTrans.LedgerDimension = ledgerAccount; break; case (LedgerJournalACType::Ledger) : ledgerJournalTrans.AccountType = LedgerJournalACType::Ledger; ledgerAccount = LedgerDefaultAccountHelper::getDefaultAccountFromMainAccountRecId(MainAccount::findByMainAccount...
Read more

How to: Use enum values instead of integers in BI reports for Dynamics 365 finance and operations

Image
For most of the BI projects related to Dynamics 365 finance and operations, We need to use BYODW to use Power BI or any other BI tools. As we know, enum fields are stored as integers in SQL, so data populated in BYODW comes as integers instead of the enum value. To display this data either you can hardcode values in SQL statements or in BI tools. Instead, we can use SRSAnalysisEnumsEntity in Dynamics 365 F&O. It exports the data from the SRSAnalysisEnums table which holds all the enum and respective enum elements used in perspective. If the enum is missing from the list then below job can be used to insert the data in SRSAnalysisEnums table. class SRSAnalysisEnumsGenerator {     public static void main(Args _args)     {         SRSAnalysisEnums analysisEnums;         DictEnum currentEnum;         str currentEnumName;         int valueCount;       ...
Read more

How to: Import Bank statements from Azure file storage to Dynamics 365 finance and operation using Power automate (formally flow)

Image
We had a requirement for importing of bank statements in Dynamics 365 Finance and Operations using integration. We achieved this using the recurring data jobs in D 365 and Microsoft Power automate. There are basically 3 parts to all the configuration 1. Azure app for authentication. 2. Data processing group and recurring data job in D 365 3. Power automate app for the integration 1. Azure app for authentication Create an Azure app for authentication as follows:     Search for App registration on  https://portal.azure.com/ Create a new app: Copy the app id, we will need this for configuration in D 365 and flow. Create a new secret and copy it. Copy the value of the secret. Now we have all the required information from the Azure portal. Let us switch to Dynamics 365 F&O. 2. Data processing group and recurring data job in D 365 F&O Configure the Bank statement import setup using the steps mentioned in  https://docs.micros...
Read more