Purchase Order Version Relation With Workflow

(0) Share

Report

Posted on by Community Member

Hello everyone,

I want to see my Purchase order version is manually approved by WF or automatic approved. But I cannot find any direct relation between PurchOrderHistory and any Workflow table (workflow tracking table).

Can anyone help me with this?

Regards,

Smit Patel

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Smit Patel,

Can't you get this information through the 'tracking list details' and 'tracking details' forms in the workflow history?

There we have the user field, the one who was assigned a task, who approved/completed a task, etc.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

We are getting details but it is related to purch Table header. Purchtable history which holds versions details we are not able to establish relationship.

Regards,

Smit Patel

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Here we need to fetch total lines amount in last manually approved version.

Was this reply helpful? Yes No
Khaled Alloud 3,658 on at

Like (0)

Report
Copy link

Link copied!

Hello,

- What do you mean by 'manually approved by WF or automatic approved'.

- And are you talking functionally on the system, or technically by code (tables) ?

Thank you,

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

We have added customization, in which based on total line amount of PO WF gets triggered. If it is lesser than some threshold amount it should automatically approve else it should manually approve.

Now if my threshold amount is 1000.

User creates PO1--> 1200 --> Manual Approval

User creates PO2 --> 800 --> Auto Approval.

Now if user does some changes through change request.(Only continuing with PO1Case)

User modifies PO1A--> 2201 (which is higher than threshold)--> Manual Approval

User modifies PO1B--> 2199 (which is less than threshold)--> Auto Approve

Now user again changes PO

PO1A --> 3200 (It should go to autoapprove as last manually approved amount is 2201 --> user can enter data till 3201)

PO1B --> User changes it to 2201 (It should go to manual approve as last manually approved amount is 1200 for this case. So I need to fetch that 1200 amount from Purch Order History Table, here though amount is added 2 $ more only (lesser than threshold), it went for manual approval as previous manual approval was only 1200.)

I hope This explains my requirement.

Thanks.

Regards,

Smit

Was this reply helpful? Yes No