• Page count on reports

    Is it possible to display a page number in a report that displays the count pertaining to each individual company within that report? i.e. Is it possible to reset the page count for the next company within the same report? For example, Company AAAA…
  • Extract details from combined INVOICE field - Sage line 50 report designer

    Backgound on the challenge I am facing: A vendor sends us an import file that combines three customer data fields into one, separated by a ‘/’. (These are Unit No / Account No / Order Reference) This combined field is imported into our Sage Line…
  • Supplier Turnover figures

    When running the report for supplier turnover, subcontractors who are nett and pay CIS tax, as it is a credit note automatically produced on your system, it is deducted from the turnover figure. We need subcontractor turnover figures to give to the…
  • Message Line on Reports - show message lines specifically on Reports (not Layouts)

    I have been asked to print out reports for meetings. This report specifically is for SOPS - printing out an itemised quote list. I usually enter an "M" Message line on the first line of every quote which I input the customer's enquiry reference. I sometimes…
  • Report designer expression question

    I want to be able to display different text in a text box based on the result of an expression. So far so good, but the text I want to display needs to be displayed as a multi line, and I can't find a way of including a linefeed or carriage return character…
  • Report Filter Expression Based On DATE, But Limited To 12 Months

    I'm trying to find out how to add a filter expression on a report for Sage 50 Accounts, such that the report only looks at GDN_ITEM_DATE that is from the last 12 months from the CRITERIA.GDN_ITEM_DATE_TO specified when the report is run. I then need to…
  • Sage Cover Extra - Report of the month - August

    The August Report of the Month is now available for download The new report is "Sales by Invoice Analysis Code 1". This Invoice report can be run for a date range and will group invoices together by the Invoice Analysis 1 field. It shows net sales per…
  • Sage 50 Accounts Professional - PROJECT BUDGETS!

    Our business is driven around using the Project Module within Sage. What I cant seem to do is find any report within Report Designer that enables me to simply print my Cost Code Budgets (Set pre start of Project) against the actual Spend figures. It…
  • Top Customer Report for Prior Year

    I would like to run a Top Customer Report for the previous Financial Year to do a comparison. Is there a simple way to do this? Claire