Dynamics Community Forum Thread Details

Purchase Order lines on Workflow Work item instructions

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

Quick Links

Leaderboard