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:

Business Central

All responses (5)

Answers (1)

Dipika 15 on at

Like (0)

Report

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

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

Like (0)

Report

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

Thanks ZHU YUN I appreciate that.
Verified answer

Alfredo_Iorio 1,260 on at

Like (0)

Report

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

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

YUN ZHU 73,472 Super User 2024 Season 2 on at

Like (0)

Report

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

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
Suggested answer

Alfredo_Iorio 1,260 on at

Like (0)

Report

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

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.