Article Details
Id: | 13786 |
Product: | finPOWER Connect |
Type: | FIX |
Version: | 3.00.00 |
Opened: | 27/04/2016 |
Closed: | 27/04/2016 |
Released: | 06/07/2016 |
Job: | J017301 |
Account Trial Balance and others; Data Export to "MS Excel Workbook" may incorrectly set columns
Performing a Data Export of the Account Trial Balance and other Reports to "MS Excel Workbook" may incorrectly set columns.
The first column's heading is correct, but the values in it are the Primary Key of the Account. All other columns are pushed over one column and the last column is not included.
For example, export the following columns Client ID, Client Name, AccountId, AccountName, Balance, BalanceOverdue and OverdueDays.
The workaround is to include the Pk column.