GL TO PO Module Undelivered Orders Reconciliation and Stale PO UDO Balances Report - PowerPoint PPT Presentation

Pat_Xavi
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
GL TO PO Module Undelivered Orders Reconciliation and Stale PO UDO Balances Report PowerPoint Presentation
Download Presentation
GL TO PO Module Undelivered Orders Reconciliation and Stale PO UDO Balances Report

play fullscreen
1 / 14
Download Presentation
GL TO PO Module Undelivered Orders Reconciliation and Stale PO UDO Balances Report
248 Views
Download Presentation

GL TO PO Module Undelivered Orders Reconciliation and Stale PO UDO Balances Report

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

    1. GL TO PO Module Undelivered Orders Reconciliation and Stale PO UDO Balances Report

    2. STARS GL To PO Reconciliation U.S. Department of Energy 2

    3. STARS GL To PO Reconciliation U.S. Department of Energy 3 GL to PO UDO Reconciliation Report Layout This report contains the following balances for each allottee: GL UDO Balance (48x1 SGLS) GL Prepayment Balance (48x2 SGLS) GL UDO Balance plus Prepayments (48x1, 48x2 SGLS) CDR Cum Obs (42010100, 48x1, 49x1, 49x2 SGLS) CDR Cum Costs (42010100, 49x1, 49x2 SGLS) CDR Uncosted Balance (48x1, 48x2 SGLS) CDR Uncosted Balance less Prepayments (48x1 SGLS) GL UDO Balance to CDR Uncosted Balance Differences PO Obligations PO Costs PO UDO balance GL UDO to PO UDO Balance Differences

    4. STARS GL To PO Reconciliation U.S. Department of Energy 4 Discoverer Viewer Report Output at the CID and Fund level

    5. STARS GL To PO Reconciliation U.S. Department of Energy 5 This report provides the drilldown capability to all AFF segments, Treasury symbol, and Award Type

    6. STARS GL To PO Reconciliation U.S. Department of Energy 6 Discoverer Viewer Report Output drilled down to the CID, Fund, and Appropriation Year

    7. STARS GL To PO Reconciliation U.S. Department of Energy 7 Purpose of the GL to PO UDO Reconciliation Report This Report is a tool that will help accomplish the following tasks without having to run multiple reports: Certify the Undelivered Orders Balance in column 9 of the 2108 (with drilldown capabilities to the CID, AFF, and Treasury Symbol) Reconcile the differences in the Undelivered Order balances between the GL and PO Modules by Allottee, CID, and Fund Provide a method to reconcile Obligations and Costs from the Purchasing Module to Source Documentation.

    8. STARS GL To PO Reconciliation U.S. Department of Energy 8 How do we calculate the Undelivered Orders Balance in STARS? The Undelivered Order Balances from the Purchasing Module will be calculated using PO Distributions with the following formula: (Quantity Ordered-Quantity Cancelled)-Quantity Delivered. The Undelivered Order Balances from the CDR will be calculated by taking the sum of the balances of the following SGL accounts: 48010000 + 48020000 + 48310000+ 48320000 + 48710000 + 48720000 + 48810000 + 48820000. The GL Undelivered Order Balances (as seen on the DOE Undelivered Orders Report and column 9 of the 2108) is calculated by taking the sum of the balances of the following SGL accounts: 48010000 + 48310000 + 48710000 + 48810000.

    9. STARS GL To PO Reconciliation U.S. Department of Energy 9 The balances on the GL to PO UDO Reconciliation Report will be updated nightly. Transactions from the PO module must be posted in the GL by 6pm eastern standard time each day in order to appear on GL to PO UDO Reconciliation Report the following day. The following would have to occur by 6pm each evening in order to view todays PO activity in reports tomorrow: a. PO entered and approved/Receipt entered and saved.

    10. STARS GL To PO Reconciliation U.S. Department of Energy 10 The balances on the GL to PO UDO Reconciliation Report will be updated nightly. b. The Program Create Journals for PO ordered activity and Receipt Transaction Processor for PO receipt activity must have run in the background. c. The Autopost process must run to post all PO activity. If any of the above (a-c) does not occur before 6pm eastern, then the PO transactions will not be included on the GL to PO Reconciliation Report the next day.

    11. STARS GL To PO Reconciliation U.S. Department of Energy 11 How the Stale PO UDO Balances Report works Provides Stale PO Module Undelivered Orders balances based on the PO last update date.

    12. STARS GL To PO Reconciliation U.S. Department of Energy 12 Stale PO UDO Balances Report Layout Allottee Fund Reporting Entity WFO PO Number Award Type PO Last Update Date PO Stale UDO Indicator (Y/N) PO UDO Balance

    13. STARS GL To PO Reconciliation U.S. Department of Energy 13 Discoverer Viewer Report Output

    14. STARS GL To PO Reconciliation U.S. Department of Energy 14 Stale PO UDO Balances Selection Criteria 36 months for award type: 'PCS' 6 months for the following award types: TDY, CARD, CRDN, EMPM, TVL, LEGL, LOCAL, MISC, PENS , PILT, PRNT, SECY, TORT, 'TRNG, UTIL 12 months for all other award types