Alpha Video Training
Results 1 to 2 of 2

Thread: ageing report

  1. #1
    vasant panjabi

    Default ageing report

    need to create an ageing report of total of payments due between

    0 to 30 days / 30 to 60 days / 60 to 90 days

    of `invoice` database

    besides creating the days past ` date()-inv_date`
    unable to proceed.

    any help would be most appreciated.


  2. #2
    Real Name
    Mike Vance
    Join Date
    Jun 2004
    Guernsey, Channel Islands

    Default RE: ageing report


    This is a Calculated field used in a report which shows aging balancesin a Sales Ledger application - in this case it calulates agings between 31 and 60 back from the global AgingDate variable. It works well in Alpha Version 5. There is a field in the Entries table set to Yes or No - you probably won't want the reference to that in the calculation.


    Hope this helps. Mike Vance

Similar Threads

  1. Web report similar to filtered desktop report
    By Robert Rough in forum Web Application Server v6
    Replies: 2
    Last Post: 06-08-2005, 11:14 AM
  2. Import a report in a sub-report
    By G Gabriel in forum Alpha Five Version 6
    Replies: 2
    Last Post: 03-11-2005, 06:02 PM
  3. Report Detail into Report String
    By Carey Sovereign in forum Alpha Five Version 4
    Replies: 1
    Last Post: 04-01-2003, 09:25 PM
  4. Report Footer and "Internal Report Error"
    By GregOnline in forum Alpha Five Version 4
    Replies: 3
    Last Post: 04-23-2002, 09:30 AM
  5. set report summary report non zero balances
    By vasant panjabi in forum Alpha Five Version 4
    Replies: 2
    Last Post: 11-15-2001, 05:45 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts