Bug 8876 - branch not always stored in the stats table for payments
Summary: branch not always stored in the stats table for payments
Status: RESOLVED DUPLICATE of bug 11229
Alias: None
Product: Koha
Classification: Unclassified
Component: Patrons (show other bugs)
Version: 3.8
Hardware: All All
: P5 - low major (vote)
Assignee: Bugs List
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-10-04 11:55 UTC by Nicole C. Engard
Modified: 2015-01-06 21:48 UTC (History)
5 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Nicole C. Engard 2012-10-04 11:55:31 UTC
When making payments the branch is not always grabbed for the stats table and people really need that info for accounting purposes.  I have no nailed down when it's not saving yet but I wanted to report this so that we can look in to it.

This is true in 3.8 and master.  I have included the proccode in this in case that's the key - I don't know what these numbers mean.


mysql> select branch, datetime, type, proccode from statistics where type= 'payment' order by datetime desc;
+--------+---------------------+---------+----------+
| branch | datetime            | type    | proccode |
+--------+---------------------+---------+----------+
| NULL   | 2012-09-11 04:13:37 | payment | 32       |
| NIC    | 2012-08-23 11:34:56 | payment | 31       |
| NULL   | 2012-08-23 11:34:48 | payment | 21       |
| NIC    | 2012-08-02 14:19:53 | payment | 12       |
| NIC    | 2012-06-26 01:42:29 | payment | 26       |
| NIC    | 2012-05-14 07:53:22 | payment | 23       |
| NULL   | 2012-05-14 07:53:09 | payment | 19       |
| NULL   | 2012-04-11 20:41:57 | payment | 16       |
| NULL   | 2012-04-11 20:41:45 | payment | 16       |
| NULL   | 2012-04-11 20:39:55 | payment | 24       |
| NIC    | 2012-03-31 14:42:25 | payment | 31       |
| NULL   | 2012-02-28 09:51:41 | payment | 4        |
| NULL   | 2012-02-28 09:51:30 | payment | 3        |
| NULL   | 2012-02-28 09:51:10 | payment | 2        |
| NULL   | 2012-02-26 22:16:22 | payment | 2        |
| NULL   | 2012-02-26 22:15:56 | payment | 4        |
| FFL    | 2012-02-24 16:10:50 | payment | 50       |
| NULL   | 2012-02-24 16:10:41 | payment | 46       |
| NULL   | 2012-02-24 16:10:35 | payment | 44       |
| NULL   | 2012-02-24 15:51:01 | payment | 40       |
| NULL   | 2012-02-24 15:50:53 | payment | 40       |
| NIC    | 2012-02-24 15:50:08 | payment | 42       |
| NULL   | 2012-02-24 15:45:24 | payment | 38       |
Comment 1 Nicole C. Engard 2012-10-04 11:58:13 UTC
Here's the payment data as well .. 

mysql> select branch, datetime, type, value, proccode from statistics where type= 'payment' order by datetime desc;
+--------+---------------------+---------+----------+----------+
| branch | datetime            | type    | value    | proccode |
+--------+---------------------+---------+----------+----------+
| NULL   | 2012-09-11 04:13:37 | payment |   5.4000 | 32       |
| NIC    | 2012-08-23 11:34:56 | payment |  34.4500 | 31       |
| NULL   | 2012-08-23 11:34:48 | payment |  12.6000 | 21       |
| NIC    | 2012-08-02 14:19:53 | payment | 100.0000 | 12       |
| NIC    | 2012-06-26 01:42:29 | payment |   6.5000 | 26       |
| NIC    | 2012-05-14 07:53:22 | payment |  10.0000 | 23       |
| NULL   | 2012-05-14 07:53:09 | payment |  16.5000 | 19       |
| NULL   | 2012-04-11 20:41:57 | payment |   2.0000 | 16       |
| NULL   | 2012-04-11 20:41:45 | payment |   4.0000 | 16       |
| NULL   | 2012-04-11 20:39:55 | payment |   0.0500 | 24       |
| NIC    | 2012-03-31 14:42:25 | payment |  15.0000 | 31       |
| NULL   | 2012-02-28 09:51:41 | payment |   0.0500 | 4        |
| NULL   | 2012-02-28 09:51:30 | payment |  15.0000 | 3        |
| NULL   | 2012-02-28 09:51:10 | payment |   0.2100 | 2        |
| NULL   | 2012-02-26 22:16:22 | payment |   1.0000 | 2        |
| NULL   | 2012-02-26 22:15:56 | payment | 120.0000 | 4        |
| FFL    | 2012-02-24 16:10:50 | payment |  20.0000 | 50       |
| NULL   | 2012-02-24 16:10:41 | payment |   4.5000 | 46       |
| NULL   | 2012-02-24 16:10:35 | payment |   2.5000 | 44       |
Comment 2 alexh 2013-09-27 19:02:53 UTC
Has there been movement of fixing this bug?
Comment 3 Mathieu Saby 2013-11-11 22:03:12 UTC
Hi
I think it is a duplicate of bug 11229.
Can you confirm that?

Mathieu
Comment 4 Katrin Fischer 2015-01-06 21:48:37 UTC
Marking this duplicate to the other bug.

*** This bug has been marked as a duplicate of bug 11229 ***