Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Projects set up with i...
Microsoft Dynamics AX (Archived)

Projects set up with incorrect Project Group, how to get figures onto new correct projects?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi all,

We have a handful of projects incorrectly set up using a Fixed Price Project Group.  they have some transactions and estimates on them already.  These should have been set up with a new Time and materials Project Group.  AX doesn't allow me to change the Project group without reversing the estimates (which I do not want to do as journals to fix this have already been made in the General Ledger.)

If we set up new replacement projects in the correct way, how do I use the Beginning balance journals to get the correct figures onto the new projects? Or are there any other suggestions?  I have mostly 'hours' transactions plus a few 'expenses'. Can I do a total journal for all the hours in one and all the expenses in one rather than line by line for each timesheet posting?  We will not be needing to raise project invoices on these projects, we are just capturing the costs.

Any ideas welcome

thanks

*This post is locked for comments

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Projects set up with incorrect Project Group, how to get figures onto new correct projects?

    Hi AXF,

    I'm not sure what will happen with the estimates. Never had the situation to correct the project related to fixed price projects. Probably you have to create a new estimate that will then recognize it should create new (reversing) transactions. But indeed, you can test it.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Projects set up with incorrect Project Group, how to get figures onto new correct projects?

    Thanks both,

    Can I adjust the transactions onto the new projects without having to reverse the estimates?  We have already reversed the effect of running the estimates in the General Ledger over the last couple of months, and would have to then effectively cancel out the reversal in the GL too.  I didn't know I could move transactions via an adjustment, thought it would have to be a project journal, will do some testing.

    regards

    AXF

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Projects set up with incorrect Project Group, how to get figures onto new correct projects?

    Hi,

    Agree with Andre, the project adjustment functionality seems to be the right one to shift the costs to the new project.

    You also want to reverse all your estimates to ensure that the estimate vouchers are canceled.

    The beginning balance journal does not create any ledger vouchers and won't really help eliminating what has been posted on the old and errorously setup project.

    Please test this process in a demo/test environment first before doing this in your live system.

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Projects set up with incorrect Project Group, how to get figures onto new correct projects?

    Hi AXFinance,

    You can try to use the adjust functionality to change the project on the posted transactions. Test it in a separate environment. I'm not sure if this works between different type of projects. If it works, it will also create required accounting transactions.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans