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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Line item workflow dev...
Microsoft Dynamics AX (Archived)

Line item workflow development

(0) ShareShare
ReportReport
Posted on by Rishi1403 1,370

Hi all,

I am working on workflows and have developed workflows for SalesTable, CustTable and SalesQuotationTable.

Now, I need to develop a workflow for line items i.e. SalesLines and SalesQuotationLines. I have followed the guidelines which are mentioned on the msdn for development of line item workflow but stuck on a point and didn't find a way out.

I have created a whole new workflow for lines, Is this really needed or just the workflow type development would get it done ? Now while adding the line item workflow to my sales table workflow it asks for a property "LineItemWorkflowRelation", In case of PurchReqReview workflow type this property shows a value in lookup. I am not getting that lookup. Could anyone please help me out ?

Many Thanks in advance,

Rishi

*This post is locked for comments

I have the same question (0)
  • Jonathan Halland Profile Picture
    Jonathan Halland 11,310 on at

    Hi Rishi. You do need to develop a who new workflow type and create a configuration against this type. Next you need to add it as a available line item workflow type on the header workflow type.

  • Rishi1403 Profile Picture
    Rishi1403 1,370 on at

    Hi Jonathan,

    Appreciate your quick response. I have created a whole new workflow and while I tried to add it to the header workflow type, It asked for a property named "LineItemWorkflowRelation" into which the lookup is empty. I didn't find the loop hole here.. :(

  • Jonathan Halland Profile Picture
    Jonathan Halland 11,310 on at

    Does your line table have a relationship defined to the header table and is it linked in the line's workflow document query?

  • Rishi1403 Profile Picture
    Rishi1403 1,370 on at

    Yes, there exists a relation between the line table and the header table and is linked with the workflow document query properly.

  • Verified answer
    Jonathan Halland Profile Picture
    Jonathan Halland 11,310 on at

    Hi Rishi.

    I finally figured out the issue. You need to do the following: On the query linked to you header workflow. You need to link in your line table as a sub datasource to the header datasource. Then most importantly you need to change the "FetchMode" to 1:n instead of 1:1. This will enable you to find the relationship on your header workflow type. I'd recommend also setting the joinmode to OuterJoin.

    I hope this helps

  • Rishi1403 Profile Picture
    Rishi1403 1,370 on at

    Ok... got it. Ton of thanks for the kind help.

    I'll implement the solution and get back to you if there's still remain any issue with the same.

    Regards,

    Rishi

  • Verified answer
    Jonathan Halland Profile Picture
    Jonathan Halland 11,310 on at

    8267.2015_2D00_08_2D00_21_5F00_1054.png

    Here is a screenshot illustrating the above things you need.

  • Rishi1403 Profile Picture
    Rishi1403 1,370 on at

    Now, that's the kind of expertise I needed.

    yes, the issue is resolved and everything is going good.

    Many Thanks once again for your precious advice. I appreciate it.

    Cheers !

    Rishi

  • Rishi1403 Profile Picture
    Rishi1403 1,370 on at

    Jonathan, one more thing I need to ask is "I cannot see the canSubmitToWorkflow method on purchreqline table", so is it necessary to have one on line ?

  • Verified answer
    Jonathan Halland Profile Picture
    Jonathan Halland 11,310 on at

    No, you can build that logic into your header workflow conditions for executing line level workflows.

    Glad I could assist.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Sukrut Parab Profile Picture

Sukrut Parab 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans