Use this to write a formula for the Description field on JobManager Jobs. By entering [[ ]] in the field, a value from a related table can be inserted.

Syntex is [[Table Number, Field Number]].

Eg. [[18,9]] indicates table 18 (Customer) and field 9 (Phone No.).

Below is a table of possible tables in different scenarios.

Table Number Tablename Active for Ref.Type
6182601 JobManager job All
5405 Production Order Production
5406 Prod.ordrelinje Production
5409 Prod. Order Routing Line Production
167 Job Job
1001 Job Task Job
1003 Job Planning Line Job
5900 Service Header Service
5901 Service Item Line Service
5902 Service Line Service
5940 Service Item Service
900 Assembly Header Assembly
901 Assembly Line Assembly
18 Customer Job, Service
27 Item Production, Service, Assembly
99000754 Work Center Production
99000758 Machine Center Production
152 Resource Group Job, Service, Assembly
156 Resource Job, Service, Assembly
7500 (X) Item Attribute (X) All

(X) Item Attribute

See also

Reference

JobManager Setup


This help includes both Dynamics NAV and Dynamics Business Central (BC). All references to NAV applies to both.