Web Help

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

Back to Journal Entry for Central

Customizing templates

Central permissions, policies, and roles

To author templates in Journal Entry, you must have the Transaction Developer role in Central.

Default templates

Winshuttle 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.

In Journal Entry for Winshuttle Central, you must store the template in Central. For more information on configuring Central, see the Winshuttle Central Admin Guide.

Journal Entry adds efficiency by allowing multiple templates or data sheets to be added to one workbook. The entire workbook is submitted to Central, which triggers one workflow for all templates.

Create a template

1. Open a new workbook in Excel or select an existing workbook to upload. Click the Journal Entry tab.
2. Click Logon to Central and enter your credentials.
3. Select the Developer role.
4. Click Create New Template, and then select one of the default templates under the headings General Entry, Accounts Payable, Accounts Receivable, or Accrual/Deferral.
5. Depending on the type of template selected, select Simple Post, Multiple Company Post, or COPA Post.
6. Select the desired t-code from those available for the selected template.
7. Select to write to the default sheet or select a specific sheet write to.
8. Under Mapping, choose Cell Based or Column Based.

   Note: Column mapping is not supported for BAPIs.

9. Click Load Default Template.
10. If you want to, add headers and data to the template.
11. Name and save the template.
12. You can add different templates to the same book, but each must be written to a different sheet.
    1. To add multiple templates, select the template.
    2. Specify the sheet.
    3. Validate and simulate each sheet before you submit the workbook to Winshuttle Central for approval.
13. Click Submit to Central.
14. When prompted, add supporting documents, if desired.

    You are notified that your template and any supporting documents have been submitted to the Central site.

Customizing templates

Whether you are creating a sheet from a 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

1. Click Logon to Central and enter your credentials.
2. Click Create New Template, and then click Customize.
3. Select the business process, the post mode, and the t-code. Specify which sheet the template should be saved to.
4. Under Mapping, choose Cell Based or Column Based.
5. Click Customize New Template.
6. On each page of the Customize pane, specify fields to include, header and cell mapping, lists of values, or document splits, as described in the Selecting fields and Mapping cells sections that follow this procedure.
7. To set a custom limit on line items for each document, in the Document Length box, enter a value between 0 and 998.
8. For debit and credit indicators, use the default "S" and "H" or type in the label of your choice.
9. Save the document. Click Publish.
10. Enter some test data in the finished document. Validate and simulate to ensure that the template behaves correctly.
11. Submit the document to Central.

Journal Entry templates from BAPI recordings

In Journal Entry, you can customize a template from the default BAPI by clicking the Customize button. The default BAPI covers document post and is available in single post or multicompany post modes.

By using the Add More Fields button in the Customization wizard, you can include headers and line items that were not included when the BAPI script, the .txr file, was created. You can search for fields, and map fields as for any other template in Journal Entry.

By default, the field return-message v2 is included among the journal line items to display the document number after post. When the sheet is posted, the field return-message v2 also returns the document number, company code and fiscal year to the post results cell and provides the document number link.

Journal Entry templates from BAPIs also may requiring splitting to simulate because BAPI processes simulations by chunks. The chunk size is specified through the split document settings that you added when you created the template. If the data exceeds the chunk size, the user is asked to split the document.

When adding data to a Journal Entry sheet, the amount must be entered as a plus or a minus because no debit or credit indicators are available. For example, a debit of $50 would be entered as "-50".

Only "Post" is available for the current implementation of BAPI in Journal Entry. "Park" is not available.

After the document number is returned, you can attach documents as for other templates in Journal Entry.

Selecting fields

• Selection: Select the fields you want to include and exclude the fields that users should not see.
  .
• Is Mandatory: Select if a field must be completed by template users.

Mapping cells

To map cells, you must map the headers on the first page of the Customization pane to the data cells on the second page of the Customization pane. There are two ways to do this:

• To manually map headers, enter a cell name next to the field name.
  .
• To automatically map field headers (If you have many cells to map), click Auto map settings and then click the AutoMap button.

  To automatically map log and output cell headers, click Log Cells and then click the AutoMap button.

  • Arrange header items vertically or horizontally .
  • Set the Excel start column and row.
  • Select to write headers to headers or items.
  • Map the log and output cells.
  • If blank lines cells are needed, select the line above where you want the blank line and click the Add Line 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-

   3. Click Excel file.
   4. Browse to a local file.
   5. 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.

Creating run-time and fixed values

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

To create a run-time value for a header or line item field

1. In the Customize pane, locate the header item to which you want to assign a runtime.
2. In the Selection Type list for that item, click Runtime.
3. Adjust any of the automap settings including column and start row and click AutoMap.
4. Click Next.
5. Create run-time values for your desired line items.
6. 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.

7. From this Data Review pane, you can choose to split the document. If you are not splitting the document, click Publish.

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.

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. Click OK.

   You will notice that the row containing the field name and description is now blue and that the cell in the Mapped to cell 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 arrow in the List of Values column, enter the new value, and click OK.

4. Adjust any of the automap settings including column and start row and click AutoMap.
5. Click Next.
6. Create fixed values for your desired line items.
7. 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.

8. From this data review pane, you can choose to split the document. If you are not splitting the document, click Publish.

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.

Splitting documents

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

Document splitting settings

When you finish creating fixed values for headers or line item fields, you will see a data review pane which includes all fields that were marked as "Runtime." Fixed items will not appear in this list.

1. Select the Split Document check box.
2. At this point, you have several customization options:
   • You can assign runtime or fixed values to each of the header or line item fields. See Creating Runtime and Fixed Values, above.
   • 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.

     Note: 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. This is because, at the time of execution, the runner can override the LOVs and enter a value that does not exist in the existing LOVs.

3. 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.
4. Click Publish.
5. When ready, click the Winshuttle for Journal Entry tab and then click Post.

Uploading large documents: Split document

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.

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 will be split into multiple SAP documents where the blank rows appear.

Also in this section Uploading data with Journal Entry

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