Alliance Partner

DATEV Interface in NetSuite – Journal Entry

One of our European clients in the Furniture industry had a custom requirement in NetSuite regarding journal entry export.

Requirement

The requirement of the client was to export the journal entry details as CSV item line details from NetSuite to use in a third-party system. The challenges our developers faced during development were,  

Only ‘xls’ Excel format is supported in NetSuite, ‘xlsx’ is not supported. 

Limitations of Saved search functionality.

The client required the CSV import to have the following details: 

Amount in EUR

Debit/Credit

Account No.

Contra Account No.

VAT-Key

Date

Invoice No.

Description

EU-Country and VAT-ID-No

EU-VAT tax rate

Solution

The requirement analysis brought our developers to two alternatives – either to use a saved search or add a ‘button’ in journal entry. Our developers initiated the development through adding the ‘button’. Refer to the image below for better understanding.  

 

The user can fetch the details from the journal entry and produce the CSV file on ‘button click’. The click will trigger the script and render the data into CSV or Excel. Refer the image below for the final CSV output.  

Result

The NetSuite customization was successful and aligned with the client requirement. The customization now helps the client to effortlessly download the journal entries in CSV or excel format.  

Schedule A Free
NetSuite Consultation

NetSuite consulting or development services when you need it as you need it.

Schedule Now