Getting first 2 lines of sales order

(0) Share

Report

Posted on by Community Member

I am putting this in to get line 1 and 2 descriptions;

IF salesline.FINDFIRST THEN BEGIN
Desc := salesline.Description;
IF salesline.NEXT <>0 THEN
Desc2 := salesline.Description;
END;

however it does not seem like it is picking up second line

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Mohana Yadav 60,977 Super User 2025 Season 2 on at

Like (1)

Report

RE: Getting first 2 lines of sales order

Its working fine in my case.

please check whether you have applied proper filters on Salesline records.

Was this reply helpful? Yes No
Saurabh Shah 4,560 on at

Like (1)

Report

RE: Getting first 2 lines of sales order

Can you please let us know starting from the filters to get the sales line so it can give more better idea.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Getting first 2 lines of sales order

salesline.SETRANGE("Document Type","Document Type");

salesline.SETRANGE("Document No.","No.");

IF salesline.FINDFIRST THEN BEGIN

Desc := salesline.Description;

IF salesline.NEXT <>0 THEN

Desc2 := salesline.Description;

END;

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,977 Super User 2025 Season 2 on at

Like (1)

Report

RE: Getting first 2 lines of sales order

Did you check whether you are applying correct filters?

Its working fine again.

Please add

Message('%1 %2',Desc,Desc2);

at the end of your code and check

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Getting first 2 lines of sales order

In the report it is moving desc2 to desc1 and skipping the desc1. The message line put in shows the correct information.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,977 Super User 2025 Season 2 on at

Like (0)

Report

RE: Getting first 2 lines of sales order

so the code is working fine.

please check the report logic again. I didn't understand what you mean by moving desc2 to sesc1 and skipping etc...

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Getting first 2 lines of sales order

I was able to do this by using the line 1 and 2 and then break after the counter >2 and it worked and I am not sure why but it is.

Was this reply helpful? Yes No