Adjutant
Welcome Guest, you are in: Login

Desktop Adjutant

RSS

Navigation







Quick Search
»


Advanced Search »

Page History: Invoices to Date Report

Compare Page Revisions



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


Page Revision: Thu, 25 Jun 2009 10:20



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 - SobillpckS)

Date time: Datetime()

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



Adjutant Wiki via Screwturn version 3.0.5.600. You are logged in as Guest. There are 921 pages in the Wiki. Learn More About Adjutant Enterprise Solutions