• Sage 50 Support
    - 2 months of support and a 1 hour training session FREE when you switch to Pimbrook
  • UK Payroll Year End
    Completing the Sage 50 UK Payroll Year End

KB Category: Pimbrook Internal

Customer reports and layouts (42)

Written by Eamon on .

Customer reports and layouts

 

Aged Debtors Analysis (Detailed) with Extra Reference

A detailed aged debtors report with a column for the extra reference.

  View the report  Download (Internal Only)

Available on request
Aged Debtors Analysis Summary by Currency and Country

Aged debtors analysis summary by currency and country.

  View the report  Download

Available on request
Aged Debtors Analysis Grouped by Invoice Ref (Detailed)

Detailed aged debtors report grouped alphabetically by the invoice reference.

  View the report  Download

Available on request
Aged Debtors (Detailed) by Payment Due Days

Detailed aged debtors report by Payment Due Days.

  View the report  Download

Available on request
Aged Debtors (Summary) by Payment Due Days

Summary aged debtors report by Payment Due Days.

  View the report  Download

Available on request
Average Days To Pay Sales Invoices

Average days to pay sales invoices for a chosen payment date range.

  View the report  Download

Available on request
Customer Activity (Detailed) with Extra Reference

A detailed customer activity report with a column for the extra reference.

  View the report  Download

Available on request
Customer Departmental Analysis – Detailed

Customer aged debtors detailed report by customer department, with sub-totals per department.

  View the report  Download

Available on request
Customer Departmental Analysis – Summary

Customer aged debtors summary by customer department, with sub-totals per department.

  View the report  Download

Available on request
Customer List with Email Address

A customer list with email addresses.

  View the report  Download

Available on request
Day Books: Customer Credits (Detailed) with Extra Reference

A detailed customer credits day books report with a column for the extra reference.

  View the report  Download

Available on request
Day Books: Customer Credits by Country (Detailed)

A detailed customer credits day books report, grouped by country.

  View the report  

 Download

Available on request
Day Books: Customer Credits by Country (Summary)

A summary customer credits day books report, grouped by country.

  View the report  

 Download

Available on request
Day Books: Customer Invoices (Detailed) with Extra Reference

A detailed customer invoices day books report with a column for the extra reference.

  View the report  Download

Available on request
Day Books: Customer Invoice & Credits by Country (Detailed)

A detailed customer invoices and credits day books report, grouped by country.

  View the report  

 Download

Available on request
Day Books: Customer Invoices & Credits by Country (Summary)

A summary customer invoices and credits day books report, grouped by country.

  View the report  

 Download

Available on request
Day Books: Customer Invoices by Country (Detailed)

A detailed customer invoices day books report, grouped by country.

  View the report  

 Download

Available on request
Day Books: Customer Invoices by Country (Summary)

A summary customer invoices day books report, grouped by country.

  View the report  

 Download

Available on request
Departmental Aged Debtors – Detailed

Detailed aged debtors report by transactional department with department totals.

  View the report  Download

Available on request
Departmental Aged Debtors – Summary

Aged debtors summary by transactional department with department totals.

  View the report  Download

Available on request
Inactive Customer List

A list of inactive customers.

  View the report  Download

Available on request
Invoice and Credit Summary by Customer

A summary report showing invoices and credits by customer.

  View the report  Download

Available on request
Invoices and Credits Detailed by Customer

Invoices and credits detailed by customer.

  View the report  Download

Available on request
Outstanding Sales Transactions with Net/VAT split

Outstanding sales transactions with Net/VAT split by customer.

  View the report  Download

Available on request
Sales Ledger Turnover by Country

Sales ledger turnover by country, with sub-totals per country.

  View the report  Download

Available on request
Sales Ledger Turnover with Nominal

Sales Ledger turnover by customer and nominal code with sub-totals per customer.

  View the report  Download

Available on request
A4 Statement, Group Date/Inv Ref – All Items Plain Paper/Email

A4 Statement in date order and showing all items. Formatted to use with plain paper or email.

  View the layout  Download

Available on request
A4 Statement, Group Date/Inv Ref – All Items Plain Paper/Email with Opayo (Formerly Sage Pay)

A4 Statement in date order, showing all items and including a Pay now button for use with Opayo. Formatted to use with plain paper or email.

  View the layout  Download

Available on request
A4 Statement, Group Date/Inv Ref – (O/S Plain Paper/Email) with Opayo

A4 Statement in date order, showing outstanding items only and including a Pay now button for use with Opayo. Formatted to use with plain paper or email.

  View the layout  Download

Available on request
A4 Statement, Grouped & All Items – Plain Paper with Logo and Bank Details (Print or Email)

A4 statement showing all items and including a placeholder logo that’s easy to edit and replace with your own logo. Also contains a bank details section that you can edit.

  View the layout  

 Download

Available on request
A4 Statement, Grouped & All Items – With Cust Order No (Plain Paper, Print or Email)

A4 Statement showing all items and including the customer order number. Formatted to use with plain paper or email.

  View the layout  Download

Available on request
A4 Statement, Grouped & All Items – With Extra Ref (Plain Paper, Print or Email)

A4 Statement showing all items and including the extra reference. Formatted to use with plain paper or email.

  View the layout  Download

Available on request
A4 Statement, Grouped & O/S Items – Plain Paper with Logo and Bank Details (Print or Email)

A4 statement showing outstanding items only and including a placeholder logo that’s easy to edit and replace with your own logo. Also contains a bank details section that you can edit.

  View the layout  

 Download

Available on request
A4 Statement, Grouped & O/S – With Cust Order No (Plain Paper, Print or Email)

A4 Statement showing outstanding items only and including the customer order number. Formatted to use with plain paper or email.

  View the layout  Download

Available on request
A4 Statement, Grouped & O/S – With Extra Ref (Plain Paper, Print or Email)

A4 Statement showing outstanding items only and including the extra reference. Formatted to use with plain paper or email.

  View the layout  Download

Available on request
A4 Statement – Grouped & O/S with Pay Now (Plain Paper/Email)

A4 Statement showing outstanding items only and including a Pay now button for use with Opayo. Formatted to use with plain paper or email.

  View the layout  Download

Available on request
A4 Statement, Grouped & Overdue Items – Plain Paper with Logo and Bank details (Print or Email)

A4 statement showing overdue items and including a placeholder logo that’s easy to edit and replace with your own logo. Also contains a bank details section that you can edit.

  View the layout  

 Download

Available on request
A4 Statement – Grouped All Items with Pay Now (Plain Paper/ Email)

A4 Statement showing all items and including a Pay now button for use with Opayo. Formatted to use with plain paper or email.

  View the layout  Download

Available on request
A4 Statement, Grouped Date/Inv Ref – O/S Items – Plain Paper/Email

A4 Statement in date order and showing outstanding items only. Formatted to use with plain paper or email.

  View the layout  Download

Available on request
A4 Statement, Individual & ALL Items – Plain Paper (Print or Email)

A4 Statement showing all transactions itemised. Formatted to use with plain paper or email.

  View the layout  Download

Available on request
A4 Statement, Individual & O/S Items – Plain Paper (Print or Email)

A4 Statement showing outstanding transactions itemised. Formatted to use with plain paper or email.

  View the layout  Download

Available on request
Plain Paper Statement, Grouped & All Items – using customer registered address

Customer statement, showing all items and using the customer’s registered address. Formatted to use with plain paper or email.

  View the layout  Download

Available on request
Plain Paper Statement, Grouped & O/S Items – using customer registered address

Customer statement, showing outstanding items and using the customer’s registered address. Formatted to use with plain paper or email.

  View the layout  Download

Available on request
Plain Paper Statement, Grouped & O/S Items with Due Date

Customer statement, showing outstanding items and showing the due dates. Formatted to use with plain paper or email.

  View the layout  Download

Available on request

Sage 50 Software closes when opening a Company or the Company can only be opened via Demo Data

Written by jennie on .

Sage 50 Software closes when opening a Company or the Company can only be opened via Demo Data

 

Problem: When you choose a company from the list of companies in the Sage50 login screen, and then enter the username & password the splash screen appears & then disappears.

 

1. First try refreshing the license:

  • Rename C:\ProgramData\Sage\SDK Licence to ‘SDK License Old’
  • Rename C:\ProgramData\Sage\Accounts\2017\Sage.usr to Sage.usr.old
  • Try to open Sage50.
  • It should prompt you for your Serial Number & Activation Key this time, then Account Code. Enter these.
  • It should proceed to offer you the companies to open.
  • Try to open a company.

If you can successfully log in this time, try to log on to the company(s) a few times over to see if the problem is gone.

 

2. If the problem returns immediately, then try the following in addition:

  • Browse to C:\ProgramData\Sage\Accounts
  • Edit the SAGE.INI file with notepad.
  • Search for the word ‘analytics’
  • If Analytics is set to 0, change it to 1. Close and save the file.

Try to log on to Sage a few times over to see if the problem is gone this time.

If the Analytics setting worked then it may have been that someone accidentally caused this by turning off the analytics setting in Tools\Options\Analytics Tab inside Sage50. (Common in versions 23.2 and 24.1)

*The ‘2017’ location shown above is for demonstration purposes, use the year number of your own affected software.

 

 

(JN)

Migration from (Software) to Sage 50 – Checklist

Written by Pimbrook Support on .

Migration from (Software) to Sage 50-Checklist

 

Install Software – Checks

  1. Check Regional Settings are correct
  2. Anti Virus Software
  3. UAC Turned Off
  4. Install and Configure Software
  5. Ensure Tax codes are Correct (Irish Settings)
  6. Is Foreign trader required to be activated
  7. Have they any UK companies – activate MTD
  8. E-banking set up
  9. Set up email for basic layouts
  10. Set financial year

Software Migrating from (Software)

  1. Export Stock records and opening stocktake if needed. (Import to Sage 50 section as well)
  2. Get copy of P&L and B/S as well as the TB (could get extra paid job creating new COA at very least)..I know this COA is in your Checks section
  3. Agree mapping of Trial Balance with client from existing Nominal codes to Sage 50 codes and Enter to Sage 50.

 

Software migrating from (Software)

  1. Export Customers from (Software)
  2. Export Suppliers from (Software)
  3. Export Nominal from Sage one
  4. Report on outstanding transactions in the Bank
  5. Export Opening balances for Customers
  6. Export Opening balances for Suppliers
  7. –
  8. Export Trial Balance

 

Sage 50

  1. Import Customers to Sage 50
  2. Import Suppliers to Sage 50
  3. Import Nominal to Sage 50
  4. Enter outstanding Bank transactions
  5. Import/Enter Opening balances for Customers
  6. Import/Enter Opening balances for Suppliers
    1. Do Journal to cancel out he suspense account entries after entering the opening balance
  7. Enter Trial Balance

 

Checks
  • Cross check that everything Balances
  • Configure COA
  • Report Design

How to Use Fiddler to Investigate a Stuck Submission

Written by Pimbrook Support on .

How to Use Fiddler to Investigate a Stuck Submission

**Please be aware that you cannot change the GUID number or ROSDATA file anymore going forward.  If a customer should need to do a submission in a previous period, then the absence of history in the ROSDATA file would stop them from doing that.

If a submission is hanging, the problem is that its stuck at Sage’s RTX server and needs to be pushed through to ROS. You can check this as follows:

Check to see if you are getting error message 500 on Fiddler (steps a – h below)

a. Download and run from https://www.telerik.com/download/fiddler/fiddler4

b. Open Progress TelerickFiddler Web Debuger

c. Select Tools  –  Options

d.Tick the box for Decrypt HTTPS CONNECT

e. Click OK

f. Log out of Fiddler and the Payroll

g. Log back in to both

h. Drag the icon over payroll

Once you are logged back in you should get the 500 error message.  It will give you any error messages in red (on the left of the screen)

 

Double click on the error and click on RAW on the right hand side and copy the error message into notepad to send with the other details to sage

 ‘Error 500 – Error retrieving file XXXXXX.zip’ would indicate a problem at Sage RTX Server and you will need to contact Sage to get the submission released.

  • 1
  • 2

Follow Us

© 2023 Pimbrook Software, all rights reserved

Build and maintained by Modus.