Order Arrival Date

(0) Share

Report

Posted on by Lovisa LH

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!

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Nitin Verma 21,698 Moderator on at

Like (1)

Report

Hi Lovisa LH ,

Its means you want to find out when the goods has been received in you warehouse. in that case you can refer "Posted Purchased Receipts" Page, also if you have access of table Purchaser Receipt Line, either way you can identify when your goods with which qty. has been received in the particular location.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

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

Was this reply helpful? Yes No
Lovisa LH 29 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Dallefeld 211 User Group Leader on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

One more option...check this out.

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

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Lovisa,

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

Thanks,

Steve

Was this reply helpful? Yes No