Change status

(0) Share

Report

Posted on by Community Member

I need to create An error which prevents a user from changing the status of a production order (Firm planned -> Released) If all the SYS parts aren't all completely picked. This is an example of what I mean.

Any feedback would be appreciated!

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (1)

Community Member on at

Like (1)

Report

Try to write some code first at your end. If you face any difficulties, we are here.

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (2)

Report

Hi,

You can try this on Page 99000829 - Firm Planned Prod. Order, "Change Status" Action before the standard code gets called.

**************

ProdOrderComponents.SETRANGE(ProdOrderComponents."Prod. Order No.", "No.");

IF ProdOrderComponents.FINDSET THEN

BEGIN

REPEAT

IF ProdOrderComponents."Qty Picked" > 0 THEN // Or if you have any other fields, you can check here

ERROR('The Prod. Order Lines has not been fully picked.'); //Customize your error message

UNTIL ProdOrderComponents.NEXT = 0

END;

************

ProdOrderComponents is table 5407. Please understand this isn't the full implementation, but a skeleton.

Hope it helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you! by taking that code above I need to tailor it so it only applies when the routing link code is SYS.

Would I just write something like IF ProdOrderComponents."Routing Link Code" = SYS THEN ...

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

If you are looking at Routing Link Code = 'SYS' then you can add as a filter on top.

**************

ProdOrderComponents.SETFILTER(ProdOrderComponents."Routing Link Code", 'SYS');

ProdOrderComponents.SETRANGE(ProdOrderComponents."Prod. Order No.", "No.");

IF ProdOrderComponents.FINDSET THEN

BEGIN

REPEAT

IF ProdOrderComponents."Qty Picked" > 0 THEN // Or if you have any other fields, you can check here

ERROR('The Prod. Order Lines has not been fully picked.'); //Customize your error message

UNTIL ProdOrderComponents.NEXT = 0

END;

************

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Where can I put this code so that it appears once the user attempts to click Yes on this page

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (1)

Report

Hi,

If you want to check after user says Yes, you probably want to code in Codeunit 5407, Prod. Order Status Management. But this codeunit manages all the Status Management regarding Production Order. Please do test all your scenarios before deploying it.

Check the screenshot. Insert the code as shown.

Hope it helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you for your help. I've inserted this code into where you stated. When I run it through Nav I get the Confirm Box as I should but when I clock yes / no it keeps appearing. I have to spam click it to get stop it appearing. How do I fix this?

Was this reply helpful? Yes No
Verified answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

Hi,

Please attach the screenshot og your code. As per the definition, This code only fires when you press Yes. Thats the whole purpose of having ACTION::Ok.

Hope it helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I figured it out

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

Hi,

I was under the impression of you need to raise an Error with particular line details. If you are using confirmation boxes then the code can be simplified.

******************

ProdOrderComponents.SETFILTER(ProdOrderComponents."Routing Link Code", 'SYS');

ProdOrderComponents.SETRANGE(ProdOrderComponents."Prod. Order No.", "No.");

ProdOrderComponents.SETFILTER(ProdOrderComponents."Qty. Picked", '>0');

ProdOrderComponents.SETFILTER(ProdOrderComponents."Qty. Picked (Base)", '>0');

IF ProdOrderComponents.FINDSET THEN

BEGIN

IF CONFIRM('Prod. Order is not fully picked', FALSE) THEN

EXIT;

END;

******************

Try this code, and its bettter to have before ChangeStatusForm.ReturnPostingInfo(NewStatus,NewPostingDate,NewUpdateUnitCost); <- this line.

Hope it helps.

Was this reply helpful? Yes No