State of North Carolina Accounts Payable System Account Analysis Report
Report Series Name
C-U-AP-ACCOUNT-ANALYSIS
Report Name
STATE OF NORTH CAROLINA
ACCOUNTS PAYABLE SYSTEM
ACCOUNT ANALYSIS REPORT
Library
Source code is located in
APPUBLIC
Use
Use this report to research
accounts payable accounting distribution balances.
Content
This report contains invoice
line amounts by company/account/center. Each Company/Account is listed
on a separate page with totals by center then account. Identifing information
is the invoice number, invoice date, vendor short name, vendor number and
vendor group number, control date and control group number.
Totals
This report gives totals
for centers and accounts by company..
Column Headings
- CENTER - the GL Center charged for this item on the invoice line
- VNDR NUMBER - the NCAS vendor number (Tax Identification Number)
- GRP # - the group number associated with the NCAS vendor number
- SHORT NAME - the vendor short name as listed in the NCAS Vendor File
- INVC NUMBER - Invoice Number
- INVC DTE- Invoice Date
- CTRL DTE- the Control Group Date of the Control Group that contains this invoice
- CTRL #- the Control Number of the control group
- LINE EXPENSE AMOUNT- the amount on the invoice including tax, freight, and additional cost proration amounts per invoice line.
The run statement member name is C-U-AP-ACCOUNT-ANALYSIS-RUN
000010 OPTION LIBRARY(APPUBLIC)
000100 RUN C-U-AP-ACCOUNT-ANALYSIS
000200 INTO LIBRARY XXXXXXXX
000300 SELECT AP-LINE-EXP-GL-COMPANY-ID
000400 'XXXX'
000500 SELECT AP-LINE-EXP-GL-ACCOUNT-ID
000600 ('XXXXXXX' 'XXXXXXX')
000700 SELECT AP-LINE-EXP-GL-CENTER-ID
000800 ('XXXXXXXXX' 'XXXXXXXXX')
000900 REPORT REPORT01
Type over the displayed variable values with your agencys values.