Drilldown to another company

julkifli33
julkifli33 Member Posts: 1,092
in NAV Three Tier
Hi All,
I am using BC SaaS.
I have created new page that show total sales for all companies.
let's say I have company A,B,C

so it will be something like
Name Total Sales
Company A $1000
Company B $2000
Company C $4000

then user open company A.
what i am looking for is when user click $2000 (which is for company B)
then it will show the details from company B
is it possible to do that?

Thanks.

Best Answers

Answers

  • RockWithNAV
    RockWithNAV Member Posts: 1,172
    Answer ✓
    You need to write a manual code using CHANGECOMPANY Function and then bring in all Records in some temp table and then you can display it out. Direct Drill down to Company B from Company A you can not do.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • yzhums
    yzhums Member Posts: 10
    Answer ✓
    Hi, hope the following will help.
    https://yzhums.com/21252/

    Thanks.
  • julkifli33
    julkifli33 Member Posts: 1,092
    Hi @RockWithNAV thank you so much.

    Hi @yzhums thanks a lot for the link
  • julkifli33
    julkifli33 Member Posts: 1,092
    Hi... i am just thinking.
    when i drill down, can we open new tab?
    trigger OnDrillDown()
var
Cust: Record Customer;
begin
  Cust.ChangeCompany(Rec.CompanyName);
  Page.Run(Page::"Customer List", Cust);
end;
  • DenSter
    DenSter Member Posts: 8,307
    edited 2022-01-19
    julkifli33 wrote: »
    Hi... i am just thinking.
    when i drill down, can we open new tab?
    trigger OnDrillDown()
var
Cust: Record Customer;
begin
  Cust.ChangeCompany(Rec.CompanyName);
  Page.Run(Page::"Customer List", Cust);
end;
    That will open the regular customer list page that is filled with customers from the other company, but then when you go to related tables it reads from the current one. You would have to create a new customer list that works on the other company
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • yzhums
    yzhums Member Posts: 10
    Answer ✓
    julkifli33 wrote: »
    Hi... i am just thinking.
    when i drill down, can we open new tab?
    trigger OnDrillDown()
var
Cust: Record Customer;
begin
  Cust.ChangeCompany(Rec.CompanyName);
  Page.Run(Page::"Customer List", Cust);
end;

    Hi, try this.
    https://yzhums.com/21578/
  • julkifli33
    julkifli33 Member Posts: 1,092
    Hi @yzhums
    thanks so much !
    this is what i am looking for.

Categories