Where is Purchase Requisition.Approval Amount

(4) Share

Report

Posted on by J_Lee

1,266

In the purchase requisition workflow, there has a field "Purchase Requisition.Approval Amount" to be selected as conditional.

However, i cannot find this field in PurchReqTable and PurchReqLine.

BTW, which table is used for [Totals] fly-out form

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (7)

Answers (2)

Suggested answer

Adis 6,080 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Its a condition that sets the workflow approval to approved or rejected, depending if the condition is met or not. However, I dont think you can see the condition. You may see it under organisation administration workflow history and then selecting the workflow, once its submitted.

Kind regards, Adis

If this helped, please mark it as "Verified" for others facing the same issue

Keep in mind that it is possible to mark more than one answer as verified

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,421 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi J Lee,

On the workflow class for the purchase requisition the approval amount is a virtual field managed with a method using X++ coding.

Was this reply helpful? Yes No
JF-11061402-0 20 on at

Like (0)

Report
Copy link

Link copied!

@André Arnaud de Calavon Hey. Could you explain a bit more about the X++ coding?

I raised a PR for 91000 EUR and this failed the condition of Purchase Requisition.Approval Amount > 90,000 EUR. Do you know why this is? What is the calculation?

I raised another PR for 95000 EUR and this passed the condition

Was this reply helpful? Yes No
Sohaib Cheema 49,492 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi @JF-11061402-0

One logical reason for the condition to be skipped is if the purchase requisition purpose is of type Replenishment rather than Consumption, in which case the total would sum to zero in the workflow condition.

1 people found this reply helpful.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,421 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi JF-11061402-0,

Does the PR has the EUR as currency? Or did you calculate the foreign currency to EUR? Is 91000 including or excluding VAT?

You can find the X++ logic for the calculated field on the class for the PR workflow document.

1 people found this reply helpful.

Was this reply helpful? Yes No
JF-11061402-0 20 on at

Like (0)

Report
Copy link

Link copied!

Hi @André Arnaud de Calavon

PR is in EUR currency (see totals below)

Condition is here

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,421 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi J Lee,

You marked a reply as verified answer. Is your question fully answered?

Was this reply helpful? Yes No