Report: Company Accounts Payable

This feature, or some fields and options described, might not be available depending on your settings, security rights, or platform package.

The Company Accounts Payable report provides a register of company payables. All invoice activity that is open during the reporting date range is reported.

This report is accessible from any center or form with a Toolbox menu. Selecting Toolbox > Reports takes you to the Reports - All list where you can make your selection.

Click Company Accounts Payable. This opens the Report - Company Accounts Payable selection form. Make your selections, pull down the File menu and select to:

Print
Print Preview
Create CSV to export the report to the program of your choice.
Preview Cover Page

Report Selections

What is this?

Report Date Range

Options

What is this?

From List

Use this option to select a pre-defined date range from the list. The default is All.

All includes dates beyond the current system date.

Select Dates

Use this option to type in a specific date range not covered by the choices in the From Listoption.

Additional Selections

Fields	What is this?
Customer	The default is (All), or you can search for and select a specific customer. When a specific customer is selected through the Search option, the Policy and Invoice options are enabled. Narrow the search by selecting a specific policy and invoice to review payments to a company for a single item. Customer Search is subject to your business unit security.
Division	The default is (All), or you can select a specific division.
Company Type	The default is All company types. This selection is disabled if a single customer is selected. You can choose: All Brokerage Company Fee Company Insurance Company
Company	The companies included in the list depend on the Company Type selected. This selection is disabled and blank if a single customer is selected.

Description

Accept the default description, or enter a new one that describes the report you are requesting.

Print Cover Page

Allows you to include a cover page listing the selected options included in the report. This option defaults as unchecked.

As of v2.0, when we allowed company beginning balance journal entries (BJE) to be entered at startup on AMS 360, they now appear in the Company Accounts Payable report:

BJE is the Type.
The Agency Gross field will be 0.00.
The Net Payable will be the amount of the BJE.
The TotalPaid will be the amount of the BJE.

Report Fields	Description
Division/Company	This report sorts first by division and then by company. The Division/Companyheader is followed by report detail for that division/company combination.
Customer	The customer name (firm name, if available; if not, then last name, first name).
Policy/Description	Policy Number for an invoice, and Description for a check, receipt or journal entry transaction.
Type	Accounting Transaction Code.
Inv/Ref#	Invoice number, or a system reference number for a check, receipt or journal entry.
Check #	If payment was rendered by check, the number assigned to the check when printed. If the check is not printed, the check number is "unassigned".
EffDate	Invoice effective date.
GLDate	General ledger posting date.
PaidToCo	The amount paid to the company for an invoice via a check, receipt, or journal entry transaction.
AgencyGross	Gross premium/non-premium for the invoice. For Company BJE's (Beginning Balance Journal Entry), the AgencyGross will be 0.00.
NetPayable	Net premium/non-premium payable to the company for the invoice. For Company BJE's (Beginning Balance Journal Entry), the BJE amount prints in the NetPayable field.
Total Paid	Total of payments made to the company on the invoice.

CSV Columns	Description
Division	General ledger division name.
Company	Company name.
Customer	Customer name
Policy	Policy number.
Description	Description of the transaction.
Type	Accounting Transaction Code.
InvNo	Invoice number.
Ref#	Reference number assigned to the source transaction (check, journal entry or receipt).
Check#	Check number, if applicable. If the check is not printed, the check number is "unassigned".
InvEffDate	Invoice effective date.
GLDate	Date transaction posted to the general ledger.
PaidToCo	The amount paid to the company for an invoice via a check, receipt, or journal entry transaction.
AgencyGross	Gross premium/non-premium for the invoice. For Company BJE's (Beginning Balance Journal Entry), the AgencyGross will be 0.
NetPayable	Net premium/non-premium payable to the company for the invoice. For Company BJE's (Beginning Balance Journal Entry), the BJE amount prints in the NetPayable field.
TotalPaid	Total of payments made to the company on the invoice.

My Vertafore Support | Vertafore University | NetVU Network | Vertafore.com

© 2015 Vertafore, Inc. and its subsidiaries. All Rights Reserved. Vertafore, the Vertafore design, AMS360, Vertafore Producer Advantage, Producer Plus, AgencyEDGE, ReferenceConnect, BenefitPoint, Engage, and WorkSmart are registered trademarks of Vertafore, Inc. or its subsidiaries. Third party marks belong to their respective holders. AMS360 Classic Help updated 5/18/2016 10:58 PM