Getting the specific record of the line items

(0) Share

Report

Posted on by Olister Rumao

3,967

Hi,
I've a requirement wherein Sales Order Card Page when I select the line item, and click on the Custom Action Button.
After selection of the Line Record and Click in the Custom Action Button I want to print a message containing the fields of the selected record.
Kindly suggest for multiple lines as well.

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (2)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

In your action:

- Declare a SalesLine variable of Type = Record that points to Sales Line table.

- In the action code, write:

CurrPage.SalesLines.PAGE.GETRECORD(SalesLine);

MESSAGE(SalesLine."No."); //This is the Sales Line selected.

Was this reply helpful? Yes No
Suggested answer

Divesh 327 on at

Like (0)

Report

In addition, if you want to handle multiple line selection then you can use

CurrPage.SETSELECTIONFILTER(SalesLine);

and then loop through the record set. An example is available in Standard Page - 22 - "Customer List".

docs.microsoft.com/.../setselectionfilter-function

Was this reply helpful? Yes No
Olister Rumao 3,967 on at

Like (0)

Report

Hi Stefano,

I would like to select multiple lines in List Part Subform as well. How do I do that?

Was this reply helpful? Yes No
Olister Rumao 3,967 on at

Like (0)

Report

Hi Divesh,

It works for List Page, but not the listpart subform.

Thanks.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

For multiple lines, you can do as described by Divesh here.

Was this reply helpful? Yes No
Suggested answer

Divesh 327 on at

Like (0)

Report

Hi

I have created an action button on the Page - 46 - Sales Order Subform and below is the code

MultiSelect - OnAction()

//lSalesLine is a local record variable that points to "Sales Line" table.

CurrPage.SETSELECTIONFILTER(lSalesLine);

IF lSalesLine.FINDSET THEN

REPEAT

MESSAGE(FORMAT(lSalesLine));

UNTIL lSalesLine.NEXT = 0;

In the Sales Order Page, on the lines Fasttab select any single / multiple lines and click this action button MultiSelect. It will loop through and display the message of the selected lines . Hope this helps. Thanks

Was this reply helpful? Yes No
Olister Rumao 3,967 on at

Like (0)

Report

Hi Divesh,

I've tried the following code

//CurrPage.SalesLines.PAGE.GETRECORD(Rec_SalesLines);

//MESSAGE(Rec_SalesLines."No.");

CurrPage.SETSELECTIONFILTER(Rec_SalesLines);

IF Rec_SalesLines.FINDSET THEN

REPEAT

MESSAGE('%1',FORMAT(Rec_SalesLines."No."));

UNTIL Rec_SalesLines.NEXT=0;

On Clicking the Action I get an error "TableID does not match."

I'm trying to select multiple lines on Sales Order page and on Action on the Sales Order Page it should display say the LineNo of the selected lines

Was this reply helpful? Yes No
Verified answer

Divesh 327 on at

Like (0)

Report

Hi

It seems that you have the action button in the Page - 42 - Sales Order and you want to display the selected lines when you click the action let's name the Action - "Get Selected Lines" to achieve this.

1. Create a function GetSelection in the Page - 46 - "Sales Order Subform"

GetSelection(VAR pSalesLine : Record "Sales Line")

CurrPage.SETSELECTIONFILTER(pSalesLine);

2. Create a Action "Get Selected Lines" in the Page - 42 - "Sales Order" and write the below code in the action or a function.

Get Selected Lines - OnAction()

//Delcare a local variable lSalesLine --> Record --> Sales Line

CurrPage.SalesLines.PAGE.GetSelection(lSalesLine);

IF lSalesLine.FINDSET THEN

REPEAT

MESSAGE(FORMAT(lSalesLine));

UNTIL lSalesLine.NEXT = 0;

Open the Page - 42 - "Sales Order" and select the lines and then click the Action Get Selected Lines" from the Page - 42 - "Sales Order" it should display the selected lines.

Hope this is what you need and it works as expected. Thanks

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,600 Super User 2025 Season 2 on at

Like (0)

Report

Many other members replied with the codes but Instead of this rather I would have asked what you tried and share your code base because this is not something that challenging. You can do it by yourself. :)

Was this reply helpful? Yes No
bharathkarunakaran 475 on at

Like (0)

Report

Hi Divesh,

Its working fine,

Can you please tell me what is the use of creating a function in sales order subform .

Regards,

Bharath K

Was this reply helpful? Yes No