Topic: Bug When Modifying Journal Entries
Hello,
I faced a problem with JV Inquiries :
1. when I enter any JV via |: Transactions / Journal Entry Web Page
2. I could not see it in : Inquiries and Reports / Journal Inquiry Web Page
3. to overpass this problem, I commented the lines # 28 in " audit_trail_db.inc "
as bellow :
// all audit records beside latest one should have gl_seq set to NULL
// to avoid need for subqueries (not existing in MySQL 3) all over the code
//$sql = "UPDATE ".TB_PREF."audit_trail SET gl_seq = NULL". " WHERE type=".db_escape($trans_type)." AND trans_no=".db_escape($trans_no)." AND id!=".db_insert_id();
// db_query($sql, "Cannot update audit gl_seq");
4. it works ok, but I faced another problem :
5. if you enter a simple JV via : Transactions / Journal Entry Web Page
6. Go to : Inquiries and Reports / Journal Inquiry Web Page
7. check the Amount of the transaction you will find it ok.
8. if you Try to modify it via the editor as permitted, then add any additional
transaction to this JV
9. Go back to : Inquiries and Reports / Journal Inquiry Web Page
10. You will see now that the Amount of the voucher displayed in the JV inquiry
page is amplified.
7. If you try to modify it again, the result will be another amplification of the
Amount of the JV in the inquiry page.
Please check. because it is very important when you enter JV's to have the option to review on screen to modify it on needed demand.
I noticed that, If I check the PDF report of the JV transactions, they appear ok.
I think it means that the problem is hoovering around the way the Amount of the JV is displayed in the "JV inquiry " web page.
Regards,
Khaled