• Transition from TASBooks to Sage 50
    Easy with the Right Partner and Remarkably Beneficial
  • Transition from TASBooks to Sage 50

KB Category: Sage 50 Reports

Slow running Bank Rec Report

Written by Pimbrook Support on .

Running the bank rec report was taking some time to run and the same amount of time to export to excel.

Report Running Slow

Report from the bank rec screen taking a very long time to come up

 

Solution

Untick the box(Group items in Bank Rec) try report again it should instant or a lot quicker

 

Please Note: To group bank payments and bank receipts, which have the same reference and date in the bank activity, select this check box.

Note: This doesn’t work retrospectively. If you change this check box, it only affects transactions that you post after you change the setting.

 

Download and run the Aged Reconciliation reports (4)

Written by Pimbrook Support on .

Download and run the Aged Reconciliation reports (4)

If the previous steps have not highlighted the discrepancy, it is likely that it is caused by the allocation dates on some transactions.

For example, a PI dated after the report date, has been allocated to a PC with an allocation date prior to the report date. The Aged Reconciliation reports highlight any transactions with allocation problems or links removed.

For a more detailed explanation of link removed transactions, please refer to article 14578.

To download the Aged Reconciliation reports

Sage Accounts v21 and above – Download and restore the Sage Accounts v21 and above – Additional Reports Backup.

Sage 50 Accounts 2014 (v20) and below – Download and restore the Sage 50 Accounts 2014 (v20) and below- Additional Reports Backup.

Sage Instant Accounts 2014 (v20) and below – Download and restore the Sage Instant Accounts 2014 (v20) and below- Additional Reports Backup.

For further information about how to download and restore these, please refer to article 28447.

 

Click here Continue to (5) or  here to go back to Summary

Aged Debtors Report and Debtors Control Account do not match (Sage Accounts)

Written by Pimbrook Support on .

Reasons this will happen:

 

  1. A journal has been posted to the Debtors Control Account and this will not wash out so it has to be reversed or highlighted to prove the difference
  2. A Receipt has been allocated to an invoice with a future date.

 

 

To find out if a Journal has been entered, go to Nominal Reports/Day Books and select Day Books: Nominal Ledger.  When the Criteria box appears, put in the dates and select 1100 Debtors Control Account. If the report is blank then proceed to Future Allocations Query.

 

To find out Future Allocations, go to Customer Reports/Aged Debt Rec Reports, if you do not have this selection of reports contact Support.

Run the various reports and it will highlight any transactions that were allocated after the month end/year end date.  You can fix the dates via Transactions by clicking Unallocate and then allocate again with the correct date.

Sage 50 Reports – ‘Generic COM Error’ or ‘Failed to Output’

Written by Pimbrook Support on .

If you’re using Microsoft Outlook, when you try to email documents from Sage Accounts or Sage 50 Payroll one of the following message may appear. These can be due to environmental settings or report specific issues.

‘Unable to send all emails.’

‘ExtendedErrorCode.COMError: “Generic COM Error’

‘Failed to output to email’

Not using Microsoft Outlook? Check your SMTP settings and check that your webmail password is correct. For information about SMTP settings in Sage Accounts, refer to article 12659.

 

Check you use a compatible version of Microsoft Outlook

1. Check your version of Outlook is compatible with your Sage software and you’re using the desktop version and not cloud based.

If you don’t have a compatible version of Outlook, to email from your Sage software use SMTP settings instead.

2. Install all updates for the version of Outlook you’re using. Read more >>

3. Try emailing your document again.

 

Check Run as administrator settings are the same for Outlook and your Sage software

1. Close all software, right-click the Outlook shortcut then click Properties.

2. Click the Compatibility tab, check if the Run this program as an administrator check box is selected or clear, click OK.

3. Right-click the Sage software shortcut then click Properties.

4. Click the Compatibility tab, set Run this program as an administrator to be the same as Outlook, click OK.

5. Try emailing your document again.

 

Check Microsoft Outlook opens correctly

1. Close and reopen Microsoft Outlook and check that it opens correctly.

2. Right-click any file on the computer, for example, a Word document, click Send To then click Mail Recipient.

If nothing happens or an error appears, proceed to the following section.

 

Set Outlook as the default mail provider

1. Press the Windows key + R, type control /name Microsoft.DefaultPrograms then click OK.

2. Click Set your default programs, click Outlook (desktop), click Set this program as default then click OK.

3. Right-click any file on the computer, for example, a Word document, click Send To then click Mail Recipient.

If a new Outlook email window appears, Outlook is now set as the default mail provider and you should try emailing your document again. If it doesn’t work, proceed to the following section.

If nothing happens or an error message appears, Outlook is not correctly configured as the default mail provider and you should contact your local IT support to carry out a repair install of Microsoft Outlook