Vendor Totals Supplemental Information

Supplemental Information

Vendor Totals - Supplemental Information

Report Description	Formats
Important Notes / Disclaimers	Fields

Report Description:

This report provides a list of Vendor transaction totals by calendar month and year. Here are some typical GP users describing how they use it:

Mary, the Purchasing Manager:

There are many times when I want to see yearly transaction totals by vendor - either to compare key vendors for a given year or to see the yearly trend of purchases for a particular vendor. This report helps me identify who our biggest vendors are (sometimes the results are surprising!) and also gives me leverage for negotiating. Being able to say to a vendor, 'We've increased our purchases from you by 40% per year for the last 3 years, now let's talk about our pricing,' is invaluable in my purchasing process.

David, the Controller: Purchasing Manager

Every December or January we start looking at our 1099 totals. While GP will let us pull up information one vendor at a time, there is no quick way to compare the yearly 1099 amount against actual payments for all vendors at once. This report helps us quickly get all the data together and lets us zero in on potential issues before we print the 1099's.

For these reasons and more we offer the Vendor Totals report. It currently comes in 2 formats: SmartList Builder and Crystal Reports.

Formats:

Order a Report Print
Order
Form

SmartList Builder:

Includes 2 SmartLists: Vendor Yearly Totals and Vendor Monthly Totals
Based on SQL Server Views
Available for GP 8.0, GP 9.0 and GP 10.0
Go To's already set up (you can always add more of your own):
- Payables Transaction Inquiry (same as Payables Transaction Inquiry - Vendor)
- Vendor Maintenance
- Vendor Credit Summary Inquiry (only for Vendor Yearly Totals)
- Vendor Credit Summary (only for Vendor Yearly Totals)
Requires SmartList Builder.

View Sample

Crystal Reports:

Includes one report based on a SQL Server stored procedure
Available for Crystal XI
Parameters:

Vendor ID (beginning with)
Year
Class ID (beginning with)
1099 Type - choice of:

Not a 1099 Vendor
Dividend
Interest
Miscellaneous
All

Requires either Crystal Reports, or a product that will allow you to run a Crystal Report from within GP. If you are interested in one, please check out our GP Reports Viewer.

View Sample

Important Notes/Disclaimers:

This report uses the Calendar Year; if you need to see this data for your Fiscal Year instead, please let us know.
This report relies on summary tables in GP - it is not adding up individual transactions. That means if you have imported data directly into tables or manipulated data in the tables, you may not see correct results. Running Reconcile and Check Links for the Purchasing series should be sufficient to fix most minor issues.
To install any of our reports you will need to install our GP Reports Installer, which is included at no additional charge with every report we sell. The GP Reports Installer is a small Dexterity application that only needs to be installed on one computer (does not have to be on the server) and will control all our reports and their associated SQL components.
All of our reports have been tested with SQL Server 2000 and 2005. Our SQL code is encrypted- that means you will not be able to modify it without our help. You WILL be able to modify the actual report in any way you want - changing the layout, linking to additional tables, adding SmartList Go To's, etc.
As with any report, there is only so much available data to test with. While we make every attempt to test all reports with various data, your data may have something unique that we did not account for. Please let us know if you are not seeing expected results.

Fields:

Vendor ID
Vendor Name
Vendor Class ID*
Vendor Status* (shows Active, Inactive, or Temporary)
1099 Type* (shows Not a 1099 Vendor, Dividend, Interest, Miscellaneous)
Payment Terms ID*
Year
Month ^
Month Number*^
Amount Billed
Amount Paid
1099 Amount
Finance Charges
Writeoffs
Returns
Trade Discounts
Term Discount Avail*
Term Discount Taken*
Term Discount Lost*
Withholding*
Number of Invoices
No. of Finance Charges
Address 1*
Address 2*
City*
State*
Zip Code*
Tax ID*

LEGEND:

* - fields are available, but not displayed by default on the reports.

^ - not on the Yearly report

Site Terms of Use