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
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?
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.
Hi Mariam,
I want the same solution.
Kind regards
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156