Help Center>Journal Entry Solution Help

Import custom scripts into Journal Entry

In addition to the default templates that are included with Winshuttle Journal Entry, you can create custom templates based on Winshuttle Transaction scripts and BAPIs.

Important: Nested loops are not supported in Journal Entry.

Tips for importing Transaction scripts

  • Test the Transaction script thoroughly before you import it into Journal Entry.
  • If you need to add, delete, or change a field, make the update first in Transaction and test it.
  • If you are updating an existing script, first delete the old script in Journal Entry and then import the updated script from Transaction.
  • If the script was recorded in Studio v11, first save the script as a Transaction v8.3 - v10.x file. (Open the script in Studio v11, click File, click Save, and then click Transaction v8.3 - v10.x in the Version list.)
  • Do not map multiple fields to the same cell or column in Transaction (for example, posting date and document date). Journal Entry requires a separate cell or column for each field.
  • Use the same mapping for a field in Journal Entry and Transaction.

Add a custom Journal Entry script

  1. In Journal Entry, on the Options menu, click Add Custom Script.

  2. In the Select Business Process list, choose General Ledger, Accounts Payable, Accounts Receivable, Accrual/Deferral, or BAPI.
  3. In the Select Mode drop-down menu, choose Simple Post, COPA Post (for General Ledger), or Multi Company Post.
  4. Browse to select a Transaction or BAPI script file.
  5. Specify the t-code name and description.

    Tip: Choose a description that will help you identify this script.

  6. Under Actions possible, specify how Runners complete a data file:
    • Park
    • Post
    • Save as Completed
    • Park and Post
    • Post and Save as Completed

    Note: You can select more than one action (Park and Post or Post and Save As Completed), but you cannot select Park and Save As Completed, because these are both parking functions.

  7. Click Next.
  8. Select the header field for the Posting Date.
  9. For any fields that are required, check the box in the SAP Mandatory column.

    Note: You can also use the Required Field check box that appears in the template customization settings.

  10. If there is an amount in the header, check the box in the Document Value Field column, and then specify whether the amount is a credit or a debit.

  11. Click Next.
  12. Mark any fields that are in a loop as mandatory.
  13. Select the check boxes for the Document Value Field and Is Debit/Credit Indicator.
  14. Specify the Default Debit Indicator and the Default Credit Indicator (depending on the transaction or recording method, this could be S/H or 40/50).

  15. If you are importing an FB60, FB65, FB70, or FB75 script that was recorded using the complex posting method (all amounts are contained within the loop, including the header amount), check the First line item contains an amount from the Header box. This is critical if you are going to use the Split Document feature with these transaction codes.

    Important: The check box will not be displayed if you marked an amount in the header.

  16. Click Finish.
  17. An information pop-up window confirms that the script was added. Click OK.
  18. Click Customize New Template and select the Business Process and Mode that you specified when you imported the script. The most recent imported script will be at the bottom of your list, and you can check the template description to make sure that it’s the one you want. Click the script, and then click the Customize New Template button.
  19. On the next screen you can make any changes to the header mapping.
    • Remove fields by unchecking the Selection check box.
    • Mark or unmark required fields using the Required Field check box.
    • Select Header Items or Log Cells, specify the column and start row, and click AutoMap to remap these fields as a group.

    Example: Header Items could be remapped from B2-B8 to C2-C8 using this feature:

    Note: If you want the field descriptions to be written for your template, keep the Write headers box checked.

  20. When the mapping is the way that you want it, click Next. On the next screen you can make changes to the loop fields:
    • Remove fields by unchecking the Selection check box.
    • Mark or unmark required fields using the Required Fields check box.
    • Select the Auto map checkbox, and provide a Starting Column and Start Row to remap all of the line items, and then click AutoMap.

    You can also change the column for a single field by double-clicking in the Mapping cell.

  21. When the mapping is the way that you want it, click Next.
  22. The next screen shows a preview of your loop and the fields within it. Make sure that the Start Row on the previous screen and the Start Row for the loop are the same, and then click Next.

  23. On the next screen, you can set the following options:
    • Auto Attach Workbook setting: Check this box to automatically attach the Journal Entry workbook to the document in SAP.
    • Split Document settings and split field selections: Consider using this feature if you are going to have documents that exceed 998 lines.

  24. Click Publish.
  25. An information popup asks you to confirm that you want to write the template to the workbook.
    • If you click Yes, the Header and Loop details will be written in the Excel file.
    • If you click No, the template will be added to the workbook, but no fields will be written in Excel. Use this option if your worksheet contains formatting that you want to keep.

  26. Save your template before use.