AGING REPORT

Before You Begin

  • To get started, ensure you have your username and password ready
  • Once logged in, you will land on the welcome screen
  • Note: This screen is specifically designed to help users search aging report records, enhancing users ability to find accurate results efficiently

    1.1 SEARCH FOR AGING REPORTS:

    Step 1: ACCESS THE AGING REPORT SECTION

  • 1. Navigate to the main menu and click on "Accounts"
  • 2. Go to "Reports" and select "Aging Report"
  • Step 2: UNDERSTANDING THE SEARCH FIELDS

    The Aging Report Search Screen allows users to generate detailed reports by applying filters across various parameters. Below is a description of each field:

  • Invoice From Date: Specifies the starting date to filter invoices
  • Invoice To Date: Specifies the ending date to filter invoices
  • Due From Date: Defines the starting date for filtering invoices based on their due dates
  • Due To Date: Defines the ending date for filtering invoices based on their due dates
  • Supplier: (Multiselect dropdown) Allows selecting suppliers. Filters the report to show invoices associated only with the selected supplier(s)
  • Days Range: (Single select dropdown) Categorizes records into predefined periods. Helps identify invoices based on how long they have been overdue
  • By using these filters effectively, users can efficiently find and manage aging report records, helping streamline the process of reviewing and auditing aging reports

    STEP 3: UNDERSTANDING FIELD VALIDATIONS

    Once all necessary inputs are provided, click on Search to generate the report

  • Only one date range can be provided at a time: either Invoice From Date and Invoice To Date (or) Due From Date and Due To Date
  • Within each date range, both the From Date and To Date must be provided together. Providing only one of them is not accepted
  • It is not allowed to provide all four fields (Invoice From Date,Invoice To Date, Due From Date, Due To Date) at the same time
  • Only one date range pair (either Invoice or Due dates) is valid at a time
  • Note: By default, Invoice From Date is set to the first day of the current month, and Invoice To Date is set to the current date

    Due From Date and Due To Date are left blank and can be filled in by the user if required

    STEP 4: START SEARCHING

    Once all necessary inputs are provided, click on "Search" to generate the report

  • Clicking on Search will fetch the records based on the selected filters, enabling users to quickly narrow down data according to their needs
  • Clear Functionality: Selecting Clear will reset all the applied filters to their default values, ensuring a clean slate for a new search
  • By leveraging these features, users can effortlessly tailor the reports to their specific needs, enhancing overall compatibility and usability.

    Step 5: UNDERSTANDING SEARCH RESULTS TABLE

    The Aging Report Search Results Table displays detailed records based on the applied filters. Below is an explanation of each column and its relevance:

  • GRN Invoice Date: The date Goods Receipt Note (GRN) invoice was generated.
  • GRN Invoice Number: A unique identifier for each GRN invoice.
  • Supplier: The name of the supplier associated with the GRN invoice.
  • Pending Amount: The total balance amount that is yet to be paid for the invoice.
  • Aging Categories: The pending amounts categorized by days ranges.
  • For example:
  • Due Date: The date by which payment for the invoice is due.
  • Grand Total: The cumulative totals at the bottom of the table:
    • Total Pending Amount: The overall outstanding amount for all invoices.
    • Aging Category Totals: The total pending amounts split across each aging category.
  • This structure allows for a detailed view of supplier invoices, pending amounts, and their distribution based on payment due dates.

    Step 6: ADDITIONAL FEATURES OF THE TABLE

  • Sorting: Each column header allows sorting in both ascending and descending order, making it easier to organize and analyze data.
  • Pagination: The table displays the total number of records along with navigation options such as "Previous," "Next," and specific page numbers.
  • Entries Per Page: A dropdown at the bottom of the table allows users to select the number of entries to display per page (e.g., 10, 25, 50, 100).
  • Excel Export: Allows users to export the current data into an Excel file. This feature enables users to further analyze or share the report outside of the application.
  • Print: Enables users to print the displayed data directly from the table. It generates the report, ensuring that users can have hard copies for other purposes.
  • By providing these structured results with flexible navigation, sorting options, and additional features like Excel Export and Print, the table enhances user compatibility and ensures efficient analysis.

    That's It !! You’ve successfully learned how to Search Aging reports based on multiple filters using the DMeX app

    For further assistance, please contact the Support Team