Ok sir, thanks for the clarification. One last thing, if I need to see the total fine of a patron, I will take sum of all the amountoutstanding for that borrowernumber, right? At some place I found someone to be taking sum of only the positive amountoutstanding, and ignoring the negative amountoutstandings. I couldn't understand why.
Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761 Personal Email <raghavarora...@yahoo.in> | University Email <f20171...@pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> On Thu, Jun 20, 2019 at 10:21 PM Michael Hafen <michael.ha...@washk12.org> wrote: > So that you know what the original amount of the fine is/was. This is > especially useful in an ongoing overdue fine, for example. The patron may > have some, but still has the book. So the script can look at what the fine > is supposed to be, and what it was last time the script ran (the amount > column) then add the difference to both the amount and amountoutstanding > columns. (Since we can't guarantee that the script is run once, and only > once, a day.) > > On Thu, Jun 20, 2019 at 3:05 AM RAGHAV ARORA < > f20171...@pilani.bits-pilani.ac.in> wrote: > >> Thank you sir, >> >> Can you please help me understand these tables? >> What is the purpose of the 2 tables 'accountlines' and 'account_offsets'? >> >> account_offsets is a child of accountlines, which allows 1 accountlines >> row to have multiple account_offsets, and the 'account_offsets.amount' is >> the total amount debited/credited. What exactly is the >> 'amountlines.amount'? >> In my database, there is an accountlines row which has 3 account_offsets >> rows linked, 2 of them credit $5, and 1 debits $10, making the >> amountoutstanding=0, which is expected. But accountlines.amount stores 10. >> Why is that so? >> >> Thanks in advance >> Regards >> *Raghav Arora* >> Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering >> Contact : (+91) 8474975691 >> Personal Email <raghavarora...@yahoo.in> | University Email >> <f20171...@pilani.bits-pilani.ac.in> >> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub >> <https://github.com/RAraghavarora/> >> >> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ >> *Birla Institute of Technology and Science, Pilani* >> Pilani campus, >> Rajasthan-333031 >> >> >> On Wed, Jun 19, 2019 at 10:25 PM Michael Hafen <michael.ha...@washk12.org> >> wrote: >> >>> Amount is the original amount of the fine/invoice, and amountoutstanding >>> is the remaining amount after receiving / sending some sort of payment. >>> There should be another row in that table, and a link in the accountoffsets >>> table, of those two columns aren't the same, but that's probably more than >>> you wanted to know. >>> >>> On Wed, Jun 19, 2019 at 5:13 AM RAGHAV ARORA < >>> f20171...@pilani.bits-pilani.ac.in> wrote: >>> >>>> Hello everyone, >>>> >>>> I am currently working on a project on Reports Management and Decision >>>> Support System for my institute library that uses Koha as it's ILS. I have >>>> a doubt in understanding what is the difference between the fields >>>> 'accountlines.amount' and 'accountlines.amountoutstanding'? >>>> >>>> Could someone help me out with this? >>>> >>>> Thanks in advance. >>>> >>>> Regards >>>> *Raghav Arora* >>>> Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics >>>> Engineering >>>> Contact : (+91) 9897597761 >>>> Personal Email <raghavarora...@yahoo.in> | University Email >>>> <f20171...@pilani.bits-pilani.ac.in> >>>> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub >>>> <https://github.com/RAraghavarora/> >>>> >>>> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ >>>> *Birla Institute of Technology and Science, Pilani* >>>> Pilani campus, >>>> Rajasthan-333031 >>>> _______________________________________________ >>>> Koha-devel mailing list >>>> Koha-devel@lists.koha-community.org >>>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >>>> website : http://www.koha-community.org/ >>>> git : http://git.koha-community.org/ >>>> bugs : http://bugs.koha-community.org/ >>> >>> >>> >>> -- >>> Michael Hafen >>> Washington County School District Technology Department >>> Systems Analyst >>> >>> > > -- > Michael Hafen > Washington County School District Technology Department > Systems Analyst > >
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/