USAS User’s Manual –
Chapter 11 – Payment Processing (continued)
Control Reports
About these Reports
There are several Control Reports which provide information on either payments or payment cancellations.
Payment Processing Reports
DAFR3521 Payment Error Comparison Processing
The DAFR3521 Payment Error Comparison Processing report lists by document payments which were not generated due to one of several errors (for example, ‘vendor not paid due to future date’ or ‘vendor not paid due to error on transaction.’) The Vendor Number is also included on this report. The DAFR3251 is a quick place to check for non-payments due to errors and what the errors were.
A picture of the DAFR3521 report
1DAFR3521 999 USAS 01 DBRE RJE R999 GOLDEN COMMISSION *****************AGCY NUMBER 999 PAYMENT ERROR COMPARISON PROCESSING AGCY PAGE 1 10/14/95 (01.00) CYCLE 0939 ************************************************************************************RUN PAGE 18 DOCUMENT FY VENDOR NAME/ ERROR DESCRIPTION AGY NUMBER YR VENDOR NO / MC VENDOR ADDRESS1 TRANS AMT *********************************************************************************************************** 0 0MANUAL WARRANTS NOT PAID NO INVALID DATA DETECTED TOTAL COUNT: 0 TOTAL AMOUNT: .00 0DOC NOT PAID DUE TO OTH TRANS NO INVALID DATA DETECTED TOTAL COUNT: 0 TOTAL AMOUNT: .00 0VEN NOT PAID DUE TO FUT DUE DT 999 XJZ95284 96 XXXXXXXXXXX 013 EMPLOYEES TEXAS TRUSTEE 392.23 VEN NOT PAID DUE TO ERR TRANS 999 20111292 96 XXXXXXXXXXX 009 209.25 VEN NOT PAID DUE TO ERR TRANS 999 20111832 96 XXXXXXXXXXX 004 903.00 VEN NOT PAID DUE TO ERR TRANS 999 30027529 96 XXXXXXXXXXX 001 TEXZOO CORP 10,144.49 PO BOX 59197 VEN NOT PAID DUE TO ERR TRANS 999 90559026 96 XXXXXXXXXXX 999 705.00 VEN NOT PAID DUE TO ERR TRANS 999 90559278 96 XXXXXXXXXXX 000 15.00 VEN NOT PAID DUE TO ERR TRANS 999 90559317 96 XXXXXXXXXXX 002 JAKECUB EYE ASSOCIATES 35.00 222 E MOUNTAIN RANGE RD SUITE 110 VEN NOT PAID DUE TO ERR TRANS 999 90559326 96 XXXXXXXXXXX 002 GOLDEN SERVICES 35.00 330 BURES BLVD VEN NOT PAID DUE TO OTH TRANS TOTAL COUNT: 8 TOTAL AMOUNT: 12,438.97
DAFR3601 Transactions Cancelled for Negative Balances
The DAFR3601 Transactions Cancelled for Negative Balances report lists by Document ID (Document Agency, CDoc, and Fiscal Year) and Vendor the non-payments that resulted from the amount of payment due for the vendor and document, netting to a negative amount. Line items on this report will clear off when they are able to combine with other payments to a non-negative amount. In the event that there will not be another payment to offset the negative amount, an adjusting entry will need to be made (either an offsetting document or deletion).
A picture of the DAFR3601 report
1DAFR3601 999 USAS 01 DBRE RJE R999 GOLDEN COMMISSION *****************AGCY NUMBER 999 TRANSACTIONS CANCELLED FOR NEGATIVE BALANCES AGCY PAGE 1 10/14/95 (01.26) CYCLE 0939 ************************************************************************************RUN PAGE 11 ---- DOCUMENT ID ---- --------------- NAME ---------- PAY IN TRANSACTION TRANSACTION AGENCY DOC-NO FY VENDOR NO / MC --- ADDRESS1 ---------- FULL DOC COUNT AMOUNT ************************************************************************************************************ 999 90540670 96 XXXXXXXXXXX 000 SCOTTCOX CORPORATION N 2 123.47 5555 JANWOOD 0 999 90540681 96 XXXXXXXXXXX 000 MYERSON PHARMACY COMPANY N 2 31.54 FOR DIRECT DEPOSIT of BILLS 0 *********** TOTAL PAYMENT WORK RECORDS FLAGGED IN ERROR: 4
DAFR3631 Fund Control Errors Occurring During Payment Processing
The DAFR3631 Fund Control Errors Occurring During Payment Processing report lists by Doc ID (Document Agency, Document Number, and Fiscal Year) and Vendor Number those documents which did not generate a payment due to failing funding edits. Remember, a document can post without passing funding edits-depending on the severity of funding edits (see the USAS User’s Manual, Chapter 12 – Understanding Financial Tables, for more information), but the transactions must pass these funding edits on the Due Date (Payment Date) or no payment will be generated.
A picture of the DAFR3631 report
DAFR3631 999 USAS 01 DBRE RJE R999 GOLDEN COMMISSION *****************AGCY NUMBER 999 FUND CONTROL ERRORS OCCURING DURING PAYMENT PROCESSING AGCY PAGE 1 10/13/95 22:45 CYCLE 0939 ************************************************************************************RUN PAGE 6 DOC CURR DOC VENDOR MAIL APPN LBB NO of AGY NUMBER FY NO CODE AGY AY NO AFUND FUND ORG PROG COBJ OBJ AMOUNT TRANS ERROR MESSAGE 999 90560443 96 XXXXXXXXXXX 001 VENDOR FAILED 999 95 13004 0166 13,179.09 0003 AVAILABLE CASH EXCEEDED 999 90560444 96 XXXXXXXXXXX 008 VENDOR FAILED 999 95 13004 0166 16,378.49 0004 AVAILABLE CASH EXCEEDED 999 90560445 96 XXXXXXXXXXX 007 VENDOR FAILED 999 95 13004 0166 18,966.86 0002 AVAILABLE CASH EXCEEDED 999 90560447 96 XXXXXXXXXXX 018 VENDOR FAILED 999 95 13004 0166 50,454.32 0002 AVAILABLE CASH EXCEEDED 999 90560462 96 XXXXXXXXXXX 081 VENDOR FAILED 999 95 13004 0166 230.00 0001 AVAILABLE CASH EXCEEDED 999 90560463 96 XXXXXXXXXXX 002 VENDOR FAILED 999 95 13004 0166 170.00 0001 AVAILABLE CASH EXCEEDED 999 90560464 96 XXXXXXXXXXX 000 VENDOR FAILED 999 95 13004 0166 175.00 0001 AVAILABLE CASH EXCEEDED 999 90560465 96 XXXXXXXXXXX 013 VENDOR FAILED 999 95 13004 0166 90.00 0001 AVAILABLE CASH EXCEEDED
DAFR3651 Warrant Register Report by Agency
The DAFR3651 Warrant Register by Agency Report lists by Document Number and Vendor Number payments generated during the payment cycle the previous night. This report will provide both the warrant number and the warrant amount.
A picture of the DAFR3651 report
DAFR3651 999 USAS 01 AGY RJE R999 GOLDEN COMMISSION *****************AGCY NUMBER 999 WARRANT REGISTER BY AGENCY REPORT AGCY PAGE 1 12/13/95 (21.47) CYCLE 0981******************************************************************RUN PAGE 2,072 WARRANT TYPE 060 BILLS ****************************************************************************************************************** APFD FUND DOC NO FY ESN VENDOR NO / MC ----VENDOR NAME/ADDRESS----PDT/C WARR NO WARR DT WARR AMT ****************************************************************************************************************** 1644407 XXXXXXXXXXX 004 ANGEL LEASING COMPANY INC RC 118866223 12/13/95 337.25 DBA ANGEL CARS P O BOX D SAN ANTONIO TX 78291 0005 1644408 XXXXXXXXXXX 007 ROLLINS RIDES RC 118866224 12/13/95 206.58 PO BOX 777 JOEY CITY NY 11530 0000 1644428 XXXXXXXXXXX 000 GOLDEN COMMISSION RC 118866225 12/13/95 1,793.90 P O BOX 13087 AUSTIN TX 78711 3087 2664336 XXXXXXXXXXX 000 CURIOUS COURIER INC RC 118866226 12/13/95 157.35 P O BOX 151 HOUSTON TX 77001 0151 2666525 XXXXXXXXXXX 001 SANITATION SERVICES RC 118866227 12/13/95 46.00 PO BOX 1927 CLEANVIEW TX 77530 0000 2666586 XXXXXXXXXXX 000 DEGENE DIRECTORY PRODUCTS RC 118866228 12/13/95 54.21 PO BOX 35 SEATTLE CITY MO 64180 0000
DAFR3691 Direct Deposit Payees by USAS
The DAFR3691 Direct Deposit Payees by Agency provides agencies with a listing of direct deposits sorted by Agency document number and payee/vendor number/mail code.
Note: For a listing of warrants generated, refer to the DAFR3651 Warrant Register by Agency Report.
A picture of the DAFR3691 report
1DAFR3691 999 USAS 01 DBRE RJE R999 GOLDEN COMMISSION ***************** AGCY NUMBER 999 DIRECT DEPOSIT PAYEES BY A AGCY PAGE 1 12/20/95 (03.34) CYCLE 0985 ******************************************************************** RUN PAGE 42 AGENCY 999 GOLDEN COMMISSION ************************************************************************************************************************ FY DOCNO VENDOR NO/MC VENDOR NAME TRANSIT BANK ACCT NO TYPE AMOUNT SEQ NO TRANS ************************************************************************************************************************ 10130583 XXXXXXXXXXX 000 JOSEPH PINK 111000025 3456789012 22 266.00 2252773 1 10130980 XXXXXXXXXXX 000 HARRY RAMSON 314986292 1234567 22 221.62 2252774 4 10130981 XXXXXXXXXXX 000 SCOTT COX 111000025 5555555555 22 939.59 2252775 4 10130982 XXXXXXXXXXX 000 LAURA JOE 313072000 2345671234 22 360.15 2252776 4 10130983 XXXXXXXXXXX 000 MERLE NORMAN 314978417 76834763728 22 74.48 2252777 1 10130984 XXXXXXXXXXX 000 PAT JONES 114903912 444444488 22 181.39 2252778 4