Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Project transaction show wrong cost from purchase order

(0) ShareShare
ReportReport
Posted on by

I have created a project Purchase order, project type time and material, I have created a purchase order from the project for a purchase category.

Purchase line is qty 1 unit price $100.00, Two way matching only.

The invoice is for $96.00 and is posted against the PO.

The project transactions show a cost of $100.00 not $96.00.

Can anyone explain why?

*This post is locked for comments

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Project transaction show wrong cost from purchase order

    Hello Sherif,

    This post is almost 3 years old and most probably related to a different system version.

    Would you please be so kind and create a new thread where you provide some information about your system version and some supporting screenprints.

    Many thanks,

    Ludwig

  • Project Sales order Profile Picture
    65 on at
    RE: Project transaction show wrong cost from purchase order

    Dear John.Holbrook

    Do u solve this issue ?

    i face the same when i upload item requirement not insert it manual any suggestions ?

  • John.Holbrook Profile Picture
    on at
    RE: Project transaction show wrong cost from purchase order

    Huzaifa

    I am one step removed from this issue now but I believe that Microsoft have recognised it as a bug and are working on a fix.

    John

  • Huzaifa Mala Profile Picture
    65 on at
    RE: Project transaction show wrong cost from purchase order

    Hi John,

    Can you confirm if the physical value check box is selected on the item model group settings?

    I am facing same issue but with lower value than the invoice.

    Did you get reason from the developer after debugging the code?

    Thanks,

    Huzaifa

  • John.Holbrook Profile Picture
    on at
    RE: Project transaction show wrong cost from purchase order

    Ludwig

    No receipt just invoice on the PO.

    So it looks like I have to get a developer to check the code.

    Thanks for your suggestions.

    John

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Project transaction show wrong cost from purchase order

    Hi John.Holbrook,

    Are you also posting product receipts for your procurement categories?

    If this is the case, can you check whether you have set up a procurement policy for your categories (category policy rule) in the procurement and sourcing module?

    Just want to verify whether you have the parameter 'accrue purchase expense on receipt' parameter activated for your categories or not.

    Otherwise, I would suggest that you ask a developer for some help to look deeper into this. I have not found a hotfix on LCS, so the behavior you experience might be because of a bug or something we overlooked.

    Best regards,

    Ludwig

  • John.Holbrook Profile Picture
    on at
    RE: Project transaction show wrong cost from purchase order

    Ludwig

    Thanks for confirming what I believe should happen.

    I can replicate this for any purchase category on any project.

  • John.Holbrook Profile Picture
    on at
    RE: Project transaction show wrong cost from purchase order

    Kavitha

    There is no tax setup for this transaction tax is 0

    the invoice number is unique and not used in other tranactions

  • Suggested answer
    Pravasti AK Profile Picture
    2,985 on at
    RE: Project transaction show wrong cost from purchase order

    the reason of wrong calculation is wrong setup.

    1st : check the sales tax code properties

    path : GL – Setup – sales tax- sales tax code

    2nd: at sales tax group.

    check the use tax checkbox, if it is not checked

                                       (or)

    The above error is due to same PO Invoice number is used in other transaction.

    user might have create two number sequence but the prefix/Postfix might be similar to both number sequence.

    for example :

    In this case number has created two different number sequence one for project invoice and other for purchase invoice.

    example :

    PO invoice :- PINV/16/######

    Project invoice :- PINV/16/######

    Now in this case user has to change the prefix in one of the number sequence and then it will work fine.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Project transaction show wrong cost from purchase order

    Hi John.Holbrook,

    AX should pick up the $96 and not the $100 if the invoice is posted with $96.

    Not sure what is wrong there. Maybe some 'hidden' charges that you overlooked, some taxes, ... ?

    Can you replicate the issue for other charge categories or is only one charge category affected?

    Did this issue happen one time only or does it happen all the time?

    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,278 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,011 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans