MYOB Endpoint: JournalTransactions

Overview

The MYOB JournalTransactions endpoint allows you to access all transactions that affect your General Ledger (sales, purchases, payments, etc.).

It does not give you complete details of each transaction. Instead, it provides information as to how the transaction affected the General Ledger.

Note an alternate endpoint named JournalTransactionsTable is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.


Fields

The following fields are available for the JournalTransactions endpoint.

UID
A GUID field representing the internal id of this record. This field can be used to link to other endpoints.
DisplayID
A text field used as the default transaction number (invoice number, purchase number, etc.)
JournalType
A text field that indicates the type of journal.
Possible values are:
  • General
  • Sale
  • Purchase
  • CashPayment
  • CashReceipt
  • Inventory
SourceTransaction
A record field that provides details to the source transaction.
See SourceTransaction Fields for more information.
DateOccurred
A date field that indicates the date of the transaction.
DatePosted
A date field that indicates the date the transaction was entered into MYOB.
Description
A text field that provides the memo for the transaction.
Lines
A table field that provides the list of all affected general ledger accounts.
See Lines Fields for more information.
RowVersion
A row version field.


SourceTransaction Fields

The SourceTransaction field contains the following sub-fields.

UID
A GUID field that provides the ID of the source transaction.
SourceTransaction
A text field that indicates the type of transaction that originated this entry.
Possible values are:
  • Bill
  • Invoice
  • SupplierPayment
  • CustomerPayment
  • SpendMoneyTxn
  • ReceiveMoneyTxn
  • TransferMoneyTxn
  • GeneralJournal
  • InventoryAdjustment
  • CreditRefund
  • CreditSettlement
  • DebitRefund
  • DebitSettlement


Lines Fields

The Lines field contains the following sub-fields.

Account
A record field that provides the general ledger account for this entry.
Amount
A decimal field that provides the amount.
IsCredit
A true/false field that indicates if the amount is a credit or debit.
Job
A record field that provides the job for this entry.
Description
A text field that provides the line memo for the transaction.
ReconciledDate
A date field that indicates the date the transaction was reconciled.
UnitCount
A decimal field that provides the unit count for this entry..


MYOB API

For a detailed run through of the endpoint, you can see the MYOB API.


Related Fields

Accounts
Jobs


Related Endpoints

CreditRefunds
CreditSettlements
DebitRefunds
DebitSettlements
CustomerPayments
GeneralJournals
InventoryAdjustments
InventoryBuildTransactions
JournalTransactionsHistory
JournalTransactionsTable
PurchasesAllInvoices
PurchasesItemInvoices
PurchasesMiscellaneousInvoices
PurchasesProfessionalInvoices
PurchasesServiceInvoices
ReceiveMoneyTransactions
SalesAllInvoices
SalesItemInvoices
SalesMiscellaneousInvoices
SalesProfessionalInvoices
SalesServiceInvoices
SalesTimeBillingInvoices
SpendMoneyTransactions
SupplierPayments
TransferMoneyTransactions


Related Topics

JournalTransactionsHistory
JournalTransactionsTable
MYOB Models
MYOB Endpoints