Production status change - consumption no output

twdavis

Navision 4.0, getting error "You cannot finish line 10000 on production order WO250037. It has consumption or capacity posted with no output."
when 'changing status of top level device from 'released' to 'finished'.

They have not upgraded to SP2 yet.

Can anyone tell me what is missing? or how to get past this issue?

thnks
t

nunomaia

When you are finished and production order, if you have made a consumption you should had output.
Normally that kind of error is a wrong configuration in Item Card -> Flushing Method.

I think that message it's custom development.

twdavis

Thanks for you reponse.

Recent changes: converted to SQL over the hoildays.

Suddenly this problem crops up! Not sure how that could cause this issue.

Looking at their settings, all of their assemblies for this device have "forward" flushing. I see in the Production Journal all the assemblies for Forward flushing and Backward flushing. There are Machine Centers that have Backward flushing.

twdavis

The problems stem from the conversion from Nav 40 to SQL.
The sorting of the table "Prod. Order Routing Line" was askew.
The data type of field "Operation No." is Code, SQL default was varchar, thus the records in the table were sorted on characters.
Set the SQL Data Type to Interger for "Operation No." and all was well.
Thank you for the responces.

twdavis

additional follow up.

after making the change to the table "Prod. Order Routing Line", my client was still periodically experiencing the same error when attempting to 'finish' a released production work order. After researching, I found that the "Next Operation No." for the last "Operation No." for the work order in the table "Prod. Order Routing Line" was NOT blank like it should be. The immediate corrective action was to blank out the "Next Operation No." field value in order to "finish" the work order.

I back tracked and determined the code unit used to maintain the "routing line" table, was codeunit 99000772, "Prod. Order Route Management".

As an after thought, I also set the field "Operation No." property SQL Data Type to Integer in the "Routing Line" table as well. I am not sure if this will prevent the "Next Operation No." from being set to blank for the last "Operation No.". I guess time will tell.

My question is where is this called and at what point in the process of creating the routing for a BOM is this code unit called? Do you think this was the problem?

Thanks for your comments.