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: Mon, 01 Jun 2009 16:58

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

Default Menu Location¶

Reports >> Shipping >> Shipped Sales Report

Click here for screenshot

General Description¶

Shipped Sales Report screen allows users to generate detail information about shipments made to the customers. Users have an option to leave the "Customer ID" blank for shipments information on all the customers or enter customer ID for specific 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

Net Amount Sales Tax

Total: * extstot * exttax

Buildings: * gc_biliding * gc_buildtax

Mini Warehouse: * gc_mini * gc_minitax