Shipped Sales Report

Modified on Wed, 27 Jul 2011 16:05 by Greg Andrews Categorized as Accounts Receivable , Metal Construction Industry, Sales Force

{TOC}

===General Description===

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

'''Screen Name''' SHIPPEDSALES

[http://www.abiscorp.com/adjwiki/GetFile.aspx?File=Shipping\Shipped Sales Report.jpg|Click here for screenshot]

'''Function''' The Shipped Sales Report is a clone of the [Invoice Register Report|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===

<table border="0"><tbody><tr><td><p>&nbsp;</p><p>Total</p><p>Buildings</p><p>Mini Warehouses</p><p>Component Buildings</p><p>Component General</p><p>Component Mini Warehouses </p></td><td><p><strong>Net Amount</strong></p><p>extstot</p><p>gc_building</p><p>gc_mini</p><p>gc_cb</p><p>gc_cg</p><p>gc_cm</p></td><td><p><strong>Sales Tax</strong></p><p>exttax</p><p>gc_buildtax</p><p>gc_minitax</p><p>gc_cbtax</p><p>gc_cgtax </p><p>gc_cmtax</p></td></tr></tbody></table>

===Additional Report Fields for Customizations===

Meta Keywords:
Meta Description:
Change Comment:

Desktop Adjutant

Navigation¶

Shipped Sales Report