• Matching Transaction Report

    Hi everyone, I'm fairly new to Sage 200 and still trying to discover it's possibilities. I've been wondering if anybody has any idea if there is any report or how to create one that will basicaly generate you a list showing all the Credits and Debits…
  • Sales Returns - How Do I Make Them Negative On A Report

    Hi I have wrote a report which gives me sales by product, country's, analysis codes etc and is pulling through our w/o cost. However I am really struggling with the logic of how I can turn sales returns into a negative number. Does anyone know…
  • Report designer error message when trying to apply a filter

    The report could not be generated. No applicable method 'StartsWith' exists in type 'DynamicClass13' I'm using a modified zero value order lines report to get invoice item descriptions and their respective invoice numbers into columns. When I try…
  • Supplier/Customer Transactions with Nominal Codes Report

    Hi We need a report that will show all invoices and credit notes by supplier with the nominal codes they were charged to within the year. Is there such a thing in Sage already? And a similar report but for Customers? Thanks
  • Is anyone using BI reports successfully?

    I have tried to use Bi reports but they keep falling over which makes it impossible.
  • Customer Order discounts

    We use global order discounts and order line discounts. Some customers have a mix of both depending on the products purchased. Is there any way to show these in reports? Or BI? I am spending too much time going into each customer account to check…
  • Sage 200 Missing Reports

    Hi, We recently installed the latest version of Sage 200 on premise on a new server. Everything appeared to go well, however, every report I try to go to shows an Unexpected Exception 'Cannot find the report file: PURCHASE\Purchase Ledger Day Book Report…
  • Profit and Loss report in Sage 200 - cost centre name

    I am looking to add the cost centre name (not the 3 digits) to my reports but can't find the variable - does anyone know what it is?
  • Want to change sort sequence in Suggested Payments Report

    The default Suggested Payments Report in Sage200 for Education lists the suppliers in Account ID sequence. I wish to change this to list them in Supplier NAME order. I understand that the sequencing is controlled by the Group header/footer which is…