Topic Options
#28303 - 08/05/11 02:37 PM Bank Rec Posting Date
Barb9 Offline
Adagio Prodigy

Registered: 03/06/06
Posts: 273
Loc: Langley
We are using Bank Rec 8.1B. When we enter a new batch, a window opens that allows us to name the batch, and an option to date the batch. On Aug 2, we realized that there was a batch of cash receipts that should have been entered into July and so we opened a batch but did not change the date in the "new batch" area, we left at the default system date of Aug 2. In the actual batch, we did change the date to July 29, to match our transactions. When we posted the batch, a whole bunch of things happened, none of them good!

The BR batch posted into the month of Aug. From this batch, a batch was retrieved to AR. The AR batch retrieved into July, and the corresponding Ledger batch also retrieved into July.

If we have an AR or AP batch to do, within two different months, we can create one batch, and simply change the date on each transaction we enter. Why would the same thinking not apply for BR?

We've fixed the problem now, but it was really quite messy, and only because the same principle does not apply to BR that applies to AR and AP.

Barb

Top
#28312 - 08/08/11 06:22 AM Re: Bank Rec Posting Date [Re: Barb9]
Brian Stief Offline
Waterloo Guy

Registered: 04/04/06
Posts: 1733
Loc: Waterloo, Ontario, Canada
Hi,
Your problem would appear to be that you did not uncheck the deposit only box when you opened the new batch. If that box is left checked then the date posted is the date of the batch header, regardless of what date you enter in the line item details. While the terminology of "deposit only" is perhaps confusing as it still appears on all receipts/transfer/payments transaction headers, unclicking the box then allows the dates of the details to be posted separately. And would have prevented your mismatched processing periods situation from occurring.

What is more puzzling is why you are still entering a new batch into BR when you are using AR, AP, and GL. This old process was enhanced as a new feature a while ago. Normally a much better solution is to enter the cash receipts transactions into AR and retrieve all transaction into Bank Rec except for the EFT direct deposits/payments coming in from the bank statements. Again this presumes you have set up your payment method codes in AR, which is essential for using BR with AR so that you get effective subtotals by payment methods (in BR).

We would suggest getting your Adagio consultant to help you change this configuration to use the BR software more efficiently. If that is a problem, give us a shout to help make this simple change.

Best,
Brian
_________________________
Brian Stief,CPA,CA
Stief Group www.stiefgroup.com
Link2 Systems www.link2systems.com
800.540.3164

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 98 Guests and 4 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14446 Topics
70591 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30