• Sage 50 Report Designer Help

    I have a report summarising invoice totals for today, the past week and the past month. Unfortunately, if an invoice is highlighted in in the Invoice List, the report picks that up a the data source, so ignores the in-built filters for dates. How do I…
  • Filtering products supplied to a customer

    Hi, I'm looking to write a report in Report Designer which gives me information on the products that we supply to our customers. I think there may already be a standard report that shows this but as far as I can see it lists sales to the customer…
  • Layout Bug in V30

    Since updating to V30 there appears to be a strange bug that has appeared when Exporting or Printing Invoice layouts. It appears that conditional formatting is not being correctly respected for 'Suppress Print' and 'Visibility' on items. It also appears…
  • Show Department names rather than Department numbers on report page headers criteria, possibly with a sub report

    I'd like to be able to see the department name instead of the number in the selected criteria shown in the page header. Currently I see "From '2' to '3' (inclusive)", or "All", or "1, 3, 4", depending on how or which departments I select to be included…
  • Reporting - IF Function

    I am trying to create an If function to show "ON HOLD" depending on the aged balance being over the credit limit for customers, but it keeps returning the following error - expecting "then", found " What I have so far is IF SUM(Aged_Period_1+Aged_Period_2…
  • Can you print customer memo / notes on aged debtors report

    I've been asked to print customer memo / notes on aged debtors report. Not sure if you can do this as notes are kept in a separate file - but it would be great if you could add them to a report. Does anyone know if you do this? Thanks Simon
  • outstanding stock items report

    Hi, New here so please go gentle. I am tying to run a pre-set report "Sales order quantities to dispatch by stock code" . This report seems to run but includes quantities on quotes as well as Sales Orders? I then run a filter on the Sales Orders…
  • If Statement

    Hi I'm trying to write a IF statement to state IF SALES_ORDER.NOTES_1 , SALES_ORDER.NOTES_2 or SALES_ORDER.NOTES_3 is populated show 'SERIAL NUMBERS' but if not populated leave blank. I have tried the one below but serial numbers is showing when…
  • Actual stock levels available report

    I am trying to find a report to show me the following fields 1. Quantity in stock 2. Quantity Allocated 3. Quantity on Order 4. Free Stock "Available Basically it's Quantity in Stock minus Allocated = Free Stock Only want to show stock items…
  • Report Export or Save As not working as expected

    Hi All, Have a multi-user site on a network setup and one user in particular is having a constant issue when trying to export a Quote or invoice or anything for that matter. When you preview on screen and click "export" then you get the "Save As" window…
  • Sales order with bom details

    Trying to add the component location on the sales order with bom details, but it shows the location of the last item in the bom for every component in the bom. Has anyone else come across this or what I have done wrong?
  • Stock Reporting

    I need a report to show how much stock was held and its value on a particular date, is there any such report? (The Stock movement report doesn't help much as it requires alot of manual intervention). Thanks
  • Editing a report

    I need a report for an export for obtaining Feefo reports that contains customer information but also some invoice information. I am currently editing "Day Books: Customer Invoices (Detailed)" and I need to add in the product code from the relevant invoice…
  • Report layouts missing from report browser when printing a quotation, but not when printing a sales order?

    We need to start using the quotations feature. When we go to print a quotation, we're missing most of the templates including some sales order templates. We want to modify a sales order template so we made a copy of it, renamed it, but it's not appearing…
  • Quantity on order and associated order number

    Hi, In reference to Quantity on order, is there similar variable to add this information to a report? The current orders, supplier and number? Currently I need to open each item within products and service, click the "on order" box, wait, make…
  • Report Designer SAGE50

    Hi, I am new to Sage50 and have just moved over from Quickbooks Desktop. I am trying to duplicate our report templates using the report designer but stuck on a tedious issue. I have manged to replicate most of our Quotation template but unable to get…
  • Stock or Inventory Usage report

    Hello, Where do I get a, " "previous 12 months stock usage" report that I use to help with predicting stock reorder levels"? I am working on an inventory project and part of what the consultant is asking me for is a usage report that will show me…
  • Quick Print Layout resets when another user prints

    We've had this issue for a long time but it has never received a fix. Not sure if it is a bug or deliberate behaviour but (as an example); when user1 on computer1 clicks 'Quick Print' they have to choose a Layout to print, then when user2 on computer2…
  • Setting a date range for a report

    Hello, I have a "previous 12 months stock usage" report that I use to help with predicting stock reorder levels. Its set up with a pre-set date range that I have to change every so often to reflect usage of items that fall outside of the original…
  • Adding a document to a Sage report

    Hi, I have a report set up that I use to check supplier deliveries and I want to add another document to the printout so that I get the Sage report and a Word document print together. Is this possible? Regards Andy
  • Sage.Reporting.Engine.Integration - "invalid report file" error when trying to run report

    We are using Sage Accounts 50 v28. I am trying to write sample report generation app using C# and I am stuck at very beginning because Sage is reporting me back that report file which I am trying to use is not valid even if it runs without any problem…
  • Exporting to multiple email addresses

    Currently when I select multiple customers to send statements to, its sending all of the statements to the first customer on the list selected rather than sending each to their respective contact email address. Any ideas why and how to fix it?
  • Sage Report Designer Expression Help

    Hi All! I'm trying to edit our purchase orders so that it works with both types of orders we do. Sometimes we don't add a code for items we're ordering in on a one off basis and we just use the S1 - Special Item code. When using STOCK.SUPPLIER_PART_NUMBER…
  • Report designer - Losing pre written email messages in Report Layouts

    Hi, Over time I've set up custom messages in my report layouts for when these are emailed. I've noticed that on a number of occasions these do not appear and, instead, the message defaults to the " Your report is attached in pdf format. You will need…
  • Email help for old version of sage

    Hi I don't know if anyone has some experience setting up and sending invoices and statements by email on a fairly old version of sage. We have recently upgraded our computer and moved over the sage software. To send statements on our old computer we…