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

Page History: Invoices to Date Report

Compare Page Revisions

12 11 10 9 8 7 6 5 4 3 2 1 0 Current 12 11 10 9 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Wed, 08 Jul 2009 13:50

Table of Contents [Hide/Show] Default Menu Location General Description Report Filters Standard Report Fields (Header - SobillpckS ) Standard Report Fields (Detail - SobillpckS ) Standard Report Fields (Group Footer Msn - SobillpckS ) Standard Report Fields (Summary - SobillpckS ) Standard Report Fields (Header - Sobillpck ) Standard Report Fields (Group Header Sono - Sobillpck) Standard Report Fields (Detail - Sobillpck ) Standard Report Fields (Group Footer Sono - Sobillpck ) Standard Report Fields (Summary - Sobillpck ) Additional Report Fields for Customization

Default Menu Location¶

Reports >> Accounts Receivable >> Invoices to Date Report

Click here for screenshot

General Description¶

The Invoices to Date screen generates reports based on projects, orders and invoices.

Report Filters¶

Sales Order: Provides a dropdown of all existing sales orders based on the data typed in.

Multi-selectable list box: Allows selection of multiple order types.

Project Number: Report can be run by project number by leaving sales order blank

Date Range: Report can be run by date ranges instead of by sales order or project number

Standard Report Fields (Header - SobillpckS)¶

Report Filters Selected

• lc_rep
  

Project

• alltrim(msn)
  

Order

• alltrim(sono)
  

Customer

• alltrim(customer)
  

Standard Report Fields (Detail - SobillpckS)¶

Order/Invoice Number

• alltrim(sono)
  

• Invno
  

Order/Invoice Date

• sodate
  

• invdate
  

Steel

• sbase
  

• ibase
  

Non-Steel

• nosteel
  

• nsteel
  

Packing

• spacking
  

• ipacking
  

Freight

• sfreight
  

• ifreight
  

Tax

• stax
  

• itax
  

Contract Total

• stotal
  

• itotal
  

Standard Report Fields (Group Footer Msn - SobillpckS)¶

Subtotal

• sbase - ibase
  

• nosteel - nsteel
  

• spacking - ipacking
  

• sfreight - ifreight
  

• stax - itax
  

• sctotal - ictotal
  

Standard Report Fields (Summary - SobillpckS)¶

Balance Open To Be Invoiced

• diffbase
  

• diffnosteel
  

• diffpack
  

• difffreight
  

• difftax
  

• diffctotal
  

Standard Report Fields (Header - Sobillpck)¶

Report Filters Selected

• lc_rep
  

Standard Report Fields (Group Header Sono - Sobillpck)¶

Project

• alltrim(msn)
  

Order

• alltrim(sono)
  

Customer

• alltrim(customer)
  

Order Date

• sodate
  

Steel

• sbase
  

Non-Steel

• nosteel
  

Packing

• spacking
  

Freight

• sfreight
  

Tax

• stax
  

Contract Total

• sctotal
  

Standard Report Fields (Detail - Sobillpck)¶

Invoice Number

• Invno
  

Invoice Date

• invdate
  

Steel

• ibase
  

Non-Steel

• nsteel
  

Packing

• ipacking
  

Freight

• ifreight
  

Tax

• itax
  

Contract Total

• ictotal
  

Standard Report Fields (Group Footer Sono - Sobillpck)¶

Total Invoiced

• ibase
  

• nsteel
  

• ipacking
  

• ifreight
  

• itax
  

• ictotal
  

Open

• sbase - ibase
  

• nosteel - nsteel
  

• spacking - ipacking
  

• sfreight - ifreight
  

• stax - itax
  

• sctotal - ictotal
  

Standard Report Fields (Summary - Sobillpck)¶

Date time: Datetime()

Page: "Page " + alltrim(str(_pageno))

Additional Report Fields for Customization¶