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. Identifying 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.

Run Statements
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.