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.
Hi, try the following.
Share
Report
All responses (
Answers (
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,554
Super User 2024 Season 2
#2
Martin Dráb
228,588
Most Valuable Professional
#3
nmaenpaa
101,148