Navigation¶

• Adjutant Wiki Home
  

• CRM Wiki
  

• AFI Wiki
  

• Categories
• All Pages
• Create a new Page
  

• Administration
• File Management
  

• Login/Logout
• Consultant Guide
• Your Profile
• Create Account
  

Quick Search
»


Advanced Search »

Vendor Distribution by Value Report

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

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
  

Additional Report Fields for Customization¶