• 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 to…

  • Report showing stocked products with zero sales

    I'm looking to create a report, or (preferably!!) doctor an existing report, that will show me products that have had ZERO sales within a specified time period. Any ideas?

  • Adding WEB_DETAILS to a Sales Order Layout inhibits "M" (message) fields

    I have a fully working Layout for Printing Quotations (run from Sales Orders) but if I add the WEB_DETAILS data field to the report, it inhibits "M" (Message) items being displayed.

    Accounts, v28.0.226.0 & Report Designer v5.0.251.0

  • 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 one line…

  • Invoices and credits template upload/design

    Greetings, 

    I produce weekly invoices for a client and currently use a workaround to export invoices from the 'invoices and credits' screen onto a Word template in order to send to the client as I haven't had a lot of luck with Sage report designer in…

  • One particular Layout gets deleted (not just un-favourited) whenever we have to remove / reconnect to RDA; can this be avoided?

    When we updated to v28 we noticed that one particular Layout from the Report Designer was deleted from all machines, luckily except one bizarrely, so we have managed to save it back as a favourite on all machines.

    Today, we've had to remove all machines…

  • Fast moving stock report

    Hi. I find in my library slow moving stock but there is nothing to pin point fast moving products. Is that additional extra in sage50 or is under different name?  I really need to have that list and I know that in the past the was report like that. Any…

  • Suppress Printing of Invoice Comment Lines if blank

    Thank you for your attention.

    I have an Invoice Report which has a Data Field that retrieves Invoice Comments (line 1 & 2), however I would like to create a conditional filter/format so that IF either of the Comment Lines are blank, the relevant Field is…

  • Drill Down In Report Designer - Customer Invoice Disputes to drill down to Customer Invoice

    In Report Designer I am editing the report called 'Customer Invoice Disputes' and I'd like to drill-down on the Invoice Reference to show the actual invoice. I am able to locate the drill-down function on the properties menu, but unable to find the right…

  • Sales Order Labels

    Hi, I'm looking for some help with label printing.  We're a goods distributor and need to find a way of applying a label to products loaded onto our vans, so the driver knows what product goes to which drop.  I have setup the template with the customer…

  • Detailed supplier transaction report including all allocations

    We have an issue with a supplier where their account is in quite a mess, however the account we have is all balanced.

    We have been back and forth a few times trying to help them match their unallocated transactions and each time it seems to open a new…

  • Using IF statement to select a delivery date?

    Hello,

    I have a Sales Order confirmation form set up so that each line on the order can show its own delivery date. This calls on SOP_ITEM.DUE_DATE and has to be manually input.

    Should any line contain a blank SOP_ITEM.DUE_DATE then I want to be able…

  • Report designer- Sum function doesn't add up properly

    I'm trying to design my sale order template and I would like to add the Total Weight and the total packages into the sales order footer.

    However, I tried the Add Expression, and I use the Sum Function, but it doesn't really do the job properly instead…

  • I cant get a total field to work in a report footer

    I have followed this help link to add a total of a field to the report footer.  It returns absolutely nothing.  Any idea what im doing wrong?

    https://gb-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=200427112203113&page=1&position…

  • Nominal Report expression and field help please? Im stuck!

    How do I add nominal debit and credit totals to a nominal report footer that only cover income and expenditure but not the bank account balances that are at the top of the report?  Have no idea with Sage reports as to which fields i need or the expression…

  • 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 on…

  • Report Designer - Customer Day Books Report - Delivery Address

    I work on Sage 50cloud. I want to add delivery address to the 'Day Books: Customer Invoices (Summary)' report as we want to be able to filter invoices by the delivery location.  Everything I have tried is just bringing up the main account address…

  • 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 more…

  • 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.…

  • Has anyone found a report that I could have that allow me to export every reccurring customer invoice details?

    Hi All.

    Hope someone can help. The recourring invoice button in the invoices and credits module has a great send to excel button which is really handy, however I'd like a report that also produce the information on this report as well as all the details…

  • CIS Domestic Reverse Charge VAT Invoice Wording

    This is a Report Designer question, I think.  I have some customised service invoice layouts which I have based on standard SAGE invoice layouts.  In Report Designer the property RevChrgMssge exists in my customised invoice layout.  When I run the report…

  • How can I add POP_ITEM.DUE_DATE to Outstanding Sales Order Report

    Hi all,

    We have just moved to Sage 50 and are looking to add the POP_ITEM.DUE_DATE to our Outstanding Sales Order Report, so that on our backorder report it shows the due date for the items ordered.

    I have been able to add the POP_ITEM.DUE_DATE to the…

  • Adding line discount to sales order in Report Designer

    Hi,

    Is it possible in Report Designer to add the line discount and percentage so it is visible on a sales order?

    I've added the discount by line to the sales order itself so I can add a discount for each line by percentage which is what I want but…

  • 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…

  • User ID in Report

    Hi guys,

    I'd like to add a field to a report that puts the user ID or user name in the corner (to show who exported it), but can't find the right field in any of the join tables.

    Does anyone have any idea where I would find the right expression…