Report: Invoice Query: Cancellation Invoices

From Agency Systems Wiki
Jump to navigation Jump to search
Related Pages
Related Categories

Overview

This report will provide a listing of Cancelled Invoices, and display the Invoice Amount, Agency Commission, and Producer Commission.

The original amount column will indicate the invoice amount, agency commission, and producer commission. (For Broker Clients, the Producer Commission will show in the Paid Amount column.)

Process

See Report: Invoice Query for additional information.

  1. Select Reports -> Invoice Query.
  2. Press CTRL + A to access the Advanced Query. Select Perform an advanced query and Next.
    Menu-ap-invqry-adv.png
  3. Select Query by Invoice, then Next.
    Menu-ap-invqry-adv-byinv.png
  4. Enter a Start Date and End Date for the range of invoices. Leave the Cut-off Date at 12/31/2099 and select Next.
    Menu-ap-invqry-adv-byinv-dates.png
  5. Check all options on the client paid screen, then select Next.
    Menu-ap-invqry-adv-byinv-client.png
  6. Check all options on the paid to company screen, then select Next.
    Menu-ap-invqry-adv-byinv-cmp.png
  7. Check all options on the paid by company screen, then select Next.
    Menu-ap-invqry-adv-byinv-cmp2.png
  8. Check all options on the producer paid screen, then select Next.
    Menu-ap-invqry-adv-byinv-prd.png
  9. Enter the Cancellation transaction code in the Transaction field, then select Next.
    Menu-ap-invqry-adv-byinv-trans.png
  10. Leave the defaults for Additional Filters screen, and select Next. (Include On-Account and Use GL Date should be defaults.)
    Menu-ap-invqry-adv-byinv-addtl.png
  11. Leave the department code blank, and select Next.
  12. Select Low Detail and Include Agency Commission. Select Next.
    Menu-ap-invqry-adv-byinv-lowdetwagycomm.png
  13. Select the desired sort option, and select Next.
  14. Select the Preview or Print.