Skip to main content

Notifications

Microsoft Dynamics NAV forum
Answered

How to Auto-fill the Data on the field

Posted on by 105

Hi all,

I have created a new field called Unit Price in the Transfer Line table and then I added that field in Transfer Order subform as well. Now when I create a Transfer order and select Item no I want also the Unit price(In my Transfer Line) of that Item to populate directly from the Item card. The same way description and unit of measure populate.

pastedimage1642770764788v1.png

Am using NAV 2015. 

Thank you for your constant assistance.

  • Maro9595 Profile Picture
    Maro9595 105 on at
    RE: How to Auto-fill the Data on the field

    Thank you ZUH

  • Maro9595 Profile Picture
    Maro9595 105 on at
    RE: How to Auto-fill the Data on the field

    thank you Josh

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 69,639 Super User 2024 Season 2 on at
    RE: How to Auto-fill the Data on the field

    Hi, as Josh mentioned, you need to add some code to the OnValidate trigger of the “Item No.” field in Transfer Line table (5741).

    For example:

                trigger OnValidate()
                var
                    Item: Record Item;
                begin
                    if Item.Get("Item No.") then
                        "Unit Price" := Item."Unit Price";
                end;

    pastedimage1642979763856v1.png

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,155 on at
    RE: How to Auto-fill the Data on the field

    Add your code to the OnValidate trigger of the “Item No.” field

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans