• Transaction report

    I've successfully imported a journal with a numeric reference. Now I would like to be able to create a transaction report that is selectable by Reference, so I can see all the lines on the journal on the same page. How do I do that? The journal is across…
  • Report with "Customer Order No."

    Afternoon, 1st time posting here.... Could someone please tell me if it is possible to produce Sage report with "customer order no." (which we enter on all invoices) included? I need an excel export of all SIs posted in month including this detail…
  • 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…
  • Include credit notes in supplier invoices due and overdue report

    Hi I was wondering if it would be possible that credit notes could be picked up in the supplier invoices due and overdue report at all i have included a screen shot of the report and the filter for the "type" as i am assuming this is what will need…
  • Help in Setting and amending a report

    Hi please could anybody help me set up this report? Covid has played havoc with my brain and I need simple instructions. Step by step kind. I am using Sage 50 Cloud Accounts uk. I’m wanting to set up a new report with the following information shown…
  • Report Designer frequently asked questions - March 2021

    We've gathered the common questions you're asking us about reporting and Report Designer in March 2021. This includes: Adding reverse charge messages to your layouts. Issues emailing documents. Finding the best report in your software Read…
  • 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…
  • Auto Generate Reporting

    Is it possible to receive automatic daily reports directly from sage using a scheduled time / date? So if i want a certain report to be emailed to me, or generated, it doesn't it automatically without me having to click on the report & criteria every…
  • 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…
  • Zero balances being selected for dunning letters?

    Can anybody advise on how to stop zero balance letters being generated? I am using report designer to create a Dunning Letter but I cannot stop a letter being produced when the 'Grand Total' field shows zero. I have looked at adjusting the report filters…
  • Sage 50 - Sales Order List edit helpre

    Hi, Trying to edit the Sales Order List report as the current report does not repeat the headers below per line how do I edit it to repeat the information per line for each product Order # Date# Account Number Account Name