1 / 19

An Alternative to FUPLOAD – Uploading Transactions with FOAPAL Checks

An Alternative to FUPLOAD – Uploading Transactions with FOAPAL Checks. Carole Wilson/Don Sloan. UNC Wilmington. Session Etiquette. Please turn off all cell phones. Please keep side conversations to a minimum. If you must leave during the presentation, please do so as quietly as possible.

sofia
Download Presentation

An Alternative to FUPLOAD – Uploading Transactions with FOAPAL Checks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. An Alternative to FUPLOAD – Uploading Transactions with FOAPAL Checks Carole Wilson/Don Sloan UNC Wilmington

  2. Session Etiquette • Please turn off all cell phones. • Please keep side conversations to a minimum. • If you must leave during the presentation, please do so as quietly as possible.

  3. Introduction • Discuss UNCW’s feed process for non-Banner feeds • Discuss how UNCW verifies FOAPAL information prior to finance feed processing • Discuss how UNCW utilizes Banner functionality as well as locally developed applications to automate finance feed processing • Determine if UNCW’s processes are functional for your campus

  4. Agenda • Why Create the Process • How Did UNCW Setup the Process • What Is the Process • Who Uses the Process at UNCW

  5. Why Create the Process • Needed to upload feeds from 3rd party software applications as well as locally developed systems • Needed to upload feeds from excel files where departments had no software applications to create the feed • Could use excel file template similar to FRS data load template • No UNIX folders established for excel files in which users could drop files • Lack of Banner experience • FUPLOAD was problematic per Banner consultant • UNCW initially created the process when Banner was first implemented

  6. How Did UNCW Setup the Process • Created Samba shares for every area submitting excel file feeds • All feed users either map a drive or create a shortcut on their desktop to the Samba Share folder • These Samba shares are to be cleaned out periodically by the folder administrators

  7. How Did UNCW Setup the Process • Created UNCW table to maintain folder system id linkage and identifies folder administrators

  8. How Did UNCW Setup the Process • Created UNCW table to map CSV columns to Oracle fields in GURFEED

  9. How Did UNCW Setup the Process • Created 3 temporary GURFEED staging tables Excel Feeds Business Application Feeds ITS Application Feeds • No document numbers on feeds at this point

  10. How Did UNCW Setup the Process • Created FTMSDAT records for Rule Code and Folder Info Allowable Rule Codes

  11. FTMSDAT Process Name Folder Name Default Rule Code Default Date – Options can be TODAY, ACCRUAL, MONTHEND, YEAREND System ID

  12. FTMSDAT Process Name Folder Name Default Rule Code Default Date – Options can be TODAY, ACCRUAL, MONTHEND, YEAREND System ID

  13. How Did UNCW Setup the Process • Wrote 2 Banner processes • FWFMPORT • Checks Samba directories for CSV files • Removes quotes from the description field • Verifies the default org/program are correct • Identifies the default rule code and system ID based on FTMSDAT setup • Moves error free excel feeds into temporary GURFEED staging table • Moves files with errors (typically FOAPAL errors) into a subdirectory and renames the file with xxx.errors • Sends email to folder administrators with errors • FWLOADA • Add document numbers to all feeds in all temporary GURFEED staging tables • Moves all feeds from temporary GURFEED staging tables to GURFEED

  14. What is the Process Anytime During the Day • User puts CSV file in Samba share (windows-enabled folder on UNIX box) • File names cannot be longer than 35 characters • Files with the same name will be overwritten • Commas should never be used in the description field • 3rd party and locally developed applications put data into appropriate temporary GURFEED tables

  15. What is the Process Hourly During the Day through UC4 (AppWorx) • FWFMPORT is run • Checks Samba directories for CSV files • Removes quotes from the description field • Verifies the default org/program are correct • Identifies the default rule code and system ID based on FTMSDAT setup • Moves error free excel feeds into temporary GURFEED staging table • Moves files with errors into a subdirectory and renames the file with xxx.errors • Sends email to folder administrators with errors

  16. What is the Process Every 2 Hours During the Day through UC4 (AppWorx) • FWLOADA • Add document numbers to all feeds in all temporary GURFEED staging tables • Moves all feeds from temporary GURFEED staging tables to GURFEED • FURFEED • FGRTRNI • FGRTRNR Feeds are now in Banner Finance!

  17. Who Uses the Process at UNCW • Accounting – Daily, month end, year end • Accruals – Beginning balance adjustments, entry to be reversed, prior year reversals, cash entry, accrual reclass adjustments • Budget – Budget entries • Facilities - Work order, gas and utility charges • Postal – Mail charges • Purchasing – PACS charges • Telecom – phone charges and encumbrances

  18. Summary • Process takes a little setup with samba shares and FTMSDAT • Maintenance free for the most part • Runs seamlessly throughout the day • Financial Accounting uses this process for all journal entries submitted by any campus user

  19. Questions & Answers Thank You! Carole Wilson wilsonc@uncw.edu Don Sloan sloan@uncw.edu

More Related