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 / Small and medium business | Business Central, N... / Order Arrival Date
Small and medium business | Business Central, N...
Answered

Order Arrival Date

(0) ShareShare
ReportReport
Posted on by Lovisa LH 29

Dear learned colleagues,

I have a beginners question here for a Monday morning 

I need to get a list from Navision of our previous Purchase Orders with their Order Date, Requested Receipt Date, Promised Receipt Date and the date the order arrived at the warehouse.

Where do I find the date the order arrived?

Thank you in advance for any advice!

  • Lovisa LH Profile Picture
    Lovisa LH 29 on at
    RE: Order Arrival Date

    Thank you to all below who took the time to answer, I will look over the responses next week and mark them as answer :-)

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Order Arrival Date

    Lovisa,

    Kim replied how to accomplish the steps via the Developer side.

    Thanks,

    Steve

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 171 User Group Leader on at
    RE: Order Arrival Date

    Wow, my apologies, I answered these as Business Central not NAV.  

    In NAV go to Object Designer, find your table, run the table, copy and paste to Excel....

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 171 User Group Leader on at
    RE: Order Arrival Date

    One more option...check this out.

    vld-nav.com/table-data-editor-for-bc

  • Dallefeld Profile Picture
    Dallefeld 171 User Group Leader on at
    RE: Order Arrival Date

    You can also go to help and support inside BC , inspect tables and pages, view table....this gets you to the same place. But it does not give you the option to export to excel or even to open in excel.

    I have seen a post....just need to find it.... that I tried and I was able to get closer to the raw data to edit.

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 171 User Group Leader on at
    RE: Order Arrival Date

    The document in the link below has all the steps to view table data

    docs.microsoft.com/.../devenv-view-table-data

  • Lovisa LH Profile Picture
    Lovisa LH 29 on at
    RE: Order Arrival Date

    Dear Steve,

    Thank you for your response; I do have Developer Licence and access to the tables. Can you point me to any instructions on how to open the table, filter and export to Excel?

    That is certainly something I would like to learn.

    Many thanks,

    LH

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Order Arrival Date

    Lovisa,

    Go to the Posted Purchase Receipt Header, which will display the Posted Purchase Receipt Lines and filter by Posting Date, which will be the Date the Order arrived (note: This assumes receipts are posted the same day). Note that if you have access to Developer license and the Tables, you can open the Table and filter and export to Excel from there.

    Hope this helps.

    Thanks,

    Steve

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 77,981 Super User 2025 Season 1 on at
    RE: Order Arrival Date

    Hi, just adding others' reply, I think you can also use Item Ledger Entries page to fitler the record you want. But some fields may need to be added.

    The following are my tests on viewing orders in Business Central that I hope will give you some hints.

    How to view ‘Shipped Not Invoiced’ List and ‘Received Not Invoiced’ List: https://yzhums.com/15136/

    How to view Outstanding Order Lines and Posted Invoice Lines (No Customization): https://yzhums.com/8876/

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 171 User Group Leader on at
    RE: Order Arrival Date

    I agree with Nitin about the Posted Purchase Receipts but the date field that you want is the Posting Date

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans