dataset
{
dataitem("G/L Account"; "G/L Account")
{
DataItemTableView = sorting("No.");
column(No_; "No.") { }
column(Name; Name) { }
column(Account_Type; "Account Type") { }
dataitem("Default Dimension"; "Default Dimension")
{
DataItemLink = "No." = field("No.");
column(Dimension_Code; "Dimension Code") { }
column(SystemId; SystemId) { }
dataitem("Dimension Value"; "Dimension Value")
{
DataItemLink = "Dimension Code" = field("Dimension Code");
column(Dimension_Value_Name;
Name)
{ }
}
}
trigger OnPreDataItem()
var
LookupTable: Record "Dimension Trial Setup";
begin
"G/L Account".SetRange("Account Type", "Account Type"::Posting);
end;
}
}
