How to lock the comments whenever purchase order is released?

(0) Share

Report

Posted on by manish.yadav

1,893

Dear experts,

I am using the nav 2016 version. My requirement is if purchase order is released through the approval process user can not modify the comments(both comments....line and header also). Please give me the suggestion, where I need to write the validation code.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Suggested answer

CDsilva 4,188 on at

Like (0)

Report

Hi MKY,

You can refer my blog.

www.cloudfronts.com/make-editable-fields-un-editable-based-condition-nav

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

Hello experts,

Comments is saved in other table not in purchase document table. I know your provided idea in the given link.I have applied several places in navision. But in herem my requirement is if after releasing the PO if user is trying to edit the comments or remove the comments to click on comments button....system is flowing the auto message....PO is released, can't edit or rewrite the new comments..

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

Like (0)

Report

You need to customize.

Was this reply helpful? Yes No
Verified answer

Tina Menezes 2,582 on at

Like (0)

Report

Hi MKY,

You need to do the following steps

In table 43 i.e. Purch. Comment Line, you have to declare 'PurchaseOrderTable' as your global variable which is table 38 Purchase Header and write the following code in OnInsert(), OnModify(). OnDelete() trigger of the table:

Note: The status of the PO once approved changes to 'Released'.

Now after approving the PO, if you try to add, edit or delete the comments you will get following error:

Was this reply helpful? Yes No
Verified answer

CDsilva 4,188 on at

Like (0)

Report

Hi MKY,

Similarly this can be done. There is a relation between Purchase Header(38) and Purchase Comment Line(43) on "No" field

here below Blockediting is a Boolean field

On the Trigger

OnAfterGetCurrRecord()

PurchaseHeader.RESET;

PurchaseHeader.SETRANGE("Document Type",Rec."Document Type");

PurchaseHeader.SETRANGE("No.",Rec."No.");

IF PurchaseHeader.FINDSET THEN BEGIN

IF PurchaseHeader.Status=PurchaseHeader.Status::Released THEN BEGIN

Blockediting:=FALSE;

MESSAGE('PO is Released, cant edit or rewrite new comments');

END

ELSE

Blockediting:=TRUE;

END;

Output:

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (2)

Report

That was my actual requirement. Now it is resolved. Thank you for your support. You guys are the best. Again thanks.

Was this reply helpful? Yes No