Exports

Exported details contain each journal entry record.

The FSL Journal Entry Details - Open Period report includes related records, including the account, opportunity, payment and allocation.

To aggregate the open period by GL account:

SELECT ssfs__GL_Code__c GL_Code, ssfs__GL_Account_Name__c GL_Name,
       SUM(ssfs__Debit__c) Debit, SUM(ssfs__Credit__c) Credit
  FROM ssfs__Journal_Entry__c
 WHERE ssfs__Accounting_Period__r.ssfs__Status__c = 'Open'
 GROUP BY ssfs__GL_Code__c, ssfs__GL_Account_Name__c

Aggregates for an accounting period, ready to be imported into the general ledger.