Is There a Way to Pull All Manual GL Entries Out of Elliott?
Elliott has no predefined report to do this. We suggest you use the Export Processor as follows:
- On the first tab labeled Category, choose "GL Transaction file";
- On the 2nd tab labeled Selection, choose GL_TRX_SOURCE between (BT) GJ0000 to GJ9999, GL_TRX_DATE Between (BT) YYYYMMDD YYYYMMDD (i.e., 20140101 ~ 20140630, which means 01/01/14 - 06/30/14). This is the internal date format as stored in Elliott and you must use this format to retrieve your records in the specified date range;
- On the 3rd tab labeled Process, click "Get Records" button;
- On the 5th tab labeled Export, select the columns you wish to see.
Refer to the screens below as your examples. You may want to save the configuration you used in the Export Processor for future use.
Related Articles
Using the Export Processor to Export Data
Q: It has been a while since we used the Export Processor to Export Data from Elliott. I remember how to select the category and choose the search data, but I can't remember how to select all the fields that need to be processed for export. Can you ...How Do I Give Someone Access to Export Processor?
Q - How do I give someone access to Export Processor? A - There are two levels to this question: How to give a user access to Export Processor; How to give a user access to each specific "Group of Records" in Export Processor. How to Give a User ...Feature - Equal Sign Support in Export Processor
Release Date - 1/5/18 When exporting Elliott's alphanumeric fields to CSV through the Export Processor, the leading zeroes will be dropped when the file is opened with Excel. For example, when opening the CSV in Excel, item number 0100 is displayed ...Export Processor Limitation on Processing Large Amount of Records
Release Date: 5/13/2021 Version: 8.0 & Up Q - I exported all invoice header records from our production company using Export Processor. No filters were used. As you can imagine, this took a long time. No errors were encountered while it was ...How to Find a Record that Does Not Have a Certain Attribute in Export Processor
Release Date: 03/21/2024 Version: 8.0 & Up Q - Just so we're sure of ourselves over here, there is still no way to use Export Processor to find records where an attribute is NOT attached to the record, correct? We're needing to filter this way often ...