Sage 50 UKI Ideas Portal

Breakdown of older debtors

Hi,


It would reduce time on me exporting and having to break the data down

  • Guest
  • Jul 12 2024
  • Guest commented
    08 Aug 11:09

    TBH I've all but given up on the "built in" reports and generally use exported data. Originally it was report data exported to excel but I've been moving to using ODBC so that I can have an excel sheet with a macro powered button that sucks the data from Sage (like the report designer) and rebuilds the report(s).

    You can change the number of days applied in each breakdown for aged debtors, but you are limited to 4 areas with the last being a maximum of 999 days (a little under 2 3/4 years) - anything over that cannot be broken down (you have to use transaction style reports with individual outstanding items exported to excel).