During posting of Invoices the calculated amount posted to GL and AR open would be incorrect in certain cases.
To create the problem create a sales order with multiple lines with the Same Part, Price and Qty. then invoice those items all on the same day and the values in gl and aropen will not balance to Invoice detail.
Steps to reproduce:
the file contain the fixed and it does work its been running on our server for the past week
Please take note i think there are still other problems with this select statement which needs further discussion as i think it can be broken in other ways.
Read more at http://www.xtuple.org/mantis/view.php?id=6392