It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Reporting → Customer Balances Report | Allocated
Hello...
I don't know if its a bug, if not..Please help me understand it..
when someone buy one of our products for lets say 1000$
and he pay only 200$.
why the allocated amount would be doubled so it shows the total of allocated 400 instead of 200.
Which version of FA are you using on what versions of PHP/MySQL and what platform?
What menu navigation steps did you use to achieve your output?
Whether Bank Payment or Customer Payment / Allocation was used?
Attached you output for forum self-sufficiency.
The Training Company (Demo Data)'s Customer Balance Report 101 is what you should have unless you customised your report and/or are using an older version of FA.
Which version of FA are you using on what versions of PHP/MySQL and what platform?
What menu navigation steps did you use to achieve your output?Whether Bank Payment or Customer Payment / Allocation was used?
Attached you output for forum self-sufficiency.
The Training Company (Demo Data)'s Customer Balance Report 101 is what you should have unless you customised your report and/or are using an older version of FA.
Thanks for your reply..
php version is 5.6.35
Mysql version is 5.1.73
i am using Fronaccounting 2.3.25
the steps to reproduce this output ..
1- Creating a Direct Invoice from the Sales page.
2- Payment due within 10 days or Cash only "Same Result"
3- Place Invoice
4- Entry customer payment for this invoice
5- i allocate the paid amount, tried with petty cash and bank account.
6- going back to the sales page.
7- Customer and Sales Reports.
8- Generating customer balances with both Show Balance on and off.
Kind Regards.
Could it be a mistake in the Arabic CoA ??
Translate the Arabic CoA into English and compare with the equivalent en_US one.
Your steps are okay.
Try the en_US-demo.sql and see if the error appears.
Hello,,
i have tried again.. this time with fresh 2.4 "2/5/2017 build" installed on my localhost
using the same steps..
and this time with the default English language and CoA..
the result is exactly the same..
i bought a product for 550..
paid cash, so nothing was left to allocate..
then bought a product for 25,000.00
i paid 15,000.00
so 10,000.00 was left to allocate.
the allocated amount was once again Combined
so 10000 + 10000 + 550 + 550 = 21,100.00
https://ibb.co/cgzN0k
This issue has been test committed out in FA 2.4 unstable repo. Please provide feedback with PHP 5.3 and MySQL 5.1.
@joe: please update the FA 2.3 repo as well if it works since we do not want the stable version to have glaring bugs such as this.
The allocated column should only be seen isolated for each record.
The mistake here is, that the column has been totalized. This should not have been done. Or it should show a minus sign for payments so the totalisation would be correctly presented.
Will fix this.
Joe
Hello,
i tried the fix but it Doesn't seem to be working. "tried on both php 5.6 and 5.4"
also tried using FA 2.3.25 and 2.4,, the result remains the same.
This has now been fixed in both the 2.3 stable repo as well as the 2.4 unstable repo.
In the allocated columns a correct - sign is shown for credit allocations and the summations are now also correctly done.
/Joe
This has now been fixed in both the 2.3 stable repo as well as the 2.4 unstable repo.
In the allocated columns a correct - sign is shown for credit allocations and the summations are now also correctly done.
/Joe
Thanks...
i just dont seem to get along with gitub ...
would you please add a direct link to 2.4 unstable repo ??
Kind Regards.
Please use this link for customer balance.
https://sourceforge.net/p/frontaccounting/git/ci/unstable/tree/reporting/rep101.php
Abd this link for supplier balance
https://sourceforge.net/p/frontaccounting/git/ci/unstable/tree/reporting/rep201.php
Please be aware that these links are for 2.4
Joe
@joe ..
Thanks,,
seems to be perfect now.
FrontAccounting forum → Reporting → Customer Balances Report | Allocated
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.
