SLS - Transactions Details Report
Overview
The School Shop 'Transactions Details Report' is a multi-purpose program that allows you to generate a report providing a transactional history for this shop. It can be run to provide analysis of invoice and/or credit transactions for:
Student sales.
Cash sales.
Commercial sales.
Department sales.
The report can be run using various selection options:
Date range.
Transaction entry person.
Stock code.
General Ledger code.
Student code.
Student groups (boarder, house, year group or campus).
General Tab
You must select from the Report Selections — either 'Student Sales', 'Cash Sales', 'Commercial Sales' or 'Department Sales'.
Important!
The search fields displayed with vary depending on the Report Selection you have made.
Select from the Enter 'Search Criteria' into the 'General' tab to filter the data produced in the report.
The 'Transaction Date' and 'Entered Date' fields allow either a single or range of dates to be entered. The 'Transaction Amount' field allows a range of dollar values to be entered.
Fields that require detailed explanation:
Report Selection = 'Student Sales' | |
|---|---|
Print transferred transactions only (Relevant to Student Sales Only) Parent Account Batch | This flag can be used as a selection criterion If this shop has been set up so that student sales are passed through to the Parent Accounts module. For more information, refer to 'School Shop Setup'. The transfer is run through program Finance > Parent Accounts > Billing Cycle > Shop Billing. All outstanding transactions from this shop on each student's ledger will be consolidated and posted as a single transaction (using this fee code) on to the parent's accounts. You can use this field as a selection criterion to print this shop's invoices/credits that make up a single parent account batch or multiple batches. Important! If this checkbox is unticked, you will only get transactions that have not been transferred. These selections are only available when 'Student Sales' is nominated in the 'Report Selections' section of this screen. |
Report Selection = 'Cash Sales' | |
|---|---|
Banked Status | You can use this field to select Unbanked or Banked transactions or both. |
Drawer | Enter a drawer name to search for or enter a partial name plus the ' |
Cheque No | Enter a cheque number to search for or enter a partial number plus the ' |
Report Selection = 'Commercial Sales' OR 'Department Sales' | |
|---|---|
Customer | You can enter or look up a customer code OR leave blank to include all customers. |
Print Tab
The 'Print' tab allows you to choose the 'destination' of the report. This can be to Adobe® PDF viewer, Microsoft Excel® or Microsoft Word®.
The 'Print' tab is also used to format the report.
Options to sort the report are available on the left side of the screen.
The report is designed to only print the first 50 characters of each line item by default to save paper. If you have longer line descriptions, check the 'Print Full Line Description' checkbox.
If you have selected 'Cash Sales' on the 'General' tab, you can now elect to print the payment details for each transaction by ticking the 'Include Payment Details'. The report will also produce a summary (at the foot of the report) broken down into EFTPOS, Cheque, Plastic and Cash totals.
Use the checkboxes to indicate your preference for displaying 'Alternate Row Colours', 'Table Borders' and 'Include Hyperlinks'. These options can enhance the readability of the report.