Last Receipt Date of an Item

(3) Share

Report

Posted on by RR-07061806-0

866

Good day,

I'm looking to create a report where item numbers are listed and I want to include the vendor number and name as well as the last receipt date. The posting date of the receipt can be used for the receipt date. I'm using the information from the items table where I will get inventory.

I need to know what tables to look for with this information, thanks for any assistance with this.

Regards

Rosemary

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (5)

Verified answer

Dhiren Nagar 2,784 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

You need to use 3 tables - Item (27), Item Ledger entries (32) and Vendor(23).

Basically you will use Item as your main data item. From there get the Item No. and Item Description.

From Item ledger entries if you apply filter of Entry Type as "Purchase" and Document type as "Purchase Receipt|Purchase Invoice" and find the last entry.

From this record you can get the Document No. - Purchase Receipt No., Posting date as Posting date of the receipt.

Source Type will be Vendor and Source No. is your Vendor No.

This Vendor No. you can then use to get the Vendor table and Vendor name from it.

✅ Tick the checkbox below to mark the answer as verified, if it helped resolve your question.

Regards,

Dhiren.

LinkedIn - https://www.linkedin.com/in/ca-dhiren-nagar-5079081b2/

Blog - https://dhirennagar.blogspot.com/

Was this reply helpful? Yes No
RR-07061806-0 866 on at

Like (0)

Report
Copy link

Link copied!

Good day,

Thank you very much for your response, much appreciated.

Regards

Rosemary

Was this reply helpful? Yes No
Verified answer

Valentin Castravet 31,960 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

The Item Ledger Entry table will have everything you’re looking for. The only thing it won’t have is the vendor name, since it stores only the Vendor No.

If you need the vendor name, you can pull it from the Vendor table, or from another table that includes it, such as Purch. Rcpt. Header (Table 120), if you’re already using that in your report.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Verified answer

YUN ZHU 98,064 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, You can try using the Item Ledger Entry (32) table.

You can directly obtain the last date using Flowfield or Query.

FlowFields (Sum, Average, Exist, Count, Min, Max, Lookup)

Dynamics 365 Business Central: Using the Date Method to retrieve only the Day, Month, and Year Data in Queries [Group by Year-month]

https://yzhums.com/14547/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

OussamaSabbouh 11,101 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello Rosemary,

Use Item (27) to list the items, Vendor (23) to get vendor name, and for “last receipt date” pull it from posted purchase activity—either Item Ledger Entry (32) (filter to purchase/inbound and take the latest Posting Date per Item) or Posted Purchase Receipt tables Purch. Rcpt. Header (120) + Purch. Rcpt. Line (121) (line gives Item No. + Vendor No., header gives Posting Date); BC posting creates item ledger entries and also stores posted purchase receipts, so those are the main places to look.

Regards,
Oussama Sabbouh

Was this reply helpful? Yes No
Verified answer

Touil Yahya 220 on at

Like (1)

Report
Copy link

Link copied!

Hi,

You can pull the last receipt date from posted purchase activity, either from Item Ledger Entry (32) or from Purch. Rcpt. Header and Purch. Rcpt. Line (line contains Item No. and Vendor No.; header contains Posting Date).

Business Central records both item ledger entries and posted purchase receipts during posting, so these are the primary sources.

Was this reply helpful? Yes No
Suggested answer

AndrewThomas81 210 on at

Like (0)

Report
Copy link

Link copied!

I would take a look at the "Posted Purchase Receipt Lines", this contains vendor number, item number and you can add dates to the list page via personalise as required.

Was this reply helpful? Yes No