Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Why can't we select Workflow status in Ledger daily journal workflow

Posted on by 504
Hi all,
 
Regarding Ledger Daily Journal Workflow, for the main table LedgerJournalTable, as per my understanding the field to identify that the record is already approved or not is the field named WorkflowApprovalStatus.
May I know why this field not appeared in the workflow it self ?
This screen is taken from LedgerDailyJournalWorkflow, within its ApprovalJournal-Step like below picture:
 
And how to make the field appear ?
 
Thanks
 
  • Verified answer
    Waed Ayyad Profile Picture
    Waed Ayyad 6,332 Super User 2024 Season 2 on at
    Why can't we select Workflow status in Ledger daily journal workflow
     
    If adding the field to the query helps you, mark my answer as verified in order to help others get this information in the future.
     
     
    Regards,
    Waed Ayyad
  • Ken Manhattan Profile Picture
    Ken Manhattan 504 on at
    Why can't we select Workflow status in Ledger daily journal workflow
    Hi Expertopinionsa12,
     
    About the field not available in Workflow editor is solved. I followed Waed's advice here to add the field in LedgerJournalWFApprovals Query.
     
    Next is about my original intention, which I'm afraid it is not possible, by studying what Andre's reply.
  • Ken Manhattan Profile Picture
    Ken Manhattan 504 on at
    Why can't we select Workflow status in Ledger daily journal workflow
    Hi Expertopinionsa12,
     
    I've added the field "WorkflowApprovalStatus" in its form "LedgerJournalTable". I guess it does not need to be in the grid, right ? Currently, it is put in Tab General (just for testing)
     
    But somehow it is still doesn't show in field selection of the workflow:
     
  • Ken Manhattan Profile Picture
    Ken Manhattan 504 on at
    Why can't we select Workflow status in Ledger daily journal workflow
    Hi Andre,
     
    "step 1 should be completed before it will activate step 2", does it mean, even when it is overdue (time limit of Step1 exceeded), it will not trigger Step2 ?
  • Suggested answer
    Why can't we select Workflow status in Ledger daily journal workflow
     

    Hey Ken Manhattan,

     

    Good question! It seems like you're looking for the WorkflowApprovalStatus field in the LedgerDailyJournalWorkflow, but it's not showing up. To make it appear, you might want to check the configuration of your workflow. Ensure that the WorkflowApprovalStatus field is added to the appropriate form or view. If it's still not showing, try customizing the form to include that field. Sometimes, it's about tweaking the display settings. Hope this helps! If you need more assistance, feel free to ask Thanks!

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    Why can't we select Workflow status in Ledger daily journal workflow
    Hi Ken,
     
    In case a user will approve the journal in step 1, then the field value on the journal is not updated directly. So, in step 2, it is still pending. Your idea will not work as step 1 should be completed before it will activate step 2. In case you need to send reminders, you can e.g. use Power Automate flows sending emails based on open work items.
  • Ken Manhattan Profile Picture
    Ken Manhattan 504 on at
    Why can't we select Workflow status in Ledger daily journal workflow
    Hi Waed,
     
    Form is LedgerJournalTable. and for the Query, I don't have any extension in that query for now. 
    Thanks,
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 6,332 Super User 2024 Season 2 on at
    Why can't we select Workflow status in Ledger daily journal workflow
     
    Yes, in case you want this field to appear in the Workflow, try to add it using an extension to the Query.
     
    For your question why you have more fields, do you have any other extension to the query? Also can you give me the name of the form that has this workflow?

     
    Regards,
    Waed Ayyad.
     
    Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
     
  • Ken Manhattan Profile Picture
    Ken Manhattan 504 on at
    Why can't we select Workflow status in Ledger daily journal workflow
    Hi Billur,
     
    I want to make my workflow check if the approver already approve or not, in other words, already take action or not ?
    If it is not, I want to have the same step repeat (at least 1 time).
     
    So, I'm thinking, in that Step1, there will be no escalation, and let it over due, then I will add another step : Step2 with the same approver with some extend time limit. This step will only run if Step1 not yet approved or rejected. Does it make sense ? and does it applicable ? the intention is to make a reminder for the approver that he/she has not taking any action. Then in this Step2 I will set the escalation and for auto-reject, if the approver still not taking any action (for the 2nd time)
     
    Or do you have some idea how to make a reminder ?
    Worth to mention again, I only want to remind by email when it is due, not to auto reject or approved when there is no action. Purely just remind again by sending email notification.

     
    Thanks,
  • Ken Manhattan Profile Picture
    Ken Manhattan 504 on at
    Why can't we select Workflow status in Ledger daily journal workflow
    Hi Waed,
     
    After checking that query, it is not included, as below:
     
    But I found those fields (for table LedgerJournalTable) also lesser than what being displayed in workflow as well.
     
    Aside from it, if the field selection in Workflow editor is based on this Query, does it mean I have to customize this Query and add WorkflowApprovalStatus field manually through some extension ?
     
    Thanks,
     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans