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

Page History: Print Sales Order

Compare Page Revisions

0 Current 0

« Older Revision - Back to Page History - Current Revision

Page Revision: Fri, 29 May 2009 11:22

Table of Contents [Hide/Show] Default Menu Location General Description Fields/Filters Standard Report Fields(Page Header)    Bill To    Ship To    Page Header continued Standard Report Fields(Line Items) Standard Report Fields(Page Footer)

Default Menu Location¶

Reports >> Order Entry >> Print Sales Order

Click here for screenshot

General Description¶

Print Sales Order screen has the ability to generate one or more sales orders and the packing lists. To print a sales order, enter the SO number. To print more than one SO, enter the beginning SO number and the ending SO number with colon in between the two numbers.

Fields/Filters¶

Sales Order Numbers: To generate reports for these Sales Order(s)

Sales Order: Check this button for Sales Orders only

Packing list: Check this button for Packing List only

Both: Check this button to print both the Sales Orders and Packing List

Standard Report Fields(Page Header)¶

Company

• a_cid.address1
• alltrim(a_cid.city)+", "+alltrim(a_cid.state)+" "+a_cid.zipcode
• "Phone: "+alltrim(a_cid.phone)
• "Fax: " + a_cid.fax
  

Order Date

• sodate
  

Form Type and Sales Order number

• lc_formtype + " " + sono
  

Shipping Event

• lc_shipevent
  

Bill To¶

• a_ent.company
  

• a_ent.address1
  

• alltrim(a_ent.city)+", "+alltrim(a_ent.state)+" "+a_ent.zipcode
  

• a_ent.country
  

• "Phone: "+alltrim(a_ent.phone)+ " Fax: " + a_ent.fax
  

Ship To¶

• a_ent.company
  

• a_ent.address1
  

• alltrim(a_ent.city)+", "+alltrim(a_ent.state)+" "+a_ent.zipcode
  

• a_ent.country
  

• "Phone: "+alltrim(a_ent.phone)+ " Fax: " + a_ent.fax
  

Page Header continued¶

Customer

• custno
  

Ship Via

• shipvia
  

F.O.B

• fob
  

Terms

• terms
  

Purchase Order Number

• custpo
  

Salesperson

• sp
  

Reference No.

• orderno
  

Standard Report Fields(Line Items)¶

Qty. Ordered

• transform(qtyord)
  

Qty. Shipped

• transform(qtyshp)
  

Back Ordered

• transform(qtyord-qtyshp)
  

Item Number

• item
  

Item Description

• descrip
• linenotes
• socdesc
  

Unit

• unit
  

Req Date

• reqdate
  

Price

• transform(sprice) + "/" + spriceunit
  

Disc

• disc
  

Tax

• iif(taxable,'y','n')
  

Extended Price

• extstot
  

Standard Report Fields(Page Footer)¶

Shipping Sub-Total

• ln_shiptot
  

Packing Sub-Total

• ln_packtot
  

Non Taxable Sub-Total

• ln_nontaxsub
  

Taxable Sub-Total

• ln_taxsub
  

Tax Amount

• ln_tottax
  

Less Discount

• ln_disamt
  

Total Ordered

• ln_shiptot+ln_nontaxsub+ln_taxsub+ln_tottax - ln_disamt + ln_packtot