Retrieve Journal Transactions

Retrieves a list of journal transactions (grouped journal entries). Each transaction contains multiple debit and credit entries.

Command Name

RetrieveJournalTransactionsQuery

Endpoint

POST /api/core/cmd

Request Parameters

Parameter	Type	Required	Description
startDate	datetime	No	Start date for filtering
endDate	datetime	No	End date for filtering
searchText	string	No	Search by transaction ID or username
pageNumber	integer	No	Page number (default: 1)
pageSize	integer	No	Items per page (default: 20)
isExport	boolean	No	Export all results (default: false)

Request Example

{
  "Cmd": "RetrieveJournalTransactionsQuery",
  "Data": {
    "startDate": "2024-01-01",
    "endDate": "2024-01-31",
    "searchText": "admin",
    "pageNumber": 1,
    "pageSize": 20
  }
}

Response Structure

{
  "IsSuccessful": true,
  "StatusCode": "00",
  "Message": "Journal transactions retrieved successfully.",
  "Data": {
    "items": [
      {
        "Id": 789,
        "TransactionId": "JT/2024/000789",
        "TransactionDate": "2024-01-15 10:30:00",
        "BookingDate": "2024-01-15T10:30:00",
        "TransactionType": 1,
        "TransactionTypeDesc": "Manual Journal Entry",
        "Amount": 50000.00,
        "Entries": 4,
        "UserName": "admin@banklingo.com",
        "UserEncodedKey": "8a8e8e8e8e8e8e8e",
        "IsManualPosting": true,
        "IsReversed": false,
        "IsAReversedTransaction": false,
        "Remarks": "Monthly salary entries"
      }
    ],
    "totalRows": 25,
    "totalPages": 2,
    "pageSize": 20,
    "currentPage": 1
  },
  "HasNext": true,
  "HasPrevious": false
}

Response Fields

Field	Type	Description
Id	long	Unique transaction ID
TransactionId	string	Human-readable transaction reference
TransactionDate	string	Formatted transaction date
BookingDate	datetime	Raw booking date
TransactionType	integer	Transaction type enum
TransactionTypeDesc	string	Description of transaction type
Amount	decimal	Total debit amount
Entries	integer	Number of journal entries in this transaction
UserName	string	User who created the transaction
UserEncodedKey	string	Encoded key of the user
IsManualPosting	boolean	True if manually posted
IsReversed	boolean	True if this transaction has been reversed
IsAReversedTransaction	boolean	True if this is a reversal of another transaction
Remarks	string	Transaction remarks