Warning message on Purchase Order

(0) Share

Report

Posted on by Community Member

Hello Experts,

Stuck in one scenario need your help i am using NAV 2009 R2 in it have added one Boolean field in Purchase Header and another Boolean filed in Purchase Line.

If Boolean filed from Header is (ticked) Yes then updating all Boolean filed in Purchase line.

Functionality working fine but when i am clicking on Boolean filed from header one warning message comes up as "Do you want to Rename the record?" if i click on Yes getting error as "You cannot rename a purchase line. (select refresh to discard errors) " and if i click on No then my functionality works properly.

Have googled for this issue and found that if we are trying to update primary key filed from table this warning message comes up. but here i am not updating primary key.

Anyone can suggest solution for this please. Thanks in advance

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Mohana Yadav 61,003 Super User 2025 Season 2 on at

Like (0)

Report

Please check the code you have added for above functionality.

it seems something to do with customized code only.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

Hi Aditi,

Is your Boolean field in the Purchase Line a part of the Purchase Line table's primary key?

Could you paste your code of updating Purchase Line Boolean field?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mahesh,

Thanks for the reply.

Filed from Purchase line is not included in primary key

PH Boolean filed name - Edit PO Update

PL Boolean filed name - PO Updated

Purchase Header page (50) code as below

Edit PO Updated - OnValidate()

IF CONFIRM('Do you want to update all PO Updated Lines?') THEN

CurrPage.PurchLines.FORM.ManagePOUpdate("No.", TRUE);

Purchase Order Subform page(54) code as below

ManagePOUpdate(PONO : Code[10];Check : Boolean)

IF Check = TRUE THEN

BEGIN

SETRANGE("Document No.",PONO);

IF FINDSET THEN

REPEAT

"PO Updated":= TRUE;

MODIFY(TRUE);

UNTIL NEXT=0;

CurrPage.UPDATE;

END;

Was this reply helpful? Yes No
Verified answer

mmv 11,471 on at

Like (0)

Report

Hi,

The above code has few issues. My suggestion is why don't you use a Flow Field in the Purchase Line? As you are updating all the lines, it's better to use a flow field to know the Status on the Purchase Header (whether it's updated).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Mahesh,

Thanks for your reply.

Requirement is user will tick filed form PH and if it is tick then only lines from PL would update.

Can you please let me know issues form the code, so i can correct and check.

Thanks

Regards,

Aditi

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Thanks for update

I have resolved the issue by writing Function on Purchase line table instead of Purchase Order Subform page. :)

Regards,

Aditi

Was this reply helpful? Yes No