web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Update Old Transaction...
Microsoft Dynamics AX (Archived)

Update Old Transaction Data Using New Account Structures

(0) ShareShare
ReportReport
Posted on by Community Member

Dear experts,

Per 01 March 2018 my company has decided to change the account structures.

The old account structures :
MainAccount-BusinessType-Location-Department-TransactionType-BudgetCodes

New Account structures:
MainAccount-LegalEntity-BusinessType-BusinessVertical-Department-Project

The problems are:

  1. There are transactions that occur during January 2018 to February 2018 that still use the old structure.
  2. Per 01 March 2018 the finance manager has changed the financial dimension values for the Department dimension. The old values use numbering as dimension value and it's all now suspended. The new values use code as dimension value. Example : 00001 - IT Department is changed to IT - IT Department.

Management asked me to update these transactions so that those transaction use the new financial dimensions without being done manually. Is it possible to do that by either by functionality or technically? Need your advice please.

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    As you are operating in a running system you will have to create new correction vouchers and post them.

    How many transactions are affected?

    Are these only GL transactions or also transactions that occurred in subledgers?

    Best regards

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Unfortunately,  the transaction occurred both in GL and in subledgers. I am not sure how many transactions are affected, but I expected to avoid any manual process as create new correction vouchers because from my management perspectives it will consume a lot of time to do that and prone to human error. Is there any way to do that like update directly from the database perhaps?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Haryo Bergas,

    I would not recommend manipulating accounting records at the database level. This might result in trouble with your financial auditors if you do that.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    I understand your concern. Can you explain about the voucher correction?

    I have an example:

    Existing voucher (status posted) as follows:

    Ledger account Debit Credit
    520003142-10-HO-01-OPEX-CV01 100
    110101101-10-HO-01-OPEX-CV01 100

    How does the correction voucher form? Is it like this:

    Ledger Account Debit Credit
    520003142-FRM-10-LOYALTY-IT-CV01 100
    110101101-FRM-10-LOYALTY-IT-CV01 100
    520003142-10-HO-01-OPEX-CV01 100
    110101101-10-HO-01-OPEX-CV01 100

    The lines with the blue color are the correction line and the lines with the red color are the reversal lines.

    Need your advice please

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Haryo,

    Yes, that is what I would consider a 'normal' financial correction posting.

    You will have to post the red colored lines first with the old structure still active.

    Then activate the new account structure and then post the new lines.

    All lines cannot be posted at the same time with the same account structure active.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Crispin,

    Thank you for your reference. You've give me an alternate solution for my problem. Currently my technical team is testing it.

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    I can use your solution, but I still have a problem with Year End voucher. Since I can't reverse it by using Reverse Transaction button in AX, the only way to re-create the voucher is by re-run Year End Process. If I re-run the Year End Process with new account structures,  will it generate a YEC voucher with a new account structures?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Haryo Bergas,

    I would expect that the new account structure is used for the YEC voucher if you re-run the process.

    Have you tried doing that in a demo/test environment?

    Did it work ok or did you get an error message.

    If everything worked ok in demo/test, probably discuss the outcome with your accountants to ensure that they are happy before doing that in live.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Dear Ludwig,

    Yes, I have tested in test environment and everything worked well after re-run process. Thank you for the solutions.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 26

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans