Jobs and Resources: Job Status

sgsatl

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

Albertvh

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

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

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

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

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