Answers.Body: <p>When someone adds a Contribution via the backend (eg Add Contribution) then an Activity is created (Type = Contribution) which will record who added that Contribution.</p>
  
  <p>If you use that fact, and set up your 'users' in a Group either manually or smart group per Aidan's answer, then you might be able to build an Activity based report to show the contributions they added.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-28T21:40:31.637Z
Answers.Text: Yes. I think that’s what I needed. I have already included users in a group. Thanks for the hint
Answers.UserDisplayName: Tapash
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-29T05:43:56.567Z
Answers.Text: Great, can you accept the answer?
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-29T08:22:39.650Z
Answers.Text: Is there a chance I could include "Payment method" option appear in one of the column in the report? thanks
Answers.UserDisplayName: Tapash
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-29T13:01:58.693Z
Answers.Text: I also would like to see the donor name in the report. it seems only in certain conditions donor name (target name) appears in report. is there a way to achieve this please? thanks
Answers.UserDisplayName: Tapash
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-29T18:46:45.610Z
Answers.Text: have a look at the actual Activities, do they all have 'target name'. if so it does seem odd if the Report then misses some out.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-29T18:47:45.780Z
Answers.Text: other option would be to look at doing this in drupal views. not sure about the Payment method. Since it is not part of the Activity then I don't think you can get that via this route.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-28T20:09:18.840Z
Answers.LastActivityDate: 2019-04-28T20:09:18.840Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>You could sync your Drupal role to a Civi group with the <a href="https://docs.civicrm.org/sysadmin/en/latest/integration/drupal/#civigroup-roles-sync" rel="nofollow noreferrer">CiviGroup Roles Sync module</a> then use the group in the report filter criteria.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-28T21:41:00.697Z
Answers.Text: How do I install this module?
Answers.UserDisplayName: Tapash
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-29T08:43:09.290Z
Answers.Text: It's installed with the normal CiviCRM Drupal package of files so just go to your Drupal modules page and enabled it.
Answers.UserDisplayName: Aidan
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-26T09:41:23.900Z
Answers.LastActivityDate: 2019-04-29T08:43:32.577Z
Answers.LastEditDate: 2019-04-29T08:43:32.577Z
Answers.UserDisplayName: Aidan
Answers.Body: <p>If you have sql skills you may be better with an sql query of the log_civicrm_contribution table with left joins 'Group' so you can filter to the 'Shop' people, and just look for the 'insert' value in the log table. Then you may be able to join in the other values you are saying you need in </p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-29T19:16:36.233Z
Answers.LastActivityDate: 2019-04-29T19:16:36.233Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>Finance department wants a weekly report of contributions taken by our shop. I have set up a drupal user role called "Shop" and permissions accordingly, and added staff to that role. But cant figure out how can I generate the report for the contribution specifically created  by those staffs of “SHOP”. Any help would be appreciated. Thanks</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-04-26T04:09:33.767Z
Comments.Text: "contribution specifically made by those users" - which 'users'? those with the Role = Shop? Doesn't make sense to me.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-04-26T20:11:00.683Z
Comments.Text: Thx. It didn't make sense to me that it would be the staff of shop who do the purchases, but i guess you have it set up so the purchase is made in their name rather than the customer. You could also use a unique Contribution Type called 'shop purchases' perhaps, so it isn't actually about 'who' buys it but 'what gets bought'?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-04-27T12:16:00.230Z
Comments.Text: I think my question still not clear enough. Sorry! What I want is, a list of Contribution details (mostly cash donation handed in person by donor) inputted into CiviCRM by a group of backoffice user to spot any discrepancies.
Comments.UserDisplayName: Tapash
Tags: <civireport><roles>
Title: How can I generate a report for the financial transaction entered by USERS of certain "drupal Role"?
ThreadText: # How can I generate a report for the financial transaction entered by USERS of certain "drupal Role"?
  
  (Asked by: username_0 on 2019-04-25)
  
  Finance department wants a weekly report of contributions taken by our shop. I have set up a drupal user role called "Shop" and permissions accordingly, and added staff to that role. But cant figure out how can I generate the report for the contribution specifically created by those staffs of “SHOP”. Any help would be appreciated. Thanks
  
  **Tags:** civireport, roles
  
  > **Comments:**
  > **username_1**: "contribution specifically made by those users" - which 'users'? those with the Role = Shop? Doesn't make sense to me.  
  > **username_1**: Thx. It didn't make sense to me that it would be the staff of shop who do the purchases, but i guess you have it set up so the purchase is made in their name rather than the customer. You could also use a unique Contribution Type called 'shop purchases' perhaps, so it isn't actually about 'who' buys it but 'what gets bought'?  
  > **username_0**: I think my question still not clear enough. Sorry! What I want is, a list of Contribution details (mostly cash donation handed in person by donor) inputted into CiviCRM by a group of backoffice user to spot any discrepancies.  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_1 on 2019-04-28. Score: 1 | Accepted answer
  
  When someone adds a Contribution via the backend (eg Add Contribution) then an Activity is created (Type = Contribution) which will record who added that Contribution.
  
  If you use that fact, and set up your 'users' in a Group either manually or smart group per username_2's answer, then you might be able to build an Activity based report to show the contributions they added.
  
  > **Comments:**
  > **username_0**: Yes. I think that’s what I needed. I have already included users in a group. Thanks for the hint  
  > **username_1**: Great, can you accept the answer?  
  > **username_0**: Is there a chance I could include "Payment method" option appear in one of the column in the report? thanks  
  > **username_0**: I also would like to see the donor name in the report. it seems only in certain conditions donor name (target name) appears in report. is there a way to achieve this please? thanks  
  > **username_1**: have a look at the actual Activities, do they all have 'target name'. if so it does seem odd if the Report then misses some out.  
  > **username_1**: other option would be to look at doing this in drupal views. not sure about the Payment method. Since it is not part of the Activity then I don't think you can get that via this route.  
  
  ---
  
  ### Answer by username_2 on 2019-04-26. Score: 2
  
  You could sync your Drupal role to a Civi group with the [CiviGroup Roles Sync module](https://docs.civicrm.org/sysadmin/en/latest/integration/drupal/#civigroup-roles-sync) then use the group in the report filter criteria.
  
  > **Comments:**
  > **username_0**: How do I install this module?  
  > **username_2**: It's installed with the normal CiviCRM Drupal package of files so just go to your Drupal modules page and enabled it.  
  
  ---
  
  ### Answer by username_1 on 2019-04-29. Score: 0
  
  If you have sql skills you may be better with an sql query of the log\_civicrm\_contribution table with left joins 'Group' so you can filter to the 'Shop' people, and just look for the 'insert' value in the log table. Then you may be able to join in the other values you are saying you need in
  
  
  ---
  
  