MS Excel ERP Template (ntexl0110s100)

Use this session to view the properties of a LN-related Microsoft Excel template.

If your template is published, click Sessions to start the ERP Template - Published in Sessions (ntwrd0130m000) session, in which you can view or maintain the list of sessions your template is available in.

Field Information

Template Name

Specifies the name of the template.

Local Path

Specifies the local path where you created the template.

Description

Specifies the template's description. The description appears in the File menu's Send To submenu of the ERP sessions in which you publish the template. The description also appears in Microsoft Excel's New ERP Workbook dialog box.

User Can Select Records In

Specifies from which applications end users can select records for workbooks that use the template.

Allowed Values:

  • LN Sessions Only.
  • Microsoft Excel Only.
  • Both LN sessions and in Microsoft Excel.
Create a new document for each record

When an end user selects multiple records in ERP to send to an Excel workbook based on the template:

  • If this check box is selected, Excel creates a new workbook for every record.
  • If this check box is cleared, Excel creates one new workbook that contains all the records.

Template is published

If this check box is selected, the template is published. Click Sessions to start the ERP Template - Published in Sessions (ntwrd0130m000) session, in which you can view the list of sessions the template is available in.