Creating Journal Entries in NetSuite via the tNetSuiteOutputComponent in Talend Studio 8

[BillG-Quanex]

I am working on a process to create journal entries in NetSuite using the tNetSuiteOuput component and have had limited luck. I am consistently getting the following error message from NetSuite:

FATAL] 14:40:10 devlibrary.testnetsuite_0_1.TestNetSuite- tNetSuiteOutput_2 You must enter at least one line item for this transaction.

I have set up a tNetSuiteConnection component to use Token based login for API 2021.2. I have a tDBSP component that returns the data needed to create the journal entry (currency - USD, tranDate, account, credit amount, debit amount, memo, and a couple custom fields). I have tried converting that data to an XML document and sending the XML document to the tNetSuiteComponent. Here's a sample of the XML document:

<record>

 <currency>USD</currency>

 <tranDate>2023-11-07</tranDate>

 <lineList>

 <line>

  <account>Account1</account>

  <credit>1154.44</credit>

  <memo>MEMO # 1</memo>

 </line>

 <line>

  <account>Account2</account>

  <debit>1154.44</debit>

  <memo>MEMO # 1</memo>

 </line>

 <line>

  <account>Account1</account>

  <debit>150.00</debit>

 </line>

 <line>

  <account>Account2</account>

  <credit>150.00</credit>

 </line>

 <line>

  <account>Account1</account>

  <debit>1150.00</debit>

 </line>

 <line>

  <account>Account2</account>

  <credit>1150.00</credit>

 </line>

 <line>

  <account>Account1</account>

  <debit>2293.18</debit>

 </line>

 <line>

  <account>Account2</account>

  <credit>2293.18</credit>

 </line>

 <line>

  <account>Account1</account>

  <debit>161.26</debit>

 </line>

 <line>

  <account>Account2</account>

  <credit>161.26</credit>

 </line>

 <line>

  <account>Account3</account>

  <debit>10426.00</debit>

  <memo>MEMO # 2</memo>

 </line>

 <line>

  <account>Account4</account>

  <credit>10426.00</credit>

  <memo>MEMO # 2</memo>

 </line>

 <line>

  <account>Account3</account>

  <debit>219.29</debit>

  <memo>MEMO # 3</memo>

 </line>

 <line>

  <account>Account4</account>

  <credit>219.29</credit>

  <memo>MEMO # 3</memo>

 </line>

 <line>

  <account>Account3</account>

  <debit>1389.25</debit>

  <memo>MEMO # 4</memo>

 </line>

 <line>

  <account>Account4</account>

  <credit>1389.25</credit>

  <memo>MEMO # 4</memo>

 </line>

 <line>

  <account>Account3</account>

  <debit>292.78</debit>

  <memo>MEMO # 5</memo>

 </line>

 <line>

  <account>Account4</account>

  <credit>292.78</credit>

  <memo>MEMO # 5</memo>

 </line>

 <line>

  <account>Account3</account>

  <debit>3012.50</debit>

  <memo>MEMO # 6</memo>

 </line>

 <line>

  <account>Account4</account>

  <credit>3012.50</credit>

  <memo>MEMO # 6</memo>

 </line>

 <line>

  <account>Account5</account>

  <debit>554.44</debit>

 </line>

 <line>

  <account>Account4</account>

  <credit>554.44</credit>

 </line>

 <line>

  <account>Account3</account>

  <debit>1893.75</debit>

 </line>

 <line>

  <account>Account4</account>

  <credit>1893.75</credit>

 </line>

 <line>

  <account>Account3</account>

  <debit>239.88</debit>

 </line>

 <line>

  <account>Account4</account>

  <credit>239.88</credit>

 </line>

 <line>

  <account>Account3</account>

  <debit>645.38</debit>

 </line>

 <line>

  <account>Account4</account>

  <credit>645.38</credit>

 </line>

 <line>

  <account>Account3</account>

  <debit>328.44</debit>

 </line>

 <line>

  <account>Account4</account>

  <credit>328.44</credit>

 </line>

 <line>

  <account>Account3</account>

  <debit>597.85</debit>

 </line>

 <line>

  <account>Account4</account>

  <credit>597.85</credit>

 </line>

 <line>

  <account>Account3</account>

  <debit>449.31</debit>

 </line>

 <line>

  <account>Account4</account>

  <credit>449.31</credit>

 </line>

 <line>

  <account>Account3</account>

  <debit>1352.13</debit>

 </line>

 <line>

  <account>Account4</account>

  <credit>1352.13</credit>

 </line>

 </lineList>

</record>

I have also tried wrapping the above XML inside <addList>[XML ABOVE]</addList>. I have further tried taking the parsed fields from the tDBSP and connecting that row directly to the tNetSuiteOutput component and sync'd the columns. I have also tried changing the <line></line> tags to <lineItem></lineItem> - no matter what I do I continue to get the error message above (you must enter at least one line item)

Here are the settings on the tNetSuiteOutput component (In this example I eliminated the use of the tNetSuiteConnection component)

 

I feel like there is something that I am missing to make this work.

Anyone have any ideas / experience working with the tNetSuiteOutput component to create Journal Entries?

Thanks.

Bill.

-- EDITTED for readability