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

BillG-Quanex — Fri, 15 Nov 2024 21:09:00 GMT

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:

<line>

<account>Account1</account>

</line>

<line>

<account>Account2</account>

</line>

<line>

<account>Account1</account>

</line>

<line>

<account>Account2</account>

</line>

<line>

<account>Account1</account>

</line>

<line>

<account>Account2</account>

</line>

<line>

<account>Account1</account>

</line>

<line>

<account>Account2</account>

</line>

<line>

<account>Account1</account>

</line>

<line>

<account>Account2</account>

</line>

<line>

<account>Account3</account>

</line>

<line>

<account>Account4</account>

</line>

<line>

<account>Account3</account>

</line>

<line>

<account>Account4</account>

</line>

<line>

<account>Account3</account>

</line>

<line>

<account>Account4</account>

</line>

<line>

<account>Account3</account>

</line>

<line>

<account>Account4</account>

</line>

<line>

<account>Account3</account>

</line>

<line>

<account>Account4</account>

</line>

<line>

<account>Account5</account>

</line>

<line>

<account>Account4</account>

</line>

<line>

<account>Account3</account>

</line>

<line>

<account>Account4</account>

</line>

<line>

<account>Account3</account>

</line>

<line>

<account>Account4</account>

</line>

<line>

<account>Account3</account>

</line>

<line>

<account>Account4</account>

</line>

<line>

<account>Account3</account>

</line>

<line>

<account>Account4</account>

</line>

<line>

<account>Account3</account>

</line>

<line>

<account>Account4</account>

</line>

<line>

<account>Account3</account>

</line>

<line>

<account>Account4</account>

</line>

<line>

<account>Account3</account>

</line>

<line>

<account>Account4</account>

</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

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

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