How to create a Descriptive Flexfield in PO_DISTRIBUTIONS with default value SQL Based
SummaryCreate a DFF with default value SQL
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?