Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
How to create a Descriptive Flexfield in PO_DISTRIBUTIONS with default value SQL Based — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to create a Descriptive Flexfield in PO_DISTRIBUTIONS with default value SQL Based

Received Response
28
Views
15
Comments
edited Feb 6, 2020 5:21PM in Purchasing 15 comments

Summary

Create a DFF with default value SQL

Content

I'd like to create a DFF in PO_DISTRIBUTIONS for automatically display Funds Available amount (XCC_BALANCES). With this information, be’ll posible compare distribution amount versus funds available.

When the Budget Amount is less Purchasing Distribution amount, I’d like to create a specific rule in Purchase Approval (BPM) requesting a different approval. This is because, when the purchase amount is equal or less Requisition amount, the system don’t check the Budget. The Funds status in this case is equal a Approved.

Is this possible?

Version

19D

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!