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

▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
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

▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
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