How to generate CSV with huge data rows in GL Journal Import FBDI Template

Isuse: When Journal Import FBDI template has huge data rows, for example more than 45000 rows, the"Generate CSV" button may not work properly or take too much time.

Solution: You can manually create CSV file by following below steps in that situation:

Step 1: Go to column last to the column at the end of FBDI template (always check latest template). In my example, it is "ET"

Step 2: Populate all the cells under above column with "END" till the data is provided in first column

Step 3: Move this sheet to new workbook (Right click on GL_INTERFACE sheet)— Don't forget to select checkbox- "Create a copy"