For users with the default entity code of 0, the Journal Import Templates program automatically sets the default entity code on the journals to 1. This allows the records to be processed successfully. The Journal Import Templates program provides the following stock import formats, which cannot be modified from their original layouts: Budget Import Format Budget Long Account Import Format Standard Excel Import Format Standard Import Format Standard Long Account Import Format Procedures Creating a Template The Journal Import Templates program can create new import templates. You can create a new template for one-time use, or for repeated import processes using a standard import file. The template creation process allows you to use any file to produce data usable by the Munis system. To create an import template: On the ribbon, click Open, and then navigate to the file for which to create the import. The program refreshes the page to display the file name in the File box. Click Create on the ribbon or Create Template next to the Template box. The program displays the Import Template Editor screen. Select a column name from the column list. Click the color box to select a highlight color for the column data. This color does not appear on the import file. It only indicates the data that is included in the column when the import is performed. Click Add Column. Manually enter the starting and ending positions for the column, or use the slider bar to define the start and end positions. Some columns have a predefined value for the start and end positions, or have a maximum or minimum length. If you enter or select a position or size that is incompatible with the column, the program displays an error message. Continue to add columns to the template. Remove a column by clicking the red X next to the column name. Preview to view an example of the imported data arranged by column. When you have finished entering columns, click Save Template. The program ensures that you have completed all of the required columns for the template. If you have not created all of the required columns, the program displays a warning message that indicates which columns are required and missing. Create any missing columns, and then Save Template. When all of the required columns exist, the program displays the Save Import Template dialog box, where you can enter a name for the template. Enter a name and click Save. The program displays the main program screen with the newly created template name in the
Template box. You can then use the template to perform an import. Note: If you use an Excel (.xlsx) file as the template source, the program provides the Excel Template Editor for creating the template. In this case, expand the header field for each column to select a name. The program assigns the name and automatically highlights each column with a unique color. You cannot assign the same column heading more than one time, and you must create a column for each required field. Modifying a Template To modify a template: Open, and then navigate to the file for which to update the template. From the Template list, select the template to update. Click Update on the ribbon or Update Template next to the Template box. The program displays the Import Template Editor pane with the template and file data loaded. Select a column to update from the Columns list. Update the highlight color and column positions, and then click Save Column. The program updates the template with the new values. In to add a new column to the template, select the column name, color, and positions using the fields. Add Column. The program adds the new column to the template. Remove a column from the template by clicking the red X next to the column name in the Columns list. The program refreshes the display to remove the column. When you have finished making changes to the template, click Save Template. The program saves your entries and displays the Save Import Template dialog box. Update the name of the column, if necessary, and then Save. The program displays the main screen. Completing an Import In addition to the creation of templates, the Journal Import Templates program performs the import process for journal entries. To import journal entries: On the ribbon, click Open and then navigate to the import file. From the Template list, select the template to use for the import. Click Next. The program refreshes the screen to display the Journal Information group. Complete the fields on the screen, selecting Now from the Execution Time list. Click the More button to display additional fields for completion.