Jobs and Resources: Job Status

sgsatl
sgsatl Member Posts: 3
edited 2005-04-22 in NAV/Navision Classic Client
In the online help (F1 key) for the Jobs menu, there are supposed to be 4 different job statuses: Planning, Order, Quote and Completed. In our instance (3.70) I only see Planning, Order and Quote.

Does anyone know how to add Completed back to the list of statuses for jobs? What is the underlying table that holds this information? The Jobs table has a Status column that is numerical so it must link to another table. I just can't figure out which one it is.

Thanks

Comments

  • Albertvh
    Albertvh Member Posts: 516
    Hi,
    The Status field on the Job Table is an Option field and the property should look something like this

    OptionString Planning,Quote,Order,Completed

    If you only have "Planning,Quote,Order" add ",Completed" to the end

    Regards

    Albert
  • sgsatl
    sgsatl Member Posts: 3
    Thanks for the reply. Would you be able to explain a little more please?

    When I look at the data in the Job table, the Status field has values of 0, 1 and 2. I am assuming these relate to the Planning, Quote and Order statuses.

    Where do I add the Completed value as you stated in your previous post? I was guessing that it was a lookup table that was being used and the Job.Status field joined with this lookup table but I can't seem to find one.

    Thanks again for the help.
  • Albertvh
    Albertvh Member Posts: 516
    Hi

    Fields that have the datatype of option use numerical characters to show their value, so in the case of the job status field you would have the following

    Planning,Quote,Order,Completed this would relate to

    0 = Planning
    1 = Quote
    2 = Order
    3 = Completed

    If you go into the object designer and design of the Job table (167) and go to the field Statusfield 19 click on the Properties button and you will see one of the property fields "OptionString" in your case it would probably only have the following

    Property Value
    OptionString Planning,Quote,Order

    The standard value should be


    Property Value
    OptionString Planning,Quote,Order,Completed

    The is no relation to any other table for these options.

    Hope this helps.
  • Auke
    Auke Member Posts: 17
    When you open the Job table in the design mode and select the status field. then open the properties of the field.

    there should be an optionstring with the options: Planning,Quote,Order,Completed

    in your CaptionML is (I suppose) the option completed not "translated"
  • Auke
    Auke Member Posts: 17
    Albertvh wrote:
    Hi

    Fields that have the datatype of option use numerical characters to show their value, so in the case of the job status field you would have the following

    Planning,Quote,Order,Completed this would relate to

    0 = Planning
    1 = Quote
    2 = Order
    3 = Completed

    If you go into the object designer and design of the Job table (167) and go to the field Statusfield 19 click on the Properties button and you will see one of the property fields "OptionString" in your case it would probably only have the following

    Property Value
    OptionString Planning,Quote,Order

    The standard value should be


    Property Value
    OptionString Planning,Quote,Order,Completed

    The is no relation to any other table for these options.

    Hope this helps.

    In the Dutch version is the status field used in the posting codeunit (202)
    Only if the status is Order there can be job journal lines posted

Categories