• 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…
  • 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…
  • 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…
  • Specific CSV sales report export report headers

    Hi, To import orders to our new warehouse system we need to export them from sage as CSV files with headers. CSV file headers have to be exact and some of these include a space. In the report designer I can choose to Generate Header Row and headers…
  • Receipts or invoice amount in words

    Can anybody suggest how to design the invoice form to include amounts in words in sage 50 UK.
  • Wordwrap when code more than (x) characters long

    Hi I'm looking to create a conditional formatting expression where if a stock code is more than x characters (lets say 10) long, then enable word wrap. I know how to enable word wrap, it is the 'if' part of the expression I am struggling with. Does…
  • System.String value

    Hi When configuring the email settings for a report and attempting to change the Filename (as standard is set to REPORT.DESCRIPTION), an error comes up saying "You must enter an expression that returns a 'System.String' value. What does this mean…
  • Zero balances being selected for dunning letters?

    Can anybody advise on how to stop zero balance letters being generated? I am using report designer to create a Dunning Letter but I cannot stop a letter being produced when the 'Grand Total' field shows zero. I have looked at adjusting the report filters…