web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Job Planning Line Custom attribute to be available in Job Journal Line and Job Ledgers Entries

(0) ShareShare
ReportReport
Posted on by 105

HI Experts, 

My aims is to create a Job planning line custom  attribute that would represent the "progress %" of task execution. It's value is depending on physical completion of a task, manually filled by users.

if i have 100 meters of lane to install and only installed 20 meters, than I'm 20% done.

I've created using code three attribute to job planning lines (progress - base, always 100, Remaining Progress, Posted Progress, and i wish this value to be available in job journal but also in job ledger entries.

I created the same in job journal, updated by an event (onAfterJobPlanningLIneToJobJnl) (it is not possible to extend codeUnit)

For job ledger entry, after created the progress attribute for this table, i use an event, OnAfterJobLedgerInsert entry to update the value after posting the JobJnl Entry.

WIth this Progress% I will be able to forecast the real cost of a job and be able to invoice customer before job ends if necessary.

In my company, we are working in micro task (10 min to 2h), and a user can send 20 to 30 tasks a day in job journal. For this, I'm always afraid about performances issues by using event, but also, adding custom attributes that requires amount of setRange/SetFilter on job planning lines, job journal, and job ledger entries to be updated.

Is there any other and better way to get it working fine ? 

Any deep documentation would be welcome.

Hicham

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    133 on at

    Have you used telemetry to determine the performance? A lot of documentation on this available if you search. The implementation in terms of event usage is certainly appropriate. Is it in anyway possible to just have the field markers and to do a batch job in the evenings? At this moves performance issues off the toes of the users and onto the job queue.

  • Hicham OE Profile Picture
    105 on at

    I'm going to get a trainingon the batch JOb. It sounds good :)

    Thnak you Josh

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans