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 query for encumbrance amount on an Open status Purchase Order

edited Jan 9, 2024 7:37AM in Purchasing 2 comments

Summary: We currently have PO139487 that has a status = Open. We are trying to query the tables to identify the encumbrance amount of $ 8,773 (35,700.00 - 26,927.00) using this table - PJC_XCC_BURDEN_DISTS. There should be an encumbrance of $ 8,773. Does anyone happen to know what columns in table PJC_XCC_BURDEN_DISTS would help me identify the encumbrance amount? If there is a better table(s) to help me find the encumbrance amount, please let me know as well.


Howdy, Stranger!

Log In

To view full details, sign in.

Register

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