Accounts Payable System Invoice Lines Charged to Fixed Asset Accounts Reports

Report Series Name

C-U-FA-AP-INVOICE-ACT

Report Name

State of North Carolina Accounts Payable System Invoice Lines Charged to Fixed Assets Accounts Sorted by Account/Center for Assets Greater than or Equal $ Extract  Value

Library
Source code is located in FAPUBLIC

Use
Use this report to identify assets that should be added to the NCAS fixed asset module. The C-FA-AP-INVOICE-ACT report series is made up of three reports which are: BYACCT - sorted by GL account charged, BYVEND - sorted by vendor / invoice, UNDERRPT - assets with a per unit value less than a specified amount from the WK-EXTRACT-VALUE run-time variable.

Content
This report contains any invoice that is paid against a fixed asset account. The value assigned to an asset includes tax, freight, additional cost and any other charges that are included in the invoice line.

Totals
The BYACCT report gives totals by center and account.
The BYVEND report gives totals by invoice number.
The UNDERRPT report gives totals by invoice number.

Column Headings

  • NEW ASSET - a blank field to be used to assign a fixed asset number
  • ACQ DT- a four position number that represents the Acquisition Date. This date is in MMYY format.
  • INVOICE - the invoice number
  • VALUE - the amount on the invoice including tax, freight, and additional cost proration amounts.
  • CTL GP DT- the Control Group Date of the Control Group that contains this invoice.
  • NUM- the Control Group Number that contains this invoice
  • PO NO- the Purchase Order Number if this was a matched invoice
  • CO- the GL Company charged for this item on the invoice line
  • ACCOUNT - the GL Account charged for this item on the invoice line
  • CENTER - the GL Center charged for this item on the invoice line
  • DESCRIPTION - the invoice line description
  • VENDOR NO - the NCAS vendor number
  • GROUP- the group number associated with the NCAS vendor number
  • VENDOR NAME - the vendor name as listed in the NCAS Vendor File

Run Statements
The run statement member name is C-U-FA-AP-INVOICE-ACT-RUN

000100 OPTION LIBRARY(FAPUBLIC)
000110 RUN C-U-FA-AP-INVOICE-ACT
000120 INTO LIBRARY XXXXXXXXXXX
000200 VARIABLE WK-EXTRACT-VALUE
000300 5000.00
000400 VARIABLE WK-FROM-DATE
000500 '07/01/95'
000600 VARIABLE WK-TO-DATE
000700 '07/31/95'
000800 SELECT AP-PAYING-ENTITY
000900 ('02' '0299')

Type over the displayed variable values with your agencys values.