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

Post a Comment

Popular posts from this blog

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

How to : get the Deep URL for a particular form with filter in Dynamics 365 Finance and Operations

Image
 If you are a developer and need to generate the Deep-link then you can follow the code mentioned in MS docs at https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/user-interface/create-deep-links But if you want to share a few URLs with filters already applied to other users then you can use the feature of  'Get a link' in D365FO. Suppose I want to share the list of all sales orders for customer 'US-001'. Go to Account Receivable -> Orders -> All sales orders  Filter by customer account 'US-001' Then in the navigation ribbon, go to Options and click on 'Get a link'   Copy all and paste the URL into new browser window. You will only see the sales orders for US-001. If you want to generate lot of deep URLs then you can also enable  'Automatically update query parameter' Once you enable this, as soon as you apply a filter on forms URL will be updated with the query parameters like below: You can copy and share the link directl...
Read more