Click to return to Sage.IE


Sage 50

SageCover Extra Report of the Month

One of the many SageCover Extra benefits is the Report Of The Month. This is a report e-mailed each month to all SageCover Extra members. It is created by the Report Design Service and its design is chosen by looking at popular customer requests and Wish List items.

July 2008: Customer Invoices (Detailed) by Nominal Code

July's report has been brought to you by popular customer request. The report is an adaptation of the standard Day Books: 'Customer Invoices (Detailed)' report but is grouped by the Nominal Code. Not only does the report show the Nominal Code number but also the Nominal Code Name and provides totals per Nominal Code. The report can be run for a range of Customer Accounts, Transaction Numbers, Transaction Dates, Departments and Nominal Codes of your choice.

June 2008 Day Books: Supplier Payments showing Supplier Name

This month's report of the month follows on from May's report and is also based upon a standard Bank report. Again, instead of showing the 'Details' column, it now shows the Supplier's Name taken from the Supplier Record to allow you to analyse your payments easier. You can choose to run the report for a range of Bank accounts, Supplier accounts, a specific date range and also for a range of transaction numbers of your choice.

May 2008 Day Books: Customer Receipts showing Customer Name

May's report of the month is a based upon a standard Bank report. However, instead of showing the 'Details' column, it now shows the Customer Name taken from the Customer Record to allow you to analyse your receipts easier. You can choose to run the report for a range of Bank accounts, Customer accounts, a specific date range and also for a range of transaction numbers of your choice.

April 2008 Day Books: Customer Invoices (Summary) with Order No.

This month’s report of the month is a modified version of the standard Day Books report. However, this report contains an extra column of 'Order No' taken directly from the invoices in the Invoicing module. You can choose to run the report for a range of customers, a specific date range and also for a range of transaction numbers of your choice.

March 2008 Slow Moving Products

March's report of the month provides a list of products for which there has been no activity for a given date range. The report shows the product code, description, category number, current quantity in stock, a valuation based on the current sales price, and the last date of sale. The report can be run for a range of stock codes, categories and dates of your choice.

February 2008 Departmental Purchase Invoices and Credits

February's report of the month is the Purchase Ledger equivalent of the previous month's report in that it will break down supplier invoices and credits by the department to which they have been posted. The report will provide a net, vat and gross subtotal for each account, as well as for the department. You can choose to run the report for a specific date range, for a range of suppliers and departments, as well as nominal code and transaction number.

January 2008 Departmental Sales Invoices and Credits

This month’s report of the month will break down customer sales and credits by the department to which sales invoices and credits have been posted. The report will provide a net, vat and gross subtotal for each account, as well as for the department. You can choose to run the report for a specific date range, for a range of customers and departments, as well as nominal code and transaction number.

December 2007 Invoices by Order Number

This month's report of the month enables you to analyse the number of invoices that have been created with the same Order Number. For all invoices that contain data in the Order Number field, the report lists the invoices and shows the Customer Name, Invoice Number, Invoice Date, Net, Tax and Gross amounts. Totals for the values are given for each Order Number and also stated is the total number of invoices for each Order Number. You can run this report for a chosen date range, for a range of invoices or a range of customers.

November 2007 Product Details by Supplier

This month's report has been brought to you by popular customer demand. This Product Report is based upon the default Supplier Reference held on the Product Record and, for each Supplier, lists the products showing the stock code, description, supplier part number, latest cost price and sales price. The report can be run for a range of Stock Codes and Suppliers of your choice.

October 2007 Transactions by Date Vat Reconciled

The idea for October’s report came to Support Technicians Sean Curry and Carol Turner, from conversations with SageCover customers. This report groups together all transactions that have been Vat reconciled on the same date and splits them further into Transaction Type and Tax Code groups. This enables you to see easily what you have reconciled on previous Vat Returns.

September 2007 Invoice Profit Report by Nominal Code

This month's report of the month enables you to analyse your invoices, product by product, by the nominal code to which the individual products were posted. The report provides you with the quantity, net amount, cost and profit of each product sold and provides totals for the invoices, the nominal codes and the report itself. You can run this report for a chosen date range, for a range of invoices or a selection of products and customers.

August 2007 Nominal Activity by Extra Ref

August's Report of the Month is the third of three similar reports. It is based upon the standard 'Nominal Activity' report and groups transactions together by the information entered into the Extra Reference field. The report can be run for a range of Nominal Codes, Dates and Transaction Numbers of your choice with the option to include brought forward values if required.

July 2007 Supplier Activity Report by Extra Ref

This month's Report of the Month follows on from June's report in that it is based upon the standard 'Supplier Activity (Detailed)' report and groups transactions together by the information entered into the Extra Reference field. The report can be run for a range of Suppliers, Dates, Departments and Nominal Codes of your choice.

How To Download The Report Of The Month (Single User)

How To Download The Report Of The Month (Multi User)

 

HOW TO DOWNLOAD THE REPORT OF THE MONTH (SINGLE USER)

  • Check your Sage Program directory. Open your Sage Sage 50 program and Open the Help menu and choose About
  • Select the System Information tab and choose Directories from the left-hand pane. Make a note of the Program Directory under the Value column in the right-hand pane (e.g. C:\Program Files\Sage\Accounts). Choose Ok and close your Sage Sage 50 program.
  • If you are using v2008 or higher, you will need to take note of the Settings Directory, go into Company.000 and then the Reports folders.
  • Select the Relevant month you want to download and click on the link. In the Download Center choose Download then Save.
  • Browse into the relevant report folder e.g. C:\Your Program Directory\Reports\Supplier\My Supplier Reports. Choose Save then Close.
  • Open your Sage Sage 50 program and then choose the relevant module e.g. Supplier Reports. Your new report can be found in the My Supplier Reports folder.

HOW TO DOWNLOAD THE REPORT OF THE MONTH (MULTI USER)

  • Open your Sage Sage 50 program. From the Settings menu choose Company Preferences and go to the Reporting Tab. If the 'Use Data Path for Reports' check box is ticked follow the steps below. If there is no tick follow steps above for Single User.
  • Check your Sage Data directory. Open your Sage Sage 50 program and Open the Help menu and choose About
  • Select the System Information tab and choose Directories from the left-hand pane. Make a note of the Data Directory under the Value column in the right-hand pane (e.g. H:\Program Files\Sage\Accounts). Choose Ok and close your Sage Sage 50 program.
  • Select the Relevant month you want to download and click on the link. In the Download Center choose Download then Save.
  • Browse into the relevant report folder e.g. H:\Your Program Directory\Reports\Supplier\My Supplier Reports. Choose Save then Close.
  • Open your Sage Sage 50 program and then choose the relevant module e.g. Supplier Reports. Your new report can be found in the My Supplier Reports folder.