Accounts Receivable Aging by Invoice-to BP

You can compare this dashboard with the Aging Analysis Summary from the Receiving Aging Analysis (tfacr2620m000) session of LN. Ensure to match the settings used when calculating the Receiving Aging Analysis in LN with these filters in LN Analytics: Accounts Receivable Document Type, Advance Invoice or Payment Request, Accounts Receivable Doubtful.

LN Analytics calculates aging based on due date and does not exclude receipt procedure steps.

Report

  • Accounts Receivable Aging by Invoice-to BP

    This report shows totals per Invoice-to BP for:

    • Main documents
    • Not segment-based

    The table report displays balance, overdue amounts for the age buckets, and estimate uncollectable measures.

    The age bucket is determined based on the number of days overdue:

    • For fully paid invoices: Clearing Date - Due Date
    • For open invoices: Current Date - Due Date

    The non-payment probability increases with age, the uncollectable amount is estimated by assigning percentages to each age bucket and summing the estimated unpaid amounts for each age bucket.

    The default buckets with estimate percentages are: Not yet due (1%), 1-30 days (5%), 31-60 days (10%), 61-90 days (25%), 91-99999 days (50%).

    Buckets and estimate percentages can be changed in user variables.