How to Auto-fill the Data on the field

(0) Share

Report

Posted on by Maro9595

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.

Am using NAV 2015.

Thank you for your constant assistance.

All responses (4)

Answers (1)

Maro9595 105 on at

Like (0)

Report

RE: How to Auto-fill the Data on the field

Thank you ZUH
Maro9595 105 on at

Like (0)

Report

RE: How to Auto-fill the Data on the field

thank you Josh
Verified answer

YUN ZHU 74,036 Super User 2024 Season 2 on at

Like (1)

Report
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;

Hope this will help.

Thanks.

ZHU
Suggested answer

JAngle 33,159 on at

Like (1)

Report

RE: How to Auto-fill the Data on the field

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