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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

André Arnaud de Cal... 301,088 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 301,088 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No