Sage Line 50 Help

System
System Posts: 100,534 🤖 Admin 🤖
Hello,<BR><BR>Does anyone know how to add tables to a report layout?<BR><BR>I'm trying to get the remittance to show the transaction number but I can't get the report designer to add the audit_header table to it.<BR><BR>Thanks for your help.

Comments

  • System
    System Posts: 100,534 🤖 Admin 🤖
    Sage Line 50 Help

    Only a sugguestion, not tried it, but If no one else answers!!<BR><BR>Try,<BR><BR>Finding a report with the details you want in! Then open the report designer, copy the fields you want and then paste them into the report you want them!!<BR><BR>Well its worth a try - Make sure you dont over write the reports you use!!!
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Sage Line 50 Help

    Hi <BR><BR>Unfortunately Line 50 is set so that the links in the tables are set "behind the scenes" this means that the tables that are there are all you have access to. <BR><BR>If you need a table from another module or one that isnt there you therefore cannot add it. <BR><BR>The only rout to go down is to use something like Crystal reports, link the tables that you want to use, set the parameters that you want and then design the layout again.<BR><BR>Hope this helps <BR><BR>Richard
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Sage Line 50 Help

    Please can you tell me where/how you all learnt about report writer. I have dabbled, but would like some more structured training. So far I have only come across the courses run by Sage. Can anyone recommend this or any other course.<BR><BR>Thank you
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Sage Line 50 Help

    Hi,<BR><BR>If you are looking for courses on report writing try-www.hotcourses.co.uk.<BR><BR>Dawn
  • System
    System Posts: 100,534 🤖 Admin 🤖
    Sage Line 50 Help

    Hi does anyone know how to get rid of the VAT column on invoices in Sage line 50?<BR><BR>Can i edit and design my own invoices?<BR><BR>Please help, would really appreciate it<BR><BR>Kelly x
Privacy Policy