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...
Suggested Answer

How to find past Purchase order numbers

(1) ShareShare
ReportReport
Posted on by 526
Hello experts, 
 
How do you find a past purchase order number from the Item where we have received and invoiced purchase order items? 
We would like to see a past history of just our purchase documents for that item. 
I have the same question (0)
  • Suggested answer
    Ahmed Mohamed Rafik Profile Picture
    3,049 User Group Leader on at
    From the Item Ledger Entries list, find entries with a Type as Purchase and Entry Type as Receipt or Invoice.
    Select the entry and click Navigate → Document. This will display the related purchase documents, including the original purchase order number, vendor details, and dates. 
     
     
  • Suggested answer
    Valentin Castravet Profile Picture
    31,439 Super User 2025 Season 2 on at
    This isn't straightforward because the system deletes fully received and invoiced purchase orders. However, there are a couple of ways you can approach this:
     
    1. If the orders have not yet been deleted, you can go to the Purchase Lines page, filter by Order Type = Order and No. = Your Item No., which will provide a list of orders your item is on.
     
     
    2. If the orders are already deleted, and you received and invoiced directly from your purchase order, you can go to the Item Ledger Entries to find the posted receipt. Open the posted receipt, and in the Order No. field, you'll find the purchase order number.
     
     
     
    3. Another option is to enable purchase order archiving in the Purchases and Receivables Setup page. Once done, you can open the Purchase Line Archive table to find a list of archived purchase order lines. Unfortunately, as far as I know, this table doesn't have a page to open it directly. However, one way is to search and open the Table Information page, filter for the Purchase Line Archive table (5110), and click on the No. of Records field to open it.

     
     
    Once the table is open, you can filter by Document Type = Order and No. = Your Item No.. This will give you a list of archived purchase orders your item was on.
     
     
  • PRao Profile Picture
    394 on at
    Hi,
    I agree with Valentin Castravet , When Purchase order fully invoiced then it is get deleted by system.

    1.  Purchase Order can be get on posted Purchase Receipt or Posted Purchase Invoice if there is only one document is required to track. 
    2. Also open the Find entry page and specify the document number either Posted Purchase receipt or Invoice and open the record and see the Order No. 

    3. I think if there is require to prepared a report then create one configuration package with table 121(Purchase Receipt Line) & 123 (Purchase Invoice) and export he data in Excel sheet and play with excel and prepared report.   
     
    Thanks
    PRao
     
     
     
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    95,597 Super User 2025 Season 2 on at
    Hi, Also add some info, if customized, you can keep these orders. Below is a simple example, I hope it can give you some tips.
    Dynamics 365 Business Central: How to keep Orders after completely invoiced
     
    Thanks.
    ZHU

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 2,785

#2
Jainam M. Kothari Profile Picture

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

#3
YUN ZHU Profile Picture

YUN ZHU 948 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans