Vendor Margin Analysis Report overview

Vendor > Reports > AP Reports > APRVM

Function acronym: APRVM

Use this report to calculate the total purchases from qualifying vendors by product line and warehouse, and compare the totals for each record against the overall totals and calculates percentages.

Use it to measure which product lines and vendors provide the greatest profitability for your company. Percentages are calculated to determine each vendor's share of the grand total.

Note:  In order to properly reflect your vendor's year-to-date amounts, perform Vendor Administrator Year End to reset accumulating totals to zero at the beginning of your fiscal year.

Vendor Purchase History Setup is the source of the sales year-to-date figure. Sales year-to-date represents the total amount sold in Sales Order Entry for this product line or vendor. Vendor Purchase History Setup is also the sources of the cost year-to-date numbers. Cost year-to-date represents the accumulative cost of each product sold in Sales Order Entry. The difference between sales year-to-date and cost year-to-date is the margin year-to-date.

The cost to process a purchase order from SA Administrator Options-Vendor-Analysis is multiplied by the number of purchase orders processed year-to-date. This amount is subtracted from the margin year-to-date to provide a profit year-to-date figure on your report.