Customer balance (CUSBAL) application
Customer balance (CUSBAL) is an application used to reconcile accounts receivable and to follow up on outstanding customer balances.
Navigate to the application
Option 1: RamBase menu→Finance→Receivables→Customer balance
Option 2: Click the Program field and type "CUSBAL" and press ENTER.
Click here to read more about the user interface.
The following areas are described in the sections below:
The Customer balance header
The Customer balance list
The Customer balance header
The Customer balance header contains fields which are used to filter the list below.
Fields and buttons | Description |
|---|---|
Customer filter field | Click on the Customer filter field to look up a specific Customer balance (CUSBAL). Click on the Filter icon to select which of the following options are to be included in the search:
|
Group by field | Click on the Group by field to filter the Customer balance (CUSBAL) list to select which of the following options are to be included in the search:
|
Due dates field | Filter the balance amounts which are due within the next:
|
Date button | Click on the Date button to filter the Customer balance (CUSBAL) by a specified date. |
Period button | Click on the Period button to filter the Customer balance (CUSBAL) by a specified period. |
Currency field | Customer balance (CUSBAL) can be displayed in any available currency. This is useful when the local currency differs from the reporting currency. |
Use transaction currency checkbox | If the Transaction currency option is selected, the amounts will be shown in the original currency of the invoices, rather than being converted using an exchange rate. |
Rate field | Here, you can choose whether to view the transaction rate (the original exchange rate at the time the invoice was registered) or the rate recalculated based on the date specified in the Rate Date field. |
Balances field | Filter the balances by choosing All balances, All overdue balances or Max overdue balances. |
Clear filters button | Click the Clear filters button to remove all filters and show all Customer balance (CUSBAL) in the list. |
View customer balance report button | This link opens the Customer balance (CUSBAL) report filtered according to the selections you have made in the application. |
The Customer balance list
The displayed Customer balance (CUSBAL) are based on the selections made in the Customer balance fields area.
The Customer balance list includes a Search field. In addition to the fields and variables in the header, the scope of the search can be further filtered by clicking the Filter builder icon to the right of the search field.
Clicking the Filter builder icon will display a popup with the options to add a Standard filter and/or Create custom filters. All custom filters can be saved and then added to the My saved filters area.
The user can customize the order of the columns by drag and drop, in addition to hover over icons and columns for further descriptions.
Columns | Description |
|---|---|
Key | GroupBy key for the customer balance. |
Name | Description of the key. |
Currency | Secondary grouping key for the customer balance. |
Credit limit | Billing amount of the day. |
Credit insurance | Credit amount insured for the customer. |
Balance (NOK) | Balance amount. |
Not due | Balance amount which is not due. |
Due (0-30 d) | Balance amount which is due within the next 0-30 days. |
Due (31-60 d) | Balance amount which is due within the next 31-60 days. |
Due (60+ d) | Balance amount which is due within the next 60+ days. |