Ledger Report (GL Journal)

This report is a date-wise journal of all transactions for the selected period, that meet the specified criteria.

While the Transaction Date range is mandatory, you can use the rest of the filters to look for the exact entries you need. The following filters are available for this report:

Single entity filters

1. Accounting transaction ID
2. GL account
3. Party ID
4. Invoice ID
5. Payment ID
6. Product ID
7. Fixed Asset ID
8. Shipment ID
   

Wildcard filters

1. Transaction type – this covers all types of transactions in CREST ERP, such as Sales, Credit Memo, Purchase, Payment, Depreciation etc.
2. Fiscal GL type – at this time, only ‘Actual’ GL is supported
3. Line description – this is a text search, allowing you to search by any keyword in the transaction line description
4. Status: Posted or Non-posted. However, the report will not show posting status per se
   

*You can choose a max of three months’ range for the report

You can export the report to PDF or Excel formats. The report columns are not sortable.