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

Page History: Items Invoiced Report

Compare Page Revisions

3 2 1 0 Current 3 2 1 0

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

Page Revision: Mon, 15 Jun 2009 12:09

Default Menu Location¶

Reports >> Item Control >> Items Invoiced Report

Click here for screenshot

General Description¶

Items Invoiced report allows users to generate an Items Invoiced report by selecting the customer, a date range, the specific item or the item description.

Fields and Filters¶

Custno: Specific customer number for the report

Company: Specific company name for the report

Invoice Dates: Specific data ranges for the report

Item: Specific item number for the report

Item Description: Specific item description for the report

Standard Report Fields¶

Company

• lc_company
  

Report title

• lc_report
  

Date range selected

• lc_date
  

Company and/or company number selected

• lc_title
  

Group Header1 (by Item)¶

Item

• Item
  

Descrip

• Descrip
  

Group Header2 (by custno)¶

Company

• alltrim(company) + " - " + custno
  

Detail Line Items¶

Inv#

• invno
  

InvDate

• invdate
  

GLAcct/PostAcct

• alltrim(glacct)+iif(not empty(postacct),"/("+alltrim(postacct)+")","")
  

QtyShipped

• qty2bill
  

Price

• extstot/qty2bill
  

Total

• extstot
  

Group Footer2 (by custno)¶

Customer number

• Custno
  

Subtotal by customer number

• extstot
  

Group Footer2 (by item)¶

Item number

• item
  

Subtotal by item number

• extstot
  

Page Footer¶

Datetime

• datetime
  

Page Number

• "Page " + alltrim(str(_pageno))
  

Summary¶

Grand Total

• extstot