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:10

Table of Contents [Hide/Show] Default Menu Location General Description Fields and Filters Standard Report Fields Group Header1 (by Item) Group Header2 (by custno) Detail Line Items Group Footer2 (by custno) Group Footer2 (by item) Page Footer Summary

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