Home For accounting professionals General accounting discussion
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚

Sage Report Designer Question

DebbieMDebbieM New MemberRegistered Posts: 13

I want to make a report that will find a sales invoice by the customer's order number. In Report Designer I have only been able to find one field for Order Number which is within the fields listed under 'Project'. I believe this field takes the order number from the Details page of the project. I don't use this field as I invoice over and over against the same projects using different order numbers. I use the order number field on the Order Details tab of each sales invoice I raise, but I can't find this field within Report Designer.

I'm sure it is possible as when I googled it I found a link to the Sage website where they had made a report doing exactly that but it is only available to customers who sign up for the extra cover which I don't.

Any ideas anyone?




  • PGMPGM Font Of All Knowledge Registered Posts: 1,954
    If you have Sage support give them a call. They charge enough!
  • PAMDILLPAMDILL Experienced Mentor Registered Posts: 716
    Did you get the report? I designed one something like it, if you did not I think I can email you a print showing the variables?
  • PAMDILLPAMDILL Experienced Mentor Registered Posts: 716
    I tell a lie, I tried to write it but it can not be done - I checked with the Sage Users Forum and it is a glitch in the programming. The report I was thinking of was for outstanding orders etc.
  • PAMDILLPAMDILL Experienced Mentor Registered Posts: 716
    I am having a bad day - last day before holiday. I had been trying to do a report that linked delivery lines to invoices, that was the one that could not be done.
  • PAMDILLPAMDILL Experienced Mentor Registered Posts: 716
    What version of Sage are you using? Do you use the sales order processing module? If you can pm me I can maybe design a report for you.
Sign In or Register to comment.