Dynamics Community Forum Thread Details

Purchase Requisition Line Workflow Condition Sales tax group uses wrong field (ProjtaxgroupID)

L.s,

I have created a workflow for Purchase Requisition Line Review
- I want an automatic action and created a condition for the line
- When I check in the condition on the field "purchase requisition lines.Product name" it works as expected, so the concept and setup seems fine

But I want to check on the field "sales tax group" and this don't work as expected:
- I select in the condition the field "purchase requisition lines.Sales Tax group"
- Condition don't give the expected result

I did some research and tests:
- In the DataBase table "Expressions" I see in the Expression that the field "ProjTaxGroupID" from the PRline is used instead of the field "(Sales)TaxGroup"
- I didn't use a Project for my PR so I use "(Sales)TaxGroup" in the PRline.
- When I enter on de PRline both fields and fill them with a different Tax Group. I see the field "ProjTaxGroupID" is evaluated in the condition.
- I experimented with other fields in the condition in the workflow but can't find one that evaluates the field "(sales) Tax Group".

Question:
- Is there a table or something where I can set the relation between:
"purchase requisition lines.Sales Tax group" and the actual field that will be used in the condition?
- Any other option so I can evaluate the field "(sales)taxgroup" in the condition in the PR line review workflow?

Thx in advanced
Peter

image_2D00_2021_2D00_02_2D00_19_2D00_00_2D00_24_2D00_14_2D00_643.png