some of the field display blank in prodroute form

Hi,

In prodroute form,some of the field like operation,run time,process qty,qualityorderstatus display blank for some of the wordorder. please can you suggest me, how the blank value is assigned for the above fields in prodroute form.

Here is path for the "ProdRoute" form

Production control/Common/Production orders/All production orders ->production details group ->Route  menu  -> prodRoute form.

  • The operation is mandatory field. How is this production order created? Were you able to reproduce the issue?

    Please tag your AX version.

  • In reply to Kranthi:

    Hi,

    It is Ax 2012.

    Yes operation field is mandatory.

    We are not use production order to create,we use batch order instead of the "production order".In prod route form for particular order blank record is created. In prodroute table also blank record is created.can you suggest me possible solution.please see screenshots for your reference.

  • In reply to Madhusrinethi:

    Did it happened only one for one order or you can still reproduce it with that item?
    Have you tried to look at the route related to that product?
  • In reply to Kranthi:

    yes, I have tried route related to the item is present,created batch order with item which having issue but unable to reproduce the Issue , batch order created without blank records.Issue happens for the 2 order.suggest me the possible solution
  • In reply to Madhusrinethi:

    can anyone suggest me the solution for the pblm
  • In reply to Madhusrinethi:

    If you cannot reproduce it, then it could be a data issue. What is the status of the batch order? What is the source of batch order (master planning)?
    If possible, try deleting the batch order and create new one. (you can only delete it if the order is not ended, by resetting the status of the order).
  • In reply to Kranthi:

    Hi,
    Batch order status is "Ended".
    What is the source of batch order (master planning)? can you explain me about this point.How can i check source of the batch order.Can you suggest me the possible solution.

  • In reply to Madhusrinethi:

    There is no solution. Your order is ended so you recorded what was done. This should have been checked before ending. They are blank because at the point of creation the data in the route field was blank.

    Black is allowed, what is your actual issue?
  • In reply to AdamRoue:

    Hi,
    They are blank because at the point of creation the data in the route field was blank.
    Are saying about route table.Can you tell me when the record is inserted into the route table with blank route id.how route record is related to the prod route.
  • In reply to Madhusrinethi:

    Each time I have seen this it is because people force entries into the route table, somettimes not related to an item so it appears on every route, sometimes item specific.

    You could check if the Formula has a Formula with Phantoms and the routes there, but generally for me it is poor data creation or people messing in the route relations table - you cannot manually create the scenario but you can look at the route relations in the production module from the routes and remove elements, but generally for me the issue has been data.
  • In reply to AdamRoue:

    Hi,
    Issue appears only for particular item.
    Can you tell me how to check the formula with phantoms and route.how to look at the route relations in production module...I am unable to see the route relation can you tell me path to see the route relation.
  • In reply to Madhusrinethi:

    On the formula on the general tab see the Line Type.
    For the table analysis I would get someone to look at the tables in the AOT, opening it from the front end may filter our rogue entries due to the table relations, but you can see the table from the front end by going to the Operations option in the Production setup and seeing relations, but you are looking for a blank operation which you cannot see from that front end, but it gives you an idea of the table relations.
    You only need to do this if the issue is still happening, if not the data has been corrected.
  • In reply to AdamRoue:

    I have checked the route relation is present.Formula Line type is "item".Issue is not happening now ,Are you saying data is corrupted.
  • In reply to Madhusrinethi:

    It is not if the route relation is present, it is what is in the table. However if the issue is not happening now then someone has fixed the corrupt data so you are looking for something you cannot find - the batch order with the route like that is proof the data was incorrect.
  • In reply to AdamRoue:

    Hi,
    can you tell me to reproduce the issue
Related
Recommended