Project

General

Profile

Time Spent - Custom Fields: Paid Jobs: Tracking amounts paid

Added by Jay Lepore almost 14 years ago

Hello,

We use freelance web developers in our business model. We use Redmine extensively for this. Thank you.

We create a project and assign issues to a developer. The developer updates the issue frequently along with their time.

This works great.

We need a way of entering in the Amount Paid to Developer, Date Paid just that lets our Bookkeeper have an ongoing tally of how much has been paid to a developer for each issue. We can then do a report for Time Spent (-) Time Paid = Time Owed x hourly rate = amount owed developer.

I have created the custom fields for Date Paid, Amount Paid in the Time Spent Custom Fields area but do not see where this information is being recorded and can be extracted.

See attached screen shot of the custom fields I created.

What sayeth the group?

Thanks


Replies (5)

RE: Time Spent - Custom Fields: Paid Jobs: Tracking amounts paid - Added by Felix Schäfer almost 14 years ago

By "can be extracted", do you mean in the redmine views or from the DB? If the latter, I think they are in a table called custom_values which should have a type column or similar, you'd have to filter them out by that column.

RE: Time Spent - Custom Fields: Paid Jobs: Tracking amounts paid - Added by Jay Lepore almost 14 years ago

Yes, I did find that table called custom_values. However, that just contains the 'title' of the custom value and not the data.

I have not been able to find out where the actual data is contained.

The row in that table looks like: type=TimeEntryCustomField, name=Paid Via, format=list etc...

However, it does not contain the data resulting from the selection ie; 'Paid Via' = PayPal, 'Amount Paid' = $210.00

I cannot find the data and I have dug in pretty deep. Do you know where that is kept for TimeEntryCustomField. I'd be willing to keep track of it externally however it would be nice if Redmine would keep a running total of things 'per issue' the same way it does with other Time Spent fields.

Your thoughts?

RE: Time Spent - Custom Fields: Paid Jobs: Tracking amounts paid - Added by Felix Schäfer almost 14 years ago

What you seem to have found is custom_fields, custom_values has the following structure for me:

  `id` int(11) NOT NULL auto_increment,
  `customized_type` varchar(30) NOT NULL default '',
  `customized_id` int(11) NOT NULL default '0',
  `custom_field_id` int(11) NOT NULL default '0',
  `value` text,

RE: Time Spent - Custom Fields: Paid Jobs: Tracking amounts paid - Added by Shane Pearlman over 13 years ago

We run the exact same business model and have a suite of plugin to address these issues, Most have been open sourced and live on eric davis' repository.

Rate plugin - allows you to assign a rate to a person (global and override by project) for a specific date range.

AP plugin - allows you to mark a specific time entry as paid and associated with an invoice. With this plugin you can run reports and get paid and unpaid time / budgets.

Overhead plugin - allows you to define time as billable to the project customer or overhead as a non billable cost. The status is assigned per activity type globally with a project level override.

Contracts plugin - currently in alpha, allows you to enters the terms of a client contract and have the data from the 3 plugins above populate it to create a running project score card.

RE: Time Spent - Custom Fields: Paid Jobs: Tracking amounts paid - Added by Mindaugas Banaitis over 13 years ago

Hi Shane,

we are also using this type of business and I am really interested to try your recommendations. But unfortunately I can not find AP plugin

    (1-5/5)