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 <raghavarora999@yahoo.in> | University Email <f20171016@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.hafen@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 < f20171016@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 <raghavarora999@yahoo.in> | University Email <f20171016@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