Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Project transaction show wrong cost from purchase order

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
    Ludwig Reinhard 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

  • 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 ?

  • 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
    Huzaifa Mala 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

  • 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
    Ludwig Reinhard 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

  • 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.

  • 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
    Pravasti AK 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
    Ludwig Reinhard 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

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans