I need expiration date from item tracking lines in a report on sales order. Expiration date is available in Tracking Specification table but in reservation entries the expiration date field is blank.

(0) Share

Report

Posted on by Dipika

where can I get expiration get from?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Alfredo_Iorio 1,264 on at

Like (0)

Report

Expiration date should be populate on the reservation entry table.

Maybe you have an extension installed that affects that field? If you have inventory with an expiration date for that lot number you might want to use the Item Ledger Entry table as a lookup in your report. You should have the expiration date there.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, I tested it, and it is the same as Dipika, the expiration date is empty.

I'm not sure if this is a bug with the standard or only in the BC22.1 version. Hope other experts can give you better advice.

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Alfredo_Iorio 1,264 on at

Like (0)

Report

Thanks for checking.

I have tested a couple of scenarios and it looks like the reservation entry does not include the expiration date when the source is a sales line.

In my example I was looking at the reservation entry for a purchase line.

I guess it's because of the Late Binding design. learn.microsoft.com/.../design-details-item-tracking-and-reservations

The only option then is to use item ledger entries and lookup the expiration date based on item number, location and lot number.

Was this reply helpful? Yes No
Dipika 15 on at

Like (0)

Report

Thanks ZHU YUN I appreciate that.

Was this reply helpful? Yes No
Dipika 15 on at

Like (0)

Report

Thanks Alfredo. I'll try this and update on the forum.

Was this reply helpful? Yes No