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

Page History: Shipped Sales 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: Thu, 23 Jul 2009 11:21

Table of Contents [Hide/Show] Default Menu Location General Description Fields/Filters Standard Report Fields(Header) Standard Report Fields(Detail) Summary Additional Report Fields for Customizations

Default Menu Location¶

Reports >> Shipping >> Shipped Sales Report

Click here for screenshot

General Description¶

The Shipped Sales Report is a clone of the Invoice Register Report that includes a summary band with information specifically for a metal building company.

Fields/Filters¶

Customer ID: Customer code

Start Date: Starting date for the report

End Date: Ending date for the report

Invoice Status: Status of generating invoices

Standard Report Fields(Header)¶

Company

• lc_company
  

Report

• lc_report
  

Date Range

• lc_date
  

Standard Report Fields(Detail)¶

Order

• alltrim(orderno)
  

Type

• alltrim(sotype)+ " "+substr(priority,14,1)
  

Invoice Date

• invdate
  

Bill Cycle

• bcycle
  

Customer

• custno
  

Company

• company
  

Net Amount

• extstot
  

Sales Tax

• exttax
  

Invoice Total

• totamt
  

Summary¶

Total Buildings Mini Warehouses Component Buildings Component General Component Mini Warehouses

Net Amount extstot gc_building gc_mini gc_cb gc_cg gc_cm

Sales Tax exttax gc_buildtax gc_minitax gc_cbtax gc_cgtax gc_cmtax

Additional Report Fields for Customizations¶