Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Item shipped with wrong price, attempting to use undo posted purchase receipt/create purchase credit memo

Posted on by 55

Hi Everyone,

As there was a purchase order that had the wrong price info, so I am attempting to undo/correct this. The item has already been shipped and a purchase receipt has been posted.

I looked around and current solutions include:

1. Undo the posted purchase receipt 

2. Create a purchase credit memo manually by using copy document or get posted document lines to reverse

However when I was attempting to undo the posted purchase receipt, an error appeared: "remaining Quantity must be equal to 'x' in Item Ledger Entry: Entry No.=xxx. Current value is '0'. "

Manually creating a purchase credit memo also generates a similar result: I have insufficient quantity of Item on inventory.

What is the best solution for this in order to change the incorrect price?

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Item shipped with wrong price, attempting to use undo posted purchase receipt/create purchase credit memo

    The best thing for you to do would be to process a purchase return ad documented here:

    learn.microsoft.com/.../purchasing-how-process-purchase-returns-cancellations

  • Suggested answer
    Manish Prasad Profile Picture
    Manish Prasad 315 on at
    RE: Item shipped with wrong price, attempting to use undo posted purchase receipt/create purchase credit memo

    Hello Dopnez,

    There are two ways to solve this issue. Hope it will help you.

    1: If you don't want undo the shipment or reverse the sales invoice if it is posted. You can add the stock of the item on same date then undo the receipt and then post with correct value. This only works when you are not using item tracking or advance warehousing.

    2: If you haven't posted purchase invoice for the receipt, you can post the purchase invoice with correct price on the purchase invoice line. It will correct the actual value of the receipt to be posted on the posted document for the purchase.

    If my answer helped you, maybe it can help others. Please verify it, so other users know it worked or helped you.

    Thank you.

  • Dopnezz Profile Picture
    Dopnezz 55 on at
    RE: Item shipped with wrong price, attempting to use undo posted purchase receipt/create purchase credit memo

    Hi Nitin,

    Yes there is a sales shipment in the item ledger entry, once I undo the sales shipment, should I manually create a credit memo and change the item price? since I am still unable to undo the posted purchase receipt. (Still the same error with remaning quantity needs to be x, current quantity 0.)

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: Item shipped with wrong price, attempting to use undo posted purchase receipt/create purchase credit memo

    Hi,

    This problem arise when someone has consumed that quantity after your Posting of Purchase receipt, either by Sales Shipment or Item Journal.

    You need to make sure this first. If its true, you can do undo receipt of that qty.

    Thanks.

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