Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Verified answer
    mmv Profile Picture
    mmv 11,467 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,467 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,467 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 47,789 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 47,789 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

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans