# Trying to Insert a ManualJournal into Xero with ODBC

**URL:** <https://community.cdata.com/t/trying-to-insert-a-manualjournal-into-xero-with-odbc/208>\
**Category:** CData Drivers\
**Tags:** sql, question, odbc, xero\
**Created:** [June 7, 2023, 7:23am UTC](https://community.cdata.com/t/trying-to-insert-a-manualjournal-into-xero-with-odbc/208 "2023-06-07T07:23:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AndyN](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/andyn/32/746_2.png) [@AndyN](https://community.cdata.com/u/AndyN)\
**Post date:** [June 7, 2023, 7:23am UTC](https://community.cdata.com/t/trying-to-insert-a-manualjournal-into-xero-with-odbc/208/1 "2023-06-07T07:23:25Z")

</div>

I am trying to insert a manual journal entry into Xero using below SQL insert statement. And I get the following error.&nbsp;  
“A validation exception occurred: The total Debits (1.50) must equal total credits (0.00)" It suggests that cdata is not processing it as one API post but as 2 posts and Xero spits back an error because it expects both lines in the&nbsp;POST api.

```sql
INSERT into ManualJournals ( JournalLine_AccountCode, JournalLine_LineAmount, Narration) VALUES (620, 1.50, 'Test1'), (611, -1.50, 'Test1');

```

Any ideas would be appreciated.

---

<div class="post-metadata">

**Author:** ![Erold\_B](https://avatars.discourse-cdn.com/v4/letter/e/85e7bf/32.png) [@Erold\_B](https://community.cdata.com/u/Erold_B)\
**Post date:** [June 7, 2023, 12:08pm UTC](https://community.cdata.com/t/trying-to-insert-a-manualjournal-into-xero-with-odbc/208/2 "2023-06-07T12:08:30Z")

</div>

Hi Andy,

Using a traditional insert in this case would result in a validation error. You’re correct to say that this is because the API calls for each insert are done individually and this results in an error since total debits =/= total credits

If I understand your use-case correctly, you need to insert multiple line items simultaneously. This can be done by using the JournalLineAggregate column. Please refer to this part of the driver’s&nbsp;documentation (under the INSERT sector)::

> **[CData ODBC Driver for Xero - ManualJournals](https://cdn.cdata.com/help/DXH/odbc/pg_accountingtable-manualjournals.htm)**
>
> CData ODBC Driver for Xero - RSBXero - ManualJournals:

In your case, I believe you would need to&nbsp;use the following query:

```sql
INSERT INTO ManualJournals (Narration, JournalLineAggregate)VALUES ('Test1', '<JournalLine><LineAmount>1.50</LineAmount><AccountCode>620</AccountCode></JournalLine> <JournalLine><LineAmount>-1.50</LineAmount><AccountCode>611</AccountCode></JournalLine>');

```

This would issue an API request with the following POST body:

```xml
<ManualJournals> <ManualJournal> <JournalLines><JournalLine><LineAmount>1.50</LineAmount><AccountCode>620</AccountCode></JournalLine> <JournalLine><LineAmount>-1.50</LineAmount><AccountCode>611</AccountCode></JournalLine></JournalLines> <Narration>Test1</Narration> </ManualJournal></ManualJournals>

```

Please let me know if your issue persists.

---

<div class="post-metadata">

**Author:** ![AndyN](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/andyn/32/746_2.png) [@AndyN](https://community.cdata.com/u/AndyN)\
**Post date:** [June 8, 2023, 3:18am UTC](https://community.cdata.com/t/trying-to-insert-a-manualjournal-into-xero-with-odbc/208/3 "2023-06-08T03:18:49Z")

</div>

That works perfectly @Erold_B &nbsp; Thanks so much!!