Skip to main content

Notifications

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

How to Auto-fill the Data on the field

(0) ShareShare
ReportReport
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 74,036 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,159 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

News and Announcements

Announcing Category Subscriptions!

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,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans