Microsoft Dynamics NAV (Archived)

Setrange problem

(0) Share

Report

Posted on by Tina Menezes

2,582

Hi all,

I have written a code on Post action of Purchase order page. Code snippet of it is given below.

PurchaseLine.RESET;
PurchaseLine.SETRANGE("Document No.","No.");
IF PurchaseLine.FINDFIRST THEN
MESSAGE('Purchase header no %1',"No.");
MESSAGE('Purchase line document no %1',PurchaseLine."Document No.");
REPEAT
PostedGateEntryHeaderTable.RESET;
PostedGateEntryHeaderTable.SETRANGE("No.",PurchaseLine."Gate Entry No.")
IF PostedGateEntryHeaderTable.FINDFIRST THEN BEGIN

This code I have written on the post action of purchase order page.

But the problem is that while I give this statement highlighted above, the "No." field which I want I of PostedGAteEntryHeaderTable but it is taking "No." of Purchase Header table by default.

Screenshot is attached which shows No. field to be of Purchase header table.

Kindly suggest

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (2)

Suggested answer

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

Like (0)

Report

Screenshot is not available.

can you please explain below sentence

But the problem is that while I give this statement highlighted above, the "No." field which I want I of PostedGAteEntryHeaderTable but it is taking "No." of Purchase Header table by default.

Was this reply helpful? Yes No
Tina Menezes 2,582 on at

Like (0)

Report

No. field should be of posted gate entry table but it is of Purchase header table 38

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report

It must be an issue of intellisense but while execution it will consider from posted gate entry table only.

or you can also write

PostedGateEntryHeaderTable.SETRANGE(PostedGateEntryHeaderTable."No.",PurchaseLine."Gate Entry No.")

Was this reply helpful? Yes No
Suggested answer

Yogesh Kulkarni_ 1,762 on at

Like (0)

Report

Hi,

In command, PostedGateEntryHeaderTable.SETRANGE("No.",PurchaseLine."Gate Entry No.")

No. will be of Posted Gate Entry Header only.

In field paramater of SETRANGE function, field is of calling Record variable.

You can refer below link:

https://msdn.microsoft.com/en-us/library/dd355053.aspx

-Yogesh Kulkarni
Please verify, if you find answer helpful.

Was this reply helpful? Yes No
Luc van Vugt on at

Like (0)

Report

Tine, what do you exactly mean with:

[quote user="Tina Menezes"]

But the problem is that while I give this statement highlighted above, the "No." field which I want I of PostedGAteEntryHeaderTable but it is taking "No." of Purchase Header table by default.

[/quote]

What makes you draw this conclusion?

Was this reply helpful? Yes No
Verified answer

Amol Salvi 18,698 on at

Like (1)

Report

You need to write this way

PurchaseLine.RESET;
PurchaseLine.SETRANGE("Document No.","No.");
IF PurchaseLine.FINDFIRST THEN
MESSAGE('Purchase header no %1',"No.");
MESSAGE('Purchase line document no %1',PurchaseLine."Document No.");
REPEAT
PostedGateEntryHeaderTable.RESET;
PostedGateEntryHeaderTable.SETRANGE(PostedGateEntryHeaderTable."No.",PurchaseLine."Gate Entry No.")
IF PostedGateEntryHeaderTable.FINDFIRST THEN BEGIN

Was this reply helpful? Yes No
Tina Menezes 2,582 on at

Like (0)

Report

Hi Luc van Vugt,

In my C/AL code it was taking Purchase Header record 38 variable and even in the debugger the correct value wasn't getting fetched. I have attached a screenshot which shows the same.

Was this reply helpful? Yes No
Tina Menezes 2,582 on at

Like (0)

Report

Thanks all.

My issue is solved.

Was this reply helpful? Yes No
Luc van Vugt on at

Like (0)

Report

Hi Tina, so that other may profit form your findings could you please share the solution?

Was this reply helpful? Yes No
Tina Menezes 2,582 on at

Like (0)

Report

Hi, Sure!

This was my initial code.

PurchaseLine.RESET;

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

IF PurchaseLine.FINDFIRST THEN

MESSAGE('Purchase header no %1',"No.");

MESSAGE('Purchase line document no %1',PurchaseLine."Document No.");

REPEAT

PostedGateEntryHeaderTable.RESET;

PostedGateEntryHeaderTable.SETRANGE("No.",PurchaseLine."Gate Entry No.")

IF PostedGateEntryHeaderTable.FINDFIRST THEN BEGIN

As suggested from the solutions given above, I replaced the above line which is shown in red colour with the below statement:

PostedGateEntryHeaderTable.SETRANGE(PostedGateEntryHeaderTable."No.",PurchaseLine."Gate Entry No.");

This solved my issue.

Was this reply helpful? Yes No