Sales Invoice Day Book List

 

Click on the "Reports" tab to bring up the list of options and then select "Invoicing & Financial" followed by "Sales Invoice Day Book List" from the menu options list. There are five versions of this report and they are detailed below.

 

 

If you select the first option ("List"), the "Print Sales Invoice Day Book" screen will appear.

 

 

The report can be run for any date range or invoice number range required and in the case of a multi-home installation either for all homes or an individual home. The report can also be ordered either by Client Surname or Invoice Number. In addition there is the option of including All Invoices, Invoices Posted to Sage or Invoices Not Posted to Sage. There is also the option of exporting the data to a CSV file. When the relevant criteria have been selected, click on the "OK" button to continue.

 

If you choose the CSV export option, the system will create the file for you and display a screen which shows the location of the created file.

 

 

Otherwise, the Printer dialog box will be displayed to allow the user to select which printer to send the report to.

 

 

Select the correct printer and then click on "OK". A print preview will now be displayed allowing a final check before printing, the report can now be printed or exported from this screen.

 

 

If you select the second option (List by Payment Type), the "Day Book by Payment Type" screen will appear. This report is used in conjunction with the Sales Invoice Payment Methods setting.

 

 

The report can be run for any date range and you can then select either a specific Payment Type or leave blank to list all Payment Types, and in the case of a multi-home installation either for all homes or an individual home.

 

When the relevant criteria have been selected, click on the "OK" button to continue.

 

You will then be asked to confirm your choice.

 

 

Click "Yes" to continue or "No" to cancel.

 

The report will now be displayed on screen and can be printed or exported. This report has an additional column to show the Payment Method.

 

 

If you select the third option (Detailed by Batch Ref to CSV File), you will see the following screen.

 

 

From the drop down list select the batch you wish to report on or you can choose a date range and the report will show all batched within that range. Select the output type on the right and then click on "OK" to continue.

 

If you selected "Screen", you will see a preview of the report on screen, if you selected "Printer", the report will be printed on your default printer or if you selected "CSV", you will see a box giving information about the name and location of the CSV file that has been created.

 

 

Navigate to the file location and the CSV file can then be opened and viewed in an appropriate program.

 

 

If you select the fourth option (List by Sales and Charge Codes), you will see the following screen.

 

 

You can choose the date range for the report along with which Home or All Homes, which Charge Code or All Charge Codes and which Sales Code or all Sales Codes. Click on OK to continue. You will be asked to confirm your choices.

 

 

Click on "Yes" to continue or "No" to cancel. If you click on "Yes", you will then see the report displayed on the screen and it can be printed or exported.

 

 

 If you select the fifth option (List by Invoice Period), you will see the following screen.

 

 

The report can be run for any invoice period by entering the "From Period" and "To Period" dates in the boxes, you can also select an invoice number range and in the case of a multi-home installation either for all homes or an individual home. In addition there is the option of including All Invoices, Invoices Posted to Sage or Invoices Not Posted to Sage. Once you have made your selections, click on "OK" to continue.

 

The report will then be displayed on the screen and you can print or export it.