Skip to main content

Notifications

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

  • Hicham OE Profile Picture
    105 on at
    RE: Job Planning Line Custom attribute to be available in Job Journal Line and Job Ledgers Entries

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

    Thnak you Josh

  • Suggested answer
    JAngle Profile Picture
    95 on at
    RE: Job Planning Line Custom attribute to be available in Job Journal Line and Job Ledgers Entries

    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.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,452

#2
YUN ZHU Profile Picture

YUN ZHU 1,313 Super User 2025 Season 1

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 1,083 Most Valuable Professional

Featured topics

Product updates

Dynamics 365 release plans