9b6d79d09c25a1ced0ad3fd7aafea22a.ppt
- Количество слайдов: 107
WELCOME TO THE FINANCIAL SERVICES CENTER AUSTIN, TEXAS A/O FEB 2009
TABLE OF CONTENTS CONSTRUCTION ACCOUNTING CLASS Section 1 1. 2 – 1. 3 1. 4 -Course Outline -Objective -Course Overview 2. 1 – 2. 7 2. 8 – 2. 18 2. 19 2. 20 2. 21 – 2. 22 2. 23 -Budget Execution -Initiating the TDA -Funding and Budget Tables -Program Class Listing -Description of Inpatient & Outpatient Care -Application Table Descriptions -Accounting Element Definitions 3. 1 – 3. 10 3. 11 – 3. 13 3. 14 – 3. 16 3. 17 – 3. 18 3. 19 3. 20 -Obligations -FMS Tables -SO Obligation -AO Obligation -Construction Appropriations -FMS Procedures Guide for Obligations 4. 1 4. 2 – 4. 6 4. 7 – 4. 23 4. 24 – 4. 28 4. 29 4. 30 4. 31 -Payment Processing -PV, MV, PG, CT Info -PV Document -MV Document -PG Document -CT Document -Prompt Pay Determination -FMS Procedures Guide for Payments Section 5 5. 1 -5. 9 -Expenditure Transfer Section 6 6. 1 -6. 4 -Research for Check Number or Trace Number Section 7 7. 1 – 7. 7 -Reconciliation (Balance/Audit Construction CPM Section 8 8 – 8. 2 8. 3 – 8. 6 8. 7 -RSD Overview -WIP Report, SV 70 -F 744 Trial Construction Balance Section 2 Section 3 Section 4 Section 9 -Miscellaneous (FMS info, Prompt Pay Codes, Certified Payment info, Proforma, FMS tables)
CONSTRUCTION ACCOUNTING COURSE OUTLINE 1
Instructors: Benita Temple Leticia Sierra Class Schedule: Class begins at 8: 30 AM Class ends at 4: 00 PM 1. 1
OBJECTIVE • The objective of this course is to provide an overview of construction accounting including budget, “handson” obligation and payment processing in the Financial Management System (FMS). 1. 2
Upon completion of this course the student will be able to: Ø Identify budget sub-system tables relating to unobligated balances Ø Describe the allotment of funds and usage of various projects Ø Explain procedures for project requests and funds distribution Ø Use FMS to: Ø Process obligations and payments Ø Determine the status of construction projects Ø Reconcile projects through the use of FMS tables 1. 3
COURSE OVERVIEW q INTRODUCTION q PAYMENTS: q BUDGET Vouchers PROCESS: Modifications Project q MISC OTHER: requests Expenditure Initiating Transfers station TDA’s Reconciliations Funding RSD Reports projects in Prompt Pay FMS Proforma Verification of Funding FMS Tables q OBLIGATIONS: Other Helpful Information Establish new obligations Modify existing obligations 1. 4
BUDGET EXECUTION 2
INITIAL REQUEST TO ESTABLISH A PROJECT • Major (36 X 0110) VISN submits a 5 year plan in the CAMS Building and Land Portfolio online application. A concept paper (CP) is evaluated by the VA Capital Investment Panel (CIP). If the CP is accepted, the next step is to prepare the business case application and submit online using CAMS. Proposals of all asset types are presented to the SMC as a prioritized list of investments. The SMC members review the list and vote on which projects will be included in the annual budget request. • Minor (36 X 0111) Facilities submits an electronic 1193 in the VSSC Capital Asset Database VISNs submit their lists to VHA Capital Asset Management and Planning Service (CAMPS) (10 NR). The plan must be concurred and approved by the Office of Asset and Enterprise Management (OAEM) (004 B). Note: 36 X 4538 (Construction/Operation of Parking Garage) was deactivated for FY 05, however active projects prior to FY 05 will continue to be processed using 36 X 4538. 2. 1
POSTING THE NEW YEAR’S BUDGET Fund: 0111 Minor Construction Source: Final Appropriations Bill Steps: • Receive Final Appropriations Bill • Verify Minor Construction funding categories specified in the appropriations bill exists on the Program Class Table (PCLS). If fund categories do not exist on the PCLS, add them. • Calculate total budget for all Minor Construction funding categories specified in the Appropriations Bill. • Verify the availability of funds on the Allotment Table (ALOT). • Enter Allowance (AL) documents to post funds for each funding category. • Verify allowance entries on the Allowance table (ALLW). 2. 2
ENTERING ESTIMATED APPROVED COSTS FOR A DIRECTLY APPROPRIATED PROJECT Fund: 0110 Major Construction Source: Form 6227, Construction Cost Estimates Steps: • Receive Form 6227, Construction Cost Estimates • Verify the availability of funds on the Project Suballowance Spending Control Table (SAS 2) • Enter an allocation on the Project Table (PROJ) for each project/control point. Verify allocation entry on the Project Table (PROJ). 2. 3
ISSUING CONTROL POINT ALLOTMENTS FOR A DIRECTLY APPROPRIATED PROJECT Fund: 0110 Major Construction Source: Major Construction Contract Steps: • Receive Major Construction Contract from Project Manager. • Locate the project/control point record on the Project Table (PROJ). Verify the availability of funds on the Project Table (PROJ). • Enter an allotment for the project/control point. Verify allotment entry on the Project Table (PROJ). • Repeat steps 2 and 3 for each project/control point on the contract. • Prepare Transfer of Disbursing Authority (TDA). Include Budget Fiscal Year on the TDA for referencing purposes. • Send TDA to facilities. 2. 4
ISSUING CONTROL POINT ALLOTMENTS FOR A NON-DIRECT PROJECT Fund: 0110 Major Construction and 0111 Minor Construction Source: Request Steps: • Receive request from Program Manager, Project Manager, Cemetery, or Regional Office to issue control point allotments for a non-direct project. • Verify project number exists on the Construction Project Table (PGM 2). If the project number does not exist on PGM 2, add it. • Verify the availability of funds on the Allowance Table (ALLW). • Enter a Suballowance (SA) document to post funds for the project. • Verify SA entry on the Suballowance Spending Control Table (SAS 2). • Enter an allocation and allotment on the Project Table (PROJ) for each project/control point. Verify allocation and allotment entries on the PROJ. • Prepare the Transfer of Disbursing Authority (TDA). Include Budget Fiscal Year on the TDA for referencing purposes. • Send TDAs to the facilities. 2. 5
INITIATING THE STATION TDA • Central Office initially establishes the project record in FMS on the PGM 2 table. This table is for construction projects only. After entering BFY and station number on the PGM 2, a list of all the projects for this station will be displayed. 2. 6
MAJOR & MINOR CONSTRUCTION ACTION: S TABLEID: PGM 2 USERID: S 104 BMT CONSTRUCTION PROJECT DATA SCREEN KEY IS BFY, STATION, FCP/PROJ PROGRAM ALLOWANCE BFY STATION FCP/PROJ CLASS CATEGORY TYPE GROUP PROJECT STATUS ------- ---------- -----01 - 09 523 PROJECT NAME: SHORT NAME: 02 PROJECT NAME: SHORT NAME: 03 PROJECT NAME: SHORT NAME: 04 PROJECT NAME: SHORT NAME: 05 PROJECT NAME: SHORT NAME: 06 PROJECT NAME: SHORT NAME: 07 PROJECT NAME: SHORT NAME: 2. 7
PGM 2 TABLE PGM 2 Required Fields: • • • Budget Fiscal Year Station Number FCP/PRJ – Project Number has 7 characters – Example: OP 3317 (OP 3 317) OP = Class (PCLS Table) 3 = Minor Construction Approp. 2 = Major Construction Approp 317 = Serial Number (PCAT Table) Position 7 = Phase Code (blank when there is no phase) 2. 8
PGM 2 TABLE ACTION: R TABLEID: PGM 2 USERID: S 104 BMT CONSTRUCTION PROJECT DATA SCREEN KEY IS BFY, STATION, FCP/PROJ 01020304050607 - PROGRAM ALLOWANCE BFY STATION FCP/PROJ CLASS CATEGORY TYPE GROUP PROJECT STATUS ------- ---------- -----09 523 IP 3345 IP 345 H NI IP 3345 H PROJECT NAME: PSYCHIATRIC NURSING UNIT B 1 -4 N SHORT NAME: PSYCH NH B 1 09 523 IP 3347 IP 347 H NI IP 3347 J PROJECT NAME: PRIMARY CARE & ER MOD SHORT NAME: PRIM CARE ER 09 523 OP 3310 OP 310 H NI OP 3310 J PROJECT NAME: HUNTINGTON HOUSE 1 & 2 SHORT NAME: HUNT HSE 1&2 09 523 OP 3317 OP 317 H NI OP 3317 J PROJECT NAME: RENOVATE B 3 AMB CARE SHORT NAME: RENOV B 3 AMB 09 523 OP 3317 B OP 317 H NI OP 3317 B J PROJECT NAME: RENOVATE B 3 FOR AMB CARE SHORT NAME: RENO B 3 AMB 09 523 OP 3320 OP 320 H NI OP 3320 PROJECT NAME: EYE CLINIC CONSOLIDATION B 1 -8 B SHORT NAME: EYE CL 09 523 OP 3330 OP 330 H NI OP 3330 N PROJECT NAME: EYE CLINIC CONSOLIDATION B 1 -8 B SHORT NAME: EYE CL PGM 2 TABLE IS FOR CONSTRUCTION PROJECTS ONLY 2. 9
REVIEW FUNDING ON SAS 2 ACTION: R TABLEID: SAS 2 USERID: S 104 BMT *** PCAS SUBALLOWANCE SPENDING CONTROL INQUIRY SCREEN *** KEY IS BUDGET FISCAL YEARS, FUND, A/O, STN, FCP/PRJ, LMT BFYS: 09 FUND: 0111 ADM/OFF: 08 STN: 523 F/P: CA 3338 LMT: STN NAME: BOSTON MA VAMC SPENDING CONTROL OVR: FCP/PRJ DESC: SPEC CARE CLINIC/OUP PAT PHARM FTES/QTY: 000000 STATUS IND: A APPROVED IND: Y POST QTR: 1 TRANS TYPES - PENDING: 01 APPROVED: 02 POSTED: 03 APRV SUBALLW AMT: 217, 616. 00 YTD UNLIQ OBLG AMT: 217, 616. 00 YTD SUBALLW AMT: 217, 616. 00 EXPENDED AMT: 0. 00 PROJ ALLOC AMT: 217, 616. 00 PROJ UNALLOC AMT: 0. 00 UNOBLIG SUBALLW AMT: 0. 00 QTR 1 2 3 4 ORIG SUBALLW AMT 217, 616. 00 0. 00 PEND SUBALLW AMT 0. 00 APRV SUBALLW AMT 217, 616. 00 0. 00 QTR 1 2 3 4 END QTR AVAILABLE 0. 00 UNLIQ OBLG AMT 0. 00 217, 616. 00 EXPENDED AMT 0. 00 2. 10
JOBT TABLE ACTION: R TABLEID: JOBT USERID: S 104 BMT JOB NUMBER REFERENCE DATA SCREEN KEY IS FISCAL YEAR, JOB NUMBER BUDGET FISCAL YEAR JOB NUMBER JOB DESCRIPTION ----------------------0109 11 CONSTRUCTION CONTRACT 0209 12 SITE ACQUISITION/LAND-CO 0309 13 CONTINGENCY 0409 14 MIS. CONST-CO, STAFF/VBA, OA-CO 0509 15 UTILITY AGREEMENTS-CO 0609 16 MISC. CONTRACT-STA LEVEL (P&H) 0709 17 COMPLETION ITEMS 0809 18 DEDICATION/GROUNDBREAKING 0909 19 IMPACT FUNDS 1009 20 CIH SERVICES 1109 21 REIMBURSABLE AUTHORITIES-CO 1209 22 TECHNICAL SERVICE DESIGN-STA. 1309 23 TECHNICAL SERVICE DESIGN-CO 1409 24 DCAA AUDITS-CO 0109 25 EQUIPMENT 0209 26 CONSTRUCTION MANAGERS-CO 0309 27 RESIDENT ENGINEER TRAILER 0409 28 VBA-R/O PROJECTS-CONSTRUCTION 0509 30 TESTING LABS 0609 41 WORKING RESERVE 0709 42 ADMINISTRATIVE RESERVE 0809 44 CONTINGENCY RESERVE Job numbers 12, 14, 15, 21, 23, 24, and 26 will not appear on the daily F 718 (RBEUAOV) Report because the funds belong to CO. 2. 11
STATION VERIFIES FUNDING After the funds have been allotted, they will appear on the IWPX and the SPRJ tables. Although these tables are similar, they have unique differences. 1. 2. IWPX scans by the installation wide project number (e. g. 523 AA 3023/11). This table displays one or multiple BFYs for each project. SPRJ scans by BFY, fund, station number, project number, and job number. This table allows the user to view additional information regarding the project (e. g. unliquidated obligations and accrued expenditures). 2. 12
CHECK IWPX FOR AVAILABLE FUNDS ACTION: R TABLEID: IWPX USERID: S 104 BMT H- INSTALLATION WIDE PROJECT/PROJECT CROSS REFERENCE KEY IS INSTALLATION-WIDE PROJ, PROJECT TABLE KEY INSTALLATION WIDE PROJECT: 523 OP 3338/13 ¦-------- PROJECT TABLE KEY --------¦ BFYS FUND A/O STN FCP/PRJ RPTG JOB UNOBLIG ALLOTMENT ------- -------- ----------01 - 06 0111 523 OP 3338 13 2. 40 02 - 07 0111 523 OP 3338 13 10. 00 03 - 09 0111 523 OP 3338 13 134, 441. 39 040506070809101112 - NOTE: Multiple BFYs for this Project/Job This table indicates the BFY, FUND, Station, PRJ, JOB, and Unobligated Allotment. This table scans by the project number and control point. 2. 13
SPRJ TABLE ACTION: R TABLEID: SPRJ USERID: S 104 BMT SUBPROJECT REFERENCE DATA SCREEN KEY IS BFYS, FUND, ADM/OFF, STN, FCP/PRJ, REPORTING CAT, JOB 01*** SUB-PROJECT *** BFYS FUND A/O STN FCP/PRJ RPTG JOB 09 0111 523 OP 3338 13 STN NAME: BOSTON MA VAMC FCP/PRJ DESC: AUDIOLOGY AND SP CONSOLIDATION ALLOTTED AMT: 48, 348. 70 FUNDS CONTROL IND: Y STATUS IND: J PROJECT LEVEL JOB CODE: 13 COMMITMENTS: UNLIQ OBLIGS: EXPENDITURES: PROJ CHARGES: UNOBLIG ALLOT: *** SUBPROJECT-TO-DATE *** 0. 00 BILLING ADJUST: 24, 558. 61 EXP ADJUST IN: 23, 790. 09 OBLIG ADJUST IN: 0. 00 SPRJ indicates the allotted, unliquidated, expensed, and unobligated amounts. This table scans by BFY and the project number. It also allows the user to view additional information pertaining to that particular project. 2. 14
SPRJ TABLE ACTION: R TABLEID: SPRJ USERID: S 104 BMT SUBPROJECT REFERENCE DATA SCREEN KEY IS BFYS, FUND, ADM/OFF, STN, FCP/PRJ, REPORTING CAT, JOB 01*** SUB-PROJECT *** BFYS FUND A/O STN FCP/PRJ RPTG JOB 09 0111 523 IP 3347 13 STN NAME: BOSTON MA VAMC FCP/PRJ DESC: PRIMARY CARE & ER MOD ALLOTTED AMT: 154, 000. 00 FUNDS CONTROL IND: Y STATUS IND: J PROJECT LEVEL JOB CODE: 13 COMMITMENTS: UNLIQ OBLIGS: EXPENDITURES: PROJ CHARGES: UNOBLIG ALLOT: *** SUBPROJECT-TO-DATE *** 0. 00 BILLING ADJUST: 60, 134. 57 EXP ADJUST IN: 74, 483. 83 OBLIG ADJUST IN: 0. 00 19, 381. 60 0. 00 How much has been obligated on this project and how much is available to obligate? 2. 15
PSDX TABLE Displays obligations and payments ACTION: R TABLEID: PSDX USERID: S 104 BMT *** PROJECT SPENDING CROSS REFERENCE SCREEN *** KEY IS BFYS, FUND, ADM/OFF, STN, FCP/PRJ, RPTG CAT, JOB, AMOUNT TYPE, TRANS ID/LINE, VENDOR BFYS 09 AMT TYPE ---01 - E 02 - E 03 - O 04050607 - FUND 0111 TRANS ID -------PV 523 Z 9000201 VS 523 Z 9000201 CO 523 Z 90002 A/O LINE NUM ---001 001 STN 523 FCP/PRJ OP 3314 VENDOR ------043466509 MISCN FY -09 09 09 RPTG JOB 11 FM -01 01 01 BOC ---3220 AMOUNT --------50, 000. 00 35. 42 2, 949, 992. 00 VS document indicates interest was paid on this construction project. Interest is withdrawn from CO funds and creates a negative balance on the IWPX table in JOB 11. Note: Although the VS transaction hits the 1720 account, VA recognizes purchase discounts lost and late payment penalties as an operating expense in the period incurred. Cost will be recorded net of purchase discounts. 2. 16
Construction Interest • • • Interest on construction contracts are identified as VS transactions. Stations may identify interest by reviewing the Installation Wide Project/Project Cross Reference (IWPX) and Project Spending Cross Reference (PSDX) table in FMS referencing station specific projects. VA Central Office (VACO) runs a SAS Job based off the PROJECT REFERENCE DATA SCREEN (PROJ)/IWPX table to create the report and determine the negative balances on projects in the accounting system. VACO will withdraw funds from job 13 (contingency) or a job with a whole dollar amount to replenish the line of interest that was paid. Job 11 is dollar specific. Interest payments less than $50. 00 will be corrected by VACO without inquiries. VACO 10 NR will send inquires to stations when interest payments are greater than $50. 00. If a project is in a negative dollar status, stations will not be able to modify or make payments to a project. Stations should contact VACO to correct the negative. Contact VACO Construction POC if you have any questions or concerns. The following next two pages include an example of the FPC 1 Weekly status of Funds Report displaying an interest payment from Job 11 and additional funds added to increase the project and an example of the VACO interest report based on data from FMS tables. 2. 17
Example of Interest Report 2. 18
SPDX TABLE ACTION: R TABLEID: SPDX USERID: S 104 BMT *** SPENDING CONTROL DOCUMENT CROSS REFERENCE INQUIRY SCREEN *** KEY IS BUDGET FY, FUND, A/O, STN, FCP/PRJ, BOC, AMOUNT TYPE , SPEND DOC ID/LINE BFY: 09 FUND: 0111 A/O: 08 STN: 523 F/P: IP 3347 BOC: 3220 0102030405 - AMT TYPE -------E E O O O TRANS ID/LINE ---------PV 523 Z 8500416 002 PV 523 Z 8500417 001 CO 523 Z 85004 003 PV 523 Z 8500416 002 PV 523 Z 8500417 001 AMOUNT --------26, 738. 83 47, 745. 00 134, 618. 40 -26, 738. 83 -47, 745. 00 SPDX is BOC Driven The AMT TYPE “E” and “O” indicates whether the transaction affected Obligations or Expenditures. 2. 19
CHANGING THE STATUS OF AN OPEN PROJECT Fund: 0110 Major Construction and 0111 Minor Construction Source: Request Steps: • Determine and record the appropriate status for the Fund Control Point/Project on the Project Status Table (PSTA). • Locate the project number record on the Status of Project Table (STAP). • Change the status for the Fund Control Point/Project on the STAP. 2. 20
FUND OBLIGATION 3
OBLIGATION PROCESSING CHAIN OBLIGATION RECEIVER PAYMENT MO RT, RC SO SO, AR CT or PV DD MV PG CT or PV CO CO AO FSC uses “CT” instead of “PV” because of the DLN. 3. 1
CHECK IWPX FOR AVAILABLE FUNDS ACTION: R TABLEID: IWPX USERID: S 104 BMT H- INSTALLATION WIDE PROJECT/PROJECT CROSS REFERENCE KEY IS INSTALLATION-WIDE PROJ, PROJECT TABLE KEY INSTALLATION WIDE PROJECT: 523 OP 2024/22 010203040506070809101112 - ¦-------- PROJECT TABLE KEY --------¦ BFYS FUND A/O STN FCP/PRJ RPTG JOB UNOBLIG ALLOTMENT ------- -------- ----------09 0110 523 OP 2024 22 20, 000. 00 3. 2
AO/CO/SO OBLIGATIONS SF 252 – Architect & Engineer Contract. 22 Tech Svc Design – Station. 23 Tech Svc Design – CO. Used by CO only The Architect-Engineer Order (AO) is used for : 1) obligating funds for architect-engineer contracts 2) reducing the available budgetary amounts for architect-engineer contracts SF 1442 Solicitation Offer & Award. 11 Construction Contract. 13 Contingency (for amendments to contracts) The Construction Contract Order (CO) is used for : 1) obligating funds for construction contracts 2) reducing the available budgetary amounts for contracts VA 2138 The Service Order (SO) is used for : 1) obligating funds for the purchase of various services 2) reducing the available budgetary amounts for the purchase of services 3) obligating funds for services that need to be accrued (automatic or manual) MODIFY THESE OBLIGATIONS BY INCREASING OR DECREASING OBLIGATION AMOUNTS 3. 3
FUND TABLE USE THIS TABLE TO FIND THE FUND CATEGORY ACTION: R TABLEID: FUND USERID: S 104 BMT FUND REFERENCE DATA SCREEN KEY IS BUDGET FISCAL YEARS, FUND 01 BFYS: 09 FUND: 0110 FUND TYPE: G BUD CAT: B DEACT DATE: NO YEAR: Y CARRYOVER: N REVOLVING: N CLOSE LVL: D TREASURY FUND TYPE: A FUND NAME: CONSTRUCTION-MAJOR TREASURY SYMBOL: 36 X 0110 SHORT NAME: CONSTR-MAJOR FUND CLASS: FUND CATEGORY: C FUND GROUP: MJ AGENCY: 36 AGENCY NAME: DEPT. OF VETERANS AFFAIRS AGY LOC CODE: 36 - 01 - 0000 OMB ID CODE: 1000 SUBCLASS: N BUREAU CODE: ALLOW UNOBLIG EXP AGST EXPRD: N CONTROL OPTIONS - APPROPRIATION: C APPORTIONMENT: C ALLOTMENT: C SUB-ALLOTMENT: I ALLOWANCE: C REVENUE BUD: N DIMENSIONS ALLOTMENT SUB-ALLOTMENT ADM/OFF: Y Y ALLOWANCE STATION: N N PGM DEF PROGRAM/DEF: N / PCLS LIMITATION: N N UNAPPLIED DEPOSIT OPT: N MEMO DEPRECIATION TRANS TYPE: RPT 224 COLUMN IND: D INTEREST BFYS: FUND: STATION: FCP/PRJ: JOB NO: COST CTR: BOC: RPT CAT: 3. 4
FCAT TABLE USE THIS TABLE FOR DESCRIPTION OF FUND CATEGORY ACTION: R TABLEID: FCAT USERID: S 104 BMT FUND CATEGORY REFERENCE DATA SCREEN KEY IS BUDGET FISCAL YEAR, FUND CATEGORY 01020304050607080910111213 - FY -09 09 09 09 FUND CAT -------A B C D E F G H J K L M N NAME ---------------VETERANS CANTEEN SERVICES REIMBURSABLE APPROPRIATIONS CONSTRUCTION FUNDS PERSONAL FUNDS OF PATIENTS EXPIRED AUTHORITY SUPPLY FUND GENERAL FUND RECEIPTS - AR COMPENSATED WORK THERAPY (CWT) FRANCHISE FUND LOAN GUARANTY - MLAC MCCF COLLECTION FUND NON-SPECIFIED (NON-APPROP) 3. 5 SHORT NAME ------VCS REIMBURSABLE CONSTRUCTION PFOP EXPIRED FUND SUPPLY FUND GENERAL FUND GFR - AR CWT FRANCH FUND LGY - MLAC MCCF NONSPEC-NA FUND CAT POSTING ------Y Y Y Y
Example of Reject TRANS CODE/TYPE NOT IN ACED COMMND: DOCID: CT 04 660 Z 8600201 STATUS: HELD 001 -001 OF 001 BATID: SUB STN: 01 LINE: 001 REF DOC: MO 660 Z 86002 REF LINE: 001 ACCP/DEL DATE: 07 15 08 VENDOR INV: INV DATE: LOG DATE: 07 28 08 INV DLN: INT REASON: DISC RSN: LINE TYPE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: 2957937 I/D: P/F: LIQ AMOUNT: DESCR: NURSE CALL 3 NORTH TOWER OUTST OBLIG: 65, 731. 94 BFYS: 06 FUND: 0111 STATION/SAT: 660 FCP/PRJ: CA 3318 JOB NO: 16 COST CTR/SUB: 854200 BOC/SUB: 3240 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: 01 -CPM 02 -TRAN CODE/TYPE NOT IN ACED Check the ACED table for resolution. Enter BFY, TRANS CODE, TRANS TYPE, VENDOR CAT, AND BOC. Check the FUND table to determine the FUND CATegory. ACTION: R TABLEID: ACED USERID: S 104 BMT ACCOUNTING ENTRIES DEFINITION REFERENCE DATA SCREEN KEY IS FISCAL YEAR, TRANS CODE, TRANS TYPE, VENDOR TYPE, BUDGET BOC, PROJECT POST TYPE, FUND CATEGORY VENDOR TRANS CAT BUDGET PROJECT FUND ACCOUNTING FY CODE TYPE BOC POST TYPE CAT ENTRY ID -------------01 - 09 CT 01 N 3240 2310 DESCRIPTION PAY VOUCHER - CERTIFIED 02 - 09 CT 01 N 3240 E 2331 DESCRIPTION PAY VOUCHER - CERTIFIED 03 - 09 CT 01 N 3240 N 0148 DESCRIPTION PAY VOUCHER - CERTIFIED 04 - 09 CT 01 N 3240 NK 0148 DESCRIPTION PAY VOUCHER - CERTIFIED 05 - 09 CT 01 N 3240 NP 0148 DESCRIPTION PAY VOUCHER - CERTIFIED 06 - 09 CT 01 N 4107 NV 1208 On the ACED table there is no “C” fund category for the CT document. 3. 6 PROMPT PAY FLAG -----Y Y Y
ACED TABLE Check Trans Code, Trans Type, Vendor Cat and Fund Category There is a “C” fund category on the MV docment. process the payment with an MV document. Therefore, user will ACTION: R TABLEID: ACED USERID: S 104 BMT ACCOUNTING ENTRIES DEFINITION REFERENCE DATA SCREEN KEY IS FISCAL YEAR, TRANS CODE, TRANS TYPE, VENDOR TYPE, BUDGET BOC, PROJECT POST TYPE, FUND CATEGORY VENDOR TRANS CAT BUDGET PROJECT FUND ACCOUNTING FY CODE TYPE BOC POST TYPE CAT ENTRY ID -------------01 - 09 MV 01 N 3240 2310 DESCRIPTION PAY VOUCHER - STRUCTURES 02 - 09 MV 01 N 3240 C 2310 DESCRIPTION PAY VOUCHER - WIP 03 - 09 MV 01 N 3240 E 2331 DESCRIPTION PAY VOUCHER - STRUCTURES 04 - 09 MV 01 N 3240 N 0148 DESCRIPTION PAY VOUCHER - STRUCTURES 05 - 09 MV 02 N NF 5901 DESCRIPTION OFFSET SO AND ESTAB COGS 06 - 09 MV 02 N 2220 NF 5901 DESCRIPTION OFFSET SO AND ESTAB COGS LEAF TO THE ACEN TABLE TO REVIEW GENERAL LEDGER ACCOUNTS 3. 7 PROMPT PAY FLAG -----Y Y Y
ACEN/ACEV TABLE REVIEW GL ENTRIES ACTION: R TABLEID: ACEN USERID: S 104 BMT ACCOUNTING ENTRIES REFERENCE DATA SCREEN KEY IS FISCAL YEAR, ACCOUNTING ENTRY ID, SEQUENCE NUMBER FISCAL YEAR: 09 ACCOUNTING ENTRY ID: 2310 ACCOUNTING EVENT TYPE: SP 03 SEQUENCE JOURNAL INCREASE ----- DEBIT ------ CREDIT ----- FLAGS NUMBER CODE LINE D/C ACCT TYPE OVERRIDE REV FIP -------- -------- --01001 GENJ D 1720 01 N 2122 02 N N N 02002 GENJ D 4610 44 N 490 N 48 N N N 03003 GENJ D 3107 03 N 5700 31 N N N 04 LEAF TO ACEV TABLE ACTION: S TABLEID: ACEV USERID: S 104 BMT H- 0102030405060708091011121314 - ACCOUNTING EVENT TYPE REFERENCE DATA SCREEN KEY IS ACCOUNTING EVENT TYPE ACCOUNTING POST FLAGS REQD EVENT VEND BOC PROJECT FUND CAT FIELD ----- -------SP 03 Y Y N Y Y SP 04 N Y Y SP 05 Y N N Y N SP 06 N N N Y Y SP 07 N N N SP 08 N N N SP 09 N N N SV 99 N Y N TK 01 N N N TK 02 N N N VS 01 N N N VS 02 N N N VS 03 N N N DESCRIPTION ---------------EXPENDITURE/EXPENSE ONLY BALANCE SHEET TRANSFER REVENUE REFUND REIM BILLED EXPEND REFUND REIM BS TRANSFER BILL REFUND REIM REVENUE BILLING MISCELLANEOUS TICKETS - PAYABLE TICKETS - PREPAID VOUCHER SELECTION DISCOUNT TAKEN DISCOUNT LOST THE BOC MUST BE POSTED ON THE ACED IF THERE IS A “Y” ON ACEV AND BOCT 3. 8
BOCT TABLE ACTION: R TABLEID: BOCT USERID: S 104 BMT BUDGET OBJECT CODE REFERENCE DATA SCREEN KEY IS BUDGET FISCAL YEAR, BUDGET OBJECT CODE FED BOC SUB BOC OBJ PS BOC 1099 TRAVEL BUDG FY CODE CLS IND IND FLAG -- --- --- ------ ---01 - 09 3240 32 N N NAME: OTHER STRUCTURES & FACILITIES 02 - 09 3241 320 32 N N C N N NAME: OTH STRUCTURES & FAC, NOT CAP 03 - 09 3252 320 32 N N C N N NAME: DEC EMERY CLEANUP LAND NON-CAP 04 - 09 3253 320 32 N N C N N NAME: DEC EMERG CLEANUP LAND CAP 05 - 09 3255 320 32 N N C N N NAME: HAZ WASTE CLNUP, BLDG&STRC N/C 06 - 09 3256 320 32 N N C N N NAME: FORCLSD ACQ PROP-LOAN GUAR-VBA 07 - 09 3257 320 32 N N C N N NAME: FORCLSD ACQ PROP IMPRVMNTS-VBA 01 - 09 2580 25 N N C N N NAME: NON-MED CONTRACT & AGREEMENTS BOC OBL= REST POST EXP LKUP DEACT LMT FLAG BOC FLAG DATE ---- -------32 Y Y N SHORT: OTH STR & FA 32 N Y N SHORT: OT ST/FAC, NC 32 N Y N SHORT: DEE C L NCAP 32 N Y N SHORT: DEE C L CAP 32 N Y N SHORT: HAZ WST CLNU 32 Y Y N SHORT: FORCLS PROP 32 Y Y N SHORT: PROP IMPRV 25 N Y N SHORT: NON-MED CNT If BOC post flag is set to “Y” on this table and on ACEV table, then the BOC must be posted on the ACED table. If either table has an “N, ” then the BOC does not need to be posted on the ACED. 3. 9
PCLS ACTION: R TABLEID: PCLS USERID: S 104 BMT PROGRAM CLASS REFERENCE DATA SCREEN KEY IS BFY, PROGRAM CLASS 0102030405060708 - PROGRAM BFY CLASS -------09 OP PROGRAM CLASS 09 OT P 7 OGRAM CLASS 09 OU PROGRAM CLASS 09 PA PROGRAM CLASS 09 PC PROGRAM CLASS 09 PE PROGRAM CLASS 09 PK PROGRAM CLASS 09 PL PROGRAM CLASS PROGRAM CATEGORY -------NAME: NAME: PROGRAM TYPE ------- PROGRAM GROUP ------- PROGRAM CLASS SHORT NAME ------O/P CARE/SUP OUTPATIENT CARE & SUPPORT OTHER OUTPATIENT IMPROVEMENTS APF ASSET MT APF ASSET MANAGEMENT APF-NCS ADV PLANNING FUND CEMETARIES PAT ENVIRO PATIENT ENVIRONMENTS PARK CONST PARKING GARAGE CONSTRUCTION PARK LEASE PARKING GARAGE LEASING NOTE: Program Class indicates the description of each project. 3. 10 REST LKUP FLAG ---N N N
EXAMPLE SERVICE ORDER DOCUMENT Entering a Service Order Document (SO) for Major Construction Introduction: A service order contract has been negotiated for air monitoring services at a VAMC and is ready for input into FMS. A service order document is entered to obligate the funds for the service order. For this order, automatic accrual may or may not be used. Instructions: 1. The Transaction Code for Service Orders will be SO. Therefore, the document identification will be as follows: TRAN ADM/OFF ID NUMBER SO 10 523 X 910_ _ 2. The date of the contract will be used for the SO date field. The accounting period will default to current month. 3. The Budget Fiscal Year and Fund fields will be entered on the header portion of the Service Order screen so they will not have to be repeated for subsequent lines. 4. Auto Accrue field defaults to “Y” if left blank. 5. Use the Quick Reference Guide to enter the SO document. 3. 11
SO DOCUMENT COMMND: 001 -001 OF 001 TRANS TYPE: VENDOR CODE: CONTRACT NO: BEGIN DATE: END DATE: DISC %: ALT PAYEE: DOC TOTAL: 01 - DOCID: SO 10 523 X 910 XX_ _ BATID: SUB STN: SERVICE ORDER INPUT SCREEN 01 SO DATE: 391097549 ACCT PRD: ACTION: E SUB STN: 104 NAME: D S ELECTRIC SUPPLY INC ADDR 1: P O BOX 2196 10 01 08 AUTO ACCRUE: N ADDR 2: XX XX XX FOB: CITY/ST/ZIP: LA CROSSE WI 546022196 DAYS: P/E TERM: ASSOC ORDER: / 100, 000. 00 BFYS: FUND: LINE: 001 STATION/SAT: 523 / COST CTR/SUB: / LINE AMOUNT: 100, 000. 00 DESCR: Note: STATUS: BFYS: 09 FCP/PRJ: OP 2024 BOC/SUB: 3220 / I/D: FUND: 0110 JOB NO: 16 REPT CATG: CLSD BFYS: CLSD FUND: Instructor to provide the END DATE. 3. 12
SO MODIFICATION Example COMMND: 000 -000 OF 000 DOCID: SO 10 523 X 910 XX _ BATID: SO 10 FSC 001 SUB STN: SERVICE ORDER INPUT SCREEN TRANS TYPE: SO DATE: ACCT PRD: VENDOR CODE: NAME: CONTRACT NO: ADDR 1: BEGIN DATE: AUTO ACCRUE: ADDR 2: END DATE: FOB: CITY/ST/ZIP: DISC %: DAYS: P/E TERM: ALT PAYEE: / DOC TOTAL: 1000. 00 BFYS: 01 LINE: 001 BFYS: STATION/SAT: / FCP/PRJ: COST CTR/SUB: / BOC/SUB: LINE AMOUNT: 1000. 00 I/D: I DESCR: STATUS: ACTION: M SUB STN: ASSOC ORDER: FUND: / FUND: JOB NO: REPT CATG: CLSD BFYS: CLSD FUND: Be sure to enter the increase (I) or decrease (D) on a modification. 3. 13
ARCHITECT-ENGINEER ORDER AO DOCUMENT Entering one Architect-Engineer Order Document (AO) for Major Construction • – – – – Introduction: An Architect-Engineer contract has been negotiated to renovate a unit at a VAMC and is ready for input into FMS. An Architect-Engineer Order document is entered to obligate the funds for the architect-engineer contract. For this contract, automatic accrual will not be used. Instructions: The transaction Code for Architect-Engineer Orders will be AO. Therefore, the document identification will be as follows: TRAN ADMIN/OFF ID NUMBER AO 10 523 X 900_ _ (last 2 digits will be your student ID number). The date of the contract will be used for the AO date field. The accounting period will default to current month. The Budget Fiscal Yr and Fund fields will be entered on the header portion of the Architect. Engineer Order screen so they will not have to be repeated for subsequent lines. This AO is not to accrue automatically. Therefore, the auto accrue field should be left blank, as it will default to “N. ” Enter obligation date in the Begin Date field. Use the Quick Reference Guide to enter the document. Note that the Architect-Engineer Order (AO) Document is entered in the same manner as the Contract Order (CO) Document, with the exception of the Trans Code field. Before processing the document, verify the available budget amount on the IWPX table. Use the Quick Reference Guide to enter the AO document. 3. 14
AO DOCUMENT COMMND: STATUS: 001 -001 OF 001 DOCID: AO 10 523 X 900 XX_ _ BATID: SUB STN: CONTRACT ORDER INPUT SCREEN TRANS TYPE: STN: FSC VENDOR CODE: CONTRACT NO: BEGIN DATE: END DATE: 53029 DISC %: ALT PAYEE: DOC TOTAL: 01 - 01 CO DATE: ACCT PRD: 391422655 V 523 P 4001 10 01 08 ACTION: E SUB NAME: P D C DESIGN GROUP ADDR 1: 700 WALNUT RIDGE DR AUTO ACCRUE: ADDR 2: CITY/ST/ZIP: HARTLAND WI DAYS: P/E TERM: ASSOC ORDER: / 110000. 00 BFYS: LINE: 001 STATION/SAT: 523 / COST CTR/SUB: / LINE AMOUNT: 110000. 00 DESCR: BFYS: 09 FCP/PRJ: OP 2024 BOC/SUB: 3220 / I/D: FUND: 0110 JOB NO: 22 REPT CATG: CLSD BFYS: CLSD FUND: Note: Enter your student id in place of the XX in the doc id. 3. 15
CONSTRUCTION CONTRACT ORDER DOCUMENT Entering a Construction Contract Order Document (CO) for Major Construction Introduction: A Construction Contract has been negotiated to renovate the restrooms on the west wing of the Medical Center and is ready for input into FMS. The CO document is entered to obligate the funds for the construction contract. Automatic Accrual will not be used. Instructions: 1. The Transaction Code for Construction Orders will be CO. Therefore, the document identification will be as follows (The last 2 digits will be your student number): TRAN ADM/OFF ID NUMBER CO 10 523 X 920_ _ 2. The date of the contract will be used for the CO date field. The accounting period will default to current period. 3. The Budget Fiscal Year and Fund fields will be entered on the header portion of the Construction Order screen so they will not have to be repeated for subsequent lines. 4. This CO is not to be accrued automatically. Therefore, the auto accrue field should be left blank, as it will default to “N. ” Enter obligation date in the Begin Date field. 5. Use the Quick Reference Guide to enter the document. Note that the Construction Order (CO) Document is entered in the same manner as the Architect-Engineer Order (AO) Document, with the exception of the Trans Code Field. 6. Verify the available budget amount on the IWPX before processing the document. 7. Use the Quick Reference Guide to enter the CO document. 3. 16
CO DOCUMENT COMMND: 001 -001 OF 001 TRANS TYPE: VENDOR CODE: CONTRACT NO: BEGIN DATE: END DATE: DISC %: ALT PAYEE: DOC TOTAL: 01 - DOCID: CO 10 523 X 920 XX__ BATID: SUB STN: CONTRACT ORDER INPUT SCREEN STATUS: ACCPT 01 CO DATE: ACCT PRD: ACTION: E SUB STN: 104 941461459 NAME: S J AMOROSO CONSTRUCTION CO V 101 C 2000 ADDR 1: INC 10 01 08 AUTO ACCRUE: N ADDR 2: 348 HATCH DR XX XX XX CITY/ST/ZIP: FOSTER CITY CA 94404 DAYS: P/E TERM: ASSOC ORDER: / 1000000. 00 BFYS: FUND: LINE: 001 STATION/SAT: 523 / COST CTR/SUB: / LINE AMOUNT: 1000000. 00 DESCR: BFYS: 09 FCP/PRJ: OP 2024 BOC/SUB: 3220 / I/D: FUND: 0110 JOB NO: 11 REPT CATG: CLSD BFYS: CLSD FUND: A--*HP 20 -DOCUMENT ACCEPTED Instructor will provide end date for CO document. 3. 17
CO MODIFICATION COMMND: DOCID: CO 10 523 X 920 XX BATID: CO 10 FSC 004 SUB STN: CONTRACT ORDER INPUT SCREEN TRANS TYPE: CO DATE: ACCT PRD: VENDOR CODE: NAME: CONTRACT NO: ADDR 1: BEGIN DATE: AUTO ACCRUE: ADDR 2: END DATE: CITY/ST/ZIP: DISC %: DAYS: P/E TERM: ALT PAYEE: / DOC TOTAL: 112, 000. 00 BFYS: 01 LINE: 002 BFYS: STATION/SAT: 523 / FCP/PRJ: COST CTR/SUB: / BOC/SUB: LINE AMOUNT: 112, 000. 00 I/D: DESCR: FC 0 -A STATUS: ACTION: M SUB STN: ASSOC ORDER: FUND: 09 OP 2024 3220 / I FUND: 0110 JOB NO: 13 REPT CATG: CLSD BFYS: CLSD FUND: When modifying a CO obligation for the first time, you will need to add a new line. All change orders are done out of contingency funds (JOB 13). Once the line has been established for JOB 13 funds, there is no need to enter all the accounting information for additional modifications to the same line. 3. 18
FMS Construction Appropriation (0110 & 0111) Customers Stations are reminded to record each contract change order as a separate line on the obligation document and not in total for multiple change orders submitted on the same day (this is optional but recommended). The change order number should be recorded in the description field on the FMS contract Order Document (oblligation document AO or CO). Note: For CO’s and AO’s, enter only one batch document per day per obligation. Each change order must be entered on a separate line using the same line number in order for the reports to reflect both the original line amounts and each modification. Line field: Description – For CO’s and AO’s enter the change order number. Please call the FSC Help Desk @1 -877 -353 -9791 for additional assistance. 3. 19
FMS PROCEDURES GUIDES FOR OBLIGATIONS J-1 thru J-33 3. 20
PAYMENT PROCESSING 4
PV MV PG CT The Accounts Payable subsystem records payments to vendors for services rendered or goods received. Process Payment Vouchers (PV) to issue payments to vendors. The Payment Voucher (PV) is used for: 1. recording a payment for goods or services that do not require a DLN 2. recording a payment that is not generated from the CAPP system 3. offsetting an account receivable 4. recording a credit memo Process Multipurpose Vouchers (MV) to record contract advances, offsets, holdbacks, and construction progress payments. Modify existing MV documents to release a contract holdback or adjust a payment. The Multipurpose Voucher (MV) is used for: 1. recording construction contract progress payments if more than one open Fund, Station, Fund Control Point/Project, Budget Object Code combination exists on the reference obligation. 2. processing contract advance issuances, advance offsets, holdbacks, and payments. Process Progress Payments Vouchers (PG) to record contract advances, offsets, holdbacks, and construction progress payments. The Progress Payment Voucher (PG) is used for: 1. recording construction contract progress payments 2. processing contract advance issuances, advance offsets, holdbacks, and payments The Certified Transaction (CT) is used for: 1. used mainly by FSC for making payments through OLCS. Note: PGs can be cancelled but not modified If the vendor is different on the invoice than on the obligation, pay the vendor as applicable to the invoice. 4. 1
PV DOCUMENT DOCID: PV 10 523 X 910 XX 01 STATUS: ACCPT BATID: SUB STN: PAYMENT VOUCHER INPUT SCREEN TRANS TYPE: 01 PV DATE: ACCT PRD: ACTION: SUB STN: 523 VENDOR CODE: 391097549 NAME: D S ELECTRIC SUPPLY BENEFICIARY: PPAY TYPE: ADDR 1: P O BOX 2196 SCHD PMT DATE: FISCAL APRV: ADDR 2: DOC TOTAL: 4000. 00 CITY/ST/ZIP: LA CROSSE WI 546022196 CHECK TYPE: COMMENT TO PRINT: DISC %: DAYS: P/E TERM: AMT: 01 LINE: 001 REF DOC: SO 523 X 910 XX_ REF LINE: 001 ACCP/DEL DATE: 10 05 08 VENDOR INV: PVSOXX INV DATE: 10 05 08 LOG DATE: 10 06 08 REF VEND CODE: REF VEND NAME: LINE AMOUNT: 4000. 00 I/D: P/F: UNAPPL DEP NO: LIQ AMOUNT: DESCR: OUTST OBLIG: LINE TYPE: INT RSN: DISC RSN: BFYS: 09 FUND: 0110 STATION/SAT: 523 FCP/PRJ: OP 2024 JOB NO: 16 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: A--*HS 60 -DOCUMENT MARKED FOR READ ONLY 01 -CV 84 W-VENDOR INVOICE NOT IN VIHT COMMND: 001 -001 OF 001 Note: The “ 01” at the end of the document number indicates this is the first payment. This sequential number is automatically populated each time you enter a payment for a particular obligation. 4. 2
EXAMPLE MODIFY A PV DOCUMENT COMMND: 001 -001 OF 001 DOCID: PV 10 BATID: PV 10 523 X 910 XX 01 FSC 001 SUB STN: STATUS: ACCPT PAYMENT VOUCHER INPUT SCREEN TRANS TYPE: PV DATE: ACCT PRD: ACTION: M SUB STN: 104 VENDOR CODE: 391097549 NAME: D S ELECTRIC SUPPLY INC BENEFICIARY: PPAY TYPE: ADDR 1: P O BOX 2196 SCHD PMT DATE: MM DD YY FISCAL APRV: ADDR 2: DOC TOTAL: 500. 00 CITY/ST/ZIP: LA CROSSE WI 546022196 CHECK TYPE: N COMMENT TO PRINT: DISC %: DAYS: P/E TERM: AMT: 01 LINE: 001 REF DOC: SO 523 X 910 XX REF LINE: 001 ACCP/DEL DATE: 10 05 08 VENDOR INV: PVSOXX INV DATE: 10 05 08 LOG DATE: 10 06 08 REF VEND CODE: REF VEND NAME: LINE AMOUNT: 500. 00 I/D: D P/F: UNAPPL DEP NO: LIQ AMOUNT: DESCR: OUTST OBLIG: LINE TYPE: INT RSN: DISC RSN: BFYS: 09 FUND: 0110 STATION/SAT: 523 FCP/PRJ: OP 2024 JOB NO: 16 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: 01 -CDT 2 O-DUPLICATE INVOICE # 01 -CV 84 W-VENDOR INVOICE NOT IN VIHT A PV can be modified when in the ACCPT Status on SUSF. A PV cannot be modified when the IN TRANSIT Status is displayed on PVHT. 4. 3
EXAMPLE CANCEL A PV DOCUMENT COMMND: 001 -001 OF 001 DOCID: PV 10 BATID: PV 10 523 X 910 XX 01 FSC 002 STATUS: ACCPT SUB STN: PAYMENT VOUCHER INPUT SCREEN TRANS TYPE: 01 PV DATE: ACCT PRD: ACTION: X SUB STN: 523 VENDOR CODE: 391097549 NAME: D S ELECTRIC SUPPLY INC BENEFICIARY: PPAY TYPE: ADDR 1: P O BOX 2196 SCHD PMT DATE: MM DD YY FISCAL APRV: ADDR 2: DOC TOTAL: CITY/ST/ZIP: LA CROSSE WI 546022196 CHECK TYPE: N COMMENT TO PRINT: DISC %: DAYS: P/E TERM: AMT: 01 LINE: REF DOC: REF LINE: ACCP/DEL DATE: VENDOR INV: INV DATE: LOG DATE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: I/D: D P/F: UNAPPL DEP NO: LIQ AMOUNT: DESCR: OUTST OBLIG: LINE TYPE: INT RSN: DISC RSN: BFYS: FUND: STATION/SAT: FCP/PRJ: JOB NO: COST CTR/SUB: BOC/SUB: REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: To cancel a payment, reference Document ID of the payment to be cancelled with a batch number, enter action of “X” and vendor code. 4. 4
PV DOCUMENT FOR AO COMMND: 001 -001 OF 001 DOCID: PV 10 523 X 900 XX 01_ _ STATUS: ACCPT BATID: SUB STN: PAYMENT VOUCHER INPUT SCREEN TRANS TYPE: 01 PV DATE: ACCT PRD: ACTION: SUB STN: 523 VENDOR CODE: 391422655 NAME: P D C DESIGN GROUP BENEFICIARY: PPAY TYPE: ADDR 1: 700 WALNUT RIDGE DR SCHD PMT DATE: FISCAL APRV: ADDR 2: DOC TOTAL: 55000. 00 CITY/ST/ZIP: HARTLAND WI 53029 CHECK TYPE: COMMENT TO PRINT: DISC %: DAYS: P/E TERM: AMT: 01 LINE: 001 REF DOC: AO 523 X 900 XX REF LINE: 001 ACCP/DEL DATE: 10 10 08 VENDOR INV: PVAOXX _ _ INV DATE: 10 10 08 LOG DATE: 10 10 08 REF VEND CODE: REF VEND NAME: LINE AMOUNT: 55000. 00 I/D: P/F: UNAPPL DEP NO: LIQ AMOUNT: DESCR: OUTST OBLIG: 85000. 00 LINE TYPE: INT RSN: DISC RSN: BFYS: 09 FUND: 0110 STATION/SAT: 523 FCP/PRJ: OP 2024 JOB NO: 22 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: A--*HS 60 -DOCUMENT MARKED FOR READ ONLY 01 -CV 84 W-VENDOR INVOICE NOT IN VIHT Note: The “ 01” at the end of the document number indicates this is the first payment. This sequential number is automatically populated each time you enter a payment for a particular obligation. 4. 5
EXAMPLE MODIFY SCHEDULE PAYMENT DATE COMMND: DOCID: PV 10 523 X 800 XX 01__ STATUS: ACCPT 000 -000 OF 000 BATID: PV 10 FSC 003 SUB STN: PAYMENT VOUCHER INPUT SCREEN TRANS TYPE: PV DATE: ACCT PRD: ACTION: M SUB STN: 104 VENDOR CODE: 391422655 NAME: P D C DESIGN GROUP BENEFICIARY: PPAY TYPE: ADDR 1: 700 WALNUT RIDGE DR *SCHD PMT DATE: xx xx xx FISCAL APRV: ADDR 2: DOC TOTAL: 0. 00 CITY/ST/ZIP: HARTLAND WI 53029 CHECK TYPE: N COMMENT TO PRINT: DISC %: DAYS: P/E TERM: AMT: 01 LINE: REF DOC: REF LINE: ACCP/DEL DATE: VENDOR INV: INV DATE: LOG DATE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: I/D: P/F: UNAPPL DEP NO: LIQ AMOUNT: DESCR: OUTST OBLIG: LINE TYPE: INT RSN: DISC RSN: BFYS: FUND: STATION/SAT: FCP/PRJ: JOB NO: COST CTR/SUB: BOC/SUB: REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: *Modify a scheduled payment date on an accepted payment. Fields underlined are required. Fiscal approval is required to change this date. 4. 6
Enter a Multipurpose Voucher 4. 7
MULTIPURPOSE VOUCHER (MV) CONSTRUCTION FUNDS (0110, 0111, 4538*) 01 – for non-advance related payments 03 – for holdbacks 04 – for advance issuance 06 – for advance offsets *FUND 4538 (Construction/Operation of Pkg. Garage) was deactivated after FY 04. 4. 8
OBLH/OBLL ACTION: R TABLEID: OBLH USERID: S 104 BMT *** ORDERS HEADER INQUIRY SCREEN *** KEY IS TRANS CODE, ORDER NUMBER TRANS CODE: CO ORDER NUMBER: 523 X 920 XX TRANS TYPE: 01 SUB STN: 104 VENDOR CODE: 941461459 CONTRACT NO: V 101 C 9000 AUTO ACCRUE: N NAME: S J AMOROSO CONSTRUCTION CO ALT PAYEE: / ORIGINAL AMENDMENT ORDERED CLOSED ACCRUED EXPENDED OUTSTANDING AMT: AMT: 1, 000. 00 112, 000. 00 1, 112, 000. 00 MISC REF AMT: HOLDBACK AMT: 0. 00 ADVANCED AMT: OUT ADVANCE AMT: PO DATE: LAST ACTIVITY DATE: BEGIN DATE: 10 01 08 END DATE: NO CONTRACT MONTHS: FOB: CLOSED DATE: DISC %: 0. 00 DOC TYPE: 0. 00 RESP PERSON: 0. 000 DAYS: 00 P/E TERM: 00 COMMENTS: ACTION: R TABLEID: OBLL USERID: S 104 BMT *** PURCHASE ORDER ACCOUNTING LINE INQUIRY SCREEN *** KEY IS TRANS CODE, ORDER NUMBER, LINE NUMBER TRANS CODE: CO ORDER NUMBER: 523 X 920 XX 01 LINE NO: 001 BFYS: 09 FUND: 0110 DESCR: ORIG LINE AMT: 1, 000. 00 ADM/OFF: 08 AMENDMENT LINE AMT: 0. 00 STATION: 523 / CLSD BFYS: PO LINE AMT: 1, 000. 00 COST CTR: / CLSD FUND: CLOSED AMT: 0. 00 FCP/PRJ: OP 2024 ACCRUED AMT: 0. 00 BOC /SUB: 3220 / JOB NO: 11 EXPENDED AMT: 0. 00 REPT CATG: ASSOC ORD: OUTSTNDNG AMT: 1, 000. 00 LAST CHANGE STATUS: HOLDBACK AMT: 0. 00 02 LINE NO: 002 BFYS: 09 FUND: 0110 DESCR: FCO-A ORIG LINE AMT: 0. 00 ADM/OFF: 08 AMENDMENT LINE AMT: 112, 000. 00 STATION: 523 / CLSD BFYS: PO LINE AMT: 112, 000. 00 COST CTR: / CLSD FUND: CLOSED AMT: 0. 00 FCP/PRJ: OP 2024 ACCRUED AMT: 0. 00 BOC /SUB: 3220 / JOB NO: 13 EXPENDED AMT: 0. 00 REPT CATG: ASSOC ORD: OUTSTNDNG AMT: 112, 000. 00 LAST CHANGE STATUS: HOLDBACK AMT: 0. 00 4. 9
MV WITH HOLDBACK COMMND: DOCID: MV 10 523 X 920 XX 01 BATID: SUB STN: MULTIPURPOSE VOUCHER INPUT SCREEN STATUS: ACCPT TRANS TYPE: MV DATE: ACCT PRD: ACTION: SUB STN: 104 REF DOC: CO 523 X 920 XX VENDOR CODE: 941461459 VENDOR INV: MV 01 XX__ NAME: S J AMOROSO CONSTRUCTION CO INV DATE: 10 15 08 PPAY TYPE: C ADDR 1: INC LOG DATE: 10 15 08 ADDR 2: 348 HATCH DR ACCP/DEL DATE: 10 15 08 CITY/ST/ZIP: FOSTER CITY CA 94404 BENEFICIARY: HOLDBACK TOTAL: 7300. 00 ADV LIQ TOTAL: WORK INSTALLED: 110000. 00 DOCUMENT TOTAL: NET PYMT AMT: 102700. 00 HOLDBACK PYMT AMT: BFYS: FUND: DISC %: DAYS: P/E TERM: AMT: SCHD PYMT DATE: FISCAL APRV: INT RSN: DISC RSN: SCHD FY/CAT: SCHD TYPE/NO: PYMT SEQ NO: CHECK TYPE: COMMENT TO PRINT: COMMND: DOCID: MV 10 523 X 920 XX 01 STATUS: ACCPT 001 -001 OF 002 BATID: SUB STN: 01 LINE: 001 REF DOC: CO 523 X 920 XX REF LINE: 001 ACCP/DEL DATE: T/T: 01 REF ADV: REF ADV LINE: PAY ADV: VENDOR INV: INV DATE: LOG DATE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: 102700. 00 I/D: P/F: LINE TYPE: LIQ AMOUNT: DESCR: OUTST OBLIG: 1, 000. 00 INT REASON: DISC REASON: BFYS: 09 FUND: 0110 STATION/SAT: 523 FCP/PRJ: OP 2024 JOB NO: 11 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: COMMND: DOCID: MV 10 523 X 920 XX 01 STATUS: ACCPT 002 -002 OF 002 BATID: SUB STN: 01 LINE: 002 REF DOC: CO 523 X 920 XX REF LINE: 001 ACCP/DEL DATE: T/T: 03 REF ADV: REF ADV LINE: PAY ADV: VENDOR INV: INV DATE: LOG DATE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: 7300. 00 I/D: P/F: LINE TYPE: H LIQ AMOUNT: DESCR: OUTST OBLIG: 897, 300. 00 INT REASON: DISC REASON: BFYS: 09 FUND: 0110 STATION/SAT: 523 FCP/PRJ: OP 2024 JOB NO: 11 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: Holdback will be listed on the PVC 2 table after MV document has been accepted. Go to VCTI and VCT 2 to see if there any duplicate invoices. 4. 10
PVC 2 ACTION: R TABLEID: PVC 2 USERID: S 104 BMT *** VOUCHER CONTRACT HOLDBACK RELEASE INQUIRY SCREEN *** KEY IS VENDOR CODE, TRANS CODE, VOUCHER NO, LINE VENDOR CODE: 941461459 TRANS CODE VOUCHER NO LINE REF DOC ID --------------------------01 MV 523 X 920 XX 01* 002* CO 523 X 920 XX 001 020304050607 - OUTST HOLDBACK AMT -------------7, 300. 00 ---- For Holdback Release, reference PVC 2 Table *The Document ID and the line number are required in order to release the holdback on a MV document. If more than one document has holdback, a batch on each document is required to release the holdback. 4. 11
MV TO ISSUE AN ADVANCE W/ HOLDBACK COMMND: DOCID: MV 10 523 X 920 XX 02 STATUS: ACCPT BATID: SUB STN: MULTIPURPOSE VOUCHER INPUT SCREEN TRANS TYPE: MV DATE: ACCT PRD: ACTION: SUB STN: 104 REF DOC: CO 523 X 920 XX VENDOR CODE: 941461459 VENDOR INV: MV 02 XX_ NAME: S J AMOROSCO CONSTR INV DATE: 11 07 08 PPAY TYPE: C ADDR 1: INC LOG DATE: 11 07 08 ADDR 2: 348 HATCH DR ACCP/DEL DATE: 11 07 08 CITY/ST/ZIP: FOSTER CITY, CA 94404 BENEFICIARY: HOLDBACK TOTAL: 12000. 00 ADV LIQ TOTAL: WORK INSTALLED: 100000. 00 DOCUMENT TOTAL: NET PYMT AMT: 108000. 00 HOLDBACK PYMT AMT: BFYS: DISC %: DAYS: SCHD PYMT DATE: FISCAL APRV: SCHD FY/CAT: SCHD TYPE/NO: CHECK TYPE: COMMENT TO PRINT: A--*HP 20 -DOCUMENT ACCEPTED FUND: P/E TERM: INT RSN: AMT: DISC RSN: PYMT SEQ NO: A--*HP 01 -WARNING MSGS; PLEASE REVIEW COMMND: DOCID: MV 10 523 X 920 XX 02 STATUS: ACCPT 001 -001 OF 003 BATID: SUB STN: 01 LINE: 001 REF DOC: CO 523 X 920 XX REF LINE: 001 ACCP/DEL DATE: T/T: 01 REF ADV: REF ADV LINE: PAY ADV: VENDOR INV: INV DATE: LOG DATE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: 88000. 00 I/D: P/F: LINE TYPE: LIQ AMOUNT: DESCR: OUTST OBLIG: INT REASON: DISC REASON: BFYS: 09 FUND: 0110 STATION/SAT: 523 FCP/PRJ: OP 2024 JOB NO: 11 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND COMMND: DOCID: MV 10 523 X 820 XX 02 STATUS: ACCPT 002 -002 OF 003 BATID: SUB STN: 01 LINE: 002 REF DOC: REF LINE: ACCP/DEL DATE: T/T: 04 REF ADV: REF ADV LINE: PAY ADV: C VENDOR INV: INV DATE: LOG DATE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: 20000. 00 I/D: P/F: LINE TYPE: LIQ AMOUNT: DESCR: OUTST OBLIG: 0. 00 INT REASON: DISC REASON: BFYS: 09 FUND: 0110 STATION/SAT: 523 FCP/PRJ: OP 2024 JOB NO: COST CTR/SUB: BOC/SUB: REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: 4. 12
COMMND: DOCID: MV 10 523 X 920 XX 02 STATUS: ACCPT 003 -003 OF 003 BATID: SUB STN: 01 LINE: 003 REF DOC: CO 523 X 920 XX__ REF LINE: 001 ACCP/DEL DATE: T/T: 03 REF ADV: REF ADV LINE: PAY ADV: VENDOR INV: INV DATE: LOG DATE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: 12000. 00 I/D: P/F: LINE TYPE: H LIQ AMOUNT: DESCR: OUTST OBLIG: INT REASON: DISC REASON: BFYS: 09 FUND: 0110 STATION/SAT: 523 FCP/PRJ: OP 2024 JOB NO: 11 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: 01 -CDT 2 O-DUPLICATE INVOICE # 01 -CV 84 W-VENDOR INVOICE NOT IN VIHT Advance will be listed on ADV 2 after MV document has been accepted. Review PVC 2 Table for Holdback. ACTION: R TABLEID: ADV 2 USERID: S 104 BMT *** ADVANCE OFFSET INQUIRY SCREEN ** KEY IS TRANS ID, LINE, VENDOR CODE, REF ADV/OBL ID, LINE, REF VENDOR CODE TRANS ID: CO 523 X 920 XX LINE: ADV TOTAL: 20, 000. 00 VENDOR CODE: 941461459 OUTST ADV AMT: 20, 000. 00 REF ADV/OBL ID LINE REF VENDOR CODE REF OUTST ADV AMT ------------------------01 - MV 523 X 920 XX 02 002 941461459 20, 000. 00 02030405 - 4. 13
MV TO RELEASE HOLDBACK COMMND: DOCID: MV 10 523 X 920 XX 01 STATUS: ACCPT BATID: MV 10 FSCXXX___ SUB STN: MULTIPURPOSE VOUCHER INPUT SCREEN TRANS TYPE: MV DATE: ACCT PRD: ACTION: M SUB STN: 104 REF DOC: VENDOR CODE: 941461459* VENDOR INV: NAME: S J AMOROSCO CONSTR INV DATE: PPAY TYPE: ADDR 1: INC LOG DATE: ADDR 2: 348 HATCH DR ACCP/DEL DATE: CITY/ST/ZIP: FOSTER CITY CA 94404 BENEFICIARY: HOLDBACK TOTAL: 7300. 00* ADV LIQ TOTAL: WORK INSTALLED: DOCUMENT TOTAL: 7300. 00 NET PYMT AMT: HOLDBACK PYMT AMT: BFYS: DISC %: DAYS: SCHD PYMT DATE: MM DD YY FISCAL APRV: SCHD FY/CAT: SCHD TYPE/NO: M CHECK TYPE: N COMMENT TO PRINT: FUND: P/E TERM: INT RSN: AMT: DISC RSN: PYMT SEQ NO: COMMND: DOCID: MV 10 523 X 920 XX 01 STATUS: ACCPT 001 -001 OF 001 BATID: MV 10 FSC__ SUB STN: 01 LINE: 002* REF DOC: CO 523 X 920 XX REF LINE: 001 ACCP/DEL DATE: 10 08 08 T/T: REF ADV LINE: PAY ADV: VENDOR INV: MV 01 XX INV DATE: 10 08 08 LOG DATE: 10 08 08 REF VEND CODE: REF VEND NAME: LINE AMOUNT: 7300. 00 I/D: D P/F: LINE TYPE: H LIQ AMOUNT: DESCR: OUTST OBLIG: INT REASON: DISC REASON: BFYS: 08 FUND: 0110 STATION/SAT: 523 FCP/PRJ: OP 2024 JOB NO: 11 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: 01 -CDT 2 O-DUPLICATE INVOICE # 01 -CV 84 W-VENDOR INVOICE NOT IN VIHT Required fields are underlined and in italics. *The document ID should reference the MV for the original holdback. See PVC 2 to get doc ID and line number of holdback. 4. 14
MV TO MAKE PAYMENT FOR HOLDBACK COMMND: DOCID: MV 10 523 X 920 XX 03 BATID: SUB STN: MULTIPURPOSE VOUCHER INPUT SCREEN STATUS: ACCPT TRANS TYPE: MV DATE: ACCT PRD: ACTION: SUB STN: 104 REF DOC: CO 523 X 820 XX VENDOR CODE: 941461459 VENDOR INV: MV 03 XX__ NAME: S J AMOROSCO CONSTR INV DATE: 12 08 08 PPAY TYPE: C ADDR 1: INC LOG DATE: 12 08 08 ADDR 2: 348 HATCH DR ACCP/DEL DATE: 12 08 08 CITY/ST/ZIP: FOSTER CITY CA 94404 BENEFICIARY: HOLDBACK TOTAL: ADV LIQ TOTAL: WORK INSTALLED: 0. 00 DOCUMENT TOTAL: NET PYMT AMT: 7300. 00 HOLDBACK PYMT AMT: 7, 300. 00 BFYS: DISC %: DAYS: SCHD PYMT DATE: XX XX XX FISCAL APRV: SCHD FY/CAT: SCHD TYPE/NO: M CHECK TYPE: Y COMMENT TO PRINT: FUND: P/E TERM: INT RSN: AMT: DISC RSN: PYMT SEQ NO: COMMND: DOCID: MV 10 523 X 920 XX 03 STATUS: ACCPT 001 -001 OF 001 BATID: SUB STN: 01 LINE: 001 REF DOC: CO 523 X 920 XX REF LINE: 001 ACCP/DEL DATE: T/T: 01 REF ADV: REF ADV LINE: PAY ADV: VENDOR INV: INV DATE: LOG DATE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: 7300. 00 I/D: P/F: LINE TYPE: LIQ AMOUNT: DESCR: OUTST OBLIG: INT REASON: DISC REASON: BFYS: 09 FUND: 0110 STATION/SAT: 523 FCP/PRJ: OP 2024 JOB NO: 11 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: 01 -CV 84 W-VENDOR INVOICE NOT IN VIHT 4. 15
EXAMPLE CPM (Critical Path Method) 4. 16
Example of MV Holdback Increase COMMND: DOCID: MV 10 757 Z 5000109 BATID: SUB STN: MULTIPURPOSE VOUCHER INPUT SCREEN STATUS: 08/01/06 TRANS TYPE: 01 MV DATE: ACCT PRD: ACTION: SUB STN: 104 REF DOC: CO 757 Z 50001 VENDOR CODE: 300175379 01 VENDOR INV: PROG PMT 09 NAME: WALSH CONST CO INV DATE: 07 10 06 PPAY TYPE: ADDR 1: DE MARIA JOINT VENTURE III LOG DATE: 07 17 06 ADDR 2: 929 W ADAMS ST ACCP/DEL DATE: 07 10 06 CITY/ST/ZIP: CHICAGO IL 606073021 BENEFICIARY: HOLDBACK TOTAL: 1750. 00 ADV LIQ TOTAL: WORK INSTALLED: 1750. 00 DOCUMENT TOTAL: NET PYMT AMT: 0. 00 HOLDBACK PYMT AMT: DISC %: SCHD PYMT DATE: SCHD FY/CAT: CHECK TYPE: BFYS: DAYS: FISCAL APRV: SCHD TYPE/NO: COMMENT TO PRINT: FUND: P/E TERM: INT RSN: AMT: DISC RSN: PYMT SEQ NO: COMMND: DOCID: MV 10 757 Z 5000109 STATUS: 001 -001 OF 001 BATID: SUB STN: 08/01/06 01 LINE: 001 REF DOC: CO 757 Z 50001 REF LINE: 001 ACCP/DEL DATE: 07 17 06 T/T: 03 REF ADV: REF ADV LINE: PAY ADV: VENDOR INV: INV DATE: LOG DATE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: 1750. 00 I/D: P/F: LINE TYPE: H LIQ AMOUNT: DESCR: CONTRUCTION AWARD OUTST OBLIG: 75, 680, 433. 16 INT REASON: DISC REASON: BFYS: 04 05 FUND: 0110 B 1 STATION/SAT: 757 FCP/PRJ: CA 2001 JOB NO: 11 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: 01 -CV 84 W-VENDOR INVOICE NOT IN VIHT This is an example of a Holdback Increase if the original MV did not include one. 4. 17
Example of MV with Advance Offset OBLH prior to offset: ACTION: R TABLEID: OBLH USERID: S 104 abc *** ORDERS HEADER INQUIRY SCREEN *** KEY IS TRANS CODE, ORDER NUMBER TRANS CODE: CO ORDER NUMBER: 999 X 49001 TRANS TYPE: 01 SUB STN: 999 VENDOR CODE: MISCN CONTRACT NO: V 101 BC 0202 AUTO ACCRUE: N NAME: MISC COMMERCIAL VENDOR ALT PAYEE: / ORIGINAL AMT: AMENDMENT AMT: ORDERED AMT: CLOSED AMT: ACCRUED AMT: EXPENDED AMT: OUTSTANDING AMT: 80, 495, 376. 00 1, 582, 840. 00 82, 078, 216. 00 56, 077, 852. 00 0. 00 56, 077, 852. 00 26, 000, 364. 00 PO DATE: LAST ACTIVITY DATE: BEGIN DATE: END DATE: NO CONTRACT MONTHS: FOB: CLOSED DATE: MISC REF AMT: HOLDBACK AMT: 0. 00 4, 351, 449. 00 DISC %: ADVANCED AMT: OUT ADVANCE AMT: 2, 998, 734. 00 428, 803. 00 DOC TYPE: RESP PERSON: 4. 18 0. 000 09 01 10 09 DAYS: 00 COMMENTS: 30 26 15 30 04 07 04 05 P/E TERM: 00
Example of MV with Advance Offset Continued ADV 2 prior to offset: ACTION: R TABLEID: ADV 2 USERID: S 104 abc *** ADVANCE OFFSET INQUIRY SCREEN ** KEY IS TRANS ID, LINE, VENDOR CODE, REF ADV/OBL ID, LINE, REF VENDOR CODE TRANS ID: CO 999 X 49001 LINE: ADV TOTAL: 2, 998, 734. 00 VENDOR CODE: MISCN OUTST ADV AMT: 428, 803. 00 REF ADV/OBL ID LINE REF VENDOR CODE REF OUTST ADV AMT ------------------------01 - MV 999 X 4900128 004 030549758 428, 803. 00 020301 -*L 009 HEADER CHANGE PVC 2 prior to offset: ACTION: R TABLEID: PVC 2 USERID: S 104 abc *** VOUCHER CONTRACT HOLDBACK RELEASE INQUIRY SCREEN *** KEY IS VENDOR CODE, TRANS CODE, VOUCHER NO, LINE VENDOR CODE: 030549758 TRANS CODE VOUCHER NO LINE REF DOC ID OUTST HOLDBACK AMT -----------------------------01 MV 999 X 4900104 002 CO 999 X 49001 3, 394. 00 02 MV 999 X 4900105 001 CO 999 X 49001 111, 128. 00 03 MV 999 X 4900106 002 CO 999 X 49001 50, 076. 00 04 MV 999 X 4900108 003 CO 999 X 49001 220, 775. 00 05 MV 999 X 4900109 002 CO 999 X 49001 200, 765. 00 06 MV 999 X 4900110 003 CO 999 X 49001 116, 126. 00 07 MV 999 X 4900111 003 CO 999 X 49001 28, 392. 00 08 MV 999 X 4900112 002 CO 999 X 49001 172, 404. 00 09 MV 999 X 4900114 003 CO 999 X 49001 36, 485. 00 10 MV 999 X 4900117 002 CO 999 X 49001 86, 894. 00 11 MV 999 X 4900119 003 CO 999 X 49001 137, 775. 00 12 MV 999 X 4900120 002 CO 999 X 49001 265, 753. 00 13 MV 999 X 4900124 003 CO 999 X 49001 253, 128. 00 14 MV 999 X 4900126 003 CO 999 X 49001 323, 624. 00 15 MV 999 X 4900128 003 CO 999 X 49001 699, 642. 00 16 MV 999 X 4900129 003 CO 999 X 49001 295, 520. 00 01 MV 999 X 4900130 002 CO 999 X 49001 283, 255. 00 02 MV 999 X 4900132 002 CO 999 X 49001 536, 079. 00 03 MV 999 X 4900133 002 CO 999 X 49001 205, 552. 00 04 MV 999 X 4900134 002 CO 999 X 49001 324, 682. 00 4. 19
Example of MV with Advance Offset Continued Prior to payment, $1, 435, 729. 00 was released from Holdback. example of how to release funds from Holdback. COMMND: DOCID: MV 04 999 X 4900108 BATID: MV 04 LS 0046 SUB STN: MULTIPURPOSE VOUCHER INPUT SCREEN Below is an STATUS: ACCPT TRANS TYPE: MV DATE: ACCT PRD: ACTION: M SUB STN: 999 REF DOC: VENDOR CODE: 030549758 VENDOR INV: NAME: WALSH CONST CO INV DATE: PPAY TYPE: ADDR 1: 929 W ADAMS ST LOG DATE: ADDR 2: ACCP/DEL DATE: CITY/ST/ZIP: CHICAGO IL 606073021 BENEFICIARY: HOLDBACK TOTAL: 220775. 00 ADV LIQ TOTAL: WORK INSTALLED: DOCUMENT TOTAL: 220775. 00 NET PYMT AMT: HOLDBACK PYMT AMT: BFYS: DISC %: DAYS: SCHD PYMT DATE: 08 04 05 FISCAL APRV: SCHD FY/CAT: SCHD TYPE/NO: M CHECK TYPE: N COMMENT TO PRINT: A--*HS 60 -DOCUMENT MARKED FOR READ ONLY FUND: P/E TERM: INT RSN: AMT: DISC RSN: PYMT SEQ NO: H--TZZ 2 O-SUBMIT STN NOT=USER'S STN COMMND: DOCID: MV 04 999 X 4900108 STATUS: ACCPT 001 -001 OF 001 BATID: MV 04 LS 0046 SUB STN: 01 LINE: 003 REF DOC: CO 999 X 49001 REF LINE: 001 ACCP/DEL DATE: 07 13 05 T/T: REF ADV LINE: PAY ADV: VENDOR INV: PROGPMT_ _ INV DATE: 07 13 05 LOG DATE: 07 13 05 REF VEND CODE: REF VEND NAME: LINE AMOUNT: 220775. 00 I/D: D P/F: LINE TYPE: H LIQ AMOUNT: DESCR: MODERNIZE IN-PATIENT SPACE OUTST OBLIG: 25, 753, 475. 00 INT REASON: DISC REASON: BFYS: 04 05 FUND: 0110 B 1 STATION/SAT: 999 FCP/PRJ: CA 2406 C JOB NO: 11 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: 01 -CDT 2 O-DUPLICATE INVOICE # 01 -CV 84 W-VENDOR INVOICE NOT IN VIHT 4. 20
Example of MV with Advance Offset Continued COMMND: DOCID: MV 04 999 X 4900135 BATID: SUB STN: MULTIPURPOSE VOUCHER INPUT SCREEN STATUS: ACCPT TRANS TYPE: MV DATE: ACCT PRD: ACTION: SUB STN: 104 REF DOC: CO 999 X 49001 VENDOR CODE: 030549758 VENDOR INV: PROGPMT 26 NAME: WALSH CONST CO INV DATE: 02 09 07 PPAY TYPE: ADDR 1: 929 W ADAMS ST LOG DATE: 02 09 07 ADDR 2: ACCP/DEL DATE: 02 09 07 CITY/ST/ZIP: CHICAGO IL 60607302 BENEFICIARY: HOLDBACK TOTAL: ADV LIQ TOTAL: 180000. 00 WORK INSTALLED: 2482492. 00 DOCUMENT TOTAL: NET PYMT AMT: 3738221. 00 HOLDBACK PYMT AMT: 1435729. 00 BFYS: DISC %: DAYS: SCHD PYMT DATE: FISCAL APRV: SCHD FY/CAT: SCHD TYPE/NO: CHECK TYPE: COMMENT TO PRINT: A--*HP 20 -DOCUMENT ACCEPTED FUND: P/E TERM: INT RSN: AMT: DISC RSN: PYMT SEQ NO: A--*HP 01 -WARNING MSGS; PLEASE REVIEW COMMND: DOCID: MV 04 999 X 4900135 STATUS: ACCPT 001 -001 OF 003 BATID: SUB STN: 01 LINE: 001 REF DOC: REF LINE: 001 ACCP/DEL DATE: T/T: 01 REF ADV: REF ADV LINE: PAY ADV: VENDOR INV: INV DATE: LOG DATE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: 3696213. 00 I/D: P/F: LINE TYPE: LIQ AMOUNT: DESCR: MODERNIZE IN-PATIENT SPACE OUTST OBLIG: 27, 024, 606. 00 INT REASON: DISC REASON: BFYS: 04 05 FUND: 0110 B 1 STATION/SAT: 999 FCP/PRJ: CA 2406 C JOB NO: 11 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: 01 -CVZEO-ADV OUTSTAND ON OBLH OR DOC 01 -CV 84 W-VENDOR INVOICE NOT IN VIHT 4. 21
Example of MV with Advance Offset Continued COMMND: DOCID: MV 04 999 X 4900135 STATUS: ACCPT 002 -002 OF 003 BATID: SUB STN: 01 LINE: 002 REF DOC: REF LINE: 001 ACCP/DEL DATE: T/T: 06 REF ADV: MV 999 X 4900128 REF ADV LINE: 004 PAY ADV: VENDOR INV: INV DATE: LOG DATE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: 180000. 00 I/D: P/F: LINE TYPE: LIQ AMOUNT: DESCR: MODERNIZE IN-PATIENT SPACE OUTST OBLIG: 23, 328, 393. 00 INT REASON: DISC REASON: BFYS: 04 05 FUND: 0110 B 1 STATION/SAT: 999 FCP/PRJ: CA 2406 C JOB NO: 11 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: 01 -CDT 2 O-DUPLICATE INVOICE # 01 -CV 84 W-VENDOR INVOICE NOT IN VIHT COMMND: DOCID: MV 04 999 X 4900135 STATUS: ACCPT 003 -003 OF 003 BATID: SUB STN: 01 LINE: 003 REF DOC: REF LINE: 002 ACCP/DEL DATE: T/T: 01 REF ADV: REF ADV LINE: PAY ADV: VENDOR INV: INV DATE: LOG DATE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: 42008. 00 I/D: P/F: LINE TYPE: LIQ AMOUNT: DESCR: 02 C-02 I 058 -066 OUTST OBLIG: 411, 487. 00 INT REASON: DISC REASON: BFYS: 04 FUND: 0110 STATION/SAT: 999 FCP/PRJ: CA 2406 JOB NO: 13 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: 01 -CDT 2 O-DUPLICATE INVOICE # 01 -CV 84 W-VENDOR INVOICE NOT IN VIHT 01 -CVZEO-ADV OUTSTAND ON OBLH OR DOC 4. 22
Example of OBLH, ADV 2, and PVC 2 after MV Advance Offset Payment OBLH, ADV 2, and PVC 2 after MV payment: ACTION: R TABLEID: OBLH USERID: S 104 abc *** ORDERS HEADER INQUIRY SCREEN *** KEY IS TRANS CODE, ORDER NUMBER TRANS CODE: CO ORDER NUMBER: 999 X 49001 TRANS TYPE: 01 SUB STN: 999 VENDOR CODE: MISCN CONTRACT NO: V 101 BC 0202 AUTO ACCRUE: N NAME: MISC COMMERCIAL VENDOR ALT PAYEE: / ORIGINAL AMENDMENT ORDERED CLOSED ACCRUED EXPENDED OUTSTANDING AMT: AMT: 80, 495, 376. 00 1, 582, 840. 00 82, 078, 216. 00 58, 560, 344. 00 0. 00 58, 560, 344. 00 23, 517, 872. 00 MISC REF AMT: HOLDBACK AMT: 0. 00 2, 915, 720. 00 ADVANCED AMT: ADVANCE AMT: 2, 998, 734. 00 248, 803. 00 PO DATE: LAST ACTIVITY DATE: BEGIN DATE: END DATE: NO CONTRACT MONTHS: FOB: CLOSED DATE: DISC %: 0. 000 09 02 10 09 DAYS: 00 30 22 15 30 04 07 04 05 P/E TERM: 00 DOC TYPE: COMMENTS: RESP PERSON: ACTION: R TABLEID: ADV 2 USERID: S 104 abc *** ADVANCE OFFSET INQUIRY SCREEN ** KEY IS TRANS ID, LINE, VENDOR CODE, REF ADV/OBL ID, LINE, REF VENDOR CODE TRANS ID: CO 999 X 49001 LINE: ADV TOTAL: 2, 998, 734. 00 VENDOR CODE: MISCN OUTST ADV AMT: 248, 803. 00 REF ADV/OBL ID LINE REF VENDOR CODE REF OUTST ADV AMT ------------------------01 - MV 999 X 4900128 004 030549758 248, 803. 00 ACTION: R TABLEID: PVC 2 USERID: S 104 abc *** VOUCHER CONTRACT HOLDBACK RELEASE INQUIRY SCREEN *** KEY IS VENDOR CODE, TRANS CODE, VOUCHER NO, LINE VENDOR CODE: 030549758 TRANS CODE VOUCHER NO LINE REF DOC ID OUTST HOLDBACK AMT -----------------------------01 MV 999 X 4900124 003 CO 999 X 49001 247, 366. 00 02 MV 999 X 4900126 003 CO 999 X 49001 323, 624. 00 03 MV 999 X 4900128 003 CO 999 X 49001 699, 642. 00 04 MV 999 X 4900129 003 CO 999 X 49001 295, 520. 00 05 MV 999 X 4900130 002 CO 999 X 49001 283, 255. 00 06 MV 999 X 4900132 002 CO 999 X 49001 536, 079. 00 07 MV 999 X 4900133 002 CO 999 X 49001 205, 552. 00 08 MV 999 X 4900134 002 CO 999 X 49001 324, 682. 00 4. 23 OUT
ENTER A PROGRESS PAYMENT (PG) DOCUMENT 4. 24
PG - PROGRESS PAYMENT VOUCHER W/HOLDBACK COMMND: DOCID: PG 10 523 X 930 XX 01 STATUS: BATID: SUB STN: PROGRESS PAYMENT VOUCHER INPUT SCREEN PG DATE: ACCT PRD: ACTION: SUB STN: 104 VEND INV: PG 01 XX__ VENDOR CODE: 752066549 PPAY TYPE: C INV DATE: 10 05 08 LOG DATE: 10 06 08 NAME: CENTEX RODGERS CONST CO ACCP/DEL DATE: 10 06 08 ADDR 1: 4 TH & COMMERCE ST SCHD PYMT DATE: FISC APRV: ADDR 2: REF DOC: CO 523 X 930 XX_____ CITY/ST/ZIP: NASHVILLE TN 37244 WORK INSTALLED CURRENT PD: 100000. 00 TO DATE ADVANCE AMT: 0. 00 TO DATE HOLDBACK AMT: 7000. 00 NET PAYMENT AMT: 93, 000. 00 REF VEND CODE: CONTRACT NO: V 101 C 2500 REF VEND NAME: BENEFICIARY: COMMENT TO PRINT: INT REASON: REGULAR PAYMENT AMT: ADVANCE AMT THIS PD: HOLDBACK AMT THIS PD: 93, 000. 00 I/D: 7, 000. 00 I/D: I PAY VENDOR: H--CV 84 W-VENDOR INVOICE NOT IN VIHT TRANS TYPE: 01 TYPE: 03 TYPE: H--CDT 2 O-DUPLICATE INVOICE # PG DOCUMENTS CANNOT BE MODIFIED, THEY CAN BE CANCELLED WORK INSTALLED CURRENT PERIOD Enter the value of the work installed current period on the source document. the current period is zero, enter 0. 00. * • *TO DATE ADVANCE AMOUNT • Enter the value of the Outstanding Advance amount on the source document. amount is zero, enter 0. 00. *TO DATE HOLDBACK AMOUNT • Enter the value of the Outstanding Holdback amount on the source document. amount is zero, enter 0. 00. If the work installed in If the outstanding advance If the outstanding Holdback *NET PAYMENT AMOUNT • Enter the value of the net payment amount (or payment this period) from the source document. amount to be paid is zero, enter 0. 00. Note: If the The “ 01” at the end of the document number indicates this is the first payment. This sequential number is automatically populated each time you enter a payment for a particular obligation. 4. 25
PG W/HOLDBACK AND ADVANCE COMMND: DOCID: PG 10 523 X 930 XX 02 STATUS: ACCPT BATID: SUB STN: PROGRESS PAYMENT VOUCHER INPUT SCREEN PG DATE: ACCT PRD: ACTION: SUB STN: 104 VEND INV: PG 02 XX VENDOR CODE: 752066549 PPAY TYPE: C INV DATE: 10 10 08 LOG DATE: 10 11 08 NAME: CENTEX RODGERS CONST CO ACCP/DEL DATE: 10 10 08 ADDR 1: 4 TH & COMMERCE ST SCHD PYMT DATE: FISC APRV: ADDR 2: REF DOC: CO 523 X 930 XX CITY/ST/ZIP: NASHVILLE TN 37244 WORK INSTALLED CURRENT PD: 100000. 00 TO DATE ADVANCE AMT: 20000. 00 TO DATE HOLDBACK AMT: 19000. 00 NET PAYMENT AMT: 108000. 00 REF VEND CODE: CONTRACT NO: V 101 C 2500 REF VEND NAME: BENEFICIARY: COMMENT TO PRINT: INT REASON: REGULAR PAYMENT AMT: ADVANCE AMT THIS PD: HOLDBACK AMT THIS PD: 88000. 00 TRANS TYPE: 01 20000. 00 I/D: I TRANS TYPE: 04 12000. 00 I/D: I TRANS TYPE: 03 PAY VENDOR: TRANS TYPE: A--*HP 20 -DOCUMENT ACCEPTED A--*HP 01 -WARNING MSGS; PLEASE REVIEW H--CV 84 W-VENDOR INVOICE NOT IN VIHT H--CDT 2 O-DUPLICATE INVOICE # H--CV 84 W-VENDOR INVOICE NOT IN VIHT 4. 26
EXAMPLE PG DOCUMENT WITH HOLDBACK INCREASE AND ADVANCE OFFSET COMMND: DOCID: PG 10 523 X 930 XX 03 STATUS: ACCPT BATID: SUB STN: PROGRESS PAYMENT VOUCHER INPUT SCREEN PG DATE: ACCT PRD: ACTION: SUB STN: 104 VEND INV: PG 03 XX__ VENDOR CODE: 752066549 PPAY TYPE: C INV DATE: 10 10 08 LOG DATE: 10 11 08 NAME: CENTEX RODGERS CONST CO ACCP/DEL DATE: 10 10 08 ADDR 1: 4 TH & COMMERCE SCHD PYMT DATE: FISC APRV: ADDR 2: REF DOC: CO 523 X 930 XX______ CITY/ST/ZIP: NASHVILLE TN 37244 WORK INSTALLED CURRENT PD: 200000. 00 TO DATE ADVANCE AMT: 0. 00 TO DATE HOLDBACK AMT: 37000. 00 NET PAYMENT AMT: 162000. 00 REF VEND CODE: CONTRACT NO: V 101 C 2500 REF VEND NAME: BENEFICIARY: COMMENT TO PRINT: INT REASON: REGULAR PAYMENT AMT: ADVANCE AMT THIS PD: HOLDBACK AMT THIS PD: 162, 000. 00 TRANS TYPE: 01 20, 000. 00 I/D: D TRANS TYPE: 06 18, 000. 00 I/D: I TRANS TYPE: 03 PAY VENDOR: TRANS TYPE: A--*HP 20 -DOCUMENT ERRORS DETECTED A--*HP 01 -WARNING MSGS; PLEASE REVIEW 4. 27
PG RELEASE HB - Example COMMND: DOCID: PG 10 523 X 840 XX 02 STATUS: ACCPT BATID: SUB STN: PROGRESS PAYMENT VOUCHER INPUT SCREEN PG DATE: ACCT PRD: ACTION: SUB STN: 104 VEND INV: RELEASE HB VENDOR CODE: 752066549 PPAY TYPE: C INV DATE: 11 20 07 LOG DATE: 11 30 07 NAME: CENTEX RODGERS CONST CO ACCP/DEL DATE: 11 20 07 ADDR 1: DRAWER T 693 3 RD NATL BK SCHD PYMT DATE: FISC APRV: ADDR 2: 4 TH & COMMERCE REF DOC: CO 523 X 840 XX CITY/ST/ZIP: NASHVILLE TN 37244 WORK INSTALLED CURRENT PD: 0. 00 TO DATE ADVANCE AMT: 0. 00 TO DATE HOLDBACK AMT: 0. 00 NET PAYMENT AMT: 50000. 00 REF VEND CODE: CONTRACT NO: V 101 C 1701 REF VEND NAME: BENEFICIARY: COMMENT TO PRINT: INT REASON: REGULAR PAYMENT AMT: ADVANCE AMT THIS PD: HOLDBACK AMT THIS PD: 0. 00 TRANS TYPE: 0. 00 I/D: TRANS TYPE: 50, 000. 00 I/D: D TRANS TYPE: 03 PAY VENDOR: Y* TRANS TYPE: 01 A--*HP 20 -DOCUMENT ACCEPTED A--*HP 01 -WARNING MSGS; PLEASE REVIEW H--CDT 2 O-DUPLICATE INVOICE # H--CV 84 W-VENDOR INVOICE NOT IN VIHT ACTION: R TABLEID: PVHT USERID: S 104 BMT *** VOUCHER HEADER INQUIRY SCREEN *** KEY IS VENDOR CODE, TRANS CODE, VOUCHER NO, TRAVEL ADV NO VENDOR CODE: 752066549 TRANS CODE: PG VOUCHER NO: NAME: CENTEX RODGERS CONST CO TRAVEL ADV NO: ADDR 1: DRAWER T 693 3 RD NATL BK NO CHK DISB: ADDR 2: 4 TH & COMMERCE D. O. : ADDR 3: FA IND: CITY/ST/ZIP: NASHVILLE TN 37244 OCR PRINT: DESCRIPTION: PROMPT PAY TYPE: C CHECK TYPE: VOUCHER TYPE: 1 FEE CODE: CORSPDNCE VENDOR CODE: AGREEMENT NO: FORCE CHECK: N DISB RUN NO: SCHD FISC YR: SCHD CATG: T SCHD TYPE: M SCHD NO: VOUCHER DATE: 12 01 06 MANUAL ADDR CHANGE: N VOUCHER AMT: SCHD DATE: MM DD YY FISCAL APRV: HOLDBACK AMT: CLOSED DATE: DISB INFO CHANGED: N CLOSED AMT: BENEFICIARY: OUTST AMT: ACCT STN: 523 SUBMIT STN: 104 IN TRANSIT AMT: DIRECT DISB NO: ADV LIQ AMT: INTR AGCY SYMBOL: LIQ AMT: • • • 523 X 840__02 N 220 N N 00000 50, 000. 00 -50, 000. 00 When releasing holdback to zero, enter “ 0. 00” in the TO DATE HOLDBACK AMT field. If releasing just part of the holdback, enter the amount you want remaining on the OBLH table in the TO DATE HOLDBACK AMT field. Enter Inv Date, Log Date, and Accp/Del Date, this will schedule the payment. *If user is only releasing the HB, be sure to change the pay vendor code to “N. ” This will not schedule a payment, it will only place the funds in O/S on the obligation. Leave the last two numbers on the Doc ID blank and the system will number your document. 4. 28
Example of CT Payment ACTION: R TABLEID: OBLL USERID: S 104 BMT *** PURCHASE ORDER ACCOUNTING LINE INQUIRY SCREEN *** KEY IS TRANS CODE, ORDER NUMBER, LINE NUMBER TRANS CODE: SO ORDER NUMBER: 640 C 52316 01 LINE NO: 001 BFYS: 05 FUND: 0162 A 1 DESCR: ORIG LINE AMT: 1, 179, 141. 90 ADM/OFF: 10 AMENDMENT LINE AMT: 0. 00 STATION: 640 / CLSD BFYS: PO LINE AMT: 1, 179, 141. 90 COST CTR: 854200 / 00 CLSD FUND: CLOSED AMT: 1, 167, 599. 15 FCP/PRJ: 2300501 X 8 ACCRUED AMT: 0. 00 BOC /SUB: 3220 / JOB NO: EXPENDED AMT: 1, 167, 599. 15 REPT CATG: ASSOC ORD: OUTSTNDNG AMT: 11, 542. 75 LAST CHANGE STATUS: HOLDBACK AMT: 0. 00 02 LINE NO: BFYS: FUND: DESCR: ORIG LINE AMT: ADM/OFF: AMENDMENT LINE AMT: STATION: / CLSD BFYS: PO LINE AMT: COST CTR: / CLSD FUND: CLOSED AMT: FCP/PRJ: ACCRUED AMT: BOC /SUB: / JOB NO: EXPENDED AMT: REPT CATG: ASSOC ORD: OUTSTNDNG AMT: LAST CHANGE STATUS: HOLDBACK AMT: Please use Cost Center 854200 for Non-Recurring Maintenance and Repair. This helps the FSC to identify what division will make the payment. COMMND: TRANS TYPE: VENDOR CODE: BENEFICIARY: SCHD PMT DATE: DOC TOTAL: VENDOR INV: CHECK TYPE: DISC %: DOCID: CT 04 640 C 5231603 STATUS: ACCPT BATID: SUB STN: 11/21/06 CERTIFIED PAYMENT VOUCHER INPUT SCREEN 01 CT DATE: ACCT PRD: ACTION: SUB STN: 104 680429887 02 PPAY TYPE: C NAME: THREE C CONST ADDR 1: ASGE CONTRACTOR BUSINESS RESOU FISCAL APRV: ADDR 2: 5230 LAS VIRGENES RD STE 200 125589. 03 CITY/ST/ZIP: CALABASAS CA 913023432 3 C 107 INV DATE: 11 11 06 INV DLN: 31869941009 COMMENT TO PRINT: DAYS: P/E TERM: AMT: COMMND: DOCID: CT 04 640 C 5231603 STATUS: ACCPT 001 -001 OF 001 BATID: SUB STN: 11/21/06 01 LINE: 001 REF DOC: SO 640 C 52316 REF LINE: 001 ACCP/DEL DATE: 11 14 06 VENDOR INV: INV DATE: LOG DATE: 11 14 06 INV DLN: INT REASON: DISC RSN: LINE TYPE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: 125589. 03 I/D: P/F: LIQ AMOUNT: DESCR: OUTST OBLIG: 137, 131. 78 BFYS: 05 FUND: 0162 A 1 STATION/SAT: 640 FCP/PRJ: 2300501 X 8 JOB NO: COST CTR/SUB: 854200 00 BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: 4. 29
EXAMPLE OF REJECT OUT OF PARTIAL NUMBERS COMMND: NEW TRANS TYPE: VENDOR CODE: BENEFICIARY: SCHD PMT DATE: DOC TOTAL: VENDOR INV: CHECK TYPE: DISC %: DOCID: CT 04 503 C 70119 STATUS: BATID: SUB STN: 01/08/09 CERTIFIED PAYMENT VOUCHER INPUT SCREEN CT DATE: ACCT PRD: ACTION: SUB STN: PPAY TYPE: NAME: ADDR 1: FISCAL APRV: ADDR 2: CITY/ST/ZIP: INV DATE: INV DLN: COMMENT TO PRINT: DAYS: P/E TERM: AMT: A--TZKTE-OUT OF PARTIAL NUMBERS A--*HS 28 -ENTER DOCUMENT NUMBER To resolve this reject, user will need to force the system to accept the next number available by using a batch number. Check DXRF for the next available number, using a batch number, process the document same as usual. Enter “edit batch” (eb) instead of “edit” (e). COMMND: NEW TRANS TYPE: VENDOR CODE: BENEFICIARY: SCHD PMT DATE: DOC TOTAL: VENDOR INV: CHECK TYPE: DISC %: DOCID: CT 04 503 C 7011908 STATUS: BATID: CT 04 la 0908 SUB STN: 01/08/09 CERTIFIED PAYMENT VOUCHER INPUT SCREEN CT DATE: ACCT PRD: ACTION: SUB STN: PPAY TYPE: NAME: ADDR 1: FISCAL APRV: ADDR 2: CITY/ST/ZIP: INV DATE: INV DLN: COMMENT TO PRINT: DAYS: P/E TERM: AMT: 4. 30
PROMPT PAY DETERMINATION Determines whether a payment is subject to prompt pay based on the following criteria: • Prompt Pay Standards Defined on the Prompt Pay Table (PPAY) - establishes the standards for prompt pay. Interest and penalty rates for invoices not paid according to prompt pay requirements are included. • Prompt Pay Options on the Transaction Category Table (TCAT) – determines whether a document type is subject to prompt pay. • Vendor Type Prompt Pay Indicator on the Vendor Type Table (VTYP) – determines whether a specific vendor type is subject to prompt pay rules. • Accounting Event Prompt Pay Indicator on the Accounting Entries Table (ACED) – determines whether an accounting event is subject to prompt pay rules (i. e. , a Certified Payment Voucher for supplies may be subject to prompt pay, whereas a prepayment is not). Station level construction contracts are usually 14 Day payments. Central Office construction contracts are usually 30 day payments. A & E and service orders are 30 day payments. 4. 31
FMS PROCEDURES GUIDES FOR PAYMENTS N-1 thru N-80 4. 32
EXPENDITURE TRANSFER 5
EXPENDITURE TRANSFER Expenditure Transfers (EW & ET & EB) records refund transfers to and from appropriations, as well as transfers between stations. ET transactions reference an obligation, EW and EB transactions transfer cost. The Expenditure Transfer is used for: Ø Recording expenditure transfers, such as transferring non-payroll expenditures Ø Refunding an appropriation out of suspense fund and PFOP APPLICATION TABLE DESCRIPTIONS Voucher Header Table PVHT - Displays summary information about outstanding, closed, and disbursed payables for a specific payment transaction, including the Expenditure Transfers (ET). Voucher Line Tables: PVLT - Shows details of outstanding and closed voucher lines, including the Expenditure Transfer (ET). Voucher Line Table JVLT - Tracks and verifies Expenditure Transfers (EW) & (EB). 5. 1
EXAMPLE MODIFY OBLIGATION AND CREATE ET TRANSACTION To make a costing correction to an obligation that is partially expended, follow these steps: 1. Modify the obligation to transfer any OUTSTANDING funds from the incorrect costing line to a new line with correct costing. 2. Enter an ET transaction with two lines to move the funds from EXPENDED to OUTSTANDING on incorrect line and OUTSTANDING to EXPENSED on correct line. 3. Modify the obligation to transfer OUTSTANDING funds from incorrect line to OUTSTANDING funds on correct line. 4. Snapshots of these transactions and the OBLL tables are on the following pages. It’s critical for these transactions to be completed on the same day so as to avoid causing an out of balance with the 224. The original payment will still be on PVHT. The OBLH and OBLL tables will reflect corrected information in addition to original information. The expended amount will be reflected on OBLH, OBLL, PVHT, and PVLT. NOTE: This type of correction cannot be performed using an EW transaction, because the obligation cannot be referenced. However, if the transaction has been fully expensed, you may use an EW transaction to correct the costing. 5. 2
EXAMPLE TO CORRECT COSTING ON A PARTIALLY EXPENDED OBLIGATION ACTION: R TABLEID: OBLL USERID: S 104 T 09 *** PURCHASE ORDER ACCOUNTING LINE INQUIRY SCREEN *** KEY IS TRANS CODE, ORDER NUMBER, LINE NUMBER TRANS CODE: AO ORDER NUMBER: 523 X 8950 XX 01 LINE NO: 001 BFYS: 08 FUND: 0110 DESCR: test for ET ORIG LINE AMT: ADM/OFF: AMENDMENT LINE AMT: STATION: 523 / CLSD BFYS: PO LINE AMT: COST CTR: / CLSD FUND: CLOSED AMT: FCP/PRJ: OP 2024 ACCRUED AMT: BOC /SUB: 3223 / JOB NO: 22 EXPENDED AMT: REPT CATG: ASSOC ORD: OUTSTNDNG AMT: LAST CHANGE STATUS: HOLDBACK AMT: 02 - LINE NO: BFYS: FUND: DESCR: ORIG LINE AMT: ADM/OFF: AMENDMENT LINE AMT: STATION: / CLSD BFYS: PO LINE AMT: COST CTR: / CLSD FUND: CLOSED AMT: FCP/PRJ: ACCRUED AMT: BOC /SUB: / JOB NO: EXPENDED AMT: REPT CATG: ASSOC ORD: OUTSTNDNG AMT: LAST CHANGE STATUS: HOLDBACK AMT: Example of OBLL prior to the modification. 5. 3 7, 950. 00 0. 00 950. 00 7, 000. 00
EXAMPLE MODIFY OBLIGATION COMMND: -001 OF 002 TRANS TYPE: VENDOR CODE: CONTRACT NO: BEGIN DATE: END DATE: DISC %: ALT PAYEE: DOC TOTAL: 01 - DOCID: AO 10 523 X 850 XX BATID: AO 10 10410 SUB STN: CONTRACT ORDER INPUT SCREEN 01 CO DATE: ACCT PRD: 161637447 01 NAME: V 523 P 3666 ADDR 1: 10 03 07 AUTO ACCRUE: N ADDR 2: CITY/ST/ZIP: 0. 000 DAYS: 00 P/E TERM: / 0. 00 BFYS: LINE: STATION/SAT: COST CTR/SUB: LINE AMOUNT: DESCR: COMMND: 002 -002 OF 002 TRANS TYPE: VENDOR CODE: CONTRACT NO: BEGIN DATE: END DATE: DISC %: ALT PAYEE: DOC TOTAL: 01 - 001 523 / / 7000. 00 TEST FOR ET BFYS: FCP/PRJ: BOC/SUB: I/D: LINE: 002 STATION/SAT: 523 / COST CTR/SUB: / LINE AMOUNT: 7000. 00 DESCR: BFYS: FCP/PRJ: BOC/SUB: I/D: FUND: 08 OP 2024 3223 / D FUND: 0110 JOB NO: 22 REPT CATG: CLSD BFYS: CLSD FUND: STATUS: ACCPT ACTION: M SUB STN: 104 20 20 DIVERSIFIED SVCS ASGE COMMERCE FUNDING CORP 3701 KIRBY DR STE 420 HOUSTON TX 770983924 00 ASSOC ORDER: FUND: 08 OP 2024 3220 / I 01 -A 051 W-NEW LINE ADDED TO ORDER Required fields are underlined. Decrease the outstanding amount on the incorrect line. Add a new line with the correct costing information. 5. 4 001 ACTION: M SUB STN: 104 20 20 DIVERSIFIED SVCS ASGE COMMERCE FUNDING CORP 3701 KIRBY DR STE 420 HOUSTON TX 770983924 00 ASSOC ORDER: DOCID: AO 10 523 X 85001 BATID: AO 10 10410 SUB STN: CONTRACT ORDER INPUT SCREEN 01 CO DATE: ACCT PRD: 161637447 01 NAME: V 523 P 3666 ADDR 1: 10 03 07 AUTO ACCRUE: N ADDR 2: CITY/ST/ZIP: 0. 000 DAYS: 00 P/E TERM: / 0. 00 BFYS: STATUS: ACCPT FUND: 0110 JOB NO: 22 REPT CATG: CLSD BFYS: CLSD FUND:
EXAMPLE OF OBLL AFTER MODIFICATION ACTION: R TABLEID: OBLL USERID: S 104 T 09 *** PURCHASE ORDER ACCOUNTING LINE INQUIRY SCREEN *** KEY IS TRANS CODE, ORDER NUMBER, LINE NUMBER TRANS CODE: AO ORDER NUMBER: 523 X 850 XX 01 LINE NO: 001 BFYS: 08 FUND: 0110 DESCR: TEST FOR ET ORIG LINE AMT: ADM/OFF: AMENDMENT LINE AMT: STATION: 523 / CLSD BFYS: PO LINE AMT: COST CTR: / CLSD FUND: CLOSED AMT: FCP/PRJ: OP 2024 ACCRUED AMT: BOC /SUB: 3223 / JOB NO: 22 EXPENDED AMT: REPT CATG: ASSOC ORD: OUTSTNDNG AMT: LAST CHANGE STATUS: HOLDBACK AMT: 02 LINE NO: 002 BFYS: 08 FUND: 0110 DESCR: ORIG LINE AMT: ADM/OFF: 08 AMENDMENT LINE AMT: STATION: 523 / CLSD BFYS: PO LINE AMT: COST CTR: / CLSD FUND: CLOSED AMT: FCP/PRJ: OP 2024 ACCRUED AMT: BOC /SUB: 3220 / JOB NO: 22 EXPENDED AMT: REPT CATG: ASSOC ORD: OUTSTNDNG AMT: LAST CHANGE STATUS: HOLDBACK AMT: Outstanding funds have been moved from Line 001 to Line 002. 5. 5 7, 950. 00 -7, 000. 00 950. 00 7, 000. 00
EXAMPLE CREATE ET TRANSACTION COMMND: DOCID: ET 10 BATID: 523 JV 81__ STATUS: ACCPT SUB STN: DIRECT DISBURSEMENT INPUT SCREEN BATCH DATE: NUM DOCS: NET: TRANS TYPE: 01 DD DATE: ACCT PRD: ACTION: SUB STN: 104 BFYS: FUND: COMMENTS: VENDOR CODE: 161637447 01 NAME: 20 20 DIVERSIFIED SVCS DIRECT DISB NO: 523 JV 8100 INTR-AGCY SYMBOL: DISB OFFICE: DOC TOTAL: 0. 00 AGREEMENT NO: ADV LIQ AMT: REF DOC NO: COMMND: DOCID: ET 10 523 JV 8100 STATUS: ACCPT 001 -001 OF 002 BATID: SUB STN: 01 LINE: 001 REF DOC: AO 523 X 850 XX REF LINE: 001 ACCP DATE: PAY ADV: REF ADV LINE: INV DATE: VENDOR INV NO/LINE: LOG DATE: T/T: BFYS: 08 FUND: 0110 STATION/SAT: 523 FCP/PRJ: OP 2024 JOB NO: 22 COST CTR/SUB: BOC/SUB: 3223 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: GL ACCOUNT: DESCR: TEST FOR ET LINE AMOUNT: 950. 00 I/D: D P/F: INT REASON: LIQ AMOUNT: QUANTITY: ADV: UNAPPLIED DEP NO: COMMND: DOCID: ET 10 523 JV 81__ STATUS: ACCPT 002 -002 OF 002 BATID: SUB STN: 01 LINE: 002 REF DOC: AO 523 X 850 XX REF LINE: 002 ACCP DATE: PAY ADV: REF ADV LINE: INV DATE: VENDOR INV NO/LINE: LOG DATE: T/T: BFYS: 08 FUND: 0110 STATION/SAT: 523 FCP/PRJ: OP 2024 JOB NO: 22 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: GL ACCOUNT: DESCR: LINE AMOUNT: 950. 00 I/D: I P/F: INT REASON: LIQ AMOUNT: QUANTITY: ADV: UNAPPLIED DEP NO: Line 001 will move the funds from EXPENDED to OUTSTANDING. Line 002 will move the funds from OUTSTANDING to EXPENDED. 5. 6
EXAMPLE OBLL AFTER ET TRANSACTION: R TABLEID: OBLL USERID: S 104 T 09 *** PURCHASE ORDER ACCOUNTING LINE INQUIRY SCREEN *** KEY IS TRANS CODE, ORDER NUMBER, LINE NUMBER TRANS CODE: AO ORDER NUMBER: 523 X 850 XX 01 LINE NO: 001 BFYS: 08 FUND: 0110 DESCR: TEST FOR ET ORIG LINE AMT: ADM/OFF: AMENDMENT LINE AMT: STATION: 523 / CLSD BFYS: PO LINE AMT: COST CTR: / CLSD FUND: CLOSED AMT: FCP/PRJ: OP 2024 ACCRUED AMT: BOC /SUB: 3223 / JOB NO: 22 EXPENDED AMT: REPT CATG: ASSOC ORD: OUTSTNDNG AMT: LAST CHANGE STATUS: HOLDBACK AMT: 02 LINE NO: 002 BFYS: 08 FUND: 0110 DESCR: ORIG LINE AMT: ADM/OFF: 08 AMENDMENT LINE AMT: STATION: 523 / CLSD BFYS: PO LINE AMT: COST CTR: / CLSD FUND: CLOSED AMT: FCP/PRJ: OP 2024 ACCRUED AMT: BOC /SUB: 3220 / JOB NO: 22 EXPENDED AMT: REPT CATG: ASSOC ORD: OUTSTNDNG AMT: LAST CHANGE STATUS: HOLDBACK AMT: 5. 7 7, 950. 00 -7, 000. 00 950. 00 7, 000. 00 950. 00 6, 050. 00
EXAMPLE FOR MODIFYING OBLIGATION COMMND: 001 -001 OF 002 TRANS TYPE: VENDOR CODE: CONTRACT NO: BEGIN DATE: END DATE: DISC %: ALT PAYEE: DOC TOTAL: DOCID: AO 10 523 X 850 XX BATID: AO 10 FSCB 25 SUB STN: CONTRACT ORDER INPUT SCREEN 01 CO DATE: ACCT PRD: 161637447 01 NAME: V 523 P 3666 ADDR 1: 10 03 07 AUTO ACCRUE: N ADDR 2: CITY/ST/ZIP: 0. 000 DAYS: 00 P/E TERM: / 0. 00 BFYS: STATUS: ACCPT ACTION: M SUB STN: 104 20 20 DIVERSIFIED SVCS ASGE COMMERCE FUNDING CORP 3701 KIRBY DR STE 420 HOUSTON TX 770983924 00 ASSOC ORDER: FUND: 01 LINE: STATION/SAT: COST CTR/SUB: LINE AMOUNT: DESCR: COMMND: / / 950. 00 TEST FOR ET DOCID: AO 10 002 -002 OF 002 TRANS TYPE: VENDOR CODE: CONTRACT NO: BEGIN DATE: END DATE: DISC %: ALT PAYEE: 001 523 BFYS: FCP/PRJ: BOC/SUB: I/D: 523 X 850 XX FUND: 0110 JOB NO: 22 REPT CATG: CLSD BFYS: CLSD FUND: STATUS: ACCPT BATID: AO 10 FSCB 25 SUB STN: CONTRACT ORDER INPUT SCREEN 01 CO DATE: ACCT PRD: 161637447 01 NAME: V 523 P 3666 ADDR 1: 10 03 07 AUTO ACCRUE: N ADDR 2: CITY/ST/ZIP: 0. 000 DAYS: 00 P/E TERM: / DOC TOTAL: 0. 00 08 OP 2024 3223 / D BFYS: ACTION: M SUB STN: 104 20 20 DIVERSIFIED SVCS ASGE COMMERCE FUNDING CORP 3701 KIRBY DR STE 420 HOUSTON TX 770983924 00 ASSOC ORDER: FUND: 01 LINE: 002 BFYS: 08 FUND: 0110 STATION/SAT: 523 / FCP/PRJ: OP 2024 JOB NO: 22 COST CTR/SUB: / BOC/SUB: 3220 / REPT CATG: LINE AMOUNT: 950. 00 I/D: I CLSD BFYS: DESCR: CLSD FUND: Required fields are in bold and underlined. Modification is necessary to decrease line 001 and increase the expended amount on OBLH, OBLL to reflect the amount paid. 5. 8
EXAMPLE OBLL AFTER MODIFICATION ACTION: R TABLEID: OBLL USERID: S 104 T 09 *** PURCHASE ORDER ACCOUNTING LINE INQUIRY SCREEN *** KEY IS TRANS CODE, ORDER NUMBER, LINE NUMBER TRANS CODE: AO ORDER NUMBER: 523 X 850 XX 01 LINE NO: 001 BFYS: 08 FUND: 0110 DESCR: TEST FOR ET ORIG LINE AMT: ADM/OFF: AMENDMENT LINE AMT: STATION: 523 / CLSD BFYS: PO LINE AMT: COST CTR: / CLSD FUND: CLOSED AMT: FCP/PRJ: OP 2024 ACCRUED AMT: BOC /SUB: 3223 / JOB NO: 22 EXPENDED AMT: REPT CATG: ASSOC ORD: OUTSTNDNG AMT: LAST CHANGE STATUS: HOLDBACK AMT: 02 LINE NO: 002 BFYS: 08 FUND: 0110 DESCR: ORIG LINE AMT: ADM/OFF: AMENDMENT LINE AMT: STATION: 523 / CLSD BFYS: PO LINE AMT: COST CTR: / CLSD FUND: CLOSED AMT: FCP/PRJ: OP 2024 ACCRUED AMT: BOC /SUB: 3220 / JOB NO: 22 EXPENDED AMT: REPT CATG: ASSOC ORD: OUTSTNDNG AMT: LAST CHANGE STATUS: HOLDBACK AMT: 7, 950. 00 -7, 950. 00 0. 00 7, 950. 00 7, 000. 00 Line 001 has been cleared of the outstanding amount and the expended amount. Line 002 indicates the expended amount to reflect the previous payment of $950. 00. 5. 9
RESEARCH FOR CHECK NUMBER OR TRACE NUMBER 6
EXAMPLE PVHT/PVLT TABLES COMMND: DOCID: MV 04 537 Z 5000706 BATID: SUB STN: MULTIPURPOSE VOUCHER INPUT SCREEN STATUS: ACCPT 11/27/07 TRANS TYPE: MV DATE: ACCT PRD: ACTION: SUB STN: 104 REF DOC: CO 537 Z 50007 VENDOR CODE: 363946864 VENDOR INV: PROGPMT 9 NAME: INTEGRATED CONST TECH CORP INV DATE: 09 30 07 PPAY TYPE: C ADDR 1: 126 S VILLA AVE LOG DATE: 10 22 07 ADDR 2: ACCP/DEL DATE: 11 05 07 CITY/ST/ZIP: VILLA PARK IL 601812653 BENEFICIARY: HOLDBACK TOTAL: 16129. 48 ADV LIQ TOTAL: WORK INSTALLED: 161294. 82 DOCUMENT TOTAL: NET PYMT AMT: 145165. 34 HOLDBACK PYMT AMT: BFYS: DISC %: DAYS: SCHD PYMT DATE: FISCAL APRV: SCHD FY/CAT: SCHD TYPE/NO: CHECK TYPE: COMMENT TO PRINT: A--*HS 60 -DOCUMENT MARKED FOR READ ONLY FUND: P/E TERM: INT RSN: AMT: DISC RSN: PYMT SEQ NO: H--TZO 3 O-8+ DAYS PRIOR TO PROMPT PAY DT COMMND: DOCID: MV 04 537 Z 5000706 STATUS: ACCPT 001 -001 OF 002 BATID: SUB STN: 11/27/07 01 LINE: 001 REF DOC: REF LINE: 001 ACCP/DEL DATE: T/T: 01 REF ADV: REF ADV LINE: PAY ADV: VENDOR INV: INV DATE: LOG DATE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: 145165. 34 I/D: P/F: LINE TYPE: LIQ AMOUNT: DESCR: DLN 29579956865 OUTST OBLIG: 301, 459. 78 INT REASON: DISC REASON: BFYS: 05 FUND: 0111 STATION/SAT: 537 FCP/PRJ: OT 3314 JOB NO: 11 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: COMMND: DOCID: MV 04 537 Z 5000706 STATUS: ACCPT 002 -002 OF 002 BATID: SUB STN: 11/27/07 01 LINE: 002 REF DOC: REF LINE: 001 ACCP/DEL DATE: T/T: 01 REF ADV: REF ADV LINE: PAY ADV: VENDOR INV: INV DATE: LOG DATE: REF VEND CODE: REF VEND NAME: LINE AMOUNT: 16129. 48 I/D: P/F: LINE TYPE: H LIQ AMOUNT: DESCR: RESEARCH LABRATORY OUTST OBLIG: 156, 294. 44 INT REASON: DISC REASON: BFYS: 05 FUND: 0111 STATION/SAT: 537 FCP/PRJ: OT 3314 JOB NO: 11 COST CTR/SUB: BOC/SUB: 3220 REPT CATG: REV SRCE/SUB: CLSD BFYS: CLSD FUND: 01 -CDT 2 O-DUPLICATE INVOICE # 01 -CV 84 W-VENDOR INVOICE NOT IN VIHT TO LOCATE THE CHECK NUMBER/TRACE NUMBER, “L” LEAF FROM PVLT TO VXDD THEN TO TSCL. 6. 1
EXAMPLE VXDD & TSCL TABLES ACTION: R TABLEID: VXDD USERID: S 104 BMT *** PAYMENT VOUCHER LINE - DISB DOCUMENT CROSS REFERENCE INQUIRY SCREEN *** KEY IS VENDOR CODE, TRANS CODE, PAYMENT VOUCHER NUM, TRAVEL ADVANCE NUMBER, PAYMENT VOUCHER LINE, REC TYPE, FY, DISB DOCUMENT NUMBER VENDOR CODE: 363946864 TC: MV NUMBER: 537 Z 5000706 TRAVEL ADVANCE NUM: TREAS REC ACT LN TYP FY DOC NUMBER AMOUNT IND --- -- ------------------- --01 - 001 P 08 A M 081114101 145, 165. 34 C 0203 - POST TREAS IND ---Y POST DET EXP IND --- --Y F BACK OUT IND ---N ACTION: R TABLEID: TSCL USERID: S 104 BMT *** TREASURY SCHEDULE CONTROL LINE INQUIRY SCREEN *** KEY IS FY, SCHEDULE CAT, SCHEDULE TYPE, SCHEDULE NUMBER, VENDOR CODE, PAYMENT VOUCHER TC, PAYMENT VOUCHER NUMBER, ADV NO, PAYMENT VOUCHER LINE, REC TYP FY: 08 SCHEDULE CAT: A SCHEDULE TYPE: M SCHEDULE NUMBER: 081114101 INDICATORS - TREAS ACT: C POST TREAS ACT: Y POST DETAILS: Y EXP: F BACKOUT: N CONF/REJ DATE: 11 16 07 P CHECK/ O ------PAYMENT VOUCHER------REC PAYMENT TRACE S VENDOR CODE TC NUMBER ADV NO LN TYP AMOUNT NUMBER T ------ ------ - --------- 363946864 MV 537 Z 5000706 001 P 145, 165. 34 1241052 Y 363949533 CT 538 C 7068503 001 P 20, 003. 76 1243995 Y 363949533 CT 554 C 7502633 001 P 736. 32 1243996 Y 363949533 CT 554 C 8503201 001 P 170. 72 1243997 Y 363949533 CV 675 A 8001001 P 5, 047. 40 1243998 Y 363988244 CT 537 C 5042308 001 I 18. 06 1242864 Y 363988244 CT 537 C 5042308 001 P 56, 539. 76 1242864 Y 363988244 CT 537 C 6034002 001 P 838. 88 1242865 Y For additional information, go to EFTH and EFTL for EFT payments, CHKH and CHKL for check payments. CHKH displays header information and CHKL displays line information. 6. 2
EXAMPLE EFTH & EFTL TABLES ACTION: R TABLEID: EFTH USERID: S 104 BMT *** EFT HEADER INQUIRY SCREEN *** KEY IS TRACE NUMBER, CONFIRM DATE, D. O. 01 TRACE NUMBER: 1241052 CONFIRM DATE: 11 16 07 D. O. : 220 SCHD FISC YEAR: 08 SCHD CAT: A SCHD TYP: M AGENCY SCHEDULE NO: 081114101 AMOUNT: 145, 165. 34 CANCELED IND: N VENDOR CODE: 363946864 REASON CODE: PAYEE NAME: INTEGRATED CONST TECH CORP VENDOR BANK NAME: KEY BANK CITY/STATE: CLEVELAND ACCOUNT NUMBER: 98900001450580 OH CORR BANK NAME: ABA NUMBER: 04100103 9 ACCOUNT TYPE: C CORR ABA NUMB: ACTION: R TABLEID: EFTL USERID: S 104 BMT *** EFT DETAIL INQUIRY SCREEN *** KEY IS TRACE NUMBER, CONFIRM DATE, DISB OFFICE, PAYMENT VOUCHER TC, PAYMENT VOUCHER NUMBER, ADV NUM, PAYMENT VOUCHER LINE, REC TYP TRACE NUMBER: 1241052 DISB OFFICE: 220 CONFIRM DATE: 11 16 07 EFT AMOUNT: 145, 165. 34 ----PAYMENT VOUCHER------TC NUMBER ADV NUM LINE -- ------- ---01 - MV 537 Z 5000706 001 02 - EFTH lists header information. REC TYP --P AMOUNT ---------145, 165. 34 Leaf to EFTL for detail information. 6. 3
EXAMPLE CXRC TABLE ACTION: R TABLEID: CXRC USERID: S 104 BMT CHECK AND EFT CANCELLATION REASON CODE REFERENCE DATA SCREEN KEY IS REASON CODE 0102030405060708091011121314 - REASON CODE ------A B D E I L N O P S U W X CANCEL REASON ---------------AMOUNT INCORRECT BETTER ADDRESS DUPLICATE PAYMENT DECEASED PAYMENT ID LIMITED PAYABILITY NOT ENTITLED SUPPLIES/SERVICES CANCELED PARTIAL WRONG PAYEE MIS-SPELLED NAME UNKNOWN WRONG PAYEE CONVERSION CANCEL REASON Use the CXRC table to reference the reason code on a cancelled check or EFT payment. 6. 4
RECONCILIATIONS 7
Balancing Auditing Construction Contract Progress Reports SEE INSERTS 7. 1
RSD OVERVIEW Naming Conventions FMS Reports are named in the following way: o R is always the first letter. R stands for Report o The next two letter indicate the Subsystem. AD – Automated Disbursements AP – Accounts Payable AR – Accounts Receivable BE – Budget Execution GL – General Ledger GS – General Systems PE – Purchasing TA – Travel o o The next three letters are assigned by FSC. These letters are intended to describe the report contents. The last letter is V, which stands for VA, indicating the FMS Report was made specifically for the VA. RSD FMS Reports Reference List RSD contains a listing of all FMS generated reports. To access this list, perform the following steps: o On the VA Access Screen, enter RSD MOD 5 in the selection field. o On the EVT Screen, enter your USERID and password. o On the Product Selection Menu Screen, type E 3. o On the Report Index Screen, type L F 523*, then type an S in the Action (A) column next to FMS REPORTS XREF. *(F 523 = Station 523) A complete listing of FMS generated reports will be displayed. To access RSD reports using your web browser enter the following link: http: //austin. aac. va. gov/Frntpage. EOS. html. After clicking on EOS API, user will be prompted to enter their user ID and password. Logon to EOS after selecting the type of reports (E 3 or EA). Find and select your station number. Select “Go to Filter” or scroll through the page to select the report desired. For more information, call the CFD Help Desk at 512 -326 -6780. FREF – FMS CREF - CALM 8
RSD REPORTS PF 1/13 HELP-COMMAND ==> -REPORT INDEX --> RINDX 3 2 RDM 30 EXCUTL. RSD. EOS. RINDX 3. UD 001 -GLOBAL USER DIRECTORYUSERS-> 2078 A-USER NAME---REPORTS------PAGES-------LINES-----F. REPORT DATE--L. REPORT DATE-s F 523 510 29355 1041346 10/08/01 01/26/05 F 523 -750 63 197 3416 07/01/02 01/26/05 F 523 -818 304 2309 51952 10/08/01 01/26/05 F 525 174 3695 79376 10/08/01 01/26/05 F 526 476 17367 573190 10/08/01 01/26/05 F 527 168 5096 133487 10/08/01 01/26/05 F 528 523 53761 1902865 10/08/01 01/26/05 F 528 -513 61 825 15161 10/08/01 01/26/05 F 528 -803 287 1714 34888 10/08/01 01/26/05 Type an S in column A then hit enter. _____________________________________ PF 1/13 HELP-COMMAND ==> -REPORT INDEX --> RINDX 3 2 RDM 30 EXCUTL. RSD. EOS. RINDX 3. UD 001 -DIRECTORY SELECTION- USER-> F 523 TR-> 510 TP-> 29355 TL-> 1041346 FORM NAME REPORT ROOTNAME NOTEPAD HEADER ==> F 744 ==> ==> REPORT VERSION REPORT STATUS ==> FROM DATE AND TIME TO DATE AND TIME ==> / / EXPIRATION DATE ARCHIVAL DATE ==> DESTINATION OUTPUT FORM ==> CLASS ==> ROOM NUMBER LOCAL PRIORITY ==> TOP SEARCH ==> <- ENTER Y WITH TOC ONLY ==> <- ENTER Y SELECTION ON TOC ==> APPL. (JOBNAME) DEFERRED ONLY ==> PRINTED REPORTS ==> DISPLAYED REPORTS ==> Enter the report name then hit enter. 8. 1 <- ENTER Y/N <- ENTER Y
RSD Reports for Construction Accounting – FSAV – Fixed Asset GSA 1166 Report • Includes a description of the Asset #, Acquired Date, and Value – FBE 1 – FMS Construction Project Appropriation • Fund transactions in and Fund transactions out – F 700 – PROJ/CP Allotment Report • Includes the allotment amount, obligation, and payment – F 718 – Status of Unobligated Allowance/Project Allotment and Unliquidated Obligation as of MM/DD/YY – FPC 1 – Weekly Status of Funds Report • This report is good for reconciling. It indicates Open/Closing Balances, Obligations, Mods, and Interest – F 876 – Work In Process (G/L 1720) • Displays the balance of the 1720 account by project, BFY, and fund. – F 744 – VA Summary Trial Construction Balance by Acctg Dist Within a Fund • Stations should be reviewing this report to correct the opposite balances. 8. 2
RVAWIP - F 876 Report RVAWIPV 999 REPORT ID: RVAWIPV *** DEPT OF VETERANS AFFAIRS (FMS) 1 RSD FORM: F 876 WORK IN PROCESS (G/L 1720) 23: 47 RUN DATE: 11/15/07 AS OF 11/15/07 STN: 999 FUND: 0110 STN BFY PROJECT DOC ID TRANS DATE 999 97 PM 2027 10/19/06 999 99 08/30/04 999 99 PM 2027 06/30/05 999 06 RM 2027 07/02/07 FUND 0110 TOTAL: *** PAGE: TIME: AMOUNT 10, 318. 40 -44, 091. 17 1, 789, 854. 46 -------1, 800, 172. 86 When an SV transaction is input without referencing the Project Number, or a different BFY is entered, the project will not be cleared from the F 876 report. User will need to enter an SV 70 transaction in order to clear the report. 8. 3
SV 70 “D” TO CLEAR GL 1720 CREDIT ACTION: R TABLEID: GLTS USERID: S 104 BMT *** GENERAL LEDGER TRIAL BALANCE BY STATION SCREEN *** KEY IS FISCAL YEAR, STATION, FUND, BFYS, GL ACCT 010203040506070809101112 - FY STATION FUND -- -----08 999 0110 GL D/ ACCT C BEG BAL ---- - -------1010 N -55, 622. 17 1720 D 0. 00 3100 C 55, 501. 85 3310 N 120. 32 4201 D -55, 622. 17 4451 C 0. 00 4610 N 55, 622. 17 480 N C 0. 00 9903 C 0. 00 9905 C 0. 00 9935 N -11, 651. 32 9936 N 11, 651. 32 BFYS ----99 DEBIT BALANCE: - CREDIT BALANCE: = DIFFERENCE: 0. 00 + DEBITS CREDITS = END BAL ---------------0. 00 -55, 622. 17 0. 00 55, 501. 85 0. 00 120. 32 0. 00 -55, 622. 17 0. 00 0. 00 -11, 651. 32 0. 00 11, 651. 32 Why does the 1720 balance equal zero? ACTION: R TABLEID: ACEN USERID: S 104 BMT ACCOUNTING ENTRIES REFERENCE DATA SCREEN KEY IS FISCAL YEAR, ACCOUNTING ENTRY ID, SEQUENCE NUMBER FISCAL YEAR: 08 ACCOUNTING ENTRY ID: 9700 ACCOUNTING EVENT TYPE: SP 05 SEQUENCE JOURNAL INCREASE ----- DEBIT ------ CREDIT ----- FLAGS NUMBER CODE LINE D/C ACCT TYPE OVERRIDE REV FIP -------- -------- --01001 GENJ D 3310 03 N 1720 01 N Y N 02002 GENJ D 9936 01 N 9935 01 N Y N 030405 - 8. 4
Example of SV 70 COMMND: SV DATE: ACTION: BFYS: REVERSAL PERIOD: COMMENT: DOCID: SV 10 999 AB 3120 STATUS: BATID: SUB STN: STANDARD VOUCHER INPUT SCREEN ACCT PRD: SUB STN: 104 EXPENSE(E), REVENUE(R), GL(G), BUDGET(B): FUND: BUDGET OVERRIDE IND: DOC TOTAL: 0. 00 DESCRIPTION: 01 LINE: 001 TRANS TYPE: 70 EXP/REV/GL/BG: G A/O: BFYS: 99 FUND: 0110 STATION/SAT: 999 FCP/PRJ: PM 2027 JOB NO: COST CTR/SUB: BOC/REV SOURCE/SUB: REPT CATG: CLSD BFYS: CLSD FUND: VENDOR: NAME: SCHD FY: SCHD CAT: SCHD TYP: SCHD NO: D. O. : GUEST SYMBOL: QTY: REF DOC ID: DOC TYP: AGR NO: AMOUNT: 44, 091. 17 I/D: I OBL FY: ACCP DATE: ADV: INVOICE NO: INV LINE: INV DATE: DESCRIPTION: TO CORRECT F 876 REPT. TREAS NO: UNAPPLIED DEP NO: 01 LINE: 002 TRANS TYPE: 70 EXP/REV/GL/BG: G A/O: BFYS: 99 FUND: 0110 STATION/SAT: 999 FCP/PRJ: JOB NO: COST CTR/SUB: BOC/REV SOURCE/SUB: REPT CATG: CLSD BFYS: CLSD FUND: VENDOR: NAME: SCHD FY: SCHD CAT: SCHD TYP: SCHD NO: D. O. : GUEST SYMBOL: QTY: REF DOC ID: DOC TYP: AGR NO: AMOUNT: 44, 091. 17 I/D: D OBL FY: ACCP DATE: ADV: INVOICE NO: INV LINE: INV DATE: DESCRIPTION: TO CORRECT F 876 REPT. TREAS NO: UNAPPLIED DEP NO: If the transaction rejects with error code 01 -ZJAZE(FCP/PROJ CLOSED ON STAP), call Central Office Construction to reopen the project. 8. 5
WIP Transactions for capitalization of Construction Funds: FUNDS: 0110 & 0111 IMPORTANT: USE SAME BFY & PROJECT General ledger 1712 SV 20 I 1712/1720 SV E 2 D 3310/1712 9936/9935 SV E 2 I 1712/3310 9935/9936 General Ledger 1730 SV 30 I 1730/1720 SV 71 I 3310/1730 9936/9935 SV D 4 I 1730/3310 9935/9936 General Ledger 1740 SV 28 I 1740/1720 SV 72 I 3310/1740 9936/9935 SV D 6 I 1740/3310 9935/9936 General Ledger 1820 SV 29 I 1820/1720 SV 73 I 3310/1820 9936/9935 SV E 9 I 1820/3310 9935/9936 Improvements to Land Fund: 0110/0111 Fund: AMAF BFY: 95 Building, Improvements, and Renovations Fund: 0110/0111 Fund: AMAF BFY: 95 Other Structures and Facilities Fund: 0110/0111 Fund: AMAF BFY: 95 Leasehold Improvements Fund: 0110/0111 Fund: AMAF BFY: 95 8. 6
F 744 Trial Construction Balance RGLASTV STA 999 REPORT ID: RGLASTV PAGE: 1 RSD FORM: F 744 DISTRIBUTION WITHIN FUND FOR ACCOUNTING PERIOD 01/09 FCP/PROJECT: GL ACCT LMT -----1720 3310 FUND: 0110 DEBIT BALANCE ---------- BFY: 09 ADMIN/OFFICE: 08 CREDIT BALANCE ---------44, 091. 17 **OPPOSITE-BALANCE** 44, 091. 17 TOTAL: FCP/PROJECT: GL ACCT LMT -----1010 1720 3100 3310 4201 4610 9935 9936 TOTAL: *** DEPT OF VETERANS AFFAIRS (FMS) *** VA SUMMARY TRIAL CONSTRUCTION BALANCE BY ACCOUNTING TIME: 03: 55 RUN DATE: 11/01/08 44, 091. 17 PM 2027 FUND: 0110 DEBIT BALANCE ---------- 44, 091. 17 BFY: 09 ADMIN/OFFICE: 08 CREDIT BALANCE ---------55, 622. 17 44, 091. 17 55, 501. 85 **OPPOSITE-BALANCE** 43, 970. 85 55, 622. 17 **OPPOSITE-BALANCE** 55, 622. 17 11, 651. 32 166, 866. 51 Note: Look for different Project numbers, different funds, different fiscal years, and different A/O. 8. 7