• Report Designer help

    Hi All I am trying to amend the invoices and credits by customer report so that it shows the carriage charge invoiced. I have added the expression to calculate the carriage charge which it has done but i notice that if the invoice has more than…
  • Grouping Report Sections

    So this question is based on a report I've been working on for while and just can't crack. I'm trying to create a report which is effectively a total requirement list for a Sales Order. It needs to list the sales line items together at the top (effectively…
  • 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…
  • Report Designer - Group by one, Sort by another

    I want to create a SOPS report Outstanding SOPS Grouped by Sales Order Sorted by Due Date (Sales_Order.Despatch_Date) I've tried using a standard report; however, I can't seem to change to details to allow both grouping of items by order number…
  • Remittance.Extra_Ref

    Sorry to repost this issue again but I am desperate to find a solution. I am using Sage 50c Accounts Essentials. When I create the email with my remittance attached in pdf format the Extra_Ref value does not appear even though the data field is on…
  • How to make Group Header / Footer not appear on report when no values to show?

    Hi, I've have tried a few expressions and filters to figure this out, but I can't seem to crack it. I want the group header and footer to not show if there are no values in the details section within the group. See image below. For reference, this…
  • [Report Help] Invoice Summary to not take 'Credits' into consideration?

    Hi, I am running a report in the Invoices and Credits section of Sage 50 Accounts Professional. This report gives me the following information: A list of the products sold for that month itemized in alphabetical order The net amount made from…
  • Repeat Order Report

    Hello all Aim: In an attempt to contact customers to offer 'special offers' or encourage more orders, I would like to be able to look through customer's previous orders, recognise the 'repeat orders' and establish a 'special offer' or at least a reminder…
  • Agents Commission Report filtered by Stock Category

    Greetings All, This may not even be possible, but I will do my best to articulate what I'm trying to achieve and hopefully someone is able to help. I'm using a report from the Customers tab > Agents Commission (@10%). I have modified this slightly…
  • PNL

    I want a "Profit and Loss (Monthly Breakdown)" [Filename PNL_MTH] - BUT, for the previous Financial Year. Is there one available?