Path: Accounting > Universal Financial > UFI Setup
UFI Setup is performed by the WebTMA System Administrator. When your organization purchases the optional Universal Financial Interface module, this is specified in the license file. It is strongly advised that you limit access to Universal Financial. Only a few WebTMA System Administrators should be allowed to use the UFI windows.
Database Connection
The following topics define your connection options.
Application
In Edit mode, select the Application used, i.e., Banner, PeopleSoft, etc. The selections for the Application field are hard wired for the applications to which UFI can connect.
UFI Web Service
The UFI Web Service field is used when clients have a web service installed on their servers. If you want to use your own server and file systems, enter the URL in this field.
When a UFI Web Service URL is provided, WebTMA also includes a copy of the export .zip file as a linked document on the UFI Export Data window. See UFI without Web Service below for details about what to expect if you do not use your own Web Service.
UFI API Key
To secure access to the UFI API Key is used. See UFI Account Validation for a full description of how validation is handled.
UFI Doc. Counter
The UFI Doc. Counter field is used to track the number of exported transactions. The field is updated when any UFI transaction is exported that uses the Document Code column. The counter is updated by transaction not per line item. If a transaction with the Document Code column is exported before the counter is set up, WebTMA automatically starts with a default value of 1.
Last Validated
This read-only field reflects the most recent date and time the time Account Validation was run.
Separator
The Separator field is used to indicate the character you wish to use to separate each segment such as a hyphen ( - ) or a period ( . ).
Summarize Header
By default, the Summarize Header check box is marked. Clear the check box if you want a header line for each transaction number.
Summary Options
The summary options are used to specify that totals from a transaction (not from individual transaction lines) are transferred based on the criteria noted in parenthesis. The default is No Summarization. If you select a different option, only the listed lines are summarized, i.e., Transaction #, Account #, etc. depending on the option selected.
Summarization does not affect the Header line in a document.
-
No Summarization
No lines are totaled. Each transaction line is independently exported to either a database or a text file.
-
Summarization (Transaction # / Date / Account # / Debit or Credit) Transaction lines with the same transaction #, the same date, the same account #, and the same credit flag are totaled. The credit flag means that credit and debit lines will not be totaled together, even if they are of the same account #.
-
Summarization (Transaction # / Account # / Debit or Credit) This is the same as the previous summarization description, except the date is ignored.
-
Summarization (Account # / Debit or Credit) All the transactions of a similar type (Work Order, Sales Order, etc.) are grouped together if the account # and credit flag are the same. This grouping does not span multiple batch jobs (posting events).
If you use the Summarization options, line items that total zero are removed from the export. For example, if a $10 Part is issued to a Work Order and later it is returned, two export lines are created, namely, 10.00 and -10.00. Since these total zero, WebTMA does not export the line items.
There are data fields on the UFI Template that are specific for each transaction line such as Transaction # or Line Item Description. If the summary option selected does not contain those data fields, WebTMA uses hard-coded descriptions, such as “Summarized Work Orders,” “Summarized Sales Orders,” and “Summarized Utility Tickets.” If you do not want to use the hard-coded descriptions, you can replace the data field with a constant value and supply your own description.
UFI without Web Service
The UFI Setup window does not require a UFI Web Service URL; however, this is only recommended if you send your data to a flat file.
When the UFI Web Service field is empty:
- All UFI exported data goes to the UFI Export Data window as a zipped file saved as a linked document
- Account Validation is ignored
- Segments in any new accounts entered from Accounting > Accounts are automatically validated as True
You have two options:
- With no Web Service URL and without using the WebTMA UFICloudStorage Module, the previous actions apply.
- With no Web Service URL but using the WebTMA UFICloudStorage Module (described next) that is available to Azure clients, the previous statements apply, plus the system exports the UFI file to TMA's SFTP site.
UFICloud Storage Module
TMA offers Cloud Storage to Azure clients. If you do not have sufficient servers to run the UFI service, connect to WebTMA, and pull UFI files, you can use our storage for a limited time. UFICloudStorage uses an SFTP (Secure File Transfer Protocol) site from which to pull files.
When you use UFICloudStorage, the following occurs:
- WebTMA DevOps sets up the SFTP site
- DevOps provides both an SSH key (access credential) and a Username
The UFI is configured to drop files into WebTMA storage under your client account. You can pick them up using your SFTP site credentials indicated above. All UFI files generated are held for 90 days.