Journals
Return, update, create and delete general journal transactions for an AccountRight company file.
Table Specific Information
Select
MYOB allows a subset of columns to be used in the WHERE clause of a SELECT query. These columns may be used with the following operators: =, !=, >, <, >=, <=. In addition, queries with multiple criterias can be executed by combining the criteria with AND and OR operators.
These columns support the above comparison types for server side filtering: ID, DateOccurred, DisplayID, GSTReportingMethod, IsTaxInclusive, IsYearEndAdjustment, Memo, CategoryID, CategoryDisplayID, CategoryName, Uri. All the other columns and operators are processed client side.
SELECT * FROM Journals WHERE ID = "7cabea25-6250-4df5-bb37-77eb2d38f803" SELECT * FROM Journals WHERE CategoryID = "6cbbea25-6256-4df4-bb37-17eb2d21f803 SELECT * FROM Journals WHERE GSTReportingMethod = "Purchase"
Insert
The following attribute is required when performing an insert: DateOccurred, Lines.
To insert an existing journal, along with its Lines, we can either pass a JSON string to the Lines value or use a temporary table like below.
INSERT INTO JournalItems#TEMP(AccountID, TaxcodeID, Amount, IsCredit) VALUES ("d3f55ef1-ce77-4ef2-a415-61d04db2c5fc", "e1e27d8e-f89d-451d-97c8-e0c3c1716a91", 11.23, true)
INSERT INTO JournalItems#TEMP(AccountID, TaxcodeID, Amount, IsCredit) VALUES ("d3f55ef1-ce77-4ef2-a415-61d04db2c5fc", "e1e27d8e-f89d-451d-97c8-e0c3c1716a91", 11.23, false)
INSERT INTO Journals(DateOccurred, Lines) VALUES ("2018-03-04", "JournalItems#TEMP")
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | Uuid | True |
Unique identifier in the form of a guid. |
| DateOccurred | Datetime | False |
Transaction date entry. |
| DisplayID | String | False |
Display ID for the object. |
| GSTReportingMethod | String | False |
Reporting Method used on the general journal transaction which accepts the following: Sale (Supply), Purchase (Acquisition). |
| IsTaxInclusive | Boolean | False |
True indicates the transaction default status is set to tax inclusiv.e False indicates the transaction status is not tax inclusive. |
| IsYearEndAdjustment | Boolean | False |
True indicates the transaction is a YearEndAdjustmen.t False indicates the transaction is not a YearEndAdjustment. |
| Memo | String | False |
Header memo of the general journal entry. |
| CategoryID | Uuid | False |
Unique category identifier in the form of a guid. |
| CategoryDisplayID | String | True |
Display id for the category. |
| CategoryName | String | True |
Name of the category. |
| CategoryURI | String | True |
Uniform resource identifier associated with the category object. |
| ForeignCurrencyID | Uuid | False |
Uniform identifier for the currency in the form of the guid. |
| ForeignCurrencyCode | String | True |
The currency code. |
| ForeignCurrencyName | String | True |
The full name of the currency. |
| ForeignCurrencyURI | String | True |
Uniform resource identifier associated with the currency object. |
| Uri | String | True |
Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. |
| RowVersion | String | True |
Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time. |
| Lines | String | False |
An array of line item information. |
| CompanyFileId | String | True |
The ID of the company file. Takes precedence over the CompanyFileId connection property. |