Get JEDetails

Use this command to retrieve journal entry details information to a file or an object list. You can retrieve specific journal entry details by using a JEQuerySpec document to filter the results retrieved.

Note: Whether you choose to use a JEQuerySpec document or not, only journal entry details that you have access to are retrieved. Therefore, only the details for shared journal entries and journal entries which you have created, will be retrieved.

Get JEDETAILS TO FileName1|ObjectListName1 FileName2|ObjectListName2 [USING JEQuerySpecName]             

where:

• FileName1 is the name for the created ASCII file, containing the journal entry details data for base dimensions in comma delimited format. It can include a complete or partial folder path in the format C:\...\FileName1. If FileName1 includes spaces, enclose it in double quotation marks; for example:

  @"C:\My Documents\JEDetails.csv"

• FileName2 is the name for the created ASCII file, containing the journal entry details data for schedule dimensions in comma delimited format. It can include a complete or partial folder path in the format C:\...\FileName2. If FileName2 includes spaces, enclose it in double quotation marks; for example:

  @"C:\My Documents\JESchedDetails.csv"

• ObjectListName1 is the name of the object list variable, containing the journal entry details data.
• ObjectListName2 is the name of the object list variable, containing the journal entry detailsdata for schedule dimensions .
• JEQuerySpecName is the name of the JEQuerySpec document to filter the result. This parameter is optional. If you do not specify a JEQuerySpecName, all journal entry headers, that you have access to, will be retrieved.

Get JEDETAILS TO JEDetails.csv JESchedDetails.csv USING MyJEQuerySpec.lvqje        

Sample output file to csv