Production Report Overview

Product: The Agency Manager, Series 6 and above

The Production Report searches for entered transactions. You may search for agency or direct bill items. This report will not look for pending transactions (e.g., installments that have not been processed).

As with all reports, check the parameters closely before beginning any troubleshooting. If there is a questionable item, view the transaction's details at the customer level, such as Agency, Branch, Department, Accounting Month, Company, Producer, etc. This information files with the transaction, based on what was on the billing screen at the time the transaction was entered. Also, remember that the override option may have been used when the transaction was entered to change any information that defaulted from the billing screen.

Parameters

Troubleshooting Tips

Sort by Producer

When the production report is sorted by producer, there are three different options to choose from. The reason for this is because on one item, there can be up to three producers. Therefore, if you run the production report to balance to another report, you must be careful when sorting by producer. Different sorts can change the report totals.

Include Item in Total for First Producer

With this option, if there is an item with a producer ABC and another producer XYZ, the production report will have to list the item under each producer on the report. But, when the item lists under the second producer, it will not add the item's agency commission, premium, etc., into the subtotals, because the agency commission (and such) would have been added into the agency commission total when it listed under the first producer. The report will place a ^ symbol beside the item under the second producer's listing. The bottom of the report displays a message that notes: "^ = Item was already printed and added to totals earlier in the report." Running the report like this will not inflate agency commission, gross premium amounts, and the bottom line report totals.

When this sort is selected, the sort option on the parameter list displays as PRO.

Something to note is that, currently, the production report considers the "first" producer to be the producer that comes first alphabetically (because it will be the producer that lists first on the report). So, if on the transaction itself, PR1 is ZZZ and PR2 is AAA, running the report with this option will include items in totals only under producer AAA, because it comes first alphabetically. The report does not consider which code is truly in the PR1 field.

Include Item in Totals for All Producers

With this option, if there is an item with a producer ABC and another producer XYZ, the production report will list the item under each producer on the report. Under each producer, the item will add into the agency commission and gross premium subtotals. This inflates the bottom-line totals for agency commission and premium amount. An agency may run the report with this option to get an accurate view of how much agency commission or premium dollar amount each producer brings. (Perhaps the producer is paid based on this information.) This report provides this information. Just remember that the bottom line totals are inflated.

When this sort is selected, the sort option on the parameter displays as PRO(A).

Only Include First Producer Per Transaction

With this option, if there is an item with producers ABC and XYZ, the production report will only list the item once on the report under the first producer - ABC. Running the report like this will not inflate agency commission and gross premium amounts in the bottom-line report totals. The item will not list under producer two at all.

When this sort is selected, the sort option on the parameter list displays as PRO(1).

Note: Unlike in option number 1, this option of the report does look at the PR1 field. It will list the item under the producer code that is in PR1 (even if the code in PR2 comes first alphabetically).

Other Sort Notes

There are some transactions out there that do not file with certain codes on them. For example, when TRNs (transfers between clients) are done, they will not file with a producer code, personal/commercial indicator, etc. Reports sorted by producer include a section called "NO PRODUCER" that lists TRNs and PAYs originally left on account, etc. Keep this in mind when using any special sort; some transactions may not file with that information filled in.

Bill Mode Information

The Bill Mode option on the Production Report offers the following selections:

All Bill Types

Includes Agency Bill, Lienholder Bill, Broker Bill, and Direct Bill. If this option is selected, the user will be prompted to make a more specific selection for Direct Bill. TAM will ask if the user wants to view Direct Bill Production Items or Direct Bill Paid Items. The Direct Bill Paid Items option lists the COM transactions. This should allow the user to compare the Production Report to the Income Statement, regardless of the Accounting Setup for their Direct Bill Production (see the Direct Bill section for more details).

All Bill Types (except Direct Bill)

This  shows all the agency bill types, including Broker Bill and Lienholder Bill.

Only Direct Bill

If this option is selected, the user will be prompted to select whether they want to view Direct Bill Production Items or Direct Bill Paid Items. The Direct Bill Paid Items option lists the COM transactions.

Note: If the agency runs on a CASH basis for Direct Bill, the Income Statement will show the commission checks the agency has received and deposited against the Direct Bill Income account. In theory, you should be depositing the exact amount that was flagged, but, in reality, this is not always the case. The user must determine this for each situation. If the agency runs on an Accrual basis for Direct Bill, then the Production report would be run for invoiced direct bill items, and the income statement should match, because it will contain the Month-End journal entries generated from the invoiced items/transactions.

The remaining selections are Only Agency Bill, Only Broker Bill, and Only Lienholder Bill.

Last Revised: September 19, 2008 02:09 PM

SWE1915