This section includes the fields and descriptions for the Print A/R Balance List tab.
Selection Criteria Island
| Field | Description |
|---|
| Customer No.
|
Here you specify a range of customer numbers. The printout will only include balances for customers within this range.
|
| Company No.
|
In these fields, you can enter a range of company numbers. The balance will only be calculated for customer entries with a settling company within the specified range. Please note that Maconomy prints one line per combination of company and customer.
|
| Dimension Comb. No.
|
In this field, you specify the number of the dimension combination when creating a new dimension combination. If the dimension combination is created on the basis of a control account, it has automatically been assigned the number of the account in question.
|
| Date
|
In this field, you enter the date of the balance you wish to see. The date entered must be a past date. Maconomy calculates which balance your customers have/had on this date, and sums up the balances per control account. These balances can be matched with the General Ledger provided you have not deleted entries between the given date and today’s date. Note that the balance may take a long time to generate if you specify a date far back in time.
|
| Customer Group
|
Here you select a customer group. The printout will only include customers in this group.
|
| Department
|
Here you select a department. The printout will only include customers assigned to this department.
|
| Country
|
Here you select a country. The printout will only include customers from this country.
|
| Currency
|
Here you select a currency. The printout will only include customers with this currency as their standard currency.
|
| Control Account
|
In this field, you can select a control account. The report will only include customers assigned to this control account.
|
| Customer Type
|
In this field, you can select a customer type. The report will only include customers of the specified type.
|
| Language
|
In this field, you can select a language. The report will only include customers whose standard language corresponds to the language specified in this field.
|
| Statistics 1-4
|
In these fields, you can select a number of statistics codes. The report will only include customers whose values in the corresponding statistics fields in the customer information card correspond to the values specified here.
|
Selection Criteria, Dimensions
| Field | Description |
|---|
| Location
|
In these fields, you can specify a range of location numbers. The printout will only include customers for which the Location field in the window Customer Information Card contains a value within the specified range.
|
| Entity
|
The functionality of these fields is similar to that of the Location field above.
|
| Project
|
The functionality of these fields is similar to that of the Location field above.
|
| Purpose
|
The functionality of these fields is similar to that of the Location field above.
|
| Spec. 1-3
|
The functionality of these fields is similar to that of the Location field above.
|
| Local Spec. 1-3
|
The functionality of these fields is similar to that of the Location field above.
|
Currency Island
| Field | Description |
|---|
| Reporting Currency
|
In this field, you can specify the currency in which the balance list should be printed. The balance list will be converted into and displayed in this currency. If the current user has been assigned to a company in the window Users, Maconomy suggests the company base currency of the company in question.
When converting amounts into the selected currency, Maconomy uses the exchange rates valid on the date entered in the field “Exchange Rate Date” below, and the exchange rate table used is the exchange rate table selected in the window System Information in the Set-Up module. Please note that Maconomy performs currency conversion even though the original amount has been registered in the same currency as the one specified in this field, which may give rise to discrepancies between the registered amounts and the amounts shown in this window.
|
| Exchange Rate Date
|
In this field, you can specify an exchange rate date. When converting amounts into the reporting currency, Maconomy uses the exchange rates valid on this date according to the enterprise exchange rate table selected in the window System Information in the Set-Up module for conversion of currency amounts. See also the field “Reporting Currency.”
|
| Exchange Rate Table
|
Specify the exchange rate table to use in the reports.
|
Print Control Island
| Field | Description |
|---|
| Layout
|
Here you choose the layout of the printout. You can choose between “Standard” and “Detailed” of which the latter shows entries that are open on the balance list start date for each customer.
If you want the printout in “Standard” or “Detailed” to give a fully updated customer balance list, it is necessary to post all customer-related journals (that is, journals of the type Collection, Customer Reconciliation, Interest Charge, and Reminder) before you print out the balance list.
|
| Include Zero Balances
|
If you mark this field, you include customers with a zero balance. If you do not mark the field, you only include customers with either a debit or credit balance.
|
Extra Fields
| Field | Description |
|---|
| Enterprise
|
In this field, you can select an enterprise. The printout will only include customers for which the value in the field “Enterprise” in the window Customer Information Card corresponds to the value specified here. However, if you leave the field blank, customers with any value in the enterprise field are included.
|
| Segment
|
In this field, you can select a segment. The printout will only include customers for which the value in the field “Segment” in the window Customer Information Card corresponds to the value specified here. However, if you leave the field blank, customers with any value in the segment field are included.
|
| Area
|
In this field, you can select an area. The printout will only include customers for which the value in the field “Area” in the window Customer Information Card corresponds to the value specified here. However, if you leave the field blank, customers with any value in the area field are included.
|
| Popup 1-5
|
In each of these fields, you can specify a customer pop-up value. The printout will only include customers for which the values in the fields “Popup 1-5” in the window Customer Information Card correspond to the values specified here. However, if you leave a given pop-up field blank, customers with any value in the field in question are included.
|