Solving for Need for Dynamic FIelds

[Jens Salvesen]

Hi!

I am trying to come up with a solution for the following issue:

Jira is currently used by my company to facilitate contract processing.

One issue type is for a contract, another for an amendment, and the last one for an invoice.

Currently the "component/s" field is being used to track cost center(s), which essentially tells us which area of the company the costs should be charged to.

The problem with this is, the multi-select "component/s" field exports in excel with all cost centers in the same column, and does not allow for us to provide the cost split between multiple cost centers. 

In addition, reports via gadgets that we use end up showing an incorrect sum, i.e. for a contract worth $1000 that is split 50% (or $500) between two cost centers, the resulting graph shows $1000 for each cost center because the total is applied in full to each one. 

I am currently considering adding more fields to accommodate (which brings in it's own unique issues that might exacerbate the issue) or finding a plugin that could assist which would allow for relational fields and/or fields that could be added as needed from within an issue's edit screen. 

Any suggestions?