Xero Accounting Endpoint: JournalsAccrual: Difference between revisions
No edit summary |
No edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
The Xero '''JournalsAccrual''' [[Xero Accounting Endpoints|endpoint]] provides the journal records on an accrual basis that had a material impact on your general ledger. | The Xero '''JournalsAccrual''' [[Xero Accounting Endpoints|endpoint]] provides the journal records on an accrual basis that had a material impact on your general ledger. | ||
Note an alternate endpoint named [[Xero Accounting Endpoint: JournalsAccrualTable|JournalsAccrualTable]] is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory. | |||
This endpoint does not internally support filters due to the Xero API Architecture. Only the '''JournalNumber''', '''JournalDate''' and '''CreatedDateUTC''' fields can be filtered. Furthermore, these fields do not support all types of operators or complex filters. | |||
For journals on a cash basis, see [[Xero Accounting Endpoint: JournalsCash|JournalsCash]]. | For journals on a cash basis, see [[Xero Accounting Endpoint: JournalsCash|JournalsCash]]. | ||
| Line 103: | Line 107: | ||
:A [[Field Type: Text|text field]] that provides the [[Xero Accounting Field: TaxTypes|tax type]]. | :A [[Field Type: Text|text field]] that provides the [[Xero Accounting Field: TaxTypes|tax type]]. | ||
; | ;TaxName | ||
:A [[Field Type: Text|text field]] that provides the name of the tax rate. | :A [[Field Type: Text|text field]] that provides the name of the tax rate. | ||