Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / High COGS when purchas...
Microsoft Dynamics AX (Archived)

High COGS when purchase order isn’t invoiced

(0) ShareShare
ReportReport
Posted on by HenkeNord 459

Hi

We are trying to close our books for this year, but got a problem on a trading item. The purchase is packing slip updated but not invoiced. However on the sales side it’s already delivered and invoiced. The problem is that the cost price of the item was set to a 10 times to high amount and since the purchase order isn’t invoiced it looks like the COGS is 10 times too high. I know (or I hope) this will be solved when the invoice is booked, but for now it looks like it will be delayd a few more days.

Two questions:

  1. Is there a way to have the cost price updated when the purchase order is packing slip updated?
  2. How should the cost price be updated in the best way when a new item is created? It’s easy to miss setting the cost price field manually and if you have a configurable item (with different cost prices per configuration) I really doesn’t understand how the correct cost price could be set.

Regards,
Henrik

*This post is locked for comments

  • guk1964 Profile Picture
    guk1964 10,877 on at
    RE: High COGS when purchase order isn’t invoiced

    You can change the price on the PO. However that needs a 'process' and is not something a storeman would normally do.

    The order might also be subject to change control to stop such changes.That might need a reapproval process.

    Presumably you would also need to reacknowledge the updated price with the vendor to sort out 3 way matching and legal liability.

  • HenkeNord Profile Picture
    HenkeNord 459 on at
    RE: High COGS when purchase order isn’t invoiced

    Yes, thanks Ludwig.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: High COGS when purchase order isn’t invoiced

    Hello Henrik,

    Have you been able to get this issue resolved in the meantime?

    Best regards,

    Ludwig

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: High COGS when purchase order isn’t invoiced

    Hello Henrik,

    Please test the parameter mentioned in a demo/test environment and let us know whether this fixed the issue.

    If everything is ok and nothing else open then please be so kind and verify the answers.

    Many thanks,

    Ludwig

  • HenkeNord Profile Picture
    HenkeNord 459 on at
    RE: High COGS when purchase order isn’t invoiced

    Thanks Ludwig, again…

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: High COGS when purchase order isn’t invoiced

    Hello Henrik,

    For 1: In the item model group there is a parameter called include phyiscal if I remember it correctly. If you tick this parameter cost prices will be updated with the packing slip posting. checking this parameter does, however, not impact your previous posting that has already been made.

    For 2: If you have a quote from your vendor then you can enter this price as a starting point in the item master. If you do not have such a price then you put an estimate there. Every estimate is in my opinion better as a price of $0.

    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