Back to

Journal Entry for Connect

Customizing templates

Default templates

Journal Entry provides several default templates, organized under headings of General Ledger, Accounts Payable, Accounts Receivable, or Accrual/Deferral. Depending on the type of template that you selected, you can further customize the templates for Simple post, Multiple Company post, or COPA post and, depending on the template, by t-code.

Create a template

  1. Select one of the default templates under the headings General Ledger, Accounts Payable, Accounts Receivable, or Accrual/Deferral.
  2. Depending on the type of template selected, select Simple Post, Multiple Company Post, or COPA Post.
  3. Depending on the type of template, select the desired t-code.
  4. Select the sheet to write to or use the default sheet.
  5. Under Mapping, choose Cell Based or Column Based.
  6. Click Load Default Template.

    Tip: If you later want to customize the template, click Re-Customize Template on the ribbon.

Customizing templates

Whether you are creating a sheet from a default template or creating an original template, the Journal Entry customization capabilities give you control over the mapping and naming of cells (similar to the functionality in Transaction) and over the layout of objects in the workbook.

Customize a template: overview

  1. With a new or existing workbook open, click Customize New Template or Re-Customize Template.
  2. If you are using a new workbook, do the following:
    1. Select the type of process you want, the mode, and the t-code.
    2. Specify which sheet the template should be saved to.
    3. Under Mapping, choose Cell Based or Column Based.
    4. Click Customize New Template.
  3. On each page of the Customize pane, specify fields, mapping, values, loop information, or document splits, as described in the sections that follow this procedure.

    For debit and credit indicators, use the default "S" and "H" or click the List of Values button and type in the labels you want.

    Note: You can add tax information on the Basic tab or the Tax tab. However, fields on the tax tab cannot be included in a loop.

  4. Click Publish.
  5. Save the document, and then enter some test data in the finished document. Validate and simulate to ensure that the template behaves correctly.

Customize the fields

Select and map the fields for the header and the log fields, add any lists of values that you want people to use. If you want to use the same value for a field every time, change it to Fixed. See the sections below for more details.

Then click Next, and select and map the fields for the line items, add LOVs and set any values that need to be fixed.

Selecting fields

After you select the mode, t-code, sheet, and mapping and click Customize New Template, check the Selection box for each field that you want people to use.

If a field must contain data, check both Selection box and the Required Field box.

Mapping fields manually or automatically

To map fields, you need to assign a column or cell to the headers on the first page of the Customization pane and the line-item fields on the second page of the Customization pane.

Tip: Take note of the row or column where your header and log fields end so that you can avoid overlapping when you map the line items.

Map fields manually

To manually map headers, enter a cell name or column name in the Mapping column.

JE manual cell map

Map fields automatically

To automatically map headers (if you have many cells to map), check the Auto map settings box, choose the settings that you want, and then click the AutoMap button JE Automap.

Auto map settings:

Creating a list of values

You can assign a list of values (LOV) to a cell by selecting to display entire SAP windows, include a text file, include an Excel file, or to include select SAP fields from an F4 lookup. Where a list of values appears, the value selected by the user during data entry is validated when the sheet is validated.

JE LOVs Import

Add a list of SAP values
  1. In the header or item mapper, click the LOV button next to a field JE list of values select icon.
  2. Click SAP.
  3. Enter your SAP credentials in the SAP logon dialog box. Click OK.
  4. In the List of Values dialog box, click OK.
Create a custom LOV from a text or Excel file
  1. In the header or item mapper, click the LOV button next to a field JE list of values select icon.
  2. Click Customize.
  3. Do one of the following:
    1. Click Text file. Browse to a local file.
    2. Set the delimiter for separating text. Click OK.

-or-

  1. Click Excel file.
  2. Browse to a local file.
  3. Specify the sheet to write to and the Excel cell range. Click OK.
Create a custom LOV from an SAP F4 lookup
  1. In the header or item mapper, click the LOV button next to a field JE list of values select icon.
  2. Click Customize.
  3. Click SAP F4, and then click Import.
  4. If you are not already logged on, enter your SAP credentials.
  5. In the SAP list, select the items you want to add to your list. Click the green check mark.

    Although SAP descriptions are not loaded, you can customize your own descriptions. In addition, you can limit the values available. Click Delete to remove a value from the list.

    JE LOV

  6. When finished, click OK.

Creating run-time and fixed values

For all header and line item fields, you can create a run-time value.

If you choose Runtime for a field, you can either give LOV values for that field or you can leave as it is. However, if you give the LOV values for that field, the runner will have to choose a value from the LOVs that you specified unless and until you select the Allow user to override Custom List of Values check box, which allows the runner to override the LOVs and enter a value that is not in the existing LOVs.

Create a fixed value for a header or line item field

For all header and line item fields, you can create a fixed value—that is, a permanent value that cannot be changed. The runner will not be able to edit this value during execution.

Note: When you finish creating fixed values for headers or line item fields, the Data Review pane will show only the fields that are marked as Runtime. Fixed items will not appear in this list.

  1. In the Customize pane, locate the header item to which you want to assign a fixed value.
  2. In the Selection Type list for the item, click Fixed.

    The Fixed value for dialog box appears.

  3. In the Fixed value for dialog box, enter the value.

    Tip: If you need to find the value you want to use, click SAP F4, log on to SAP if necessary, click the value that you want to use, and then click the green check mark.

  4. Click OK.

    You will notice that the row containing the field name and description is now blue and that the cell in the Mapping column is now gray. This is because fixed values are not mapped to a particular cell in Excel.

    Note: To change a current fixed value, click the red pin in the List of Values column, enter the new value, and click OK.

Add loop information

After you map the line-item fields, click Next.

Note: If Journal Entry prompts you that line items will overlap with existing log and out cells, do one of the following: increase the Start Row, uncheck the Write headers for Journal Entry Header Items box, or change the mapping for header items or logs.

Enter the loop information:

Defining a custom document length

Template authors can define a custom length of between 0 and 998 line items for a document. If a runner tries to post a document that exceeds the maximum item length, a message prompts the runner to split the document. Document chunks from a split cannot be longer than the maximum length for that template.

Uploading large documents: Split document

For large uploads, instead of using multiple workbooks, you can split your document.

Important: Journal Entry cannot split a column-based document that contains multiple loops at the same level.

You need to know the name or number of an SAP reconciliation or offset account so that all the documents that result from a split can be balanced.

  1. Create and name an offset account. Ensure that you add a user-friendly description so that users of the template understand why extra lines appear.
  2. In the No. of rows box, specify how many rows should be processed before a document is split. A common length for a document is 999 lines.
  3. Click Publish.
  4. When data is entered and validated, click Split document. Blank rows will appear at the specified interval. When you post, the entries are split into multiple SAP documents where the blank rows appear.
  5. Select the Split Document check box.
  6. In the No. of rows box, specify how many rows should be processed before a document is split (maximum is 997 lines). If you're not sure how many rows you'd like to enter, you can adjust the split settings later.
  7. Click Publish.
  8. When ready, click the Winshuttle for Journal Entry tab and then click Post.

Also in this section

Uploading data with Journal Entry for Connect

Journal Entry templates from BAPI recordings