Bank Register Descriptions too long, journal reference settings are overridden

I'm trying to simplify the Bank Register Descriptions that the system assigns to entries that are automatically created from batch entry when the "automatically create bank adjustments" option is selected – especially for RE batches. All our RE deposits hit the Bank Register with the Description format, “Adjustment-deposit #_______: Summary Cash/AR Only - Batch #________”. This is way too long, and the ONLY info that’s useful to us (Batch #) is at the very end, which always gets truncated reports or screen displays in FE (the “deposit #” is totally obscure, not relevant to us).

I’ve spent a lot of time playing around with this. I see two areas where my settings for Reference generation are being overridden by the system’s settings because of 'special mechanisms': one in RE and one in FE.

In RE, we post using the option “Post the transactions in Summary(Cash/AR Only)”. (This is the only way to do it that makes bank feed matching in FE NXT feasible… another story for another post.) When posting in this format, RE assigns its own Reference to the cash summary entr(ies) created – ignoring whatever Reference setup we have in Config, General Ledger settings. It doesn’t make a difference whether I select “Use default journal reference” or Use journal reference from Configuration” – in either case, Config is ignored, and the cash summary reference is always, “Summary Cash/AR Only - Batch #________”.

In FE, the problem is the system adding additional text in front of the Reference when you go to post that batch and the system automatically creates the bank adjustments for cash entries. The system adds to the front of the reference, “Adjustment-deposit #_______: “. I tried changing the settings in General ledger, settings, Posting info, Journal references, by changing the “Cash Management adjustment” reference settings – but once again, this makes no difference as the system ignores our Reference settings in favor of its own format for its 'special feature'.

If there were only a way to change EITHER the description assigned by RE’s “Summary Cash/AR Only” feature, OR the description assigned by FE’s “Create bank adjustments” feature, then I could get by. But as it is now, these bank register Descriptions are SO long – and to make matters worse, Blackbaud changed the coding in the Bank Feed matching screen so that column widths RESET every time you match items! So the batch number is always truncated at the very end and we’re constantly having to really maneuver to make it useful.

  • Casey Richey
  • May 23 2024
  • No Status
  • Attach files