Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Creating new tab on lookup on a field in transfer journal

Posted on by 3,024

TabLookupforemptylocation.png

Dear Experts,

A requirement was given by our warehouse that is in the Transfer journal on the field" from  location". As the user clicks on the field it shows two tabs One is "Locations"(Which shows all locations the second tab is the "on-hand tab", we have that location where we have existing items or available items.But our warehouse requirement is to create another tab on that lookup and shows the blank location.Please check the above image as well.

Best Regards,

Shabir Ahmad

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: Creating new tab on lookup on a field in transfer journal

    Hi André Arnaud de Calavon,

    Thank you so much you showed to the place where i can create new tab. But the actual question was not done or what was the purpose of this post not completed. i created a new tab but that tab show Blank(Empty) Locations. For example Locations tab shows all locations, On-Hand shows on hand but we need another tab which i will  show that locations which are blank that location will not have any materials(Empty Materials Location)

    Best Regards,

    Shabir Ahmad

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Creating new tab on lookup on a field in transfer journal

    Hi Shabir,

    To be honest, I have no idea now. I'm at an event and can't access any AX2012 environment currently. I have an environment at a separate SSD-drive which I did not take with me. Have you tested the coding yourself? What is the current result?

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: Creating new tab on lookup on a field in transfer journal

    Dear André Arnaud de Calavon,

    Do you think to change in below code on form level methods. I did the same as you suggest me i copy on-hand button and just paste it. Now the next task is to bring some modification in the new tab code for Empty Location as for our needful.Is this correct place need to be changed.

    void setShowAvail()

    {

       this.lock();

       ctrlInventSum_AvailOrdered.visible(ctrlShowAvail.value());

       ctrlInventSum_AvailPhysical.visible(ctrlShowAvail.value());

       ctrlPhysicalInvent.visible(!ctrlShowAvail.value());

       this.resetSize();

       this.arrange();

       this.unLock();

    Second method on Form level methods below.

    FormControl getLocationIdControl()

    {

       InventDimFormControlInterface fc;

       Object dummy;

       InventDimAXFormControlAdapter controlAdapter;

       InventDimControlsCollect_Frm    inventDimControls = this.inventDimSetupObject().inventDimControls();

       DictField   df = new DictField(tableNum(InventDim),fieldNum(InventDim,wmsLocationId));

       for (fc=inventDimControls.first();fc;fc=inventDimControls.next())

       {

           if (fc.isInGrid())

               if (df.name() == new DictField(tableNum(InventDim),fieldExt2Id(fc.dataField())).name())

               {

                   //work around the compiler bug

                   dummy = fc;

                   controlAdapter = dummy;

                   return controlAdapter.parmFormControl();

               }

       }

       return null;

    }

    }

    Please suggest me. Thanks in advance

    Best Regards,

    Shabir Ahmad

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Creating new tab on lookup on a field in transfer journal

    Hi Shabir,

    I have seen multiple lookup forms in the past. Ususally the name of a lookup form starts with the object/field name and end with 'lookup'. As the location is usually starting with WMSLocation, it was easy to find for me. This is the advantage of having some experience already and knowing the application patterns.

    It would be possible to look at the on-hand and see if you can copy this, but then use a notexistsjoin to "reverse" the on-hand logic.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: Creating new tab on lookup on a field in transfer journal

    Dear Andre,

    Thanks for your kind reply, Yes, that is the location which i was looking for. Now, i have 2 questions please clear it to me.

    1) How you found this lookups tell in sequence because i tried but didn't find??

    2)Here is another requirement from my warehouse for  me, that is now i will create a new tab but that tab show Blank(Empty) Locations. For example Locations tab shows all locations, On-Hand shows on hand but we need another tab which i will do it but any logic which will show blank location in simple  locations - on hand = all blank locations.

    Best Regards,

    Shabir Ahmad

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Creating new tab on lookup on a field in transfer journal

    Hi Shabir,

    The standard form name is WMSLocationIdLookup.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: Creating new tab on lookup on a field in transfer journal

    Dear André Arnaud de Calavon ,

    Thanks for your kind reply, i didn't find any Lookup Form. Would you like to suggest me its full name?

    Best Regards,

    Shabir Ahmad

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Creating new tab on lookup on a field in transfer journal

    Hi Shabir,

    The lookup form is a form in the AOT. You can customize it and add a new tab page containing your details.

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

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans