Skip to main content

Knowledge Center

Supplier balance (SUPBAL) application

Supplier balance (SUPBAL) is an application used to reconcile accounts payable and to follow up on outstanding supplier balances.

Navigate to the application

Option 1: RamBase menu→Finance→Payable→Supplier balance

Option 2: Click the Program field and type "SUPBAL" and press ENTER.

Click here to read more about the user interface.

The following areas are described in the sections below:

CUSBAL.png

  • The Supplier balance header

  • The Supplier balance list

The Supplier balance header

The Supplier 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 Supplier balance (SUPBAL).

Click on the Filter icon to select which of the following options are to be included in the search:

  • Supplier id

  • Supplier name

Group by field

Click on the Group by field to filter the Supplier balance (SUPBAL) list to select which of the following options are to be included in the search:

  • Supplier account

  • Supplier account & currency

  • Currency

  • Document type

  • Country

  • Intercompany code

  • Status

  • Enterprise number

  • Date

  • Due date

  • Pay term

Due dates field

Filter the balance amounts which are due within the next:

  • 0-10,11-20,20+ days.

  • 0-30,31-60,60+ days.

  • 0-30,31-90,90+ days.

  • 0-51,51-100,100+ days.

  • 0-100,101-200,200+ days.

  • 0-200,201-400,400+ days.

Date button

Click on the Date button to filter the Supplier balance (SUPBAL) by a specified date.

Period button

Click on the Period button to filter the Supplier balance (SUPBAL) by a specified period.

Currency field

Supplier balance (SUPBAL) 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 Supplier balance (SUPBAL) in the list.

View supplier balance report button

This link opens the Supplier balance (SUPBAL) report filtered according to the selections you have made in the application.

The Supplier balance list

The displayed Supplier balance (SUPBAL) are based on the selections made in the Supplier balance fields area.

The Supplier 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 supplier balance.

Name

Description of the key.

Currency

Secondary grouping key for the supplier balance.

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.

In this section: