OTBI PO Balance Report to Tie to Budgetary Control Obligation Balances — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

OTBI PO Balance Report to Tie to Budgetary Control Obligation Balances

Summary:

I am attempting to build an OTBI report that will pull PO balances by PO that will ultimately tie to a cost centers obligation balance in Budgetary Control. We created a formula that takes the PO balance - the PO Matched Amount to manually calculate the PO Balance. However, this formula is not correct when a PO has been closed or finally closed with a balance remaining.

Is there a formula that can be used to say if a status is "Closed" or "Finally Closed", the PO Balance should be $0?

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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