Dispatched Sales Order Report - Line Level

Question

Hi, 
 
 Is it possible to create a report which will export the data in the following columns? 
 
 Order Date / Order Number / Account Ref / Account Name / Product Code / Product Description / Quantity / Price &pound; / Net &pound; / 
 
 Trying to do this without having all the header summaries at the top which the standard report that are in Sage. 
 
 Can this be done?

fiona wilson · Answer

Hi Ian 
 You can send your Sage Accounts reports to Excel for further analysis in just a few clicks. 
 Open Sage 50 Accounts, then browse to and click the report you want to send to Excel. 
 Click the required output option as follows: 
 To send the report data to Excel, placing the information in columns ready for further analysis. 
 Sage 50 Accounts v23.2 or above, with Report Designer v4.0.140 - Click Data to Excel. 
 Sage 50 Accounts v23.2 or above, with Report Designer v4.0.134 - Click Excel. 
 This option is not available in Sage 50 Accounts v23.1 and below. 
 You can then configure the columns as required. 
 If you&rsquo;d prefer that a report is created for you, our Business Insight team can help. They can create customised designs tailored to your requirements. In addition if you require training to support your design, then please advise and we can discuss suitable training options.

Sage 50 Accounts

Dispatched Sales Order Report - Line Level

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING