Revision History

Introduction

This file records the month-end unpaid invoices that is included in the SMS fifth day KFS feedback file.  

File Format

The format of the file is the standard KFS Collector Feeder File format.   The KFS GL Collector File Upload process allows you to upload either the XML or flat file transactions from the external feeder systems.  The uploaded files are pre-validated and processed by the Collector Job. The Scrubber and Poster jobs will then process the output to update the GL balances. Unlike the Enterprise Batch Feed,which only validates the totals to the reconciliation file, the GL Collector Batch Upload process performs the format validation and matching of the totals.  

Refer to KFS Collector File specification.

Functional Requirement used for legacy KFS-AMS integration

UCI Medical Center purchasing system monthly sends invoice accruals (“Items Received but not yet paid”) to GL via AMS 1.9.11 interface.  This functional Spec describes the KFS process to replace this existing functionality.

The collector flat file is made up of three sections in one file:

• Transaction Header:  contains the information regarding the sender of the file
• Transaction: transactions to be posted to KFS
• Transaction Trailer: contains the total counts and amounts to be used to validate the transactions.

Refer to the Functional Requirement Document.

Sample File from June 2017 kfsmc_prd_kfsgl_kfsmc_20170602085449.data