Proposal summary

The requirement put forward was to provide a way for exporting journal entry item line details as CSV files. The solution we are proposing is to use either a saved search or adding a button in a journal entry

Requirement

The requirement was to export the journal entry details as CSV files from Netsuite to use for a third-party system. The CSV import should have the following details

• Amount in EUR
• Debit/Credit
• Account No.
• Contra Account No. [We haven’t seen any field name like this journal entry]
• VAT-Key
• Date
• Invoice No.[We haven’t seen any field name like this journal entry]
• Description
• EU-Country and VAT-ID-No
• EU-VAT tax rate

Our Solution

We would like to propose two solutions for achieving the same

Solution 1

This would be a scripting solution.

We need to add a button in the journal entry. On the click, the button will fetch the mentioned details from the journal entry and produce the CSV file.

We will create a user event script to add the button in the journal entry.

We will create a Client script to perform a button click function.

And a Suitelet script to perform the fetching and rendering of data into CSV OR EXCEL

• Rendering into Excel will take more time than CSV and in CSV the styling options such as making the heading bold and all are not supported. Please confirm whether we need to do it in excel or CSV.
• Only xls Excel format is supported in Netsuite. xlsx is not supported.
• Users will be able to download the data directly from the journal entry record.
• This solution will take more time and effort for developing

Solution 2

Another solution is to use a saved search with an available filter that will display the following results.

• Amount Debit
• Amount credit
• Account Name and Number
• Contra account No (We couldn’t able to find these values in journal entry)
• VAT Key (Please confirm where we need to take value for this field)
• Date
• Invoice number (We couldn’t able to find these values in the journal entry)
• Description (memo)
• Country – In the following case country would be Germany
• Tax item (We believe that VAT ID is the tax item name. Do we need country and ID in the same field. Please confirm)
• Tax rate

There will be an available filter in the Saved search. In which we add the journal document number and click enter.

The sample saved search with these values is shown below.

Please check the JOU_1094 journal and check whether the data showed is as expected.

We can download these results in excel.

• The results modification and fetching will be limited in the case of the saved search. But it will be less time-consuming.
• The user would need to go to the search results all the time and add the Journal entry number in the search filter to get the results. We won’t be getting it directly from the journal entry.
• We can download the result directly from the search in Excel format. Only XLS excel format is supported in Netsuite

Please check both of the solutions and confirm with the more feasible solution according to the requirement.

Assumptions

We believe that if we are using the script, we can convert the data into CSV format while downloading. For CSV the styling possibilities are not available. So the heading in bold letters as given in the sample file will not be done.

If we need it in excel format, we need to render it to excel which will take more time. Please confirm whether we need to do it in excel or CSV

We are not sure about the field “Invoice Number”. Please check and confirm.

The following are our field mapping assumptions about the mentioned field in CSV

• Vat Key —> Tax Item
• Description —> Memo
• EU Tax rate —> Tax rate

We didn’t understand the difference between Vat Key and Vat ID NO. Please confirm about it. There is no sample value for the VAT ID number in the shared excel sample sheet.

In the Debit/credit field, the values are S & H. We believe that S indicates Debit and H indicates Credit. Please confirm.

Do we need EU Country and VAT ID number in the same column? Please confirm.

Risks

• Only xls Excel format is supported in Netsuite. xlsx is not supported.
• Saved search functionality is limited.
• Some of the following fields are not in the journal entry record
  • Contra account No
  • Invoice number

Time

Description	Time Required
Solution 1: Script to add the button to download the CSV file & Testing	20 hr
Solution 2: Saved search to display the details as mentioned above & Testing	8 hr

Additional Recommendations

If it is possible please provide the excel file mapping to the Netsuite field. That would be very helpful