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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Purchase Order lines on Workflow Work item instructions

(0) ShareShare
ReportReport
Posted on by 110

Hi,

I'm trying to design the workflow email template for the Purchase Order approval. This is should include the Purchase Order lines. I have included the below in the work item instructions and then used %message% in my email template:

Purchase Order: %Purchase orders.PurchId%
Account Code: %Purchase orders.OrderAccount%
Account Name: %Purchase orders.PurchName%
Entered By: %Purchase orders.createdBy%

Lines:
Depot: %Purchase orders.Purchase order lines.DefaultDimension.A_Department%, Item: %Purchase orders.Purchase order lines.DefaultDimension.B_Item% - %Purchase orders.Purchase order lines.Name%, Qty: %Purchase orders.Purchase order lines.QtyOrdered%, Line Total: %Purchase orders.Purchase order lines.LineAmount%, Project: %Purchase orders.Purchase order lines.ProjId%

Total: %Purchase orders.CurrencyCode% %Purchase orders.Amount (exc VAT)%

Last note: %Workflow.Last note%

This below is how it is displayed in the email:

Purchase Order: 101~PO000032
Account Code: SLOK001
Account Name: Test Test
Entered By: Test User

Lines:
Depot: DSALFER,DSALFER, Item: STA0006,STA0006 - Archive Boxes,Stationery General, Qty: 0.00,0.00, Line Total: 5,100.00,20.00, Project: ,

Total: GBP 5,120.00

Last note: This is the submission comment

As you can see, the lines are not showing in a rows/columns format - is there any way for this to be done? I'm using D365 FO On-Prem (this is a busier forum! :) ) - i saw another post that says there are email templates you can choose from in AX2012 but I don't seem to have these in our version - any help would be appreciated.

Cheers

*This post is locked for comments

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans