Exporting finance structures into multiple columns
When exporting journal entries to a .CSV file, the Finance Structure is displayed as one concatenated field. This table contains examples:
Finance structure | Amount | Currency | Hours |
---|---|---|---|
CORE|8500|101|99800||||| | USD | ||
CORE|8500|101|12000||||| | 3,000.04 | USD | |
CORE|8500|101|18000|358654-2||GRANT 3|| | -750.01 | USD | |
CORE|8500|101|18000|358654-2||GRANT 3|| | -750.01 | USD | |
CORE|8500|101|18000|358654-2||GRANT 3|| | -750.01 | USD | |
CORE|8500|101|18000|358654-2||GRANT 3|| | -750.01 | USD |
You can change the .CSV file to save each part of the finance structure to an individual column.