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