Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

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) ShareShare
ReportReport
Posted on by 15

where can I get expiration get from?

  • Dipika Profile Picture
    Dipika 15 on at
    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 Profile Picture
    Dipika 15 on at
    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 Profile Picture
    Alfredo_Iorio 1,260 on at
    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 Profile Picture
    YUN ZHU 74,115 Super User 2024 Season 2 on at
    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.

    pastedimage1685320570039v4.png

    pastedimage1685320578596v5.png

    Thanks.

    ZHU

  • Suggested answer
    Alfredo_Iorio Profile Picture
    Alfredo_Iorio 1,260 on at
    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.

    pastedimage1685286023955v2.png

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans