web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Show Lot No. with Flow...
Business Central forum

Show Lot No. with Flowfield

(0) ShareShare
ReportReport
Posted on by Community Member

Hey guys,

I have in my subform a field "Lot No.". In this I want to show the used "Lot No." from Item Tracking.

Here you see the line, where I want to see the used "Lot No." (it is still empty):

ItemTracking1.PNG

And this is the line with the "Lot No.", which I would like to see in the above image:

ItemTracking2.PNG

For this I have to use a Flowfield with CalcFormula = lookup, right?!

This is my curent code:

Caption = 'Lot No.';
FieldClass = FlowField;
CalcFormula = lookup ("Tracking Specification"."Lot No.");
Editable = false;

Thank you ;)

Categories:
Other
I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    When you enter the lot number, the Tracking Specification is a temporary table and you cannot use a flowfield here.

    Look into subscribing Item Tracing Mgt. codeunit:

    pastedimage1569831747306v1.png

    You want to catch the lot number when the user closes the Item tracking page and insert it into a regular field on the line.

    Tero

  • Community Member Profile Picture
    Community Member on at

    Okay and how can I catch the lot number?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Its field No. 20 in the Item tracing buffer, which is the second variable in the Publisher. Its probably best if you create the subscriber and set a breakpoint there to see how it functions.

    pastedimage1569833386328v1.png

    Tero

  • Community Member Profile Picture
    Community Member on at

    Ok, I do not understand, sorry...

    Is there also another possibility to solve my issue?

  • Community Member Profile Picture
    Community Member on at

    Ok, maybe it is easier to try to do a flow field that points to Reservation Entry table, but the problem you will be facing here is that you have room for one Lot No per item line and there can be any number of lots in the item tracking for the line.

    Tero

  • Community Member Profile Picture
    Community Member on at

    Ok, let's say I show the lot number, if there is only one and if there are more, you tell the user, that there is at least more than one lot number.

    Is something like this possible?  

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans