CiviCRM Community Forums (archive)

I just had another thought about the need of adding a column to the civicrm_contribution table or civicrm_line_item table and I wonder if it is necessary at all or even a good idea. It hinges on whether I am correct in my understanding about whether when a transaction is made the related entries will be recorded in the civicrm_financial_item table.

At the moment on my test site it only appears that the entry for the account that holds the "Income Account is..." relationship is recorded in the civicrm_financial_item table but if all related account transactions are recorded in this table we don't need to duplicate the data elsewhere; we just need to join on the recorded tax data when we pull the report.

The benefit I see of this is that the report can dynamically add tax columns based on the number of tax types it returns in the query whereas if we decide to add a tax column to the civicrm_contribution table every new tax added will have to alter the table.

Any thoughts?

Ok, so I guess what is holding us up is the lack of a Tax Rules mechanism to define our rules for how a specific tax is associated with a particular financial type within core.

I don't see this as being a particularly complicated mechanism. All it needs to do is relate taxes declared in the Financial Accounts table with Financial Types. Since we can't be sure when this will happen and it's holding things up, I suggest we build it ourselves keeping in mind that we will detach it at some point when it is available in core. We should be able to manage this within a single database table.

Any thoughts?

Edit: What I mean by any thoughts is, is there any reason why we shouldn't move ahead. Business is ratcheting up for us at the moment but I'm still in the mood to donate, pledge, etc... time and resources to move forward with this. 

Andrew

Hi all,

I've put my work on the tax extension on the back burner recently because a couple of other jobs came up however, one of the jobs I'm working on will require it at some point so I'm keen to work on it if anyone else is interested.

Hi everyone,

I moved this topic to the main Extensions forum section (instead of the "new extensions" sub-forum).

We are going to delete the "New extensions" sub-forum since there is low-traffic and it will provide better visibility to these discussions.

Mathieu

I have an immediate need and would be interested in being directed to latest codebase so that I can implement and test for a WordPress site.

Wonderful, thanks Andrew. My need is to support Canadian taxes in WordPress.

Thanks lolas,

So was this achieved without an extension at all? It sure would be cool to be able to do it with a recipe rather than an extension but I couldn't figure out how to do that.

In the extension, I injected jQuery into specific pages on the page build and form build hooks.

I have to deal with some daily things first but I'll report back this afternoon (evening for you guys) and we'll see if we can get this back on track.

lolas: I'm really interested in more about what you guys achieved and how you achieved it. In previous attempts I hacked core templates and added code right in the payment processing classes which is completely unmaintainable but had to be done at the time. I'll never do that again 

Yes, I figured there had to be a module in there somewhere but it sounds like your solution was cleaner than my first attempt. I'm excited to get some interest in this again. I'll post back tonight.

Cheers,
Andrew