Revision History

Date	Initial	Description
6/7/17	KT	Initial

Introduction

This file records the monthly inventory usage that is included in the SMS fith 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 Requirements used for legacy KFS-AMS integration

Currently MC generates transactions to reclassify asset to expenses by crediting inventory and debiting departmental accounts (42xxxx). AMS uses average cost of inventory and generates Stores Summary report on a monthly basis. The report is used to generate a campus KFS transaction file containing reclassification of inventory asset to expenditures. This functional specification replaces two current processes with one AMS process to generate KFS collector file.

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_fs_kfsmc_fstrans_s53_20170601075257.xml

Browser not supported