1 (edited by Kalido 12/15/2009 05:50:51 pm)

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

Re: Bug When Modifying Journal Entries

Hello Kalido,
We are looking into this. Will be fixed soon. We are short of developers right now, but early next week it should be fixed.

/Joe

Re: Bug When Modifying Journal Entries

Yes, there is problem with incorrect amounts in journal inquires, when bank account is used. This will be fixed as Joe stated.

But I can't reproduce problem reported in p 1-2. Moreover p.3 is not acceptable fix - this would lead to inconsistent audit_trail table.

Janusz

Re: Bug When Modifying Journal Entries

thanks for your responses:

note : I use PHP 5.2.8 & Mysql 5.1.3. w/ WAMP

The initial Problem I faced w/ JV entries, was in the past versions:

1. When I enter the JV's and go to JV's Inquity i do not see what I entered p1-2.

2. I made changes as mentioned in p.3 before. it works then.


Now I rechecked the original copy of Ver 2.2, and saw that is ok, no need at all of that. No need to comment # lines # 28 in : audit_trail_db.inc , as I did before.


Exactly as " Janusz " said.


khaled

Re: Bug When Modifying Journal Entries

Hello,

I hope you are all fine in this new year.

Does the Journal Entry Modifications was resolved (Amplification of the figures) ?

I noticed that is resolved in the demos or what ?

Thanks.


Khaled

Re: Bug When Modifying Journal Entries

The Journal Inquiry was rolled back to how it worked before the join of bank transactions.

/Joe

Re: Bug When Modifying Journal Entries

Please update your FA sources  to 2.2.2 version to fix the problem.
Janusz

Re: Bug When Modifying Journal Entries

which file I need to download and update ?

khaled

Re: Bug When Modifying Journal Entries

There was a couple of bug fixes since 2.2.1., so the best you can do (if you have plain, not customized FA installation) is to download 2.2.2 tarball from sf.net and unpack in your FA directory. The exact file related to this issue was most likely /includes/ui/allocation_cart.inc, and maybe /sales/includes/cart_class.inc (see stable branch CVS Changelog and/or mantis reports)
Janusz

Re: Bug When Modifying Journal Entries

Thanks,


I will move to Ver 2.2.2



khaled