How to Automate Billing (Collector) File Upload

Owned by Kathleen Avery (Deactivated)
Last updated: Aug 17, 2021

 

General: The Collector Flat File process is a way to process a large quantity of journal entries with a single file.

Create process:

 

  1. Add an entry to the Origination Code Table. Value can be any 2-digit value.  Updating the table is done through the Origination Code Link (Jump To ... Origination Code)
  2. Decide on a document number scheme.  See Collector File Document Numbers to see values currently being used. 
  3. Determine the Organization Code (4-digits) for the department.  This is needed in the header record.
  4. Contact server support to create a directory structure on the KFS Batch Server.
  5. Request Scheduling to create a Control-M MFT, job to perform the file transfer.  The MFT job must create an associated .done file and archive the original file after transfer.  Also, needed are job request forms for each job requested.  Jobs are to be set up in UAT as ad-hoc and production as part of the daily schedule. Verify appropriate emails are sent out indicating the status of the file transfer.
  6. Add contact information to the KFS Integrations (Interfaces) page in confluence.  Include any documentation or descriptions