Scope the problem by the business owner

[99904047]

Karen to scope the problem fully including the following: 1 - List the browser report(s) needed 2 - Document which fields are needed within the report(s) listed above, outlining those that are mandatory and those which are idea 3 - Do you require the report in excelerator and or agresso etc

Please note this list is not complete and your free to add more to it

[99904047]

Karen emailed me asking for the following 4 reports:

Credit Control requirements. Debtors Ledger Overdue Balance-from Aged Debtor report but to show only overdue balances with total of debt on each account.

Ability to search on specified date range Customer Code Customer Name Sponsor A/c Number ( if sponsored) exclude SLC 14444) Total overdue - outstanding balance of the whole account Student Status – Home /EU / Overseas Student Type FT/PT Payment Plan attached Y/N Entity Customer Email Customer telephone number Customer Address

Overdue Transaction Report – to be broken down by individual invoice Ability to search on specified date range Customer Code Customer Name Sponsor A/c Number( if sponsored) exclude SLC 14444) Invoice Number Account Notes Indicator Transaction date Gross Value of Invoice Outstanding overdue amount (either full amount or instalment amount) Number of days overdue Student Status – Home /EU / Overseas Student Type FT/PT Type of debt- (Tuition Accommodation, Commercial etc.) Payment due date Payment Plan attached Y/N Entity Customer email address Customer telephone number Customer Address

Debtors Ledger Matched Cash Report- Required to run each day to show payments posted from previous day (s) to monitor accounts with sanctions to be removed or added. Ability to search by date range Customer Code Customer Name Type of debt- (Tuition Accommodation, Commercial etc.) Invoice Payment method- Journal type CA CC CQ EPAY BACS, exclude MM txns Payment Plan Attached Y/N Amount of payment Date of Payment Entity Sanction Type on Account in QL e.g. A10 (not sure if this can be transferred across?)

Unmatched Cash Report- Used by Income and Credit Control to show any amounts on the Sales Ledger that are not matched to an invoice- these could be payments that have been missed for matching, posted to a wrong account or an advance deposit payment required before enrolment and therefore needs a sanction removing to allow enrolment. Ability to search by date range Customer Code Customer Name Payment method- Journal type CA CC CQ EPAY BACS, exclude MM txns Amount of payment Date of Payment Cost Code Sanction Type on Account in QL e.g. A10 (not sure if this can be transferred across?) Entity

[99904047]

Karen also provided the following debt types:

1 - Student debt types created via the OCCAM (accomodation import routine) that may require a payment plan:

Rent (Full Academic Year) Rent-Summer Contract

2 - Student debt types created via the QL (ETL import routine) that may require a payment plan:

Tuition fees Full time - Home- Under Grad Tuition fees Full time - Home- Post Grad Tuition fees Full time - Overseas-Under Grad Tuition Fees Full time - Oversea Post Grad Tuition Fees-Part time UG Tuition Fees -Part Time Post Grad

3 - Student debt types created via sales order workflow that may require a payment plan:

Tuition Fees-Phd Full Time Tuition Fees- Phd Part Time Short Courses Field Trip Emergency Loan Repayment Disciplinary Fine Re-charge of student travel expenses Additional Modules Re-charge of Bursary Award

4 - Commercial debt types created via adhoc sales invoicing that may require payment plans:

Projects Commercial Rent Invoices

4 - Commercial debt types created via adhoc sales invoicing that DO NOT require payment plans:

Sponsored Student tuition fees - Full time Sponsored Student tuition fees -Part Time Sponsored Student tuition fees-Overseas Expenses Misc Goods & Services Conferences Misc events Enterprises Company ICON ?

[99904047]

Karen

Has now provided additional information see below:

Credit Control requirements. Debtors Ledger Overdue Balance-from Aged Debtor report but to show only overdue balances with total of debt on each account.

Ability to search on specified date range Customer Code Customer Name Sponsor A/c Number ( if sponsored) exclude SLC 14444) DIM_5 Total overdue - outstanding balance of the whole account Student Status – Home /EU / Overseas STUDORIGIN Student Type FT/PT STUDMODE Payment Plan attached Y/N PAY_PLAN_ID Entity DIM­_7 Customer Email Customer telephone number Customer Address

Overdue Transaction Report – to be broken down by individual invoice Ability to search on specified date range Customer Code Customer Name Sponsor A/c Number( if sponsored) exclude SLC 14444) DIM_5 Invoice Number Account Notes Indicator TEXT ? Transaction date Gross Value of Invoice Outstanding overdue amount Number of days overdue Student Status – Home /EU / Overseas STUDORIGIN Student Type FT/PT STUDMODE Type of debt- (Tuition Accommodation, Commercial etc.) xvoucher_type Payment due date due_date Payment Plan attached Y/N Entity Dim_7 Customer email address Customer telephone number Customer Address

Debtors Ledger Matched Cash Report- Required to run each day to show payments posted from previous day (s) to monitor accounts with sanctions to be removed or added. Ability to search by date range Customer Code Customer Name Type of debt- (Tuition Accommodation, Commercial etc.) Invoice Payment method- Journal type CA CC CQ EPAY BACS, exclude MM txns xvoucher_type Payment Plan Attached Y/N PAY_PLAN_ID Amount of payment cur_amount Date of Payment payment_date Entity DIM_7 Sanction Type on Account in QL e.g. A10 (not sure if this can be transferred across?) * _QL Field College specific details Unmatched Cash Report- Used by Income and Credit Control to show any amounts on the Sales Ledger that are not matched to an invoice- these could be payments that have been missed for matching, posted to a wrong account or an advance deposit payment required before enrolment and therefore needs a sanction removing to allow enrolment. Ability to search by date range Customer Code Customer Name Payment method- Journal type CA CC CQ EPAY BACS, exclude MM txns xvoucher_type Amount of payment cur_amount Date of Payment payment_date Course xdim4 Student Status – Home /EU / Overseas STUDORIGIN Student Type FT/PT STUDMODE Sanction Type on Account in QL e.g. A10 (not sure if this can be transferred across?) Entity dim_7

*QL Field College specific details