There is often some confusion over the two endpoints /GeneralLedger/JournalTransaction and /GeneralLedger/GeneralJournal and what data is pulled via these endpoints.
/GeneralLedger/GeneralJournal: A Journal entry is a double-entry transaction system. Journal entries are transactions you can use to track business activity that you wouldn't want to track with other kinds of transactions, such as deposits or payments. This will show the debit and credit of the transaction.
From the UI these transactions would be entered into the following location:
AccountRight:
1. Accounts
2. Record a journal Entry
Get Request to the API endpoint: /GeneralLedger/GeneralJournal:
{
"UID": "f634941b-f4aa-4fb8-96ed-1a372076bb61",
"DisplayID": "GJ000001",
"DateOccurred": "2021-02-22T10:23:53.403",
"IsTaxInclusive": false,
"Memo": "",
"GSTReportingMethod": "Purchase",
"IsYearEndAdjustment": false,
"Category": null,
"Lines": [
{
"RowID": 541,
"Account": {
"UID": "19a1c319-973b-4728-b247-a38a435f2840",
"Name": "General Cheque Account 1",
"DisplayID": "1-1110",
"URI": "https://arl2.api.myob.com/accountright/dcc6be7f-6e9e-4c5e-b14d-470e702606fc/GeneralLedger/Account/19a1c319-973b-4728-b247-a38a435f2840"
},
"Job": null,
"Memo": "",
"TaxCode": {
"UID": "62324ffa-0dd0-4429-bdb0-623289f1216d",
"Code": "GST",
"URI": "https://arl2.api.myob.com/accountright/dcc6be7f-6e9e-4c5e-b14d-470e702606fc/GeneralLedger/TaxCode/62324ffa-0dd0-4429-bdb0-623289f1216d"
},
"Amount": 90.910000,
"AmountForeign": null,
"IsCredit": false,
"TaxAmount": 9.090000,
"TaxAmountForeign": null,
"IsOverriddenTaxAmount": false,
"UnitCount": null,
"RowVersion": "-8617637886973444096"
},
{
"RowID": 542,
"Account": {
"UID": "2738fb27-4b83-4733-b28c-20570c2fe391",
"Name": "American Express",
"DisplayID": "2-1110",
"URI": "https://arl2.api.myob.com/accountright/dcc6be7f-6e9e-4c5e-b14d-470e702606fc/GeneralLedger/Account/2738fb27-4b83-4733-b28c-20570c2fe391"
},
"Job": null,
"Memo": "",
"TaxCode": {
"UID": "db47ef71-1549-4f22-b21d-c1ff26f4c516",
"Code": "N-T",
"URI": "https://arl2.api.myob.com/accountright/dcc6be7f-6e9e-4c5e-b14d-470e702606fc/GeneralLedger/TaxCode/db47ef71-1549-4f22-b21d-c1ff26f4c516"
},
"Amount": 100.000000,
"AmountForeign": null,
"IsCredit": true,
"TaxAmount": 0.000000,
"TaxAmountForeign": null,
"IsOverriddenTaxAmount": false,
"UnitCount": null,
"RowVersion": "-8401465104859660288"
}
],
"ForeignCurrency": null,
"CurrencyExchangeRate": null,
"URI": "https://arl2.api.myob.com/accountright/dcc6be7f-6e9e-4c5e-b14d-470e702606fc/GeneralLedger/GeneralJournal/f634941b-f4aa-4fb8-96ed-1a372076bb61",
"RowVersion": "-8761753075049299968"
}
/GeneralLedger/JournalTransaction: Returns a list of journals for most transaction types e.g
Bill
Invoice
SupplierPayment
CustomerPayment
SpendMoneyTxn
ReceiveMoneyTxn
TransferMoneyTxn
GeneralJournal
InventoryAdjustment
CreditRefund
CreditSettlement
DebitRefund
DebitSettlement
From the UI these transactions would be from the following location:
AccountRight:
1. Accounts
2. Transaction Journal
Get request to the API endpoint /GeneralLedger/JournalTransaction
{
"UID": "2083eef7-4695-4ab6-a4aa-300ad8fef7d3",
"DisplayID": "16",
"JournalType": "CashPayment",
"SourceTransaction": {
"UID": "c7e199bb-481e-42b2-bd63-a13f1dc35b68",
"TransactionType": "SpendMoneyTxn",
"URI": "https://arl2.api.myob.com/accountright/dcc6be7f-6e9e-4c5e-b14d-470e702606fc/Banking/SpendMoneyTxn/c7e199bb-481e-42b2-bd63-a13f1dc35b68"
},
"DateOccurred": "2019-07-11T00:00:00",
"DatePosted": "2020-04-01T22:21:27",
"Description": "Metropolitan Electricity",
"Lines": [
{
"Account": {
"UID": "24561179-383f-41e1-86a0-3d420d2d6223",
"Name": "GST Paid",
"DisplayID": "2-3030",
"URI": "https://arl2.api.myob.com/accountright/dcc6be7f-6e9e-4c5e-b14d-470e702606fc/GeneralLedger/Account/24561179-383f-41e1-86a0-3d420d2d6223"
},
"Amount": 22.760000,
"IsCredit": false,
"Job": null,
"LineDescription": null,
"ReconciledDate": null,
"UnitCount": null
},
{
"Account": {
"UID": "19a1c319-973b-4728-b247-a38a435f2840",
"Name": "General Cheque Account 1",
"DisplayID": "1-1110",
"URI": "https://arl2.api.myob.com/accountright/dcc6be7f-6e9e-4c5e-b14d-470e702606fc/GeneralLedger/Account/19a1c319-973b-4728-b247-a38a435f2840"
},
"Amount": 250.350000,
"IsCredit": true,
"Job": null,
"LineDescription": null,
"ReconciledDate": "2019-07-31T00:00:00",
"UnitCount": null
},
{
"Account": {
"UID": "eb608b85-7434-475e-bc0b-72c82cc140e0",
"Name": "Electricity",
"DisplayID": "6-2120",
"URI": "https://arl2.api.myob.com/accountright/dcc6be7f-6e9e-4c5e-b14d-470e702606fc/GeneralLedger/Account/eb608b85-7434-475e-bc0b-72c82cc140e0"
},
"Amount": 227.590000,
"IsCredit": false,
"Job": null,
"LineDescription": null,
"ReconciledDate": null,
"UnitCount": null
}
],
"URI": "https://arl2.api.myob.com/accountright/dcc6be7f-6e9e-4c5e-b14d-470e702606fc/GeneralLedger/JournalTransaction/2083eef7-4695-4ab6-a4aa-300ad8fef7d3",
"RowVersion": "6347823674778714112"
}
If you have any questions, feel to log a ticket with the Customisation & Integration Team.
Comments
0 comments
Article is closed for comments.