Welcome Guest, you are in: <root>AFIweb • Login

Page History: Vendor Distribution by Value Report

Compare Page Revisions

3 2 1 0 Current 3 2 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: Thu, 14 May 2009 12:15

Table of Contents [Hide/Show] Default Menu Location General Description Fields and Filters Standard Report Fields(Page Header) Standard Report Fields(Line Items)

Default Menu Location¶

Reports >> Purchase Order >> Vendor Distribution By Value

Click here for screenshot

General Description¶

Vendor Distribution by Value Report displays a list of all the vendors including how much your company has spent within a specific time frame.

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