Shipped Sales Report

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

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