web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Adjusting (expected) c...
Microsoft Dynamics NAV (Archived)

Adjusting (expected) costs of uninvoiced purchase orders

(0) ShareShare
ReportReport
Posted on by Richard Xpol 201

Hi,

I hope somebody can help me with the issue below. Is it in any way possible to adjust the (expected) costs for a purchase order which is received, consumed but at an incorrect price?

I do have a purchase order which is received and the quantity is consumed. However, the purchase price of the bought item was incorrect in the system. Therefore, the actual cost of the consumption and sales is incorrect. Is it possible to adjust it without posting the purchase invoice? As in our industry it can take some time before we receive a proper invoice...

Thanks for the support.


Regards,

Richard

*This post is locked for comments

I have the same question (0)
  • Verified answer
    mmv Profile Picture
    mmv 11,471 on at
    RE: Adjusting (expected) costs of uninvoiced purchase orders

    Hi,

    Sorry, I didn't notice that the entries were consumed.  

    Perhaps, you may try this way, you may create another Purchase Order with correct Unit Cost and remove the application from of the Sales Shipment and apply to the new Purchase Receipt and undo the old Purchase Receipt and delete the same.

    If the above also is not possible, you may reverse everything (after posting the Invoice) by passing a credit note.

    Best Regards,

    MMV

  • Richard Xpol Profile Picture
    Richard Xpol 201 on at
    RE: Adjusting (expected) costs of uninvoiced purchase orders

    Hi,

    Is that possible when the quantity of the receipt is already consumed?

    Regards,

  • mmv Profile Picture
    mmv 11,471 on at
    RE: Adjusting (expected) costs of uninvoiced purchase orders

    Hi,

    My suggestion is to undo the Purchase Receipt and enter the correct cost and re-post it.

    Best Regards,

    MMV

  • Richard Xpol Profile Picture
    Richard Xpol 201 on at
    RE: Adjusting (expected) costs of uninvoiced purchase orders

    Hi,

    The reason is that in such occasions, my reporting (COGS) is incorrect. And as said, it can take sometimes 2 months to receive an invoice for the delivery. I can't wait for that to report.

    Regards,

  • mmv Profile Picture
    mmv 11,471 on at
    RE: Adjusting (expected) costs of uninvoiced purchase orders

    Hi,

    Why the expected cost is to be adjusted?  If there is a specific reason, we can find a work around.

    Best Regards,

    MMV

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,231 Super User 2025 Season 2 on at
    RE: Adjusting (expected) costs of uninvoiced purchase orders

    I will check if there is any other way, but the real question why do you even want to modify the expected cost, since when get your actual invoice and when you post that it gets cleared with Actual Cost.

  • Richard Xpol Profile Picture
    Richard Xpol 201 on at
    RE: Adjusting (expected) costs of uninvoiced purchase orders

    I saw that my screendump doesn't work. The message was "Completely invoiced must be Yes in Item Ledger Entry Entry Type No. = '233337'"

  • Richard Xpol Profile Picture
    Richard Xpol 201 on at
    RE: Adjusting (expected) costs of uninvoiced purchase orders

    Hi,

    I have tested it, but the following error message appeared:

    and that is the issue, it can take a while before we get the invoice from our supplier.

    Regards,

    Richard

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,231 Super User 2025 Season 2 on at
    RE: Adjusting (expected) costs of uninvoiced purchase orders

    I have not tested this, but try Revaluation Journal for the inbound transaction using Applies to Entry No.

    Please test this in your test database first.

    There is one similar example in our blog 

    http://www.archerpoint.com/blog/Posts/revaluing-inventory-microsoft-dynamics-nav-revaluation-journal

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans