Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / 'No transaction up...
Microsoft Dynamics AX (Archived)

'No transaction updated' when trying to do project adjustment

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

We have some project transactions with the wrong funding source after it was changed on the project so they do not show up on the invoice proposal to the new customer.

When doing a project adjustment I can see that the proposed adjustment has picked up the default funding source now and appears correct.  I click Post and get the message 'no

transaction updated for transaction xxx' and it doesn't do anything.

The PMA parameters tick box to 'always create adjustment transaction' is ticked.  I have a feeling we need to make a change to the sales or cost price to force the adjustment to actually post?  I don't want to change these.  I have tried ticking/unticking all the options on the adjustment form to no avail.

Do I have to make a change to the numbers and then adjust them back to the correct numbers again to force it to pick up the current funding source on the transaction?

(AX 2012 R3)

thanks

AXF

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: 'No transaction updated' when trying to do project adjustment

    Hi AXF,

    Can you double check that in a demo system?

    I simply posted some transactions, switched the contract, posted the adjustment with the funding source update and created the invoice.

    This was in an R3 CU10 system.

    Just wondering whether something else might prevent the adjustment posting.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: 'No transaction updated' when trying to do project adjustment

    sadly not, I've tried ticking the Funding source box with or without the other boxes, and the adjustment shows the change in the bottom half of the screen correctly, but then fails to post, 'no transaction updated'.

    regards

    AXF

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: 'No transaction updated' when trying to do project adjustment

    Hi AXF,

    I tried duplicating that and was able to post the adjustment with the new project contract selected.

    The project invoice was originally not created.

    Only after posting the adjustment with the parameter 'funding source' selected the new funding source got updated and I could create the invoice.

    Can you test if that works the same in your environment?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: 'No transaction updated' when trying to do project adjustment

    They simply change the Project Contract ID on the project from one to another in the drop down list.  There appear to be no restrictions on this.

    regards

    AXF

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: 'No transaction updated' when trying to do project adjustment

    Hi AXF,

    Changing the funding source is actually not possible without any 'manipulation' if transactions have already been posted.

    Can you find out more how the change was made?

    I fear that some manipulations have been made at the database level that cause this issue.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: 'No transaction updated' when trying to do project adjustment

    all I can say is that the project was set up with an incorrect funding source which was then changed on the project to the correct one ( changed from one existing funding source to another one).  The first few transactions show the original funding source prior to the change.  I cannot say with any more detail than this exactly how it was done.

    regards

    AXF

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: 'No transaction updated' when trying to do project adjustment

    Hello AXF,

    Can you describe in more detail how the funding source was changed?

    Has a new one been setup or the existing one been changed?

    How has this been done exactly?

    Best regards,

    Ludwig

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans