Sage Report Designer Question
DebbieM
Registered Posts: 13 New contributor 🐸
Hello
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?
Thanks,
Debbie
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?
Thanks,
Debbie
0
Comments
-
If you have Sage support give them a call. They charge enough!0
-
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?0
-
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.0
-
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.0
-
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.0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 324 NEW! Qualifications 2022
- 160 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 94 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 273 VAT
- 92 Software
- 274 Tax
- 138 Bookkeeping
- 7.2K General accounting discussion
- 201 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership