• 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…
  • CSV sales order export with headers

    Hi, We need to export our sales orders to import to our warehouse system, but the new system requires CSV files to have the first row of headers. However I would try to create headers - they would only appear on excel forma, but not CSV. Please…
  • 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?
  • Report Designer

    Hi, Could you tell me, is it still not possible to join SOP_ITEM and INVOICE_ITEM within Sage 50 Report Designer? I have tried and can't seem to get it to work. I know it was a know issue years ago, but I would have thought Sage would have fixed it…
  • Agents Commission Report

    Simple question (I think). How do I amend the Agents Commission 10% report to show only the invoice total and commission and NOT every invoice line. Any help would be appreciated Thanks.
  • 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…
  • 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…