Navigation¶

• Adjutant Wiki Home
  

• CRM Wiki
  

• AFI Wiki
  

• Categories
• All Pages
• Create a new Page
  

• Administration
• File Management
  

• Login/Logout
• Consultant Guide
• Your Profile
• Create Account
  

Quick Search
»


Advanced Search »

Shipped Sales Report

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¶