JournalTransaction

Return a list of journals for all transaction types.

Date Released: Aug 2013 Date Updated: Feb 2021
URLSupports
/{cf_uri}/GeneralLedger/JournalTransaction GET |  PUT |  POST |  DELETE
Please note: While accessibility via the API is available to both AccountRight and new Essentials files. Not all features will be displayed in Product for new Essentials

The elements list below details information for JournalTransaction. To view the descriptions for the elements you can either hover any attribute to reveal details or click here to show all details inline.

Items shown with are required when posting or puting data
Items shown with are read-only elements

Attribute Details

  • UIDGuid (36)
  • Unique identifier in the form of a guid.
  • DisplayIDString (13)
  • Journal transaction id.
  • JournalTypeString
  • Full list of journal types:
    General
    Sale
    Purchase
    CashPayment
    CashReceipt
    Inventory
  • SourceTransactionString
  • Source transaction that created the journal entry.
    • UIDGuid (36)
    • Foreign Key: Unique identifier for the source transaction in the form of a guid.
    • TransactionTypeString (30)
    • Transaction types consist of the following:
      Bill
      Invoice
      SupplierPayment
      CustomerPayment
      SpendMoneyTxn
      ReceiveMoneyTxn
      TransferMoneyTxn
      GeneralJournal
      InventoryAdjustment
      CreditRefund
      CreditSettlement
      DebitRefund
      DebitSettlement
    • URIString
    • Uniform resource identifier associated with the transaction object.
  • DateOccurredDateTime
  • Transaction date entry, format YYYY-MM-DD HH:MM:SS { 'DateOccurred': '2014-04-09 00:00:00' }
  • DatePostedDateTime
  • Date timestamp for day the transaction was entered, format YYYY-MM-DD HH:MM:SS { 'DatePosted': '2014-08-11 13:33:02' }
  • DescriptionString (255)
  • Journal memo assigned to the transaction.
  • Lines []
  • An array of journal line information
    • Account
    • The following set of information pulls through details for an Account
      • UIDGuid (36)
      • Foreign Key: Unique identifier for the account in the form of a guid.
      • NameString (60)
      • Account name belonging to the account record.
      • DisplayIDString (6)
      • Account code format includes separator ie 1-1100{ 'DisplayID': '1-1200' }
      • URIString
      • Uniform resource identifier associated with the account object.
    • AmountDecimal (13.6)
    • Dollar amount posted to the Account object for each line of the transaction.
    • IsCreditBoolean
    • True indicates the amount posted a credit to the Account object.
      False indicates the amount posted did not record as a credit to the Account object.
    • Job
    • The following set of information pulls through the details for a job
      • UID GUID (36)
      • Foreign Key: Unique guid identifier belonging to the job for the line of the service sale.
      • Number String (30)
      • Number assigned to the job
      • Name String (30)
      • Name assigned to the job
      • URI String
      • Uniform resource identifier associated with the job object
    • LineDescriptionString (255)
    • Line description for each line of the transaction if one has been entered.
    • ReconciledDateDateTime
    • Date timestamp for day the transaction was reconciled, format YYYY-MM-DD HH:MM:SS { 'ReconciledDate': '2014-08-11 13:33:02' }
    • UnitCountDecimal (19.6)
    • Quantity value of the journal transaction entry.
    • URIString
    • Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web.
    • RowVersionString
    • Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time.


Paging: default page size is set to 400 with a maximum of 5000 results.

Example json GET response

  • {
    • "UID" : "9992534b-7cfe-46a3-9077-4368016adf66",
    • "DisplayID" : "00000001",
    • "JournalType" : "Sale",
    • "SourceTransaction" : {
      • "UID" : "c604ae23-220d-43b7-8f57-f10478bc9066",
      • "TransactionType" : "Invoice",
      • "URI" : "{cf_uri}/Sale/Invoice/c604ae23-220d-43b7-8f57-f10478bc9066"
      • },
    • "DateOccurred" : "2014-04-09T00:00:00",
    • "DatePosted" : "2014-03-10T03:31:57.19",
    • "Description" : "Sale; Cameron, James",
    • "Lines" : [
      • {
        • "Account" : {
          • "UID" : "17960eb4-3e14-4805-aae2-5b2387da1153",
          • "Name" : "Trade Debtors",
          • "DisplayID" : "1-1310",
          • "URI" : "{cf_uri}/GeneralLedger/Account/17960eb4-3e14-4805-aae2-5b2387da1153"
          • },
        • "Amount" : 100,
        • "IsCredit" : false,
        • "Job" : null,
        • "LineDescription" : ""
        • "ReconciledDate" : null,
        • "UnitCount": null
        • },
      • {
        • "Account" : {
          • "UID" : "f7d18c92-ada8-428e-b02a-9223022f84b2",
          • "Name" : "Late Fees Collected",
          • "DisplayID" : "4-3000",
          • "URI" : "{cf_uri}/GeneralLedger/Account/f7d18c92-ada8-428e-b02a-9223022f84b2"
          • },
        • "Amount" : 90.91,
        • "IsCredit" : true,
        • "Job" : null,
        • "LineDescription" : "Line 1 testing",
        • "UnitCount": null
        • },
      • {
        • "Account" : {
          • "UID" : "5427d47c-499a-4386-ad67-72de39520a00",
          • "Name" : "GST Collected",
          • "DisplayID" : "2-1210",
          • "URI" : "{cf_uri}/GeneralLedger/Account/5427d47c-499a-4386-ad67-72de39520a00"
          • },
        • "Amount" : 9.09,
        • "IsCredit" : true,
        • "Job" : null,
        • "LineDescription" : "",
        • "ReconciledDate" : null,
        • "UnitCount": null
        • }
      • ],
    • "URI" : "{cf_uri}/GeneralLedger/JournalTransaction/9992534b-7cfe-46a3-9077-4368016adf66",
    • "RowVersion" : "-1435803856201056256"
    • }
Hypermedia in the MYOB Business API

The {cf_uri} is provided by the Company File endpoint.

Read more about Hypermedia in the MYOB Business API in our best practice guide.