You are here: Customizing solutions > Publish a solution

Publish a solution

When you finish customizing the template, publish it to an Excel worksheet so that runners can use it to upload data.

  1. First, ensure that you have specified the following:
    • Action (Park, Post, Save as Completed)
    • Allow validate, Allow simulate
    • Posting date field
    • Document value
    • Debit/credit indicator field (not required for BAPI-based solutions)

    If you want runners to use validate and simulate before they upload the data, ensure that the Allow Validate and Allow Simulate boxes are checked.

  2. To replace any existing headers with the solution headers, check the Write header item headers box or the Write line item headers box under Template properties in the Script Properties panel. Or check both boxes to overwrite all headers.
  3. Save the solution.
  4. On the Run tab, click Publish Solution.

    If any of the options listed above have not been set, Journal Entry Management opens the Configure JEM Solution wizard on the tab where you need to set the option.

  5. In the Publish in Excel box, specify the workbook and sheet.

    Important: A sheet can contain only one published solution. If a solution has already been published to the specified sheet, Journal Entry Management will ask you to confirm that you want to overwrite the existing sheet.

  6. If the properties are set to overwrite header or line item headers but you do not want to overwrite them on the specified sheet, uncheck the Overwrite data file headers box.
  7. Click Publish.

When publication is successful, you have the option of opening the solution in the Excel sheet.