I am trying to insert a manual journal entry into Xero using below SQL insert statement. And I get the following error.
“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 POST api.
INSERT into ManualJournals ( JournalLine_AccountCode, JournalLine_LineAmount, Narration)
VALUES (620, 1.50, 'Test1'), (611, -1.50, 'Test1');
Any ideas would be appreciated.
Best answer by AndyNView original