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 - Current Revision

Page Revision: Wed, 27 Jul 2011 16:05

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

General Description¶

Default Menu Location Reports >> Shipping >> Shipped Sales Report

Screen Name SHIPPEDSALES

Click here for screenshot

Function 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¶