Add company lookup to Report request page

(0) Share

Report

Posted on by CRSW

593

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

All responses (13)

Answers (1)

CRSW 593 on at

Like (0)

Report

RE: Add company lookup to Report request page

Yes I will. It is just playing around. writing a new report and do such stuff seems to be easy (more or less) but extending one and do the coding to change the functionality of the existing one is not that clear to me
Suggested answer

Mohana Yadav 59,194 Super User 2024 Season 2 on at

Like (0)

Report

RE: Add company lookup to Report request page

Give it a try.

https://yzhums.com/6362/
CRSW 593 on at

Like (0)

Report

RE: Add company lookup to Report request page

Hi

Yes as I told in the first message I am new to BC. Thx. a lot. the lookup works.

Now I have to find out how I can extend the rest to copy the FA from the selected company to the current one.
Verified answer

Mohana Yadav 59,194 Super User 2024 Season 2 on at

Like (0)

Report

RE: Add company lookup to Report request page

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

}
CRSW 593 on at

Like (0)

Report

RE: Add company lookup to Report request page

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

}

}

}

}
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

RE: Add company lookup to Report request page

Please share your complete code here
Suggested answer

Mohana Yadav 59,194 Super User 2024 Season 2 on at

Like (0)

Report

RE: Add company lookup to Report request page

Could you please share the code and error?
CRSW 593 on at

Like (0)

Report

RE: Add company lookup to Report request page

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

Mohana Yadav 59,194 Super User 2024 Season 2 on at

Like (0)

Report

RE: Add company lookup to Report request page

This code should be enough

field(CompName; CompName)

{

Caption = 'Company Name';

ApplicationArea = FixedAssets;

TableRelation = Company;

}

var

CompName: Code[30];
Suggested answer

Mohana Yadav 59,194 Super User 2024 Season 2 on at

Like (0)

Report

RE: Add company lookup to Report request page

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

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