How to Auto-populate data On a field

(1) 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 the 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(Take the value which is in the Item card unit price). The same way description and unit of measure populate.

Thank you for your constant assistance.

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

JAngle 133 on at

Like (0)

Report

Create an event subscriber to the transfer line table OnAfterInsert. Use the .GET() to fill a var of the item table and then pass the required value to your field and modify()

Was this reply helpful? Yes No
Maro9595 105 on at

Like (0)

Report

Thank you Josh,

Can you please guide me on how to accomplish this you have mentioned new another object "Event subscriber"

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

Just so you are aware. When you do a transfer the unit cost that is posted will be determined by the costing method on your items. But your added field might fill another purpose. Anyway i just wanted to let you know.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,548 Super User 2025 Season 2 on at

Like (0)

Report
Hi, try the following.

tableextension 80122 MyExtension extends "Transfer Line" { fields { modify("Item No.") { trigger OnAfterValidate() var Item: Record Item; begin if Item.Get("Item No.") then "Unit Price" := Item."Unit Price"; end; } field(50100; "Unit Price"; Decimal) { DataClassification = CustomerContent; } } } pageextension 80122 MyExtension extends "Transfer Order Subform" { layout { addafter(Quantity) { field("Unit Price"; Rec."Unit Price") { ApplicationArea = All; } } } }

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Maro9595 105 on at

Like (0)

Report

that's supper ZHU

thank you so much

Was this reply helpful? Yes No