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 »

Drop Ship Report

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¶

The Drop Ship Report generates a report of items marked as a drop ship on Sales Orders.

The report displays Customer, SO#, SO Date, Item, and Quantity Ordered/Shipped information.

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¶