Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Serious Issue: Bank Account Balances wrong in Balance Sheet
05-05-2018, 01:15 AM (This post was last modified: 05-05-2018 05:41 AM by donnell_512.)
Post: #1
Serious Issue: Bank Account Balances wrong in Balance Sheet
I use webERP version 4.14.1.
I noted a discrepancy in the Bank Account balances shown on Balance Sheet.
When I run the "Daily Bank Transactions" for accounts both in my Base Currency (CHF) and other currencies (EUR), the balance shown is correct for each and every day.
When I print the month and Balance Sheet, the amount shown for Bank Accounts is incorrect.

For example:
Date ....... | ...... Daily Bank Transactions ....... | . Balance Sheet . |
.............. | Balance in CHF | Running Total CHF | ....................... |
31.12.2017 | .. 4,679.85 .... | . 4,679.85 ......... | . 5,131.52 ........ |
30.11.2017 | . -1,446.63 .... | -1,446.63 .......... | .. -994.96 ........ |

The situation is much worse for Bank Accounts in non Base Currency (EUR).
For example:
Date: ...... | ...... Daily Bank Transactions ....... | . Balance Sheet . |
.............. | Balance in EUR | Running Total CHF | ....................... |
31.12.2017 | .. 4,679.85 .... | -1,689.54 .......... | -32,735.69 ........ |
31.08.2017 | .. 9,450.45 .... | . 4,352.45 ......... | . 14,834.91 ....... |

Here BOTH the "Running Total in CHF" and "Balance Sheet" are inconsistent.

CHECK TOTALS in balance sheet show 0

I tried to run the following utilities but the issue did not correct:
- Re-Post all GL transactions from a specified period
- Re-calculate brought forward amounts in GL

Any idea to restore the correct balances?
Thank you very much for your help.


Attached File(s)
.zip  BankAccountsError.zip (Size: 144.48 KB / Downloads: 3)
Find all posts by this user
Quote this message in a reply
05-05-2018, 02:31 AM
Post: #2
RE: Serious Issue: Bank Account Balances wrong in Balance Sheet
The CHF account went 451.67 out in November and then stayed that amount out in December.

I know it's an obvious question but is there a transaction for 451.67 in November?

It will be easiest to sort out the CHF account first and it may give us a pointer to why the EUR account is also out.

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
05-05-2018, 05:48 AM (This post was last modified: 05-05-2018 06:04 AM by donnell_512.)
Post: #3
RE: Serious Issue: Bank Account Balances wrong in Balance Sheet
Hi Tim, thanks for your reply.
After inquiring, I realized that the first discrepancy in the CHF account popped up back in July 2016.
On 21.07 I input for the first time a transfer from the EUR account to the CHF account. I suspect this is the transaction which triggers the error.

I have attached to the original post some info which I hope will help in tracking down the issue.
Thanks,
Donnell
I also checked the Exchange Difference in the General Ledger Journal Inquiry and spotted some anomalous entries, which may be connected.
From 10.10.2017 onwards, there are revaluations on the EUR account of a size incompatible with the balance of the account.
Seems likely the difference is posted here to agree.
See attached,
Thanks


Attached File(s)
.pdf  Exchange_Difference.pdf (Size: 192.27 KB / Downloads: 5)
Find all posts by this user
Quote this message in a reply
05-11-2018, 11:43 PM
Post: #4
RE: Serious Issue: Bank Account Balances wrong in Balance Sheet
Dear Tim,
sorry to insist, but could you understand what happened?
Do I need to dig additional info?
Thanks
Find all posts by this user
Quote this message in a reply
05-21-2018, 06:35 PM
Post: #5
RE: Serious Issue: Bank Account Balances wrong in Balance Sheet
Hi Tim,
since I see no follow up to this bug, I am left with no other option but to abandon Weberp. It's a pity as believe it's a good product, but lack of support leaves me with no option but to abandon this otherwise great solution.
What a pity!
Find all posts by this user
Quote this message in a reply
05-21-2018, 09:54 PM (This post was last modified: 05-21-2018 09:57 PM by VortecCPI.)
Post: #6
RE: Serious Issue: Bank Account Balances wrong in Balance Sheet
A signed NDA followed by a SQL dump would allow Phil or Tim the ability to see actual data and likely aid with a solution.

Have you reached to Phil at LogicWorks yet? http://www.logicworks.co.nz

Phil has been VERY helpful to us in our webERP endeavors.

And... webERP meets our every need so far...

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
05-23-2018, 12:14 AM
Post: #7
RE: Serious Issue: Bank Account Balances wrong in Balance Sheet
hi, donnell,

I have client has run webERP in a multiple currency business environment over years.
And those bugs have been fixed along with it.
It's better to view the details to check what's goes wrong.
You can mail your sql to my email address: hexinfans@gmail.com if you like it.
Best regards!
Exson
Find all posts by this user
Quote this message in a reply
06-17-2018, 04:28 AM (This post was last modified: 06-17-2018 04:29 AM by TurboPT.)
Post: #8
RE: Serious Issue: Bank Account Balances wrong in Balance Sheet
Donnell, there was a calculation matter that Paul B. found in DailyBankTransactions.

You can get the 2-line update fix here.
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)