Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Spent amount in Project contract in AX2012 Project accounting

(0) ShareShare
ReportReport
Posted on by 520

Hi,

I created a new Project with Grant as the funding type.

I enter funding limit in Project contract.

I created an on-account transaction equal to funding limit, create invoice proposal for the on account and post the transaction.

When I check the project contract, the Spent amount was updated by the on-account transaction.

Should the on-account transaction update the Spent amount in project contract?

The on-account transaction is an advance payment made by the customer and should not update the Spent amount in project contract.

My issue here is I cannot create a Purchase order because the funding limit is already consumed by the on-account transaction.

Now I created a reversal of the on-account transaction so that I can create a Purchase order but the system did not allow me because the Spent amount in project contract did not update with the reversal of on-account transaction.

The error message when I create a Purchase order is as follows:

Revenue could not be allocated. Verify that funding rules have been set up to allocate the revenue'

I'm using AX2012 R3.

Pls advise.

Thanks.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Spent amount in Project contract in AX2012 Project accounting

    Hi marypeace,

    Please open a support case then and let us know the outcome.

    Much appreciated.

    Cheers,

    Ludwig

  • marypeace Profile Picture
    520 on at
    RE: Spent amount in Project contract in AX2012 Project accounting

    Hi Ludwig,

    Sorry but I believe it is a bug :)

    I already reversed the transaction but the spent amount was not updated.

    Anyway, thanks for your reply.

  • Suggested answer
    MauricioSaldana Profile Picture
    on at
    RE: Spent amount in Project contract in AX2012 Project accounting

    Hi Marypeace,

    The logic is that if the customer already paid the full amount that you setup on the funding limit you cannot create a purchase order with a billable category, because that will exceed the limit customer needs to pay. Check if by changing the line property on the PO (not billable) you can carry on with the process.

    Thanks

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Spent amount in Project contract in AX2012 Project accounting

    Hi marypeace,

    I don't know if this can be called a bug.

    I would rather call it 'works as designed'.

    Best regards,

    Ludwig

  • marypeace Profile Picture
    520 on at
    RE: Spent amount in Project contract in AX2012 Project accounting

    Hi Ludwig,

    Is this a bug?

    I made an adjustment in funding limit, I double the amount but is this the proper way of doing it?

    Thanks.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Spent amount in Project contract in AX2012 Project accounting

    Hi marypeace,

    I would suggest to manually adjust the funding limit and then try to get the PO created.

    This should bring you over the error message 'hurdle'.

    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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,274 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,947 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans