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

Page History: Salesperson Collection Report

Compare Page Revisions

10 9 8 7 6 5 4 3 2 1 0 Current 10 9 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Wed, 27 Jul 2011 15:57

Table of Contents [Hide/Show]    General Information    Report Filters    Standard Report Fields       Page Header       Group Header 1       Group Header 2    Standard Report Fields (Line Items)       Group Footer (Custno)       Group Footer (SP)    Page Footer

General Information¶

Default Menu Locator Reports >> Accounts Receivable >> Salesperson Collections Report

Screen Name' ARSP90

Click here for a screenshot

Function Sales Person Collection Report screen allows you to see the status of aging AR reports.

Report Filters¶

Age From: Inventory Date or Due Date for the report

Older Than: Days range for the report

Invoice Status: The status of the invoices from the report

Sales Person: The Sales Person for the report

Account Manager: The Account Manager for the report

Drill Down View: Drill Down View of the report

Standard Report Fields¶

Page Header¶

Company: Company name

• lc_comapny
  

Report:

• lc_report
  

Title:

• lc_title
  

Group Header 1¶

SP: Sales Person

• "SP: " + sp
  

Group Header 2¶

Company and customer number

• alltrim(company) + " - " + custno
  

Standard Report Fields (Line Items)¶

Invoice#

• invno
  

InvDate

• ttod(invdate)
  

Due Date

• ttod(duedate)
  

Type

• invtype
  

Inv Amount

• totamt
  

Balance

• balance
  

Group Footer (Custno)¶

Customer Total

• totamt
  

• balance
  

Group Footer (SP)¶

SP Total

• totamt
  

• balance
  

Page Footer¶

Total

• totamt
  

• balance