How to Map Credit and Debit Accounts for Journal Entry in NetSuite Connector When Only One Line:account Field is Available?

Integrator.io
1

Hi everyone,

I'm trying to create a Journal Entry in NetSuite using the Celigo NetSuite Connector. I receive a single row of data from a CSV file that represents one transaction, and I want to create two lines in the Journal Entry: one for the debit and one for the credit.

However, in the NetSuite mapping stage, I only see one field available on the NetSuite side: Line:account. I'm not sure how to differentiate or map both the credit and debit accounts when I only have one Line:account field to work with.

Has anyone done this before? Is it even possible to create two lines from a single CSV row in this way? If so, how should I set up my mapping or transformation to split one row into two journal lines?

Any help or example mappings would be greatly appreciated!

Thanks in advance!

2

You would need to make a script, could be preSavePage, preMap, postResponseMap script, or transform script. In the script, you should make a new field in your record for lines, then have the script generate 2 lines for you. From there, you would then map that into NetSuite.