Browse By Tags

  • 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…
  • 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…
  • 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…
  • 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?
  • 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…
  • 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 - 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. What…
  • 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…
  • How to us Web_Category_2 as a number for calculations

    I am trying to tweak a product valuation to add column for shipping costs per unit. I have used Web Category 2 to enter costs attributed to each product. I am now trying to get the report to calculate the figure in WEB_CATEGORY_2 by multiplying with…
  • Training on Sage Report Designer

    I've used Sage for years, and have a tiny bit of self taught experience in Report Designer. I'm looking to plug the holes in my knowledge but can't find a book or anything like that online. Can anyone recommend a good way of getting training in report…