Bank Book module

[dgillz]

I admittedly do not work much with this module, but I am seeing deposits showing up in the bank reconciliation by date screen as credits.

A SQL query shows the raw data is also a credit.

The bank reconciliation report itself is fine and we are balanced, but the screen balance and the underlying data is hosed!

On a sidebar, deposits made to the GL via Macola's credit card processing are not showing up in Bank book at all, and we had to enter thse manually via open item load.

Its the weekend and I have not heard from Exact tech support but I was wondering if any of the tek-tip gurus have any insights on this.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra

 

[NEmacGuy]

Don
Bank books reports like a bank. A bank credits your account when you make a deposit and debits your account when you write a check. In G\L your cash account is debited for receipts and credited for payments.
So it sounds like you are ok.

Deposits not hitting bank books do to Credit Card Processing, have yet to use it, but for a transaction to get to bank book in native macola, it must be from AR, AP, OE Cash Receipt, or dirrectly in Bank Book.

My guess you may be hitting a bug. Check your deposits posting report. Any error messages. I know of one issue that I am not sure if it has been catagorized as a bug, but is a real pain, (old code) if you wrote a check number 71006 and today posted a cash deposit number 71006, the second transaction will not post to the bank rec open item file. Index issue. They should include doc type, seq_no is always 0 on AR and AP transactions.

INDEX [IBBOPNFIL_SQL0] ON [dbo].[BBOPNFIL_SQL] ([cash_mn_no], [cash_sb_no], [cash_dp_no], [doc_no], [seq_no])