/quickbooks-journal-entries

Foundational GET all handler for: quickbooks-journal-entries
This is used to track the Quickbooks Journal Entries.
ID: NUMBER: This is the Primary Key (Numeric) for the Quickbooks Journal Entry
CEPHISSO_PLATFORM_ACCOUNTS_ID: NUMBER:
QUICKBOOKS_ID: VARCHAR2(255): Unique identifier for this object Sort order is ASC by default
LINE: JSON: Individual line items of a transaction There must be at least one pair of Journal Entry Line elements representing a debit and a credit called distribution lines Valid Line types include: JournalEntryLine and DescriptionOnlyLine
SYNC_TOKEN: VARCHAR2(255): Version number of the object It is used to lock an object for use by one app at a time As soon as an application modifies an object its SyncToken is incremented Attempts to modify an object specifying an older SyncToken fails Only the latest version of the object is maintained by QuickBooks Online
CURRENCY_REF_VALUE: VARCHAR2(3): A three letter string representing the ISO 4217 code for the currency For example USD AUD EUR and so on
CURRENY_REF_NAME: VARCHAR2(255): The full name of the currency
DOC_NUMBER: VARCHAR2(255): Reference number for the transaction Throws an error when duplicate DocNumber is sent in the request and if Preferences:OtherPrefs:NameValueName WarnDuplicateJournalNumber is true Recommended best practice: check the setting of Preferences:OtherPrefs:NameValueName WarnDuplicateJournalNumber before setting DocNumber If a duplicate DocNumber needs to be supplied add the query parameter namevalue pair includeallowduplicatedocnum to the URI Sort order is ASC by default With this change V3 JournalEntry API will be supporting autoassign docNumber when null in the request only till minorversion53 Starting minorversion54 if null value is sent in the request null will be saved With minorversion54 if there is a need to support assigning a docNumber when null it can be achieved through include param includeallowautodocnum
PRIVATE_NOTE: CLOB: User entered organization-private note about the transaction
TRANSACTION_DATE_STRING: VARCHAR2(255): The date entered by the user when this transaction occurred For posting transactions this is the posting date that affects the financial statements If the date is not supplied the current date on the server is used Sort order is ASC by default
EXCHANGE_RATE: NUMBER: The number of home currency units it takes to equal one unit of currency specified by CurrencyRef Applicable if multicurrency is enabled for the company
TAX_RATE_REF: JSON: The ID for the referenced object as found in the Id field of the object payload The context is set by the type of reference and is specific to the QuickBooks company file
TRANSACTION_LOCATION_TYPE: VARCHAR2(255): The account location Valid values include:WithinFranceFranceOverseasOutsideFranceWithEUOutsideEUFor France locales only
TRANSACTION_TAX_DETAIL: JSON: This data type provides information for taxes charged on the transaction as a whole It captures the details sales taxes calculated for the transaction based on the tax codes referenced by the transaction This can be calculated by QuickBooks business logic or you may supply it when adding a transaction See Global tax model for more information about this element If sales tax is disabled (PreferencesTaxPrefsUsingSalesTax is set to false) then TxnTaxDetail is ignored and not stored
GLOBAL_TAX_CALCULATION: VARCHAR2(255): Method in which tax is applied Allowed values are: TaxExcluded TaxInclusive
ADJUSTMENT: NUMBER: Indicates the total amount of the transaction This includes the total of all the charges allowances and taxes By default this is recalculated by the system based on sub-items total and overridden
QUICKBOOKS_METADATA: JSON: Descriptive information about the object The MetaData values are set by Data Services and are read only for all applications
RECUR_DATA_REF: JSON: A reference to the Recurring Transaction It captures what recurring transaction template the JournalEn

Provide your bearer token in the

Authorization

header when making requests to protected resources.

Example:

Authorization: Bearer ********************

{ "items": [ { "adjustment": 0, "cephisso_platform_accounts_id": 0, "created_by": "string", "created_on": "2019-08-24T14:15:22Z", "currency_ref_value": "string", "curreny_ref_name": "string", "data_lineage": null, "doc_number": "string", "exchange_rate": 0, "global_tax_calculation": "string", "home_total_amt": 0, "id": 0, "last_updated_by": "string", "last_updated_on": "2019-08-24T14:15:22Z", "line": null, "metadata": null, "private_note": "string", "quickbooks_id": "string", "quickbooks_metadata": null, "quickbooks_realms_id": 0, "recur_data_ref": null, "sync_token": "string", "tax_rate_ref": null, "total_amt": 0, "transaction_date_string": "string", "transaction_location_type": "string", "transaction_tax_detail": null, "udfs": null } ] }

Request

Responses