Hello! We have a problem with reports hanging due to the system working to validate every check number issued (or not issued) for that bank account. We have one bank account for cash receipts and one for cash disbursements (to minimize our funds' exposure), so from a single bank account, we issue checks, payroll checks, payroll direct deposits and electronic funds transfers initiated by our bank or others' banks. Our Sage 100 set up is not connected to the internet, so we are not integrated with our bank. Each of these types of payments needs a reference (check) number assigned in Sage and it is impossible to assign numbers that have any meaning and keep them within a minimal range for Sage to generate reports in a timely manner. If we use eight of the ten digits permitted (using a date reference number), it creates a delta of 20,000,000 records, or more, that have to be "checked" or "validated." It took 45 minutes to run a payment history report for one vendor with 13 payments. Not good. I've asked and there is no reasonable solution for this (separate bank accounts for each type of transaction is not a reasonable solution), all Sage can say is to submit an enhancement request - personally, I think this is more like a program fix request since running routine reports, such as a payment history report, that takes 45 minutes cannot be considered industry standard.

by: Dawn M. | over a year ago | Financial Management