Aged outstanding (AR631500)

This topic provides information about the elements in this window in Visma Net, such as fields, field values, buttons, and check boxes.

This report is designed to show when you should expect to get payments for the outstanding documents. The report shows all open documents recorded in the system, regardless of the current business date or the date specified in the Ageing date field in the report window.

That is, the reports show open general ledger documents, even if they are posted to periods later than the ageing date period.

The documents are grouped by statement cycle and by customer, broken down by ageing periods. The amounts are shown in the base currency.

Calculating ageing periods

The system calculates ageing periods for this report based on the date you select in the Ageing date field on the Report parameters tab of this report form and on the statement cycle settings specified in the Statement cycles (AR202800) window as follows:

• If the Use financial periods for ageing check box is selected for the statement cycle, the system will use aging periods that correspond to the financial periods; the zero aging period (the Due date column in the report) is the financial period of the Ageing date on the Report parameters tab.
• If the Use financial periods for ageing check box is cleared for the statement cycle, the system will show the aging periods that are specified in the statement cycle.

On the generated report, the selected financial period is displayed in the Fin. period field and the last date of the period is displayed in the Aged on field.

Ageing outstanding documents

The system distributes the open invoices, debit notes, and overdue charges over the financial periods or ageing periods depending on the statement cycle settings in the Statement cycles (AR202800) window:

• If Due date is selected in the Age based on field for the statement cycle, the system will compare the due dates of outstanding documents with the Ageing date date you specify in this report window. The overdue balances are displayed in the zero ageing period (the Past due column on the report), while the balances that are not overdue are grouped by the ageing periods or financial periods specified for the statement cycle.
• If Document date is selected in the Age based on field for the statement cycle, the system will compare the document dates of outstanding documents with the Ageing date date you specify in this report window. The balances of the documents with dates earlier than the ageing date are displayed in the zero ageing period on the report. Other outstanding balances are broken down by the number of days from the Aged on of the report through the document date. For more information, see: About customer ledger ageing reports.

Ageing credit amounts

In the report, the amounts of open payments, prepayments, and credit memos are aged by periods if the Age credits check box is selected in the Customer ledger preferences (AR101000)window. If the credit amounts are aged, they are broken down by the number of days that have passed from the document date through the Aged on date. By default, the check box is cleared and the credit amounts show up in the Current column.

See below for a description of each parameter on the Report parameters tab.

Report parameters

You use the following parameters to select the information to be displayed on the report:

Element	Description
Report format	The format of the report. Select one of the following options: Detailed (default): To view outstanding customer documents. Summary To view outstanding customer balances.
Company	The company the report should cover. Select a company, or leave the field blank to view data on all companies. By default, the current company is selected. This field is available only if the Multi-branch support functionality is enabled in your system, in the Enable/disable functionalities (CS100000) window.
Branch	The branch the report should cover. Select a branch, or leave the field blank to view data on all branches. This field is available only if the Multi-branch support functionality is enabled in your system, in the Enable/disable functionalities (CS100000) window.
Customer class	The customer class for which you want to display data. Select a customer class from the list of customer classes, or leave the field blank to view information on all classes.
Customer	The customer to be reported on, if any. Select a customer by ID from the list of active customers, or leave the field blank to view information on all customers.
Ageing date	The date the system will use when calculating the ageing categories for the documents. By default, the current date is used, but you can select another date.
Group by parent account	A check box you select to group customer accounts that are involved in parent-child relationship under a parent account and display consolidated balance of the group. The system will group only those child accounts that have the Consolidate balance check box selected. The check box is available if the Parent-child customer relationship functionality is enabledthe Enable/disable functionalities (CS100000) window. For details, see: Manage parent-child relationships - overview.

## The report settings and options Before running a report, you set a variety of parameters in the report window. You can select a template or manually make selections that affect the information to be collected. Also, you can specify appropriate settings to print or email the report generated. ### The report window toolbar The following table lists the buttons of the report window toolbar when you are configuring a report. {{< vismanet-table >}} {{< vismanet-header-row >}} {{< vismanet-cell header="true" >}}Button{{< /vismanet-cell >}} {{< vismanet-cell header="true" >}}Description{{< /vismanet-cell >}} {{< /vismanet-header-row >}} {{< vismanet-row >}} {{< vismanet-cell >}} **Parameters**{{< /vismanet-cell >}} {{< vismanet-cell >}}Navigates to and from the report window to let you change the report parameters.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}} **Cancel**{{< /vismanet-cell >}} {{< vismanet-cell >}}Clears any changes you have made and restores default settings.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Run report{{< /vismanet-cell >}} {{< vismanet-cell >}}Initiates data collection for the report and displays the generated report.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Save template{{< /vismanet-cell >}} {{< vismanet-cell >}}Saves the currently selected report as a template with all the selected settings.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Remove template{{< /vismanet-cell >}} {{< vismanet-cell >}}Removes the previously saved template. This button is available only when you select a template.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Schedule template{{< /vismanet-cell >}} {{< vismanet-cell >}}Opens the **Select schedule name** dialog box, which you can use to schedule the processing of the report. This button is available only when you select a template.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Edit report{{< /vismanet-cell >}} {{< vismanet-cell >}} Opens Visma BI - Report Designer in a new browser tab, where you can edit your report. > [!NOTE] > However, if you are working with a [Balance sheet (GL634000)](/visma-net-erp/help/general-ledger/general-ledger-reports/balance-sheet-gl634000/) report or any Profit and loss report or a [Profit and loss (PM64300S)](/visma-net-erp/help/project-accounting/projects-reports/profit-and-loss-pm64300s/) report, you will be navigated to the [Report definitions (CS206000)](/visma-net-erp/help/general-ledger/general-ledger-windows/report-definitions-cs206000/) window to make your changes there. {{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Export report design{{< /vismanet-cell >}} {{< vismanet-cell >}} Makes a copy of the report that you can import (for example, for another company) by using the  button on the **Report versions** tab. Then you select that the copy of the report is not going to be the default version which is used when you click the **Run report** button. This button is only available for users assigned with the Report designer user role. {{< /vismanet-cell >}} {{< /vismanet-row >}} {{< /vismanet-table >}} #### The Select schedule name dialog box {{< vismanet-table >}} {{< vismanet-header-row >}} {{< vismanet-cell header="true" >}}Element{{< /vismanet-cell >}} {{< vismanet-cell header="true" >}}Description{{< /vismanet-cell >}} {{< /vismanet-header-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Schedule{{< /vismanet-cell >}} {{< vismanet-cell >}} The schedule for report processing. Select an existing schedule, or leave the field blank and click **OK** to open the [Automation schedules (SM205020)](/visma-net-erp/help/automation/automation-windows/automation-schedules-sm205020/) window to create a new schedule for running the report. {{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Merge reports{{< /vismanet-cell >}} {{< vismanet-cell >}} When this check box is selected, this report will be merged with the other reports selected for merging into one net report when processed. > [!NOTE] > You can check the reports that will be merged when processed in the [Send reports (SM205060)](/visma-net-erp/help/automation/automation-windows/send-reports-sm205060/) window. {{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Merging order{{< /vismanet-cell >}} {{< vismanet-cell >}}The number of the report in the net report.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< /vismanet-table >}} ### The template area Use the elements in this area to select an existing template and then use the template, share it with other users, or use it as your default report settings. The template area elements, which are available for all reports, are described in the following table. {{< vismanet-table >}} {{< vismanet-header-row >}} {{< vismanet-cell header="true" >}}Element{{< /vismanet-cell >}} {{< vismanet-cell header="true" >}}Description{{< /vismanet-cell >}} {{< /vismanet-header-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Template{{< /vismanet-cell >}} {{< vismanet-cell >}}The template to be used for the report. If any templates were created and saved, you can select a template to use its settings for the report.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Default{{< /vismanet-cell >}} {{< vismanet-cell >}}When this check box is selected, the selected template is marked as the default one for you. A default template cannot be shared.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Shared{{< /vismanet-cell >}} {{< vismanet-cell >}}When this check box is selected, the selected template is shared with other users. A shared template cannot be marked as the default.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Locale{{< /vismanet-cell >}} {{< vismanet-cell >}} A locale that you select to indicate to the system that the report should be prepared with the data translated to the language associated with this locale. > [!NOTE] > This field is displayed if there are multiple active locales in the system. {{< /vismanet-cell >}} {{< /vismanet-row >}} {{< /vismanet-table >}} ### The report toolbar The following table lists the buttons of the toolbar after you run the configured report. {{< vismanet-table >}} {{< vismanet-header-row >}} {{< vismanet-cell header="true" >}}Buttons{{< /vismanet-cell >}} {{< vismanet-cell header="true" >}}Description{{< /vismanet-cell >}} {{< /vismanet-header-row >}} {{< vismanet-row >}} {{< vismanet-cell >}} **Parameters**{{< /vismanet-cell >}} {{< vismanet-cell >}}Navigates back to the report window to let you change the report parameters.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}} **Refresh**{{< /vismanet-cell >}} {{< vismanet-cell >}}Refreshes the information displayed in the report (if any data changes were made).{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Groups{{< /vismanet-cell >}} {{< vismanet-cell >}}Adds to the report a left pane where the report structure is shown. Click a report node to highlight the pertinent data in the right pane.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}} **View PDF** / **View HTML**{{< /vismanet-cell >}} {{< vismanet-cell >}}Displays the report as a PDF, or displays the report in HTML format. The available button depends on the current report view; if you are viewing a PDF, for instance, you will see the **View HTML** button.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Go to first page (Ctrl + Page up){{< /vismanet-cell >}} {{< vismanet-cell >}}Displays the first page of the report.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Go to previous page (Page up){{< /vismanet-cell >}} {{< vismanet-cell >}}Displays the previous page.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Go to next page (Page down){{< /vismanet-cell >}} {{< vismanet-cell >}}Displays the next page.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Go to last page (Ctrl + Page down){{< /vismanet-cell >}} {{< vismanet-cell >}}Displays the last page of the report.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Print{{< /vismanet-cell >}} {{< vismanet-cell >}}Opens the browser dialog box so you can print the report.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Send{{< /vismanet-cell >}} {{< vismanet-cell >}}Opens the **Email activity** dialog box, which you use to send the report file (in the chosen format) to the specified email address.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Export{{< /vismanet-cell >}} {{< vismanet-cell >}} Allows you to export the data in the chosen format: + **Excel** + **Excel with headers** (this option is only available for ARM reports) + **PDF** {{< /vismanet-cell >}} {{< /vismanet-row >}} {{< /vismanet-table >}} ### The Report parameters tab This tab includes sections where you can specify the contents of the report depending on the current report and vary in the following regards: + How many elements and which elements are available on a particular report + Whether elements contain default values + Whether specific elements require values to be selected + Whether elements may be left blank to let you display a broader range of data ### The Additional sort and filters tab If you are working with a [Balance sheet (GL634000)](/visma-net-erp/help/general-ledger/general-ledger-reports/balance-sheet-gl634000/) report or any Profit and loss report or a [Profit and loss (PM64300S)](/visma-net-erp/help/project-accounting/projects-reports/profit-and-loss-pm64300s/) report, this tab is not shown in your report window. The **Additional sort and filters** tab contains additional sorting and filtering conditions: Additional sorting conditions : Defines the sorting order. You can add a line, select one of the report-specific properties, and select the **Descending** or **Ascending** sort order for the column. Additional filtering conditions : Defines the report filter. You can add a line, select one of the report-specific properties, and define a condition and its value. The list of conditions includes one-operand and two-operand conditions. To create a more complicated logical expression, you can use brackets and logical operations between brackets. ### The Print and email settings tab #### The Print settings section If you plan to print the report or save the report as a PDF, select the appropriate settings in the **Print settings** section. {{< vismanet-table >}} {{< vismanet-header-row >}} {{< vismanet-cell header="true" >}}Element{{< /vismanet-cell >}} {{< vismanet-cell header="true" >}}Description{{< /vismanet-cell >}} {{< /vismanet-header-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Deleted records{{< /vismanet-cell >}} {{< vismanet-cell >}} Selects the visibility of the data deleted from the database. + **Hide** + **Print** + **Only** {{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Print all pages{{< /vismanet-cell >}} {{< vismanet-cell >}}Prints all pages of the report.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Print in PDF format{{< /vismanet-cell >}} {{< vismanet-cell >}}Displays the report in PDF format.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Compress PDF file{{< /vismanet-cell >}} {{< vismanet-cell >}}Indicates that the system will generate a compressed PDF.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Embed fonts in PDF file{{< /vismanet-cell >}} {{< vismanet-cell >}}Indicates that the system will generate the PDF with fonts embedded.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< /vismanet-table >}} #### The Email settings section If you plan to send the report as an email, in the **Email settings** section, specify the format in which the report will be sent, as well as the email subject, the recipients of copies of the report, and the email of the recipient. {{< vismanet-table >}} {{< vismanet-header-row >}} {{< vismanet-cell header="true" >}}Field{{< /vismanet-cell >}} {{< vismanet-cell header="true" >}}Description{{< /vismanet-cell >}} {{< /vismanet-header-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Format{{< /vismanet-cell >}} {{< vismanet-cell >}} The format in which the report will be emailed: + **HTML** + **PDF** + **Excel** + **Excel with header** (this option is only available for ARM reports) > [!NOTE] > The merge function for reports in Excel format is not supported. If you want to merge a report with other reports and send an aggregated report by email, you should select either the HTML or PDF format for the report. {{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}To{{< /vismanet-cell >}} {{< vismanet-cell >}}The email address of the recipient.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Cc{{< /vismanet-cell >}} {{< vismanet-cell >}}An additional addressee to receive a carbon copy ( **Cc** ) of the email.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Bcc{{< /vismanet-cell >}} {{< vismanet-cell >}}The email address of anyone to receive a blind carbon copy ( **Bcc** ) of the email; an address you enter in this box will be hidden from other recipients.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Subject{{< /vismanet-cell >}} {{< vismanet-cell >}}The subject of the email.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< /vismanet-table >}} ### The Report versions tab This tab shows the data only to users assigned with the Report designer user role If the report has multiple versions, you can select one of them. {{< vismanet-table >}} {{< vismanet-header-row >}} {{< vismanet-cell header="true" >}}Button{{< /vismanet-cell >}} {{< vismanet-cell header="true" >}}Description{{< /vismanet-cell >}} {{< /vismanet-header-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Edit version{{< /vismanet-cell >}} {{< vismanet-cell >}}Click this to edit the selection version of the report.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Refresh dataset{{< /vismanet-cell >}} {{< vismanet-cell >}}Click this button to refresh the data set you have selected.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Activate{{< /vismanet-cell >}} {{< vismanet-cell >}}Temporarily activates the selected report.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}} **Import report design**{{< /vismanet-cell >}} {{< vismanet-cell >}} Click this button to select an exported report you want to import into this company. This button is only available for users assigned with the Report designer user role. The imported report will be set as the active report. {{< /vismanet-cell >}} {{< /vismanet-row >}} {{< /vismanet-table >}} {{< vismanet-table >}} {{< vismanet-header-row >}} {{< vismanet-cell header="true" >}}Column{{< /vismanet-cell >}} {{< vismanet-cell header="true" >}}Description{{< /vismanet-cell >}} {{< /vismanet-header-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Version{{< /vismanet-cell >}} {{< vismanet-cell >}}The number of the report version.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Description{{< /vismanet-cell >}} {{< vismanet-cell >}}The description of the report version.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Active{{< /vismanet-cell >}} {{< vismanet-cell >}}When this check box is selected, the report version is active.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Created{{< /vismanet-cell >}} {{< vismanet-cell >}}The creation date of the report version.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< vismanet-row >}} {{< vismanet-cell >}}Not default dataset{{< /vismanet-cell >}} {{< vismanet-cell >}}This check box is automatically selected if the report version is an import of an external report.{{< /vismanet-cell >}} {{< /vismanet-row >}} {{< /vismanet-table >}}

Related pages

Concepts

• Customer ledger reports - overview
• About customer ledger ageing reports

Windows

• Customer summary (AR401000)
• Customer details (AR402000)
• Aged outstanding (currency) (AR631600)
• Statement cycles (AR202800)