Difference between revisions of "Vendor Distribution Report"

From Adjutant Wiki
Line 1: Line 1:
 +
__NOTOC__
 +
===General Information===
  
 +
'''Default Menu Location''' Reports >> Purchase Order >> Vendor Distribution Report
 +
 +
'''URL''' Reports/VendorDistributionReport_S.htm
 +
 +
'''Function''' Creates a report of an organization's spending across vendors in a defined date range.
 +
 +
[[image:venddistrep.png]]
 +
 +
===Instructions===
 +
 +
'''1.''' Select filters for the report. This report can be filtered by vendor, item number, and date range.
 +
* Leave "Vendno" blank for a report of all vendors used within a date range.
 +
*Leave "Item" blank for a report summing all items purchased per vendor.
 +
*Leave both blank for a report comparing total expenditures per vendor that displays all vendors used.
 +
 +
[[image:venddistrep2.png]]
 +
 +
'''2.''' Click the '''Report''' button. Use the '''Save RS Opts''' button to save a set of filters for future reports from this screen.
 +
 +
[[image:venddistrep3.png]]
 +
 +
==Fields and Filters==
 +
 +
'''Vendor No:''' Vendor number
 +
 +
'''PO Date:''' Specific Purchase Order date
 +
 +
'''Item no:''' Item number or item code
 +
 +
==Standard Report Fields(Page Header)==
 +
 +
'''Company'''
 +
 +
* lc_company
 +
 +
'''Date Range'''
 +
 +
* lc_daterange
 +
* iif(empty(alltrim(lc_para)), '( All )' , '( ' + alltrim(lc_para) + ' )')
 +
 +
==Standard Report Fields(Line Items)==
 +
 +
'''Vendor No'''
 +
 +
* custno
 +
 +
'''Company'''
 +
 +
* company
 +
 +
'''Last Date'''
 +
 +
* iif(isnull(podate),'', podate)
 +
 +
'''$ Purchased in Date Range'''
 +
 +
* sales
 +
 +
'''Avg Pur Monthly'''
 +
 +
* totsales/ln_months
 +
 +
'''% of Purch'''
 +
 +
* round((totsales/lc_total),3) * 100
 +
 +
'''% of Cum Pur'''
 +
 +
* round((tot/lc_total),3) * 100
 +
 +
===Example Vendor Distribution Report===
 +
 +
[[image:venddistrep4.png]]
 +
 +
[[image:venddistrep5.png]]
 +
 +
[[category:Purchasing]]

Revision as of 15:22, 12 December 2022

General Information

Default Menu Location Reports >> Purchase Order >> Vendor Distribution Report

URL Reports/VendorDistributionReport_S.htm

Function Creates a report of an organization's spending across vendors in a defined date range.

Venddistrep.png

Instructions

1. Select filters for the report. This report can be filtered by vendor, item number, and date range.

  • Leave "Vendno" blank for a report of all vendors used within a date range.
  • Leave "Item" blank for a report summing all items purchased per vendor.
  • Leave both blank for a report comparing total expenditures per vendor that displays all vendors used.

Venddistrep2.png

2. Click the Report button. Use the Save RS Opts button to save a set of filters for future reports from this screen.

Venddistrep3.png

Fields and Filters

Vendor No: Vendor number

PO Date: Specific Purchase Order date

Item no: Item number or item code

Standard Report Fields(Page Header)

Company

  • lc_company

Date Range

  • lc_daterange
  • iif(empty(alltrim(lc_para)), '( All )' , '( ' + alltrim(lc_para) + ' )')

Standard Report Fields(Line Items)

Vendor No

  • custno

Company

  • company

Last Date

  • iif(isnull(podate),, podate)

$ Purchased in Date Range

  • sales

Avg Pur Monthly

  • totsales/ln_months

% of Purch

  • round((totsales/lc_total),3) * 100

% of Cum Pur

  • round((tot/lc_total),3) * 100

Example Vendor Distribution Report

Venddistrep4.png

Venddistrep5.png

Retrieved from "http://www.abiscorp.com/faq/index.php?title=Vendor_Distribution_Report&oldid=4219"