Preparation of Dunning Letters: To Run the AR Aging Report

The following activity will walk you through the process of running the AR Aging report.

Story

Suppose that the Credit Control team of SweetLife Fruits & Jams starts its operation with finding out which customer accounts are overdue. The team lead runs the AR Aging report to see which invoices are still open, the balances of unpaid invoices, and how long the invoices have been outstanding.

Acting as Yona Jones, you need to run the AR Aging (AR631000) report for local customers of the DEFAULT customer class and analyze this information with the team.

Configuration Overview

In the U100 dataset, the following tasks have been performed for the purposes of this activity:

  • On the Enable/Disable Features (CS100000) form, the Dunning Letter Management feature has been enabled.
  • On the Statement Cycles (AR202800) form, the EOM (End of Month) statement cycle has been created.
  • On the Customers (AR303000) form, for customers of the DEFAULT customer class, the EOM cycle has been selected in the Statement Cycle ID box on the Financial tab.

Process Overview

In this activity, you will run a report on the AR Aging (AR631000) form for the customers of the DEFAULT customer class, and review the list of past-due amounts for these customers.

System Preparation

Before you begin running the AR Aging report, do the following:

  1. Launch the MYOB Acumatica website with the U100 dataset preloaded, and sign in as Jona Jones by using the jones username and the 123 password.
  2. In the info area, in the upper-right corner of the top pane of the MYOB Acumatica screen, click the Business Date menu button, and select 1/31/2024 on the calendar.
  3. On the Company and Branch Selection menu on the top pane of the MYOB Acumatica screen, select the SweetLife Head Office and Wholesale Center branch.

Step: Running the AR Aging Report

To run the AR Aging (AR631000) report, do the following:

  1. Open the AR Aging form.
  2. On the Report Parameters tab, specify the following settings:
    • Report Format: Summary
    • Company/Branch: SWEETLIFE
    • Customer Class: DEFAULT
    • Age as of Date: 1/31/2024
  3. On the form toolbar, click Run Report and review the printed report form.

    On the report, notice that the GOODFOOD customer has past-due documents whose amount is shown in the 11 - 30 Days aging bucket. The COFFEESHOP customer has a past-due document with the amount shown in the 31 - 60 Days aging bucket, and multiple customers have past-due documents that fall within the Over 60 Days aging bucket. The Credit Control team will start the dunning process by preparing dunning letters for all these customers.