PeopleSoft Newsletter for Finance

Cross-Referencing GL Journal IDs to Requisitions and Purchase Orders

To assist you in your efforts to reconcile your financials data, two new queries have been developed to cross-reference GL journal IDs to requisition and purchase order numbers.  Journal IDs generated from the purchasing subsystem will either begin with “REQ” followed by a seven-digit number (REQ0012345) for requisition-related transactions or “PO” followed by an eight-digit number (PO00067891).  These journal IDs are not requisition or PO numbers.  Requisition and PO numbers are ten-digit numbers with no leading alpha characters (0000001234).

To cross-reference journal IDs beginning with “REQ” to the requisitions included in that journal, use query SB_JRNL_ID_TO_REQ_ID_XREF.  Enter the full journal ID at the prompt and a list of the requisition lines and their associated chartfield strings will be displayed.  To cross-reference journal IDs beginning with “PO” to the purchase orders included in the journal, use query SB_JRNL_ID_TO_PO_XREF.  Enter the full journal ID at the prompt and a list of the PO lines and their associated chartfield strings will be displayed.  Armed with the requisition or PO number cross-reference you can go into the procurement panels to view document detail.

For additional cross-referencing tips, see the “Purchase Order/Requisition Cross Referencing” document at: http://purchasing.csusb.edu/ps_purchasing.htm.