integrating KOHA with other financial system
Hello Team, Im pretty new here, I have query where I have been tasked with getting fines from the koha system and exporting this to the existing ERP the insitute is using, I have managed to create a sort of a bridge to export from koha to the other database, from the database level, I am using the table "accountsline" table and successfully took my records to the finance ERP... the payments are done there and I need to update my koha I am inserting back to the same table successfully but when I go to the patrons' fines list in koha the entry "my payment" is there but the total havent cleared what do I need to do here. thanks -- Dennis K. Njuguna
Dennis Njuguna schreef op wo 13-11-2013 om 13:22 [+0300]:
the payments are done there and I need to update my koha I am inserting back to the same table successfully but when I go to the patrons' fines list in koha the entry "my payment" is there but the total havent cleared what do I need to do here.
When updating the accountlines table you need to go and retroactively update the totals for the borrower. Here's an example from a script that I use when migrating accounts from a legacy system to Koha: https://gitorious.org/koha-migration-toolbox/koha-migration-toolbox/source/a... this function goes through all the borrowers that have been updated and "replays" the transactions to keep the totals in sync. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
Robin Sheat, You have no idea how you have saved me, thanks a million It worked.... On Thu, Nov 14, 2013 at 12:16 AM, Robin Sheat <robin@catalyst.net.nz> wrote:
Dennis Njuguna schreef op wo 13-11-2013 om 13:22 [+0300]:
the payments are done there and I need to update my koha I am inserting back to the same table successfully but when I go to the patrons' fines list in koha the entry "my payment" is there but the total havent cleared what do I need to do here.
When updating the accountlines table you need to go and retroactively update the totals for the borrower.
Here's an example from a script that I use when migrating accounts from a legacy system to Koha:
https://gitorious.org/koha-migration-toolbox/koha-migration-toolbox/source/a...
this function goes through all the borrowers that have been updated and "replays" the transactions to keep the totals in sync.
-- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Dennis K. Njuguna
participants (2)
-
Dennis Njuguna -
Robin Sheat