Skip to main content

Knowledge Center

Inspect the customer ledger using the Customer balance (CUSBAL) application

To follow up the customer ledger you have to acquire information about the customer balances. You may inspect the customer ledger by using the Customer Balance (CUSBAL) application.

  1. To open the Customer Balance (CUSBAL) application, find Finance in the RamBase menu and then Receivables. Click Customer balances to enter the CUSBAL application.

    clip1213.png
  2. In the Parameters section, use the drop-down menus for filtering the information to be displayed in the list below, or use the radiobuttons on the bottom of the page.

  3. Fields in the Parameters section:

    • ACCOUNT - Group the accounts by account number and name.

    • ACCOUNT, CUR - Group the accounts by account number and name and currency. If the company for instance has liabilities to a supplier in EUR, the account would be presented with one record showing the liabilities in EUR and one for the liabilities in NOK.

    • CUR - Group the account's documents by currency. If the company has large claims in USD and the currency rates for USD is falling, this signals for a loss on exchange which will have a positive impact on the short-term liabilities.

    • ICTDB - Group the accounts by internal trades. From a corporate point of view, internal trade balances are not a part of the short-term liabilities.

    • DOC - Group the accounts by document type. Sales invoices (CIN), sales credit notes (CCN) and payments in advance (PAY).

    • ST - Group the accounts by document status. Status code 4> indicates registered documents (usually sales invoices CIN), status code 5> indicates documents selected for payment, status code 7> indicates document prepared for payment and status code 8> indicates payed documents.

    • OURNO - Lists the claims with reference to single documents (i.e. CIN/101265).

    • INVCC - Groups the accounts by countries for where the customers are registered.

    • DUEDATE - Groups the accounts by the document due dates.

    • DATE - Groups the accounts by the document issuing dates.

    • PERIOD - Groups the accounts by period.