Web Help

Introduction to Winshuttle Journal Entry > Journal Entry for Connect > Customizing templates

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.

   Notes:
   If your template is column-based, add the Company Code on the last screen before you click Publish. You can select the column that is mapped to the Company Code, or you can type a fixed value.
   
   In Journal Entry 9.1, you can choose to show the field's technical name instead of its description. Check the Show Technical Name box.

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.

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 .

Auto map settings:

• Arrange header items vertically or horizontally (this option is available for cell-based mapping only).

  

• Set the Excel start column and row for the header, log, and line items.
• Select to write headers for header items.
• If blank lines of cells are needed, select the line above where you want the blank line and click the Add Blank Cell button .
• If you want, assign a list of values to a field. Click the List of Values button .

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.

Add a list of SAP values

1. In the header or item Mapper, click the LOV button next to a field .
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 .
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 .
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.

   

6. When finished, click OK.

If you later want to change the LOV, click the LOV button in the Mapper to open the list.

Create a list of custom posting keys

1. Click Re-Customize.
2. Click the List of Values button for the Posting Key field.
3. In the Debit row of the Custom Debit Credit Indicators box, click the Custom Values field, and do one of the following:
   • Type the value or values, separated by commas.
   • Click the List of Values button, check the boxes next to the values that you want to use for debit line items, and then click the Continue button.
4. Repeat for the Credit row of the Custom Debit Credit Indicators box.
5. To upload the custom values, check the Preserve Excel Posting Key Values box.

   If you do not check the box, SAP will convert the custom values to the default values that are listed in the Custom Debit Credit Indicators box.

   Note: In version 9.2, the Preserve Excel Posting Key Values box is checked by default.

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.

• You can create a custom list of values for any of the line items listed. Click the List of Values icon next to the desired line item, select Customize, and enter the desired values in the Value List.
• You can allow a user to override the Custom List of Values. Click the List of Values icon next to the desired line item, select Customize, select the Allow user to override Custom List of Values check box, and enter the desired values in the Value List.

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:

• If you are using cell-based mapping, type the Start Row and End Row of the line-item fields.
• If you are using column-based mapping, you also specify an ID column and Header and Line identifiers (for example, H and D) that you will use to indicate whether a row is header data or line-item data.

Split documents

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

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.

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

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

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 System requirements for Connect Working with Journal Entry Working with protected sheets Uploading data with Journal Entry for Connect Journal Entry templates from BAPI recordings

• Trademarks
• Winshuttle.com
• Back to top
        
• 
• 
• 
•