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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

How to correct Purchase Order line pricing after receipt

(0) ShareShare
ReportReport
Posted on by 74

We have a few purchase orders (approx. 100) that have some incorrect line item pricing.  The purchase orders are received but not yet invoiced because of the incorrect lines.  Can a configuration package be used to export, edit, and import to update the purchase order lines?  

I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    95,329 Super User 2025 Season 2 on at

    Hi, If the line is not fully received, you can reopen the order and modify the price directly.

    pastedimage1641339784794v1.png

    pastedimage1641339802606v2.png

    pastedimage1641339817038v3.png

    But this will not affect the price that has been received.

    I suggest using the Undo in Posted Purchase Receipt to cancel the receipt first, and then edit the price on the purchase order and post the receipt again.

    pastedimage1641339931175v4.png

    Hope this will help.

    Thanks.

    ZHU

  • T Henry Profile Picture
    74 on at

    Hi Zhu,

    Thanks.  This helps understand the process of the posted purchase receipt.  Is there any way to do this in mass update? (config package, excel, code?) There are too many to do manually.  
    To further clarify I am trying to ensure when the purchase order invoice is created that the item prices will match the vendor.

  • Verified answer
    S.Kawamura Profile Picture
    1,530 on at

    Hi,

    If you want to open the status of about 100 purchase orders, you can filter the order number and status in the list page and click the "Reopen" button repeatedly.
    Edit in Excel doesn't work for reopen. Personally, I do not recommend using Configuration Package to open a status.
    pastedimage1641357023578v1.png

    After reopen, you can use Edit in Excel to correct the order line.
    pastedimage1641357193954v2.png

    pastedimage1641357319705v3.png

    I hope this is useful to you.

    S.Kawamura

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans