Add company lookup to Report request page

(0) Share

Report

Posted on by CRSW

627

Hello

I am new to BC and I have to create a Report extension (Copy fixed asset) and add a company lookup to the Report Request Page to use the Selection for the copy later

How can I do this?

Best regards

Chris

I have the same question (0)

All responses (13)

Answers (1)

Sort by

CU11121527-0 4 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello,

Not sure I understand what you are trying to do? If you are simply looking for a list of companies you could try the following tables via API

table 2000000006 = Company (holds list of companies) you may not have access to this table

table 79 = Company Information (holds details about a specific company)

See this article for more details link

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,123 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, It seems that you need a lookup to the company field, I hope the following information can give you some hints.

How to create a Lookup, Drop-Down, or Option list (Single and Multi select)

https://yzhums.com/5985/

Thanks.

ZHU

Was this reply helpful? Yes No
CRSW 627 on at

Like
a
(0)

Report
Copy link

Link copied!

thx for the answer. I did it exactly like described inside a fielddefinition named CompanyName but I get the message: The left-hand side of an assignment must be a variable or field

Here the code:

field(CompanyName; CompanyName)

{

Caption = 'Company Name';

ApplicationArea = FixedAssets;

Lookup = true;

;

TableRelation = "Company Information";

trigger OnLookup(var Text: Text): Boolean

var

CompanyRec: Record "Company Information";

begin

CompanyRec.Reset();

if Page.RunModal(Page::"Company Information", CompanyRec) = Action::LookupOK then

CompanyName := CompanyRec.Name;

end;

}

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,223 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

CompanyName is system defined function so we should not use that.

Declare a variable with name CompName etc. and use it instead of CompanyName.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,223 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

This code should be enough

field(CompName; CompName)

{

Caption = 'Company Name';

ApplicationArea = FixedAssets;

TableRelation = Company;

}

var

CompName: Code[30];

Was this reply helpful? Yes No
CRSW 627 on at

Like
a
(0)

Report
Copy link

Link copied!

Nothing seems to work. All options mentioned here are ending in errors....(different kind of)

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 61,223 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you please share the code and error?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Please share your complete code here

Was this reply helpful? Yes No
CRSW 627 on at

Like
a
(0)

Report
Copy link

Link copied!

Here the code (but I played around allready:

reportextension 62005 "CopyFixedAssetCFAC" extends "Copy Fixed Asset" //5685

{

dataset

{

}

requestpage

{

layout

{

addbefore(FANo)

{

/*

field(CompName; CompName)

{

Caption = 'Company Name';

ApplicationArea = FixedAssets;

TableRelation = "Company Information";

}

trigger OnLookup(var Text: Text): Boolean

var

CompanyRec: Record "Company Information";

begin

CompanyRec.Reset();

if Page.RunModal(Page::"Company Information", CompanyRec) = Action::LookupOK then

CName := CompanyRec.Name;

end;

*/

field(CompName; CompName)

{

Caption = 'Company Name';

ApplicationArea = FixedAssets;

TableRelation = Company;

}

var

CompName: Code[100];

}

}

}

}

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 61,223 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Try with this. Looks like you are new to BC coding and need to learn where to place the code/variable declaration etc.

reportextension 62005 "CopyFixedAssetCFAC" extends "Copy Fixed Asset" //5685

{

dataset

{

}

requestpage

{

layout

{

addbefore(FANo)

{

/*

field(CompName; CompName)

{

Caption = 'Company Name';

ApplicationArea = FixedAssets;

TableRelation = "Company Information";

}

trigger OnLookup(var Text: Text): Boolean

var

CompanyRec: Record "Company Information";

begin

CompanyRec.Reset();

if Page.RunModal(Page::"Company Information", CompanyRec) = Action::LookupOK then

CName := CompanyRec.Name;

end;

*/

field(CompName; CompName)

{

Caption = 'Company Name';

ApplicationArea = FixedAssets;

TableRelation = Company;

}

}

}

}

var

CompName: Code[100];

}

Was this reply helpful? Yes No