Welcome Guest, you are in: <root>AFIweb • Login

Page History: Drop Ship Report

Compare Page Revisions

2 1 0 Current 2 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: Thu, 21 May 2009 08:27

Table of Contents [Hide/Show] Default Menu Location General Description Fields/Filters Standard Report Fields(Page Header)    Group Header 1:Custno    Group Header 2:Shipno    Group Header 3:Sono Standard Report Fields(Line Items) Additional Report Fields for Customization

Default Menu Location¶

Reports >> Shipping >> Drop Ship Report

Click here for screenshot

General Description¶

Drop Ship Report screen generates a report with Sales Order numbers, item descriptions, order and shipped quantity.

Fields/Filters¶

Company: Company name and code

Ship To: Company name and code

SO Date Range: Sales Order date range

Item: Item code

Whse: Warehouse location

Standard Report Fields(Page Header)¶

Company

• company
  

Report

• lc_report
  

Filter

• lc_filter
  

Group Header 1:Custno¶

Sold TO

• alltrim(company) + " : " + alltrim(custno)
  

Group Header 2:Shipno¶

Ship TO

• alltrim(scompany) + " : " + alltrim(shipno)
  

Group Header 3:Sono¶

SO# Date

• sono
• ttod(sodate)
  

Standard Report Fields(Line Items)¶

Item

• item
  

Description

• descrip
  

QtyOrd

• qtyord
  

QtyShp

• qtyshp
  

Additional Report Fields for Customization¶