Sage 50 v14 Custom Report Design issues

Hi, I need a simple custom spreadsheet from Sage 50 v14 with the sections below grouped out in date order, for a date range of say 11-12-22 to 10-01-23.

I have to produce this each month using a laborious Bank Reports > Export to Excel cut and paste method in which the cells are often in different formats and the total formulas do not work once I export to Excel:-

Customer receipts

Cash receipts

Invoice Profit Bank Payments (difficult as my old Sage 50 v14 lets me highlight the invoices I want for the months date range they were paid in but then says, 'No data was returned for this report')

Bank receipts

Cash receipts

Supplier payments

Corp Tax Payments

VAT payments

Is this something anyone knows how to design or can recommend a budget priced designer?

Regards, Andrew

  • 0

    This is the type of report that can be custom written. I use XLGL for reports that are required on frequent basis. XLGL can be searched in your browser for the Logicimtech XLGL  https://www.logicimtech.com/products/xlgl  This program can pull any information in Sage 50 CDN and report on it. The program uses Excel advanced formulas etc. If you are not sufficiently familiar with the tables in Sage 50 or the use of Excel then Pierre will write the report for you at a reasonable cost.