1 Reply Latest reply: Oct 11, 2012 6:15 AM by John van der Kooij RSS

    PeopleSoft 9.1 - Finalized PO Reporting

      Hello. We use Peoplesoft 9.1 and I need to create a query that will show me POs that have/have not been finalized. Can anyone help me find the field that I need to include in a query that shows that information? Thank you!
        • 1. Re: PeopleSoft 9.1 - Finalized PO Reporting
          John van der Kooij
          According to Google:

          PO_HDR Purchase Order Header - Header Record for Purchase Order
          PO_LINE Purchase Order Line - Line Record for Purchase Order
          PO_LINE_DISTRIB PO Line Accounting Entries - Accounting Distribution for Purchase Order
          PO_LINE_MATCHED PO Line Billed Amounts - Match Information for PO (Voucher, Receipt, PO)
          PO_APPROVAL Purchase Order Approval - Approval Information for Purchase Order
          PO_LINE_SHIP PO Line Shipping Schedule - Shipment Details for Purchase Order

          Maybe PeopleBooks on Financials has more or better information.