Get Journal Entries

Retrieve a list of Journal Entries based on specified filters.

Query parameters

perioddateOptional

Period for which the journal entry is being posted. Will be in the YYYY-MM-DD format. It will be set to the current period if not provided

statusenumOptional

Holds the status of the journal entry line. If no status filter is defined, API will return only journal entries with EXTRACTED status.

Allowed values:

vendor_idstringOptional

Id of the Vendor/Supplier. This value will match the source/vendors:source_system_id.

created_atdatetimeOptional

Journal Entry created date and time stamp.

updated_atdatetimeOptional

Journal Entry updated date and time stamp.

resubmittedbooleanOptional

Indicates if the Journal Entry was resubmitted after being rejected within Gappify. It is either 0 (False) or 1 (True).

reviewedbooleanOptional

Indicates if the Journal Entry was reviewed at any point. It is either 0 (False) or 1 (True).

has_je_idbooleanOptional

Indicates if the Journal Entry has je_id. It is either 0 (False) or 1 (True).

Response

List of Journal Entry retrieved successfully.

idinteger

Gappify generated unique identifier for the journal entry.

namestring

Vendor/Supplier name.

vendor_idstring

Id of the Vendor/Supplier. This value will match the source/vendors:source_system_id.

subsidiarystring

Subsidiary name linked to the journal entry. This value will match the name in source/coa:name.

subsidiary_idstring

Subsidiary id linked to the journal entry. This value will match the source/coa:source_system_id.

departmentstring

Department name linked to the journal entry. This value will match the source/coa:name.

department_idstring

Department ID linked to the journal entry. This value will match the source/coa:source_system_id.

glaccountstring

GLAccount name linked to the journal entry. This value will match the source/coa:name.

glaccount_idstring

GLAccount ID linked to the journal entry. This value will match the source/coa:source_system_id.

classstring

Class name linked to the journal entry. This value will match the name in source_coas.

class_idstring

Class id linked to the journal entry. This value will match the source_system_id in source_coas.

projectstring

Project name linked to the journal entry. This value will match the name in source_coas.

project_idstring

Project id linked to the journal entry. This value will match the source_system_id in source_coas.

currencystring

Currency in which the transaction will be posted in the JE. Will match the name in the currency list of source_coas.

currency_idstring

Currency id in which the transaction will be posted in the JE. Will match the source_system_id in the currency list of source_coas.

debitdouble

Journal entry debit amount based on transaction currency. Will be blank for the credit line.

creditdouble

Journal entry credit amount based on transaction currency. Will be blank for the debit line.

je_datedate

Journal entry date as entered by the user when posting the lines. Will be in the YYYY-MM-DD format.

je_reversal_datedate

Journal entry reversal date as entered by the user when posting the lines. Will be in the YYYY-MM-DD format.

je_memostring

Journal entry memo description/details as entered by the user when posting the lines.

line_descriptionstring

Holds the value of the description field from the Transaction line record.

statusstring

Holds the status of the journal entry line. See <> for detailed error status workflow. The value is auto updated.

perioddate

Period for which the journal entry is being posted. Will be in the YYYY-MM-DD format.

po_source_system_idinteger

Purchase order Id on the journal entry for accrual manager lines originating from purchase order lines. It should match source/purchase_order:source_system_id

po_numberstring

Purchase order number on the journal entry for accrual manager lines originating from purchase order lines.

po_line_idstring

Purchase order line Id on the journal entry for accrual manager lines originating from purchase order lines.

po_line_descriptionstring

Purchase order line description on the journal entry for accrual manager lines originating from purchase order lines.

po_line_amountdouble

Purchase order line amount on the journal entry for accrual manager lines originating from purchase order lines.

created_atdatetime

QJE created date and time stamp.

updated_atdatetime

QJE updated date and time stamp.

external_idstring

Combination of Subsidiary, Transaction Currency, Date.

locationstring

Location name linked to the journal entry. This value will match the name in source_coas.

location_idstring

Location id linked to the journal entry. This value will match the source_system_id in source_coas.

preparerstring

Email of the user that prepared the QJE (Transaction to QJE).

group_idstring

Gappify generated unique identifier for the debit/credit pair. This group_id should be leveraged to perform updates to the Gappify JE’s.

posted_bystring

Email of the user that posted the journal entry.

posted_atdatetime

Datetime stamp of when the journal entry was flagged as posted. Auto updated when JE is updated with a non null je_id.

regionstring

Region name linked to the journal entry. This value will match the name in source_coas.

region_idstring

Region ID linked to the journal entry. This value will match the name in source_coas.

je_idstring

Record Id of the resulting journal entry in the customer ERP. This value will be used to create link between Gappify QJE and Customers journal entry. Upon successful creation in the ERP system, update Gappify with a valid non null value to change status to POSTED.

service_start_datedate

Purchase order line start date on the journal entry for accrual manager lines originating from purchase order lines. This field can also hold transaction level start date as provided by Vendors.

service_end_datedate

Purchase order line end date on the journal entry for accrual manager lines originating from purchase order lines. This field can also hold transaction level end date as provided by Vendors.

companystring

Company name linked to the journal entry. This value will match the name in source_coas.

company_idstring

Company id linked to the journal entry. This value will match the source_system_id in source_coas.

intercompanystring

Intercompany name linked to the journal entry. This value will match the name in source_coas.

intercompany_idstring

Intercompany id linked to the journal entry. This value will match the source_system_id in source_coas.

channelstring

Channel name linked to the journal entry. This value will match the name in source_coas.

channel_idstring

Channel id linked to the journal entry. This value will match the source_system_id in source_coas.

je_reject_reasonstring

Reason if the QJE was ever rejected or is currently in rejected status within Gappify.

rejected_bystring

Email of the user that rejected the journal entry within Gappify.

rejected_atdatetime

Datetime stamp of when the journal entry was flagged as rejected within Gappify.

threshold_support_documentstring

Supporting details (can be words or url) for the journal entry.

productstring

Product name linked to the journal entry. This value will match the name in source_coas.

product_idstring

Product id linked to the journal entry. This value will match the source_system_id in source_coas.

je_batchstring

Unique reference to a JE outbound file.

resubmittedboolean

Indicates if the QJE was resubmitted after being rejected within Gappify.

deleted_atdatetime

Indicates timestamp of when the JE is soft deleted

reviewedboolean

Indicates if the QJE was reviewed at any point.

reporting_amountdouble

The Reporting currency converted amount as available on the transaction line.

subsidiary_amountdouble

The Subsidiary currency converted amount as available on the transaction line.

reporting_currencystring

The Reporting currency stamped on the transaction line. This value is derived from the Company settings.

subsidiary_currencystring

The Subsidiary currency stamped on the transaction line.

reporting_currency_idstring

The Reporting currency id as linked to COA currency values.

subsidiary_currency_idstring

The Subsidiary currency id as linked to COA currency values.

po_line_amount_usddouble

Purchase order line amount in USD currency on the journal entry for accrual manager lines originating from purchase order lines.

po_balance_usddouble

Purchase order line balance amount in USD currency on the journal entry for accrual manager lines originating from purchase order lines.

error_detailsstring

Update the field with error details upon failure to POS JE to the respective system.

1	[
2	{
3	"id": 1,
4	"name": "name",
5	"vendor_id": "vendor_id",
6	"subsidiary": "subsidiary",
7	"subsidiary_id": "subsidiary_id",
8	"department": "department",
9	"department_id": "department_id",
10	"glaccount": "glaccount",
11	"glaccount_id": "glaccount_id",
12	"class": "class",
13	"class_id": "class_id",
14	"project": "project",
15	"project_id": "project_id",
16	"currency": "currency",
17	"currency_id": "currency_id",
18	"debit": 1.1,
19	"credit": 1.1,
20	"je_date": "2023-01-15",
21	"je_reversal_date": "2023-01-15",
22	"je_memo": "je_memo",
23	"line_description": "line_description",
24	"status": "status",
25	"period": "2023-01-15",
26	"po_source_system_id": 1,
27	"po_number": "po_number",
28	"po_line_id": "po_line_id",
29	"po_line_description": "po_line_description",
30	"po_line_amount": 1.1,
31	"created_at": "2024-01-15T09:30:00Z",
32	"updated_at": "2024-01-15T09:30:00Z",
33	"external_id": "external_id",
34	"location": "location",
35	"location_id": "location_id",
36	"preparer": "preparer",
37	"group_id": "group_id",
38	"posted_by": "posted_by",
39	"posted_at": "2024-01-15T09:30:00Z",
40	"region": "region",
41	"region_id": "region_id",
42	"je_id": "je_id",
43	"service_start_date": "2023-01-15",
44	"service_end_date": "2023-01-15",
45	"company": "company",
46	"company_id": "company_id",
47	"intercompany": "intercompany",
48	"intercompany_id": "intercompany_id",
49	"channel": "channel",
50	"channel_id": "channel_id",
51	"je_reject_reason": "je_reject_reason",
52	"rejected_by": "rejected_by",
53	"rejected_at": "2024-01-15T09:30:00Z",
54	"threshold_support_document": "threshold_support_document",
55	"product": "product",
56	"product_id": "product_id",
57	"je_batch": "je_batch",
58	"resubmitted": true,
59	"deleted_at": "2024-01-15T09:30:00Z",
60	"reviewed": true,
61	"reporting_amount": 1.1,
62	"subsidiary_amount": 1.1,
63	"reporting_currency": "reporting_currency",
64	"subsidiary_currency": "subsidiary_currency",
65	"reporting_currency_id": "reporting_currency_id",
66	"subsidiary_currency_id": "subsidiary_currency_id",
67	"po_line_amount_usd": 1.1,
68	"po_balance_usd": 1.1,
69	"error_details": "error_details"
70	},
71	{
72	"id": 1,
73	"name": "name",
74	"vendor_id": "vendor_id",
75	"subsidiary": "subsidiary",
76	"subsidiary_id": "subsidiary_id",
77	"department": "department",
78	"department_id": "department_id",
79	"glaccount": "glaccount",
80	"glaccount_id": "glaccount_id",
81	"class": "class",
82	"class_id": "class_id",
83	"project": "project",
84	"project_id": "project_id",
85	"currency": "currency",
86	"currency_id": "currency_id",
87	"debit": 1.1,
88	"credit": 1.1,
89	"je_date": "2023-01-15",
90	"je_reversal_date": "2023-01-15",
91	"je_memo": "je_memo",
92	"line_description": "line_description",
93	"status": "status",
94	"period": "2023-01-15",
95	"po_source_system_id": 1,
96	"po_number": "po_number",
97	"po_line_id": "po_line_id",
98	"po_line_description": "po_line_description",
99	"po_line_amount": 1.1,
100	"created_at": "2024-01-15T09:30:00Z",
101	"updated_at": "2024-01-15T09:30:00Z",
102	"external_id": "external_id",
103	"location": "location",
104	"location_id": "location_id",
105	"preparer": "preparer",
106	"group_id": "group_id",
107	"posted_by": "posted_by",
108	"posted_at": "2024-01-15T09:30:00Z",
109	"region": "region",
110	"region_id": "region_id",
111	"je_id": "je_id",
112	"service_start_date": "2023-01-15",
113	"service_end_date": "2023-01-15",
114	"company": "company",
115	"company_id": "company_id",
116	"intercompany": "intercompany",
117	"intercompany_id": "intercompany_id",
118	"channel": "channel",
119	"channel_id": "channel_id",
120	"je_reject_reason": "je_reject_reason",
121	"rejected_by": "rejected_by",
122	"rejected_at": "2024-01-15T09:30:00Z",
123	"threshold_support_document": "threshold_support_document",
124	"product": "product",
125	"product_id": "product_id",
126	"je_batch": "je_batch",
127	"resubmitted": true,
128	"deleted_at": "2024-01-15T09:30:00Z",
129	"reviewed": true,
130	"reporting_amount": 1.1,
131	"subsidiary_amount": 1.1,
132	"reporting_currency": "reporting_currency",
133	"subsidiary_currency": "subsidiary_currency",
134	"reporting_currency_id": "reporting_currency_id",
135	"subsidiary_currency_id": "subsidiary_currency_id",
136	"po_line_amount_usd": 1.1,
137	"po_balance_usd": 1.1,
138	"error_details": "error_details"
139	}
140	]

Headers

Query parameters

Response

Errors

1	curl https://api.gappify.com/v1/qje \
2	-H "Authorization: <Bearer>"