Path: Accounting > Universal Financial > UFI Template Setup
You can have a number of different templates, which are similar to ad hoc reports. Templates are used to send information to the external accounting system. Template selections will populate the columns of the database or the flat file.
If you plan to import directly to a table, make certain that the number of columns in the following are equal:
- Template
- Number of Header lines
- Number of Line Item lines
For example, if you have 2 columns, your Header columns must equal 2. Note that you can omit Header columns to avoid confusion since these are not imported. There is only one Header per document if the Header Row is defined.
The Position column is calculated or recalculated depending on the number added in the length field.
Important: Code and Ledger Group can be included in a Header (given a value of H) or line items (given a value of L). You will probably opt to use one or other. The Code is required.
When you set up your Template, one of the available column types is Constant. If you include Constant, WebTMA will export any values that are in the Default column on the template. See Appendix A at the end of this document for definitions of all options.
The System Date column type includes both date and time. If you select System Date as one of your columns, WebTMA uses the following hierarchy to determine the time zone value:
- User record
- Admin > Client Info / Preferences
- UTC (Universal Time Code)
If you insert an asterisk (*) at the beginning of the Value column, the output will be capitalized. When the Batch Job Service runs, WebTMA checks to see if the first character of the Value column contains an asterisk. If an asterisk is the first character, the asterisk is removed and the output is capitalized. For example, if the date format is dd-MMM-yyyy, the output will be 12-DEC-2015 instead of the standard output of 12-Dec-2015.
The asterisk can be used in any column, but if the value contains numbers only, no visual difference displays.
If your setup includes Debit/Credit, UFI checks the Value field for a vertical bar | character. If the Value field column contains a vertical bar | in the Debit / Credit row, then UFI interprets everything before the bar as the flag for Debits and everything after the bar as the flag for Credits. For example, a value of DE|CR would flag the debits as DE while the credits would be flagged as CR.
When you select Trans Amount in your setup, it supports an Absolute Value function. To enable the Absolute Value, the Value column of the Trans Amount row needs to contain a minus ( - ) character. When UFI exports data using this feature, any negative numbers return the Absolute Value and the Debit/Credit flag is switched. For example, a Debit of -1200.00 becomes a Credit of 1200.00.
When you select a date column, be sure to edit the entry and define the date format using the format that is accepted by your accounting package. For example, PeopleSoft accepts mmddyyyy; however, the default in WebTMA is dd-mm-yyyy. WebTMA uses Microsoft .NET standards for all date formatting. Use the list found in Appendix B at the end of the document to edit your format according to your needs. Note that the .NET formatting is case sensitive.
How to Set Up a UFI Template
Path: Universal Financial > UFI Template Setup
This window is used to determine the position and characteristics of columns for identified templates.
The following instructions apply to the Header or Line Items Subtab. Remember to set up entries on both Subtabs. Reminder: For Date columns, be sure to edit the selection.
- Click Add on the WebTMA Toolbar.
- Enter the Code - up to 10 alphanumeric characters to identify the Template.
- (Optional) Enter the Ledger Group - up to 10 alphanumeric characters to assign a name associated with this Template.
- Click the Add Column link to open the Column Entry popup window. The selections on the Column Entry window derive from segments you have created previously.
- Check the columns desired.
- Click the Add Selected button before closing the popup.
- Click the Edit (pencil) icon for each line item to change or add values.
- Click Save on the WebTMA toolbar.
NOTE: If you include Constant, WebTMA exports any values that are in the Default column on the template.
UFI Template Format Options
Path: Accounting > Universal Financial > UFI Template Setup
The character entered in the Value column depends on your organization's financial policies. Once you determine the policy, add the appropriate indicator to the Value column for each line item in the UFI Template Setup window.
WebTMA only supports the following indicators:
D
C
+
-
If you choose the minus (-) indicator, the symbol is only used if the line is a credit. If the line is a debit, no indicator is given.
On the other hand, if the plus (+) indicator is selected, a minus (-) indicator shows if the line is a credit and a plus (+) shows if the line is a debit.
To remove a decimal point from numeric values, set the value of the column in the UFI Template Setup to 0D (that is, a numeric zero and alpha D). This only applies to numeric columns, i.e., Data Type = N. For example, with a 0D setting, a value of 14.23 becomes 1423.
To truncate a character string from right to left, set the value of the UFI Template Setup column to RL. This only applies to columns that contain strings, i.e., Data Type = C. As an example, transaction number PP 20130001235415 with a length of 8 would have a truncated value of PP-20130; however, if you apply RL to the string, the value is 01235415.