Alpha Video Training
Results 1 to 2 of 2

Thread: ageing report

  1. #1
    vasant panjabi
    Guest

    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.

    regards,
    v.p.

  2. #2
    Member
    Real Name
    Mike Vance
    Join Date
    Jun 2004
    Location
    Guernsey, Channel Islands
    Posts
    419

    Default RE: ageing report

    Vasant

    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.

    if(((Entries-"Cleared='No'.AND.var-"AgingDate-Entries-"Entry_Date"30).AND.(var-"AgingDate-Entries-"Entry_Date"=60)),calc-"Custbalance,0)

    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

Bookmarks

Posting Permissions

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