Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Location
    Anchorage, AK
    Posts
    3

    Question Default Order Entry 30, 60, 90 aging report

    Hello,
    I'm using the Default Order Entry Database Receivable Aging 30, 60, 90 day report. It's working fine except I don't need line by line date entries in the report, just the total amount due.

    I'm trying to get a report similar to the Total Sales by Customers but with 30, 60, 90 days. My inputs are:

    Customer Name
    Acct#
    Total Sales or Amount Due

    by 0-30, 31-60, 61-90, 90+ columns.

    Please help. Thank you.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    hide the detail section then ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Sep 2006
    Location
    Anchorage, AK
    Posts
    3
    I'm still new in this database.
    so, for ex. I looked in the detail section and have the following:
    Customer Name, Acct# 0-30, 31-60, 61-90, 90+ in the detail section.

    for ex.
    1 customer has 2 line entries, line 1=$30.00 & line 2=$70.00 totaling in 0-30 $100.00

    2nd customer has 3 line entries, line 1=$30.00, line 2=$30.00 & line 3=$30.00 totaling $90.00, 0-30 $60.00, 31-60 $30.00.

    it's currently just pring the 2 line entries for customer 1 & 3 line entries for customer 2.

    what I need is just the totals in aging report for $100.00 & $90.00 only but still shows customer & acct's with totals. The reports footer is just fine will need totals for all customers.

    I looked in the detail section if I hide them then will it just print the totals for each customers plus the report footer?

  4. #4
    Join Date
    Sep 2006
    Location
    Anchorage, AK
    Posts
    3

    Question Aging Reports

    Hello again,
    I was looking at the Sales by customer reports. It would work if the totals can be in a aging report by 0-30, 31-60, 61-90, 90+.

    can anyone help me with this report. thank you.

Posting Permissions

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