Finance | Project Operations, Human Resources, ...

Replacing main account in ledger dimension

(1) Share

Report

Posted on by MariamW

hello,
I tried this method:

GeneralJournalAccountEntry GTabl;

ttsbegin;

update_recordset GTabl
setting LedgerDimension = LedgerDimensionFacade::serviceCreateLedgerDimension(LedgerDefaultAccountHelper::getDefaultAccountFromMainAccountId('200999'),LedgerDimensionFacade::getDefaultDimensionFromLedgerDimension(GTabl.LedgerDimension)) where GTabl.RecId==5637145040;

ttscommit;

to change the main account of ledger account but it's not working .

thanks

kind regards

I have the same question (0)

All responses (3)

Answers (0)

Sort by

L 31 on at

Like (1)

Report
Copy link

Link copied!

Hi Mariam,

I want the same solution.

Kind regards

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 305,196 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi MariamW, ChahrazadK,

The GeneralJournalAccountEntry table contains posted transactions. It is not allowed to just change the contents of this table using a script. This is according to international accounting rules. Or do you have permissions from an external auditor to do so? When making this change, you will create inconsistencies with the DimensionFocusBalance table and the Financial Reporter might not be aware of it. If the entry comes from a subledger, then also other table references will have incorrect data.

My recommendation would be to create a reversing entry and then post the correct entry.

Was this reply helpful? Yes No
MariamW 46 on at

Like (0)

Report
Copy link

Link copied!

hello Thank you very much for your answer.

I just want to know , How do I find the Main account linked to items to set conditions and replace it with another Main account?

Was this reply helpful? Yes No