Difference between revisions of "MYOB Endpoint: GeneralJournals"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
The MYOB '''GeneralJournals''' [[MYOB Endpoints|endpoint]] allows you to get access to general journal transactions posted within MYOB. | The MYOB '''GeneralJournals''' [[MYOB Endpoints|endpoint]] allows you to get access to general journal transactions posted within MYOB. | ||
Note an alternate endpoint named [[MYOB Endpoint: GeneralJournalsTable|GeneralJournalsTable]] is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory. | |||
| Line 7: | Line 9: | ||
The following fields are available for the GeneralJournals endpoint. | The following fields are available for the GeneralJournals endpoint. | ||
;DataFile | |||
:A [[Field Type: Record|record field]] that identifies the [[Field: DataFiles|source data file]] for this record. | |||
;UID | ;UID | ||
Latest revision as of 18:15, 27 March 2025
Overview
The MYOB GeneralJournals endpoint allows you to get access to general journal transactions posted within MYOB.
Note an alternate endpoint named GeneralJournalsTable 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 GeneralJournals endpoint.
- DataFile
- A record field that identifies the source data file for this record.
- 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 that provides the transaction number.
- DateOccurred
- A date field that indicates the date of the transaction.
- IsTaxInclusive
- A true/false field that indicates if the amounts are tax inclusive or not.
- Memo
- A text field that provides the memo for the transaction.
- GSTReportingMethod
- A text field that indicates whether this transaction is considered a sale or purchase with regards to GST and BAS.
- Possible values are:
- Sale
- Purchase
- IsYearEndAdjustment
- A true/false field that indicates if the transaction is an end of year adjustment or not.
- Category
- A record field that provides the category associated with this transaction.
- Lines
- A table field that provides the lines of this transaction.
- See Lines Fields for more information.
- ForeignCurrency
- A record field that provides the currency associated with this transaction.
- CurrencyExchangeRate
- A decimal field that provides the exchange rate for foreign currency transactions.
- RowVersion
- A row version field.
Lines Fields
The Lines field contains the following sub-fields.
- RowID
- A integer field representing the internal id of this line.
- Account
- A record field that provides the account for this line.
- Job
- A record field that provides the job for this line.
- Memo
- A text field that provides the line memo for the transaction.
- TaxCode
- A record field that provides the tax code for this line.
- Amount
- A decimal field that provides the amount.
- AmountForeign
- A decimal field that provides the amount in foreign currency if applicable.
- IsCredit
- A true/false field that indicates if the amount is a credit or debit.
- TaxAmount
- A decimal field that provides the tax amount.
- TaxAmountForeign
- A decimal field that provides the tax amount in foreign currency if applicable.
- IsOverridenTaxAmount
- A true/false field that indicates if the tax amount was edited and not automically calculated based on the tax code rate.
- UnitCount
- A decimal field that provides the quantity for this line.
- Only applicable to MYOB Essentials.
- RowVersion
- A row version field.
MYOB API
For a detailed run through of the endpoint, you can see the MYOB API.
Related Fields
Related Endpoints